eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_NONROUTINE_PVT dependencies on FND_MSG_PUB

Line 217: FND_MSG_PUB.Initialize;

213: END IF;
214:
215: -- Initialize message list if p_init_msg_list is set to TRUE
216: IF FND_API.To_Boolean(p_init_msg_list) THEN
217: FND_MSG_PUB.Initialize;
218: END IF;
219:
220: -- Initialize Procedure return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 398: IF (FND_MSG_PUB.count_msg > 0) THEN

394:
395: END LOOP;
396:
397: -- initialize stack if any warning messages from CS APIs exist.
398: IF (FND_MSG_PUB.count_msg > 0) THEN
399: FND_MSG_PUB.Initialize;
400: END IF;
401:
402: -- NR MR ER -- start

Line 399: FND_MSG_PUB.Initialize;

395: END LOOP;
396:
397: -- initialize stack if any warning messages from CS APIs exist.
398: IF (FND_MSG_PUB.count_msg > 0) THEN
399: FND_MSG_PUB.Initialize;
400: END IF;
401:
402: -- NR MR ER -- start
403: /*

Line 413: l_msg_count := FND_MSG_PUB.count_msg;

409:
410: Create_task( p_x_task_tbl => p_x_sr_task_tbl,
411: x_return_status => l_return_status);
412:
413: l_msg_count := FND_MSG_PUB.count_msg;
414:
415: IF ( upper(l_return_status) <> FND_API.G_RET_STS_SUCCESS or l_msg_count>0) THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;

Line 520: Fnd_Msg_Pub.ADD;

516: OPEN cs_sr_status;
517: FETCH cs_sr_status INTO l_sr_status_id;
518: IF ( cs_sr_status%NOTFOUND) THEN
519: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_STATUS_ERROR');
520: Fnd_Msg_Pub.ADD;
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: END IF;
523: */
524:

Line 596: IF (FND_MSG_PUB.count_msg > 0) THEN

592:
593: END IF;
594:
595: -- initialize stack if any warning messages from CS APIs exist.
596: IF (FND_MSG_PUB.count_msg > 0) THEN
597: FND_MSG_PUB.Initialize;
598: END IF;
599:
600: -- Standard check of p_commit

Line 597: FND_MSG_PUB.Initialize;

593: END IF;
594:
595: -- initialize stack if any warning messages from CS APIs exist.
596: IF (FND_MSG_PUB.count_msg > 0) THEN
597: FND_MSG_PUB.Initialize;
598: END IF;
599:
600: -- Standard check of p_commit
601: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 610: FND_MSG_PUB.count_and_get

606: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
607: END IF;
608:
609: -- Count and Get messages
610: FND_MSG_PUB.count_and_get
611: ( p_encoded => fnd_api.g_false,
612: p_count => x_msg_count,
613: p_data => x_msg_data
614: );

Line 625: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
625: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
626: p_data => x_msg_data,
627: p_encoded => fnd_api.g_false);
628:
629: -- Disable debug

Line 638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
639: p_data => x_msg_data,
640: p_encoded => fnd_api.g_false);
641:
642: -- Disable debug

Line 650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

646:
647: WHEN OTHERS THEN
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
651: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
652: p_procedure_name => 'Process_Nonroutine_Job',
653: p_error_text => SUBSTR(SQLERRM,1,240));
654: END IF;

Line 651: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

647: WHEN OTHERS THEN
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: Rollback to AHL_PROCESS_NONROUTINE_JOB_PVT;
650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
651: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
652: p_procedure_name => 'Process_Nonroutine_Job',
653: p_error_text => SUBSTR(SQLERRM,1,240));
654: END IF;
655: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 655: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

651: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
652: p_procedure_name => 'Process_Nonroutine_Job',
653: p_error_text => SUBSTR(SQLERRM,1,240));
654: END IF;
655: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
656: p_data => x_msg_data,
657: p_encoded => fnd_api.g_false);
658:
659: -- Disable debug

Line 778: Fnd_Msg_Pub.ADD;

774: (p_x_sr_task_rec.customer_name <> FND_API.G_MISS_CHAR) ) THEN
775: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_MISMATCH');
776: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
777: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
778: Fnd_Msg_Pub.ADD;
779: x_return_status := FND_API.G_RET_STS_ERROR;
780: END IF;
781:
782: EXCEPTION

