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_OSP_PO_REQ_PVT dependencies on FND_MSG_PUB

Line 302: FND_MSG_PUB.Initialize;

298: END IF;
299:
300: -- Initialize message list if p_init_msg_list is set to TRUE
301: IF FND_API.To_Boolean(p_init_msg_list) THEN
302: FND_MSG_PUB.Initialize;
303: END IF;
304:
305: -- Initialize API return status to success
306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 373: x_msg_count := FND_MSG_PUB.count_msg;

369: l_po_req_line_tbl.DELETE(l_temp_num); -- Delete the last (null) record
370: -- Validate Lines
371: Validate_PO_Req_Lines(l_po_req_line_tbl, l_po_req_header.OSP_ORDER_ID);
372: -- Check Error Message stack.
373: x_msg_count := FND_MSG_PUB.count_msg;
374: IF x_msg_count > 0 THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:

Line 416: FND_MSG_PUB.ADD;

412: END IF;
413: -- Check if request was submitted without error
414: IF (l_request_id = 0) THEN
415: -- Add Error Message generated by Concurrent Manager to Message List
416: FND_MSG_PUB.ADD;
417: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
419: END IF;
420: RAISE FND_API.G_EXC_ERROR;

Line 436: x_msg_count := FND_MSG_PUB.count_msg;

432: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Processing. Checking for errors');
434: END IF;
435: -- Check Error Message stack.
436: x_msg_count := FND_MSG_PUB.count_msg;
437: IF x_msg_count > 0 THEN
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440:

Line 454: FND_MSG_PUB.Count_And_Get

450: COMMIT WORK;
451: END IF;
452:
453: -- Standard call to get message count and if count is 1, get message info
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data,
457: p_encoded => fnd_api.g_false
458: );

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

464: EXCEPTION
465: WHEN FND_API.G_EXC_ERROR THEN
466: ROLLBACK TO Create_PO_Requisition_pvt;
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
469: p_data => x_msg_data,
470: p_encoded => fnd_api.g_false);
471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO Create_PO_Requisition_pvt;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
476: p_data => x_msg_data,
477: p_encoded => fnd_api.g_false);
478:
479: WHEN OTHERS THEN

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

478:
479: WHEN OTHERS THEN
480: ROLLBACK TO Create_PO_Requisition_pvt;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
483: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
484: p_procedure_name => 'Create_PO_Requisition',
485: p_error_text => SUBSTR(SQLERRM,1,240));
486: END IF;

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

479: WHEN OTHERS THEN
480: ROLLBACK TO Create_PO_Requisition_pvt;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
483: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
484: p_procedure_name => 'Create_PO_Requisition',
485: p_error_text => SUBSTR(SQLERRM,1,240));
486: END IF;
487: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

483: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
484: p_procedure_name => 'Create_PO_Requisition',
485: p_error_text => SUBSTR(SQLERRM,1,240));
486: END IF;
487: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
488: p_data => x_msg_data,
489: p_encoded => fnd_api.g_false);
490:
491:

Line 560: FND_MSG_PUB.Initialize;

556: END IF;
557:
558: -- Initialize message list if p_init_msg_list is set to TRUE
559: IF FND_API.To_Boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.Initialize;
561: END IF;
562:
563: -- Initialize API return status to success
564: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 631: x_msg_count := FND_MSG_PUB.count_msg;

627: IF (p_concurrent_flag = 'Y') THEN
628: fnd_file.put_line(fnd_file.log, 'Completed Requisition Synch Process. Checking for errors.');
629: END IF;
630: -- Check Error Message stack.
631: x_msg_count := FND_MSG_PUB.count_msg;
632: IF x_msg_count > 0 THEN
633: RAISE FND_API.G_EXC_ERROR; --Note that commit might already have taken place
634: END IF;
635:

Line 644: FND_MSG_PUB.Count_And_Get

640: -- COMMIT WORK; --Note that commit might already have taken place
641: -- END IF;
642:
643: -- Standard call to get message count and if count is 1, get message info
644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => fnd_api.g_false
648: );

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

