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_MESSAGE

Line 1143: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_NULL');

1139: END IF;
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;

Line 1152: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');

1148: ELSE
1149: OPEN l_validate_osp_csr(p_po_req_header_rec.OSP_ORDER_ID);
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);

Line 1153: FND_MESSAGE.Set_Token('OSP_ID', p_po_req_header_rec.OSP_ORDER_ID);

1149: OPEN l_validate_osp_csr(p_po_req_header_rec.OSP_ORDER_ID);
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;

Line 1164: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPPLIER_ID_NULL');

1160: END IF;
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;

Line 1173: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SUPP_INVALID');

1169: ELSE
1170: OPEN l_validate_supplier_csr(p_po_req_header_rec.VENDOR_ID);
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);

Line 1174: FND_MESSAGE.Set_Token('SUPP_ID', p_po_req_header_rec.VENDOR_ID);

1170: OPEN l_validate_supplier_csr(p_po_req_header_rec.VENDOR_ID);
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;

Line 1185: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_ID_NULL');

1181: END IF;
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;

Line 1194: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SSITE_INVALID');

1190: ELSE
1191: OPEN l_validate_supp_site_csr(p_po_req_header_rec.VENDOR_SITE_ID, p_po_req_header_rec.VENDOR_ID);
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);

Line 1195: FND_MESSAGE.Set_Token('SS_ID', p_po_req_header_rec.VENDOR_SITE_ID);

1191: OPEN l_validate_supp_site_csr(p_po_req_header_rec.VENDOR_SITE_ID, p_po_req_header_rec.VENDOR_ID);
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;

Line 1209: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_VCONTACT_INVALID');

1205: IF (p_po_req_header_rec.VENDOR_CONTACT_ID IS NOT NULL AND p_po_req_header_rec.VENDOR_CONTACT_ID <> FND_API.G_MISS_NUM) THEN
1206: OPEN l_validate_vendor_contact_csr(p_po_req_header_rec.VENDOR_CONTACT_ID, p_po_req_header_rec.VENDOR_SITE_ID);
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);

Line 1210: FND_MESSAGE.Set_Token('V_CONTACT_ID', p_po_req_header_rec.VENDOR_CONTACT_ID);

1206: OPEN l_validate_vendor_contact_csr(p_po_req_header_rec.VENDOR_CONTACT_ID, p_po_req_header_rec.VENDOR_SITE_ID);
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;

Line 1221: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_ID_NULL');

1217: END IF;
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;

Line 1230: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_BUYER_INVALID');

1226: ELSE
1227: OPEN l_validate_buyer_csr(p_po_req_header_rec.BUYER_ID);
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);

Line 1231: FND_MESSAGE.Set_Token('BUYER_ID', p_po_req_header_rec.BUYER_ID);

1227: OPEN l_validate_buyer_csr(p_po_req_header_rec.BUYER_ID);
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;

Line 1283: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');

1279:
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;

Line 1293: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NO_PO_LINES');

1289: END IF;
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;

Line 1308: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ITEM_INVALID');

1304: -- Non One-time Item
1305: OPEN l_validate_item_csr(p_po_req_line_tbl(i).ITEM_ID, p_po_req_line_tbl(i).SHIP_TO_ORG_ID);
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);

Line 1309: FND_MESSAGE.Set_Token('ITEM', p_po_req_line_tbl(i).ITEM_ID);

1305: OPEN l_validate_item_csr(p_po_req_line_tbl(i).ITEM_ID, p_po_req_line_tbl(i).SHIP_TO_ORG_ID);
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;

Line 1319: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_IDESC_NULL');

1315: CLOSE l_validate_item_csr;
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;

Line 1327: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_UOM_CODE_NULL');

1323: END IF;
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;

Line 1337: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_NULL');

1333: END IF;
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;

Line 1344: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_QUANTITY_INVALID');

1340: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1341: END IF;
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);

Line 1345: FND_MESSAGE.Set_Token('QUANTITY', p_po_req_line_tbl(i).QUANTITY);

1341: END IF;
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;

Line 1355: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NEED_BY_DATE_NULL');

1351: END IF;
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;

Line 1362: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_NBDATE_INVALID');

1358: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1359: END IF;
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);

Line 1363: FND_MESSAGE.Set_Token('NBDATE', p_po_req_line_tbl(i).NEED_BY_DATE);

1359: END IF;
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;

Line 1373: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_SHIP_TO_ORG_NULL');

1369: END IF;
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;

Line 1382: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_NULL');

1378: END IF;
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;

Line 1391: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_LN_TYPE_ID_INVALID');

1387: ELSE
1388: OPEN l_validate_line_type_csr(p_po_req_line_tbl(i).PO_LINE_TYPE_ID);
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);

Line 1392: FND_MESSAGE.Set_Token('LINE_TYPE_ID', p_po_req_line_tbl(i).PO_LINE_TYPE_ID);

1388: OPEN l_validate_line_type_csr(p_po_req_line_tbl(i).PO_LINE_TYPE_ID);
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;

Line 1473: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_ID_INVALID');

1469: -- Retrieve the current record
1470: OPEN l_osp_dtls_csr(p_osp_order_id);
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);

Line 1474: FND_MESSAGE.Set_Token('OSP_ID', p_osp_order_id);

1470: OPEN l_osp_dtls_csr(p_osp_order_id);
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;

Line 1763: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_OSP_LINE_ID_INVALID');

1759: -- Retrieve the current record
1760: OPEN l_osp_line_dtls_csr(p_osp_order_line_id);
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);

Line 1764: FND_MESSAGE.Set_Token('OSP_LINE_ID', p_osp_order_line_id);

1760: OPEN l_osp_line_dtls_csr(p_osp_order_line_id);
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;

Line 2326: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_REQ_ID_NULL');

2322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'PO_REQ_HEADER_ID: '|| p_po_req_header_id);
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

Line 2334: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_REQ_HDR_ID_INV');

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);
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';

Line 2335: FND_MESSAGE.Set_Token('REQ_HDR_ID', p_po_req_header_id);

2331: OPEN l_val_req_hdr_id_csr(p_po_req_header_id);
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;