Line 786: Fnd_Msg_Pub.ADD;

782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_INVALID');
785: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
786: Fnd_Msg_Pub.ADD;
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: WHEN TOO_MANY_ROWS THEN
789: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');
790: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);

Line 791: Fnd_Msg_Pub.ADD;

787: x_return_status := FND_API.G_RET_STS_ERROR;
788: WHEN TOO_MANY_ROWS THEN
789: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');
790: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
791: Fnd_Msg_Pub.ADD;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: END;
794:
795:

Line 813: Fnd_Msg_Pub.ADD;

809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_INVALID');
812: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
813: Fnd_Msg_Pub.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: WHEN TOO_MANY_ROWS THEN
816: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');
817: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);

Line 818: Fnd_Msg_Pub.ADD;

814: x_return_status := FND_API.G_RET_STS_ERROR;
815: WHEN TOO_MANY_ROWS THEN
816: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');
817: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
818: Fnd_Msg_Pub.ADD;
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: END;
821: -- NR MR ER - start
822: -- Balaji added following elseif clause to explicitly pass null to

Line 861: Fnd_Msg_Pub.ADD;

857: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
858: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
859: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
860: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
861: Fnd_Msg_Pub.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END IF;
864:
865: EXCEPTION

Line 869: Fnd_Msg_Pub.ADD;

865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
868: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
869: Fnd_Msg_Pub.ADD;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 874: Fnd_Msg_Pub.ADD;

870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
874: Fnd_Msg_Pub.ADD;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END;
877:
878:

Line 898: Fnd_Msg_Pub.ADD;

894: EXCEPTION
895: WHEN NO_DATA_FOUND THEN
896: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
897: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
898: Fnd_Msg_Pub.ADD;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: WHEN TOO_MANY_ROWS THEN
901: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
902: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 903: Fnd_Msg_Pub.ADD;

899: x_return_status := FND_API.G_RET_STS_ERROR;
900: WHEN TOO_MANY_ROWS THEN
901: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
902: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
903: Fnd_Msg_Pub.ADD;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END;
906: -- NR MR ER -- start
907: -- Balaji added following elseif clause to explicitly pass null to

Line 948: Fnd_Msg_Pub.ADD;

944: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) ) THEN
945: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
946: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
947: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
948: Fnd_Msg_Pub.ADD;
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: END IF;
951:
952: EXCEPTION

Line 956: Fnd_Msg_Pub.ADD;

952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN
954: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
955: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
956: Fnd_Msg_Pub.ADD;
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: WHEN TOO_MANY_ROWS THEN
959: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
960: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 961: Fnd_Msg_Pub.ADD;

957: x_return_status := FND_API.G_RET_STS_ERROR;
958: WHEN TOO_MANY_ROWS THEN
959: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
960: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
961: Fnd_Msg_Pub.ADD;
962: x_return_status := FND_API.G_RET_STS_ERROR;
963: END;
964:
965:

Line 986: Fnd_Msg_Pub.ADD;

982: EXCEPTION
983: WHEN NO_DATA_FOUND THEN
984: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
985: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
986: Fnd_Msg_Pub.ADD;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: WHEN TOO_MANY_ROWS THEN
989: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
990: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 991: Fnd_Msg_Pub.ADD;

987: x_return_status := FND_API.G_RET_STS_ERROR;
988: WHEN TOO_MANY_ROWS THEN
989: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
990: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
991: Fnd_Msg_Pub.ADD;
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: END;
994: -- NR MR ER -- start
995: -- Balaji added following elseif clause to explicitly pass null to

Line 1049: Fnd_Msg_Pub.ADD;

1045: -- Part of NR MR ER.
1046: IF p_x_sr_task_rec.problem_code IS NULL THEN
1047: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
1048: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
1049: Fnd_Msg_Pub.ADD;
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: END IF;
1052: -- NR MR ER - end
1053:

Line 1067: Fnd_Msg_Pub.ADD;