656: -- No need to rollback: Individual procedures commit or rollback
657: -- within themselves.
658: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
661: p_data => x_msg_data,
662: p_encoded => fnd_api.g_false);
663: IF (p_concurrent_flag = 'Y') THEN
664: fnd_file.put_line(fnd_file.log, 'Caught Execution Exception: ' || x_msg_data);

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

671: -- No need to rollback: Individual procedures commit or rollback
672: -- within themselves.
673:
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
676: p_data => x_msg_data,
677: p_encoded => fnd_api.g_false);
678: IF (p_concurrent_flag = 'Y') THEN
679: fnd_file.put_line(fnd_file.log, 'Caught Unexpected Exception: ' || x_msg_data);

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

685: WHEN OTHERS THEN
686: -- No need to rollback: Individual procedures commit or rollback
687: -- within themselves.
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
690: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
691: p_procedure_name => 'PO_Synch_All_Requisitions',
692: p_error_text => SUBSTR(SQLERRM,1,240));
693: END IF;

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

686: -- No need to rollback: Individual procedures commit or rollback
687: -- within themselves.
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
690: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
691: p_procedure_name => 'PO_Synch_All_Requisitions',
692: p_error_text => SUBSTR(SQLERRM,1,240));
693: END IF;
694: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

690: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
691: p_procedure_name => 'PO_Synch_All_Requisitions',
692: p_error_text => SUBSTR(SQLERRM,1,240));
693: END IF;
694: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => fnd_api.g_false);
697: IF (p_concurrent_flag = 'Y') THEN
698: fnd_file.put_line(fnd_file.log, 'Caught Unknown Exception: ' || x_msg_data);

Line 779: FND_MSG_PUB.Initialize;

775: END IF;
776:
777: -- Initialize message list if p_init_msg_list is set to TRUE
778: IF FND_API.To_Boolean(p_init_msg_list) THEN
779: FND_MSG_PUB.Initialize;
780: END IF;
781:
782: -- Initialize API return status to success
783: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 809: x_msg_count := FND_MSG_PUB.count_msg;

805: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Associated ' || l_temp_count || ' OSP Orders with Requisitions');
806: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Processing. Checking for errors.');
807: END IF;
808: -- Check Error Message stack.
809: x_msg_count := FND_MSG_PUB.count_msg;
810: IF x_msg_count > 0 THEN
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;
813:

Line 823: FND_MSG_PUB.Count_And_Get

819: COMMIT WORK;
820: END IF;
821:
822: -- Standard call to get message count and if count is 1, get message info
823: FND_MSG_PUB.Count_And_Get
824: ( p_count => x_msg_count,
825: p_data => x_msg_data,
826: p_encoded => fnd_api.g_false
827: );

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

833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO Associate_All_New_Reqs_pvt;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
838: p_data => x_msg_data,
839: p_encoded => fnd_api.g_false);
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO Associate_All_New_Reqs_pvt;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
845: p_data => x_msg_data,
846: p_encoded => fnd_api.g_false);
847:
848: WHEN OTHERS THEN

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

847:
848: WHEN OTHERS THEN
849: ROLLBACK TO Associate_All_New_Reqs_pvt;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
852: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
853: p_procedure_name => 'Associate_All_New_Reqs',
854: p_error_text => SUBSTR(SQLERRM,1,240));
855: END IF;

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

848: WHEN OTHERS THEN
849: ROLLBACK TO Associate_All_New_Reqs_pvt;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
852: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
853: p_procedure_name => 'Associate_All_New_Reqs',
854: p_error_text => SUBSTR(SQLERRM,1,240));
855: END IF;
856: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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

852: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
853: p_procedure_name => 'Associate_All_New_Reqs',
854: p_error_text => SUBSTR(SQLERRM,1,240));
855: END IF;
856: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
857: p_data => x_msg_data,
858: p_encoded => fnd_api.g_false);
859:
860: END Associate_All_New_Reqs;

Line 1144: FND_MSG_PUB.ADD;

1140:
1141: -- OSP Order Id
1142: IF (p_po_req_header_rec.OSP_ORDER_ID IS NULL OR p_po_req_header_rec.OSP_ORDER_ID = FND_API.G_MISS_NUM) THEN
1143: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');
1144: FND_MSG_PUB.ADD;
1145: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1147: END IF;
1148: ELSE