1063: FETCH sr_qality_inspection_type INTO p_x_sr_task_rec.quality_inspection_type_code;
1064: IF (sr_qality_inspection_type%NOTFOUND ) THEN
1065: Fnd_Message.SET_NAME('AHL','AHL_PRD_QA_INSP_TYPE_INVALID');
1066: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.quality_inspection_type);
1067: Fnd_Msg_Pub.ADD;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;
1070: CLOSE sr_qality_inspection_type;
1071:

Line 1093: Fnd_Msg_Pub.ADD;

1089: -- Part of NR MR ER
1090: IF p_x_sr_task_rec.resolution_code IS NULL THEN
1091: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
1092: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
1093: Fnd_Msg_Pub.ADD;
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: END IF;
1096: -- NR MR ER -- end
1097:

Line 1129: Fnd_Msg_Pub.ADD;

1125: EXCEPTION
1126: WHEN NO_DATA_FOUND THEN
1127: Fnd_Message.SET_NAME('AHL', 'AHL_WARRANTY_INVALID_CNTR_NUM');
1128: Fnd_Message.SET_TOKEN('CNTR_NUM', p_x_sr_task_rec.warranty_contract_number);
1129: Fnd_Msg_Pub.ADD;
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: END;
1132:
1133: ELSIF ( upper(p_x_sr_task_rec.operation_type) = 'UPDATE') THEN

Line 1162: Fnd_Msg_Pub.ADD;

1158: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1159: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1160: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1161: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1162: Fnd_Msg_Pub.ADD;
1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164: END IF;
1165:
1166:

Line 1171: Fnd_Msg_Pub.ADD;

1167: EXCEPTION
1168: WHEN NO_DATA_FOUND THEN
1169: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1170: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1171: Fnd_Msg_Pub.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: WHEN TOO_MANY_ROWS THEN
1174: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1175: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 1176: Fnd_Msg_Pub.ADD;

1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: WHEN TOO_MANY_ROWS THEN
1174: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1175: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1176: Fnd_Msg_Pub.ADD;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: END;
1179:
1180:

Line 1199: Fnd_Msg_Pub.ADD;

1195: EXCEPTION
1196: WHEN NO_DATA_FOUND THEN
1197: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1198: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1199: Fnd_Msg_Pub.ADD;
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: WHEN TOO_MANY_ROWS THEN
1202: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1203: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 1204: Fnd_Msg_Pub.ADD;

1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: WHEN TOO_MANY_ROWS THEN
1202: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1203: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1204: Fnd_Msg_Pub.ADD;
1205: x_return_status := FND_API.G_RET_STS_ERROR;
1206: END;
1207: -- NR MR ER -- start
1208: -- Balaji added following elseif clause to explicitly pass null to

Line 1249: Fnd_Msg_Pub.ADD;

1245: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1246: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1247: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1248: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1249: Fnd_Msg_Pub.ADD;
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: END IF;
1252:
1253: EXCEPTION

Line 1257: Fnd_Msg_Pub.ADD;

1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1256: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1257: Fnd_Msg_Pub.ADD;
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: WHEN TOO_MANY_ROWS THEN
1260: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1261: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

Line 1262: Fnd_Msg_Pub.ADD;

1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: WHEN TOO_MANY_ROWS THEN
1260: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1261: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1262: Fnd_Msg_Pub.ADD;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: END;
1265:
1266:

Line 1287: Fnd_Msg_Pub.ADD;

1283: EXCEPTION
1284: WHEN NO_DATA_FOUND THEN
1285: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1286: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1287: Fnd_Msg_Pub.ADD;
1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: WHEN TOO_MANY_ROWS THEN
1290: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1291: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

Line 1292: Fnd_Msg_Pub.ADD;

1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: WHEN TOO_MANY_ROWS THEN
1290: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1291: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1292: Fnd_Msg_Pub.ADD;
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: END;
1295: -- NR MR ER -- start
1296: -- Balaji added following elseif clause to explicitly pass null to

Line 1327: Fnd_Msg_Pub.ADD;

1323: -- Part of NR MR ER.
1324: IF p_x_sr_task_rec.problem_code IS NULL THEN
1325: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
1326: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
1327: Fnd_Msg_Pub.ADD;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: END IF;
1330: -- NR MR ER -- end
1331:

Line 1352: Fnd_Msg_Pub.ADD;

1348: -- Part of NR MR ER
1349: IF p_x_sr_task_rec.resolution_code IS NULL THEN
1350: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
1351: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
1352: Fnd_Msg_Pub.ADD;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: END IF;
1355: -- NR MR ER -- end
1356:

Line 1501: Fnd_Msg_Pub.ADD;

1497: -- is null then return error message.
1498: IF (p_x_sr_task_rec.instance_id is null or p_x_sr_task_rec.instance_id = FND_API.G_MISS_NUM) THEN
1499:
1500: Fnd_Message.SET_NAME('AHL','AHL_PRD_INSTANCE_VALUE_REQ');
1501: Fnd_Msg_Pub.ADD;
1502: RAISE FND_API.G_EXC_ERROR;
1503:
1504: END IF;
1505:

Line 1511: Fnd_Msg_Pub.ADD;

1507: -- return an error message.
1508: IF (p_x_sr_task_rec.originating_wo_id is null or p_x_sr_task_rec.originating_wo_id = FND_API.G_MISS_NUM) THEN
1509:
1510: Fnd_Message.SET_NAME('AHL','AHL_PRD_TASK_ORG_WOID_REQ');
1511: Fnd_Msg_Pub.ADD;
1512: RAISE FND_API.G_EXC_ERROR;
1513:
1514: END IF;
1515:

Line 1527: Fnd_Msg_Pub.ADD;

1523: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1524: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1525:
1526: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');
1527: Fnd_Msg_Pub.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529:
1530: END IF;
1531: END IF;

Line 1551: FND_MSG_PUB.ADD;

1547: p_item_instance_id => NULL);
1548: IF l_return_status = FND_API.G_TRUE THEN
1549: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_CRT_SR_UNTLCKD');
1550: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: END IF;
1554: -- rroy
1555: -- ACL Changes

Line 1570: Fnd_Msg_Pub.ADD;

1566: ELSE
1567: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1568: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1569: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1570: Fnd_Msg_Pub.ADD;
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: END IF;
1573:
1574: END IF;

Line 1593: Fnd_Msg_Pub.ADD;

1589: IF( cs_sr_status%NOTFOUND) THEN
1590: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_DEFAULT_ERR');
1591: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1592: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1593: Fnd_Msg_Pub.ADD;
1594: x_return_status := FND_API.G_RET_STS_ERROR;
1595: ELSE
1596: FETCH cs_sr_status INTO p_x_sr_task_rec.status_id;
1597: END IF;

Line 1610: FND_MSG_PUB.ADD;

1606: IF (p_mr_asso_count = 0 and
1607: p_x_sr_task_rec.status_id = 2 and p_x_sr_task_rec.warranty_contract_id IS NOT null) THEN
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_MESSAGE.set_name('AHL', 'AHL_PRD_NR_WARR_CNTR_RO');
1610: FND_MSG_PUB.ADD;
1611: END IF;
1612:
1613: -- If severity is null then derive it from profile.
1614: -- If profile value is null then return an error message.

Line 1628: Fnd_Msg_Pub.ADD;

1624: IF ( cs_sr_severity_validate%NOTFOUND) THEN
1625: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_INVALID');
1626: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1627: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1628: Fnd_Msg_Pub.ADD;
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630: END IF;
1631:
1632: CLOSE cs_sr_severity_validate;

Line 1637: Fnd_Msg_Pub.ADD;

1633: ELSE
1634: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_REQ');
1635: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1636: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1637: Fnd_Msg_Pub.ADD;
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639: END IF;
1640:
1641: END IF;

Line 1668: Fnd_Msg_Pub.ADD;

1664:
1665: Fnd_Message.SET_NAME('AHL','AHL_PRD_SUMMARY_REQ');
1666: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1667: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1668: Fnd_Msg_Pub.ADD;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: END IF;
1672:

Line 1701: Fnd_Msg_Pub.ADD;

1697: IF ( default_party_id%NOTFOUND) THEN
1698: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1699: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1700: Fnd_Message.SET_TOKEN('INSTANCE_NUM',null);
1701: Fnd_Msg_Pub.ADD;
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: END IF;
1704: OPEN owner_customer_type(p_x_sr_task_rec.customer_id);
1705: FETCH owner_customer_type INTO p_x_sr_task_rec.customer_type;