Line 1154: FND_MSG_PUB.ADD;

1150: FETCH l_validate_osp_csr INTO l_dummy;
1151: IF (l_validate_osp_csr%NOTFOUND) THEN
1152: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
1153: FND_MESSAGE.Set_Token('OSP_ID', p_po_req_header_rec.OSP_ORDER_ID);
1154: FND_MSG_PUB.ADD;
1155: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1157: END IF;
1158: END IF;

Line 1165: FND_MSG_PUB.ADD;

1161:
1162: -- Supplier
1163: IF (p_po_req_header_rec.VENDOR_ID IS NULL OR p_po_req_header_rec.VENDOR_ID = FND_API.G_MISS_NUM) THEN
1164: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPPLIER_ID_NULL');
1165: FND_MSG_PUB.ADD;
1166: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1168: END IF;
1169: ELSE

Line 1175: FND_MSG_PUB.ADD;

1171: FETCH l_validate_supplier_csr INTO l_dummy;
1172: IF (l_validate_supplier_csr%NOTFOUND) THEN
1173: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');
1174: FND_MESSAGE.Set_Token('SUPP_ID', p_po_req_header_rec.VENDOR_ID);
1175: FND_MSG_PUB.ADD;
1176: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1178: END IF;
1179: END IF;

Line 1186: FND_MSG_PUB.ADD;

1182:
1183: -- Supplier Site
1184: IF (p_po_req_header_rec.VENDOR_SITE_ID IS NULL OR p_po_req_header_rec.VENDOR_SITE_ID = FND_API.G_MISS_NUM) THEN
1185: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_ID_NULL');
1186: FND_MSG_PUB.ADD;
1187: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1189: END IF;
1190: ELSE

Line 1196: FND_MSG_PUB.ADD;

1192: FETCH l_validate_supp_site_csr INTO l_dummy;
1193: IF (l_validate_supp_site_csr%NOTFOUND) THEN
1194: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');
1195: FND_MESSAGE.Set_Token('SS_ID', p_po_req_header_rec.VENDOR_SITE_ID);
1196: FND_MSG_PUB.ADD;
1197: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1198: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1199: END IF;
1200: END IF;

Line 1211: FND_MSG_PUB.ADD;

1207: FETCH l_validate_vendor_contact_csr INTO l_dummy;
1208: IF (l_validate_vendor_contact_csr%NOTFOUND) THEN
1209: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');
1210: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_req_header_rec.VENDOR_CONTACT_ID);
1211: FND_MSG_PUB.ADD;
1212: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1213: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1214: END IF;
1215: END IF;

Line 1222: FND_MSG_PUB.ADD;

1218:
1219: -- Buyer
1220: IF (p_po_req_header_rec.BUYER_ID IS NULL OR p_po_req_header_rec.BUYER_ID = FND_API.G_MISS_NUM) THEN
1221: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_ID_NULL');
1222: FND_MSG_PUB.ADD;
1223: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1224: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1225: END IF;
1226: ELSE

Line 1232: FND_MSG_PUB.ADD;

1228: FETCH l_validate_buyer_csr INTO l_dummy;
1229: IF (l_validate_buyer_csr%NOTFOUND) THEN
1230: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');
1231: FND_MESSAGE.Set_Token('BUYER_ID', p_po_req_header_rec.BUYER_ID);
1232: FND_MSG_PUB.ADD;
1233: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1234: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1235: END IF;
1236: END IF;

Line 1284: FND_MSG_PUB.ADD;

1280: -- Get the current Org
1281: l_org_id := MO_GLOBAL.get_current_org_id();
1282: IF (l_org_id IS NULL) THEN
1283: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
1284: FND_MSG_PUB.ADD;
1285: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1286: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
1287: END IF;
1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1294: FND_MSG_PUB.ADD;

1290:
1291: -- Non zero count
1292: IF (p_po_req_line_tbl.COUNT = 0) THEN
1293: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NO_PO_LINES');
1294: FND_MSG_PUB.ADD;
1295: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1297: END IF;
1298: RETURN; -- Cannot do any further validation

Line 1310: FND_MSG_PUB.ADD;