Line 1710: Fnd_Msg_Pub.ADD;

1706: IF ( owner_customer_type%NOTFOUND) THEN
1707: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR'); -- Customer Type is Invalid
1708: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1709: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1710: Fnd_Msg_Pub.ADD;
1711: x_return_status := FND_API.G_RET_STS_ERROR;
1712: END IF;
1713:
1714: CLOSE owner_customer_type;

Line 1722: Fnd_Msg_Pub.ADD;

1718: IF ( default_contact%NOTFOUND ) THEN
1719: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1720: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1721: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1722: Fnd_Msg_Pub.ADD;
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: ELSE
1725: p_x_sr_task_rec.contact_type := 'EMPLOYEE';
1726: END IF;

Line 1738: Fnd_Msg_Pub.ADD;

1734: IF( l_owner_id <> nvl(p_x_sr_task_rec.customer_id,l_owner_id) and
1735: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1736: Fnd_Message.SET_NAME('AHL','AHL_PRD_INVALID_OWNER'); -- New Error Message Should be added
1737: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1738: Fnd_Msg_Pub.ADD;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: END IF;
1741:
1742: END IF;

Line 1760: Fnd_Msg_Pub.ADD;

1756: IF ( default_customer_type%NOTFOUND) THEN
1757: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1758: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1759: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1760: Fnd_Msg_Pub.ADD;
1761: x_return_status := FND_API.G_RET_STS_ERROR;
1762: ELSE
1763: p_x_sr_task_rec.customer_id := fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1764: END IF;

Line 1774: Fnd_Msg_Pub.ADD;

1770: IF ( default_contact%NOTFOUND ) THEN
1771: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1772: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1773: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1774: Fnd_Msg_Pub.ADD;
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: ELSE
1777: p_x_sr_task_rec.contact_type := 'EMPLOYEE';
1778: END IF;

Line 1787: Fnd_Msg_Pub.ADD;

1783:
1784: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_PROFILE_REQ');
1785: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1786: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1787: Fnd_Msg_Pub.ADD;
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789:
1790: END IF;
1791:

Line 1803: Fnd_Msg_Pub.ADD;

1799:
1800: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_TYPE_REQ');
1801: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1802: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1803: Fnd_Msg_Pub.ADD;
1804: x_return_status := FND_API.G_RET_STS_ERROR;
1805:
1806: END IF;
1807:

Line 1817: Fnd_Msg_Pub.ADD;

1813:
1814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1815: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1816: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1817: Fnd_Msg_Pub.ADD;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819:
1820: END IF;
1821:

Line 1831: Fnd_Msg_Pub.ADD;

1827:
1828: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1829: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1830: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1831: Fnd_Msg_Pub.ADD;
1832: x_return_status := FND_API.G_RET_STS_ERROR;
1833:
1834: -- If Contact is not null but Customer is null then
1835: -- return an error message.

Line 1842: Fnd_Msg_Pub.ADD;

1838:
1839: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUSTOMER_REQ');
1840: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1841: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1842: Fnd_Msg_Pub.ADD;
1843: x_return_status := FND_API.G_RET_STS_ERROR;
1844:
1845: END IF;
1846:

Line 1855: Fnd_Msg_Pub.ADD;

1851:
1852: Fnd_Message.SET_NAME('AHL','AHL_PRD_VISIT_VALUE_REQ');
1853: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1854: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1855: Fnd_Msg_Pub.ADD;
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857:
1858: END IF;
1859:

Line 1875: Fnd_Msg_Pub.ADD;

1871: EXCEPTION
1872: WHEN NO_DATA_FOUND THEN
1873: Fnd_Message.SET_NAME('AHL','AHL_PRD_SERVICE_TYPE_INVALID');
1874: -- Fnd_Message.SET_TOKEN('SERVICE_TYPE',p_x_sr_task_rec.service_type);
1875: Fnd_Msg_Pub.ADD;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: END;
1878: ELSE
1879: p_x_sr_task_rec.service_type_code := NULL;

Line 1885: Fnd_Msg_Pub.ADD;

1881:
1882: --amsriniv. Issue 105. Begin ER 6014567
1883: IF (p_x_sr_task_rec.instance_quantity IS NOT NULL AND p_x_sr_task_rec.instance_quantity <= 0) THEN
1884: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');
1885: Fnd_Msg_Pub.ADD;
1886: x_return_status := FND_API.G_RET_STS_ERROR;
1887: END IF;
1888:
1889: IF (upper(p_x_sr_task_rec.WO_Create_flag) = 'N') THEN

Line 1895: Fnd_Msg_Pub.ADD;

1891: FETCH check_inst_nonserial INTO l_dummy;
1892: IF (check_inst_nonserial%FOUND) THEN
1893: Fnd_Message.SET_NAME('AHL','AHL_NO_CREATE_WO_NONSER');
1894: Fnd_Message.SET_TOKEN('FIELD',l_instance_num);
1895: Fnd_Msg_Pub.ADD;
1896: x_return_status := FND_API.G_RET_STS_ERROR;
1897: END IF;
1898: CLOSE check_inst_nonserial;
1899: END IF;

Line 1909: Fnd_Msg_Pub.ADD;

1905: IF (validate_quantity%NOTFOUND) THEN
1906: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_ISSUED');
1907: Fnd_Message.SET_TOKEN('INS_NUM',l_instance_num);
1908: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1909: Fnd_Msg_Pub.ADD;
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1912: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1913: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);

Line 1917: Fnd_Msg_Pub.ADD;

1913: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1914: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1915: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1916: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));
1917: Fnd_Msg_Pub.ADD;
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: END IF;
1920: ELSE
1921: Fnd_Message.SET_NAME('AHL','AHL_NR_WO_NOT_RELEASED');

Line 1922: Fnd_Msg_Pub.ADD;

1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: END IF;
1920: ELSE
1921: Fnd_Message.SET_NAME('AHL','AHL_NR_WO_NOT_RELEASED');
1922: Fnd_Msg_Pub.ADD;
1923: x_return_status := FND_API.G_RET_STS_ERROR;
1924: END IF;
1925: END IF;
1926: --amsriniv. Issue 105. End ER 6014567

Line 1942: Fnd_Msg_Pub.ADD;

1938: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1939: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1940:
1941: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');
1942: Fnd_Msg_Pub.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944:
1945: END IF;
1946: END IF;

Line 1965: FND_MSG_PUB.ADD;

1961: p_item_instance_id => NULL);
1962: IF l_return_status = FND_API.G_TRUE THEN
1963: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UPD_SR_UNTLCKD');
1964: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: END IF;
1968: -- rroy
1969: -- ACL Changes

Line 1980: Fnd_Msg_Pub.ADD;

1976:
1977: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1978: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1979: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1980: Fnd_Msg_Pub.ADD;
1981: x_return_status := FND_API.G_RET_STS_ERROR;
1982:
1983: END IF;
1984:

Line 1994: Fnd_Msg_Pub.ADD;

1990:
1991: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1992: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1993: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1994: Fnd_Msg_Pub.ADD;
1995: x_return_status := FND_API.G_RET_STS_ERROR;
1996:
1997: END IF;
1998:

Line 2008: Fnd_Msg_Pub.ADD;

2004:
2005: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_REQ');
2006: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
2007: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
2008: Fnd_Msg_Pub.ADD;
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010:
2011: END IF;
2012:

Line 2023: Fnd_Msg_Pub.ADD;

2019:
2020: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_OBJ_VER_ID_REQ');
2021: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
2022: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
2023: Fnd_Msg_Pub.ADD;
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025:
2026: END IF;
2027:

Line 2038: Fnd_Msg_Pub.ADD;

2034:
2035: Fnd_Message.SET_NAME('AHL','AHL_PRD_INCIDENT_VALUE_REQ');
2036: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
2037: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
2038: Fnd_Msg_Pub.ADD;
2039: x_return_status := FND_API.G_RET_STS_ERROR;
2040: END IF;
2041:
2042: END IF;

Line 2172: Fnd_Msg_Pub.ADD;