1306: FETCH l_validate_item_csr INTO l_dummy;
1307: IF (l_validate_item_csr%NOTFOUND) THEN
1308: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');
1309: FND_MESSAGE.Set_Token('ITEM', p_po_req_line_tbl(i).ITEM_ID);
1310: FND_MSG_PUB.ADD;
1311: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1312: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1313: END IF;
1314: END IF;

Line 1320: FND_MSG_PUB.ADD;

1316: ELSE
1317: -- One-time Item: Description is mandatory
1318: IF (TRIM(p_po_req_line_tbl(i).ITEM_DESCRIPTION) IS NULL OR p_po_req_line_tbl(i).ITEM_DESCRIPTION = FND_API.G_MISS_CHAR) THEN
1319: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_IDESC_NULL');
1320: FND_MSG_PUB.ADD;
1321: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1323: END IF;
1324: END IF;

Line 1328: FND_MSG_PUB.ADD;

1324: END IF;
1325: -- One-time Item: UOM is mandatory
1326: IF (TRIM(p_po_req_line_tbl(i).UOM_CODE) IS NULL OR p_po_req_line_tbl(i).UOM_CODE = FND_API.G_MISS_CHAR) THEN
1327: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_UOM_CODE_NULL');
1328: FND_MSG_PUB.ADD;
1329: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1330: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1331: END IF;
1332: END IF;

Line 1338: FND_MSG_PUB.ADD;

1334:
1335: -- Quantity
1336: IF (p_po_req_line_tbl(i).QUANTITY IS NULL OR p_po_req_line_tbl(i).QUANTITY = FND_API.G_MISS_NUM) THEN
1337: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_NULL');
1338: FND_MSG_PUB.ADD;
1339: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1340: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1341: END IF;
1342: ELSE

Line 1346: FND_MSG_PUB.ADD;

1342: ELSE
1343: IF (p_po_req_line_tbl(i).QUANTITY <= 0) THEN
1344: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');
1345: FND_MESSAGE.Set_Token('QUANTITY', p_po_req_line_tbl(i).QUANTITY);
1346: FND_MSG_PUB.ADD;
1347: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1349: END IF;
1350: END IF;

Line 1356: FND_MSG_PUB.ADD;

1352:
1353: -- Need By Date
1354: IF (p_po_req_line_tbl(i).NEED_BY_DATE IS NULL OR p_po_req_line_tbl(i).NEED_BY_DATE = FND_API.G_MISS_DATE) THEN
1355: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NEED_BY_DATE_NULL');
1356: FND_MSG_PUB.ADD;
1357: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1358: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1359: END IF;
1360: ELSE

Line 1364: FND_MSG_PUB.ADD;

1360: ELSE
1361: IF (TRUNC(p_po_req_line_tbl(i).NEED_BY_DATE) < TRUNC(SYSDATE)) THEN
1362: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');
1363: FND_MESSAGE.Set_Token('NBDATE', p_po_req_line_tbl(i).NEED_BY_DATE);
1364: FND_MSG_PUB.ADD;
1365: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1366: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1367: END IF;
1368: END IF;

Line 1374: FND_MSG_PUB.ADD;

1370:
1371: -- Ship To Organization
1372: IF (p_po_req_line_tbl(i).SHIP_TO_ORG_ID IS NULL OR p_po_req_line_tbl(i).SHIP_TO_ORG_ID = FND_API.G_MISS_NUM) THEN
1373: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_ORG_NULL');
1374: FND_MSG_PUB.ADD;
1375: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1377: END IF;
1378: END IF;

Line 1383: FND_MSG_PUB.ADD;

1379:
1380: -- Line Type
1381: IF (p_po_req_line_tbl(i).PO_LINE_TYPE_ID IS NULL OR p_po_req_line_tbl(i).PO_LINE_TYPE_ID = FND_API.G_MISS_NUM) THEN
1382: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_NULL');
1383: FND_MSG_PUB.ADD;
1384: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1385: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1386: END IF;
1387: ELSE

Line 1393: FND_MSG_PUB.ADD;