2168: open default_item_org_id(p_x_sr_task_rec.Originating_wo_id);
2169: Fetch default_item_org_id INTO l_service_request_rec.inventory_item_id,l_service_request_rec.inventory_org_id;
2170: IF (default_item_org_id%NOTFOUND ) THEN
2171: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_ORG_ERROR');
2172: Fnd_Msg_Pub.ADD;
2173: x_return_status := FND_API.G_RET_STS_ERROR;
2174: END IF;
2175: CLOSE default_item_org_id;
2176:

Line 2201: Fnd_Msg_Pub.ADD;

2197: Fetch default_incident_type_id INTO l_service_request_rec.type_id,l_service_request_rec.type_name;
2198:
2199: IF ( default_incident_type_id%NOTFOUND) THEN
2200: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_INCIDENT_ERROR');
2201: Fnd_Msg_Pub.ADD;
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;
2204:
2205: IF (G_DEBUG = 'Y') THEN

Line 2321: Fnd_Msg_Pub.ADD;

2317: EXCEPTION
2318:
2319: WHEN OTHERS THEN
2320: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');
2321: Fnd_Msg_Pub.ADD;
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323:
2324: END;
2325:

Line 2432: FND_MSG_PUB.ADD;

2428:
2429: x_return_status := FND_API.G_RET_STS_ERROR;
2430: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
2431: FND_MESSAGE.set_token('INCIDENT_ID', l_sr_task_rec.incident_id);
2432: FND_MSG_PUB.ADD;
2433: RETURN;
2434: END IF;
2435: CLOSE Get_warranty_entl_rec_csr;
2436:

Line 2485: FND_MSG_PUB.ADD;

2481:
2482: x_return_status := FND_API.G_RET_STS_ERROR;
2483: FND_MESSAGE.set_name('AHL', 'AHL_LTP_TASK_ID_INVALID');
2484: FND_MESSAGE.set_token('TASK_ID', l_visit_task_id);
2485: FND_MSG_PUB.ADD;
2486: RETURN;
2487: END IF;
2488: CLOSE Get_workorder_id_csr;
2489:

Line 2783: FND_MSG_PUB.ADD;

2779: THEN
2780: x_return_status := FND_API.G_RET_STS_ERROR;
2781: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR');
2782: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2783: FND_MSG_PUB.ADD;
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786: CLOSE c_get_ue_id;
2787:

Line 3098: FND_MSG_PUB.Initialize;

3094: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
3095: RAISE Fnd_Api.g_exc_unexpected_error;
3096: END IF;
3097: ELSE
3098: FND_MSG_PUB.Initialize;
3099: END IF;
3100: END IF;
3101: END IF;
3102: END LOOP;

Line 3243: Fnd_Msg_Pub.ADD;

3239: If GetOrgTaskDet%Found and GetOrgTaskDet%rowcount >1
3240: Then
3241: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TASK_ID_NOT_UNIQUE');
3242: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
3243: Fnd_Msg_Pub.ADD;
3244: RAISE FND_API.G_EXC_ERROR;
3245: ElsIf GetOrgTaskDet%NotFound
3246: Then
3247: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');

Line 3249: Fnd_Msg_Pub.ADD;

3245: ElsIf GetOrgTaskDet%NotFound
3246: Then
3247: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');
3248: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
3249: Fnd_Msg_Pub.ADD;
3250: RAISE FND_API.G_EXC_ERROR;
3251: End if;
3252: Close GetOrgTaskDet;
3253:

Line 3288: Fnd_Msg_Pub.ADD;

3284: IF getUnitEffectivity%NotFound
3285: Then
3286: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR'); -- New Message needed to be added
3287: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
3288: Fnd_Msg_Pub.ADD;
3289: RAISE FND_API.G_EXC_ERROR;
3290: End if;
3291: Close getUnitEffectivity;
3292: l_create_job_task_tbl(i).unit_effectivity_id := l_unit_effectivity_id;

Line 3349: l_msg_count := FND_MSG_PUB.count_msg;

3345: -- even though visit validation fails. The validation errors are put in the
3346: -- error stack. In this case, the WO creation api will not be called and
3347: -- wo_id returned is null. Task is created.
3348:
3349: l_msg_count := FND_MSG_PUB.count_msg;
3350:
3351: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_count > 0) THEN
3352:
3353: IF (l_debug_UEXP >= l_debug_LEVEL) THEN