1389: FETCH l_validate_line_type_csr INTO l_dummy;
1390: IF (l_validate_line_type_csr%NOTFOUND) THEN
1391: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');
1392: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_req_line_tbl(i).PO_LINE_TYPE_ID);
1393: FND_MSG_PUB.ADD;
1394: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1395: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1396: END IF;
1397: END IF;

Line 1475: FND_MSG_PUB.ADD;

1471: FETCH l_osp_dtls_csr INTO l_osp_dtls_rec;
1472: IF (l_osp_dtls_csr%NOTFOUND) THEN
1473: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');
1474: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);
1475: FND_MSG_PUB.ADD;
1476: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1477: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1478: END IF;
1479: CLOSE l_osp_dtls_csr;

Line 1765: FND_MSG_PUB.ADD;

1761: FETCH l_osp_line_dtls_csr INTO l_osp_line_dtls_rec;
1762: IF (l_osp_line_dtls_csr%NOTFOUND) THEN
1763: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');
1764: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);
1765: FND_MSG_PUB.ADD;
1766: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1768: END IF;
1769: CLOSE l_osp_line_dtls_csr;

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

1973:
1974: WHEN OTHERS THEN
1975: ROLLBACK TO Handle_Deleted_Req_Headers_pvt;
1976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1978: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1979: p_procedure_name => 'Handle_Deleted_Req_Headers',
1980: p_error_text => SUBSTR(SQLERRM,1,240));
1981: END IF;

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

1974: WHEN OTHERS THEN
1975: ROLLBACK TO Handle_Deleted_Req_Headers_pvt;
1976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1978: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1979: p_procedure_name => 'Handle_Deleted_Req_Headers',
1980: p_error_text => SUBSTR(SQLERRM,1,240));
1981: END IF;
1982: END Handle_Deleted_Req_Headers;

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

2132:
2133: WHEN OTHERS THEN
2134: ROLLBACK TO Handle_Cancelled_Req_Lines_pvt;
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2137: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2138: p_procedure_name => 'Handle_Cancelled_Req_Lines',
2139: p_error_text => SUBSTR(SQLERRM,1,240));
2140: END IF;

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

2133: WHEN OTHERS THEN
2134: ROLLBACK TO Handle_Cancelled_Req_Lines_pvt;
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2137: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2138: p_procedure_name => 'Handle_Cancelled_Req_Lines',
2139: p_error_text => SUBSTR(SQLERRM,1,240));
2140: END IF;
2141:

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

2281:
2282: WHEN OTHERS THEN
2283: ROLLBACK TO Handle_Deleted_Req_Lines_pvt;
2284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2285: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2286: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2287: p_procedure_name => 'Handle_Deleted_Req_Lines',
2288: p_error_text => SUBSTR(SQLERRM,1,240));
2289: END IF;

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

2282: WHEN OTHERS THEN
2283: ROLLBACK TO Handle_Deleted_Req_Lines_pvt;
2284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2285: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2286: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2287: p_procedure_name => 'Handle_Deleted_Req_Lines',
2288: p_error_text => SUBSTR(SQLERRM,1,240));
2289: END IF;
2290:

Line 2327: FND_MSG_PUB.ADD;

2323: END IF;
2324:
2325: IF (p_po_req_header_id IS NULL OR p_po_req_header_id = FND_API.G_MISS_NUM) THEN
2326: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_REQ_ID_NULL');
2327: FND_MSG_PUB.ADD;
2328: RETURN 'N';
2329: ELSE
2330: --validate the requisition_header_id. If it is not present, it may mean that user need to perform a PO Synch
2331: OPEN l_val_req_hdr_id_csr(p_po_req_header_id);

Line 2336: FND_MSG_PUB.ADD;

2332: FETCH l_val_req_hdr_id_csr INTO l_dummy;
2333: IF (l_val_req_hdr_id_csr%NOTFOUND) THEN
2334: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_REQ_HDR_ID_INV');
2335: FND_MESSAGE.Set_Token('REQ_HDR_ID', p_po_req_header_id);
2336: FND_MSG_PUB.ADD;
2337: CLOSE l_val_req_hdr_id_csr;
2338: RETURN 'N';
2339: END IF;
2340: CLOSE l_val_req_hdr_id_csr;