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

Line 182: FND_MSG_PUB.Initialize;

178:
179: -- Initialize message list if p_init_msg_list is set to TRUE
180: IF FND_API.TO_BOOLEAN(p_init_msg_list)
181: THEN
182: FND_MSG_PUB.Initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 206: FND_MSG_PUB.ADD;

202: l_header_status := Get_MC_Status(null, p_x_node_rec.mc_header_id);
203: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
204: THEN
205: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
206: FND_MSG_PUB.ADD;
207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message
210: (

Line 246: FND_MSG_PUB.ADD;

242: IF (check_dup_poskey%FOUND)
243: THEN
244: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DUP_POSKEY');
245: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
246: FND_MSG_PUB.ADD;
247: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
248: THEN
249: fnd_log.message
250: (

Line 261: x_msg_count := FND_MSG_PUB.count_msg;

257: CLOSE check_dup_poskey;
258: END IF;
259:
260: -- Check Error Message stack.
261: x_msg_count := FND_MSG_PUB.count_msg;
262: IF x_msg_count > 0 THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:

Line 389: x_msg_count := FND_MSG_PUB.count_msg;

385: p_x_counter_rules_tbl(i)
386: );
387:
388: -- Check Error Message stack.
389: x_msg_count := FND_MSG_PUB.count_msg;
390: IF x_msg_count > 0 THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:

Line 425: x_msg_count := FND_MSG_PUB.count_msg;

421: p_x_subconfig_tbl(i)
422: );
423:
424: -- Check Error Message stack.
425: x_msg_count := FND_MSG_PUB.count_msg;
426: IF x_msg_count > 0 THEN
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429:

Line 457: x_msg_count := FND_MSG_PUB.count_msg;

453: END IF;
454: -- API body ends here
455:
456: -- Check Error Message stack.
457: x_msg_count := FND_MSG_PUB.count_msg;
458:
459: IF x_msg_count > 0 THEN
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;

Line 470: FND_MSG_PUB.count_and_get

466: COMMIT WORK;
467: END IF;
468:
469: -- Standard call to get message count and if count is 1, get message info
470: FND_MSG_PUB.count_and_get
471: (
472: p_count => x_msg_count,
473: p_data => x_msg_data,
474: p_encoded => FND_API.G_FALSE

Line 481: FND_MSG_PUB.count_and_get

477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: Rollback to Create_Node_SP;
481: FND_MSG_PUB.count_and_get
482: (
483: p_count => x_msg_count,
484: p_data => x_msg_data,
485: p_encoded => FND_API.G_FALSE

Line 491: FND_MSG_PUB.count_and_get

487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: Rollback to Create_Node_SP;
491: FND_MSG_PUB.count_and_get
492: (
493: p_count => x_msg_count,
494: p_data => x_msg_data,
495: p_encoded => FND_API.G_FALSE

Line 501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

497:
498: WHEN OTHERS THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: Rollback to Create_Node_SP;
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
502: THEN
503: FND_MSG_PUB.add_exc_msg
504: (
505: p_pkg_name => G_PKG_NAME,

Line 503: FND_MSG_PUB.add_exc_msg

499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: Rollback to Create_Node_SP;
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
502: THEN
503: FND_MSG_PUB.add_exc_msg
504: (
505: p_pkg_name => G_PKG_NAME,
506: p_procedure_name => 'Create_Node',
507: p_error_text => SUBSTR(SQLERRM,1,240)

Line 510: FND_MSG_PUB.count_and_get

506: p_procedure_name => 'Create_Node',
507: p_error_text => SUBSTR(SQLERRM,1,240)
508: );
509: END IF;
510: FND_MSG_PUB.count_and_get
511: (
512: p_count => x_msg_count,
513: p_data => x_msg_data,
514: p_encoded => FND_API.G_FALSE

Line 636: FND_MSG_PUB.Initialize;

632:
633: -- Initialize message list if p_init_msg_list is set to TRUE
634: IF FND_API.TO_BOOLEAN(p_init_msg_list)
635: THEN
636: FND_MSG_PUB.Initialize;
637: END IF;
638:
639: -- Initialize API return status to success
640: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 662: FND_MSG_PUB.ADD;

658: l_header_status := Get_MC_Status(null, p_x_node_rec.mc_header_id);
659: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
660: THEN
661: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
662: FND_MSG_PUB.ADD;
663: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
664: THEN
665: fnd_log.message
666: (

Line 703: FND_MSG_PUB.ADD;

699: IF (check_poskey_update%FOUND)
700: THEN
701: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSKEY_NOUPD');
702: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
703: FND_MSG_PUB.ADD;
704:
705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN
707: fnd_log.message

Line 721: x_msg_count := FND_MSG_PUB.count_msg;

717:
718: -- ER #2631303 is not valid since there can be no units created from DRAFT MCs
719:
720: -- Check Error Message stack.
721: x_msg_count := FND_MSG_PUB.count_msg;
722: IF x_msg_count > 0 THEN
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725:

Line 799: FND_MSG_PUB.ADD;

795: l_header_status := Get_MC_Status(p_x_node_rec.relationship_id, null);
796: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
797: THEN
798: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
799: FND_MSG_PUB.ADD;
800: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
801: THEN
802: fnd_log.message
803: (

Line 824: FND_MSG_PUB.ADD;

820: -- Validate active_end_date >= sysdate exists
821: IF (trunc(nvl(l_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
822: THEN
823: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
824: FND_MSG_PUB.ADD;
825: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
826: THEN
827: fnd_log.message
828: (

Line 837: x_msg_count := FND_MSG_PUB.count_msg;

833: END IF;
834: END IF;
835:
836: -- Check Error Message stack.
837: x_msg_count := FND_MSG_PUB.count_msg;
838: IF x_msg_count > 0 THEN
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:

Line 892: x_msg_count := FND_MSG_PUB.count_msg;

888: );
889: END IF;
890:
891: -- Check Error Message stack.
892: x_msg_count := FND_MSG_PUB.count_msg;
893: IF x_msg_count > 0 THEN
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896: END LOOP;

Line 928: x_msg_count := FND_MSG_PUB.count_msg;

924: );
925: END IF;
926:
927: -- Check Error Message stack.
928: x_msg_count := FND_MSG_PUB.count_msg;
929: IF x_msg_count > 0 THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932: END LOOP;

Line 949: x_msg_count := FND_MSG_PUB.count_msg;

945: END IF;
946: -- API body ends here
947:
948: -- Check Error Message stack.
949: x_msg_count := FND_MSG_PUB.count_msg;
950: IF x_msg_count > 0 THEN
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:

Line 982: FND_MSG_PUB.add;

978: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
979: FND_MESSAGE.Set_Token('POS', l_get_ata_top_node_rec.POSITION_REF_MEANING);
980: FND_MESSAGE.Set_Token('MC', l_get_ata_top_node_rec.NAME);
981: FND_MESSAGE.Set_Token('SUBCONFIG', p_x_node_rec.POSITION_REF_MEANING);
982: FND_MSG_PUB.add;
983: END IF;
984: END LOOP;
985:
986: CLOSE get_ata_for_top_node;

Line 1015: FND_MSG_PUB.add;

1011: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
1012: FND_MESSAGE.Set_Token('POS', p_x_node_rec.POSITION_REF_MEANING);
1013: FND_MESSAGE.Set_Token('MC',l_get_ata_leaf_node_rec.POSITION_REF_MEANING );
1014: FND_MESSAGE.Set_Token('SUBCONFIG', l_get_ata_leaf_node_rec.name);
1015: FND_MSG_PUB.add;
1016: END IF;
1017: END LOOP;
1018: CLOSE get_ata_for_leaf_node;
1019: END IF;

Line 1030: x_msg_count := FND_MSG_PUB.count_msg;

1026: COMMIT WORK;
1027: END IF;
1028:
1029: -- Check Error Message stack.
1030: x_msg_count := FND_MSG_PUB.count_msg;
1031:
1032: IF ( x_msg_count > 0 and x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;

Line 1037: FND_MSG_PUB.count_and_get

1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: -- Standard call to get message count and if count is 1, get message info
1037: FND_MSG_PUB.count_and_get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => FND_API.G_FALSE

Line 1048: FND_MSG_PUB.count_and_get

1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: Rollback to Modify_Node_SP;
1048: FND_MSG_PUB.count_and_get
1049: (
1050: p_count => x_msg_count,
1051: p_data => x_msg_data,
1052: p_encoded => FND_API.G_FALSE

Line 1058: FND_MSG_PUB.count_and_get

1054:
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: Rollback to Modify_Node_SP;
1058: FND_MSG_PUB.count_and_get
1059: (
1060: p_count => x_msg_count,
1061: p_data => x_msg_data,
1062: p_encoded => FND_API.G_FALSE

Line 1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1064:
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: Rollback to Modify_Node_SP;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1069: THEN
1070: FND_MSG_PUB.add_exc_msg
1071: (
1072: p_pkg_name => G_PKG_NAME,

Line 1070: FND_MSG_PUB.add_exc_msg

1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: Rollback to Modify_Node_SP;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1069: THEN
1070: FND_MSG_PUB.add_exc_msg
1071: (
1072: p_pkg_name => G_PKG_NAME,
1073: p_procedure_name => 'Modify_Node',
1074: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1077: FND_MSG_PUB.count_and_get

1073: p_procedure_name => 'Modify_Node',
1074: p_error_text => SUBSTR(SQLERRM,1,240)
1075: );
1076: END IF;
1077: FND_MSG_PUB.count_and_get
1078: (
1079: p_count => x_msg_count,
1080: p_data => x_msg_data,
1081: p_encoded => FND_API.G_FALSE

Line 1136: FND_MSG_PUB.Initialize;

1132:
1133: -- Initialize message list if p_init_msg_list is set to TRUE
1134: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1135: THEN
1136: FND_MSG_PUB.Initialize;
1137: END IF;
1138:
1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1161: FND_MSG_PUB.ADD;

1157: -- 6i. Validate that the config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
1158: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
1159: THEN
1160: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
1161: FND_MSG_PUB.ADD;
1162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1163: THEN
1164: fnd_log.message
1165: (

Line 1256: x_msg_count := FND_MSG_PUB.count_msg;

1252: END IF;
1253: -- API body ends here
1254:
1255: -- Check Error Message stack.
1256: x_msg_count := FND_MSG_PUB.count_msg;
1257: IF x_msg_count > 0 THEN
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:

Line 1268: FND_MSG_PUB.count_and_get

1264: COMMIT WORK;
1265: END IF;
1266:
1267: -- Standard call to get message count and if count is 1, get message info
1268: FND_MSG_PUB.count_and_get
1269: (
1270: p_count => x_msg_count,
1271: p_data => x_msg_data,
1272: p_encoded => FND_API.G_FALSE

Line 1279: FND_MSG_PUB.count_and_get

1275: EXCEPTION
1276: WHEN FND_API.G_EXC_ERROR THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: Rollback to Delete_Node_SP;
1279: FND_MSG_PUB.count_and_get
1280: (
1281: p_count => x_msg_count,
1282: p_data => x_msg_data,
1283: p_encoded => FND_API.G_FALSE

Line 1289: FND_MSG_PUB.count_and_get

1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: Rollback to Delete_Node_SP;
1289: FND_MSG_PUB.count_and_get
1290: (
1291: p_count => x_msg_count,
1292: p_data => x_msg_data,
1293: p_encoded => FND_API.G_FALSE

Line 1298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1294: );
1295: WHEN OTHERS THEN
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: Rollback to Delete_Node_SP;
1298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1299: THEN
1300: FND_MSG_PUB.add_exc_msg
1301: (
1302: p_pkg_name => G_PKG_NAME,

Line 1300: FND_MSG_PUB.add_exc_msg

1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: Rollback to Delete_Node_SP;
1298: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1299: THEN
1300: FND_MSG_PUB.add_exc_msg
1301: (
1302: p_pkg_name => G_PKG_NAME,
1303: p_procedure_name => 'Delete_Node',
1304: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1307: FND_MSG_PUB.count_and_get

1303: p_procedure_name => 'Delete_Node',
1304: p_error_text => SUBSTR(SQLERRM,1,240)
1305: );
1306: END IF;
1307: FND_MSG_PUB.count_and_get
1308: (
1309: p_count => x_msg_count,
1310: p_data => x_msg_data,
1311: p_encoded => FND_API.G_FALSE

Line 1355: FND_MSG_PUB.Initialize;

1351:
1352: -- Initialize message list if p_init_msg_list is set to TRUE
1353: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1354: THEN
1355: FND_MSG_PUB.Initialize;
1356: END IF;
1357:
1358: -- Initialize API return status to success
1359: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1381: FND_MSG_PUB.ADD;

1377: -- 3a. Validate that the config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
1378: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
1379: THEN
1380: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
1381: FND_MSG_PUB.ADD;
1382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1383: THEN
1384: fnd_log.message
1385: (

Line 1402: x_msg_count := FND_MSG_PUB.count_msg;

1398: -- 5. Validate p_x_node_rec.object_version_number for the MC node with RELATIONSHIP_ID = p_x_node_id
1399: Validate_Node_Exists(p_x_node_id, nvl(p_x_node_obj_ver_num, 0));
1400:
1401: -- Check Error Message stack.
1402: x_msg_count := FND_MSG_PUB.count_msg;
1403: IF x_msg_count > 0 THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406:

Line 1458: x_msg_count := FND_MSG_PUB.count_msg;

1454: END IF;
1455: -- API body ends here
1456:
1457: -- Check Error Message stack.
1458: x_msg_count := FND_MSG_PUB.count_msg;
1459: IF x_msg_count > 0 THEN
1460: RAISE FND_API.G_EXC_ERROR;
1461: END IF;
1462:

Line 1470: FND_MSG_PUB.count_and_get

1466: COMMIT WORK;
1467: END IF;
1468:
1469: -- Standard call to get message count and if count is 1, get message info
1470: FND_MSG_PUB.count_and_get
1471: (
1472: p_count => x_msg_count,
1473: p_data => x_msg_data,
1474: p_encoded => FND_API.G_FALSE

Line 1481: FND_MSG_PUB.count_and_get

1477: EXCEPTION
1478: WHEN FND_API.G_EXC_ERROR THEN
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: Rollback to Copy_Node_SP;
1481: FND_MSG_PUB.count_and_get
1482: (
1483: p_count => x_msg_count,
1484: p_data => x_msg_data,
1485: p_encoded => FND_API.G_FALSE

Line 1491: FND_MSG_PUB.count_and_get

1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: Rollback to Copy_Node_SP;
1491: FND_MSG_PUB.count_and_get
1492: (
1493: p_count => x_msg_count,
1494: p_data => x_msg_data,
1495: p_encoded => FND_API.G_FALSE

Line 1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1497:
1498: WHEN OTHERS THEN
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: Rollback to Copy_Node_SP;
1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1502: THEN
1503: FND_MSG_PUB.add_exc_msg
1504: (
1505: p_pkg_name => G_PKG_NAME,

Line 1503: FND_MSG_PUB.add_exc_msg

1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: Rollback to Copy_Node_SP;
1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1502: THEN
1503: FND_MSG_PUB.add_exc_msg
1504: (
1505: p_pkg_name => G_PKG_NAME,
1506: p_procedure_name => 'Copy_Node',
1507: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1510: FND_MSG_PUB.count_and_get

1506: p_procedure_name => 'Copy_Node',
1507: p_error_text => SUBSTR(SQLERRM,1,240)
1508: );
1509: END IF;
1510: FND_MSG_PUB.count_and_get
1511: (
1512: p_count => x_msg_count,
1513: p_data => x_msg_data,
1514: p_encoded => FND_API.G_FALSE

Line 1644: FND_MSG_PUB.Initialize;

1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE
1642: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1643: THEN
1644: FND_MSG_PUB.Initialize;
1645: END IF;
1646:
1647: -- Initialize API return status to success
1648: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1928: x_msg_count := FND_MSG_PUB.count_msg;

1924: p_x_subconfig_tbl => l_subconfig_tbl
1925: );
1926:
1927: -- Check Error Message stack.
1928: x_msg_count := FND_MSG_PUB.count_msg;
1929: IF x_msg_count > 0 THEN
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;
1932:

Line 1992: x_msg_count := FND_MSG_PUB.count_msg;

1988: x_msg_data => l_msg_data
1989: );
1990:
1991: -- Check Error Message stack.
1992: x_msg_count := FND_MSG_PUB.count_msg;
1993: IF x_msg_count > 0 THEN
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:

Line 2015: x_msg_count := FND_MSG_PUB.count_msg;

2011: l_nodes_tbl(i).relationship_id
2012: );
2013:
2014: -- Check Error Message stack.
2015: x_msg_count := FND_MSG_PUB.count_msg;
2016: IF x_msg_count > 0 THEN
2017: RAISE FND_API.G_EXC_ERROR;
2018: END IF;
2019: END LOOP;

Line 2034: x_msg_count := FND_MSG_PUB.count_msg;

2030: END IF;
2031: -- API body ends here
2032:
2033: -- Check Error Message stack.
2034: x_msg_count := FND_MSG_PUB.count_msg;
2035: IF x_msg_count > 0 THEN
2036: RAISE FND_API.G_EXC_ERROR;
2037: END IF;
2038:

Line 2046: FND_MSG_PUB.count_and_get

2042: COMMIT WORK;
2043: END IF;
2044:
2045: -- Standard call to get message count and if count is 1, get message info
2046: FND_MSG_PUB.count_and_get
2047: (
2048: p_count => x_msg_count,
2049: p_data => x_msg_data,
2050: p_encoded => FND_API.G_FALSE

Line 2057: FND_MSG_PUB.count_and_get

2053: EXCEPTION
2054: WHEN FND_API.G_EXC_ERROR THEN
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056: Rollback to Copy_MC_Nodes_SP;
2057: FND_MSG_PUB.count_and_get
2058: (
2059: p_count => x_msg_count,
2060: p_data => x_msg_data,
2061: p_encoded => FND_API.G_FALSE

Line 2067: FND_MSG_PUB.count_and_get

2063:
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: Rollback to Copy_MC_Nodes_SP;
2067: FND_MSG_PUB.count_and_get
2068: (
2069: p_count => x_msg_count,
2070: p_data => x_msg_data,
2071: p_encoded => FND_API.G_FALSE

Line 2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2073:
2074: WHEN OTHERS THEN
2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2076: Rollback to Copy_MC_Nodes_SP;
2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2078: THEN
2079: FND_MSG_PUB.add_exc_msg
2080: (
2081: p_pkg_name => G_PKG_NAME,

Line 2079: FND_MSG_PUB.add_exc_msg

2075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2076: Rollback to Copy_MC_Nodes_SP;
2077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2078: THEN
2079: FND_MSG_PUB.add_exc_msg
2080: (
2081: p_pkg_name => G_PKG_NAME,
2082: p_procedure_name => 'Copy_MC_Nodes',
2083: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2086: FND_MSG_PUB.count_and_get

2082: p_procedure_name => 'Copy_MC_Nodes',
2083: p_error_text => SUBSTR(SQLERRM,1,240)
2084: );
2085: END IF;
2086: FND_MSG_PUB.count_and_get
2087: (
2088: p_count => x_msg_count,
2089: p_data => x_msg_data,
2090: p_encoded => FND_API.G_FALSE

Line 2132: FND_MSG_PUB.Initialize;

2128:
2129: -- Initialize message list if p_init_msg_list is set to TRUE
2130: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2131: THEN
2132: FND_MSG_PUB.Initialize;
2133: END IF;
2134:
2135: -- Initialize API return status to success
2136: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2158: FND_MSG_PUB.ADD;

2154: -- FP #8410484
2155: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED', 'COMPLETE'))
2156: THEN
2157: FND_MESSAGE.Set_Name('AHL', 'AHL_DI_ASSO_UPDATE_ERROR');
2158: FND_MSG_PUB.ADD;
2159: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2160: THEN
2161: fnd_log.message
2162: (

Line 2176: x_msg_count := FND_MSG_PUB.count_msg;

2172: Set_Header_Status(p_node_id);
2173: END IF;
2174:
2175: -- Check Error Message stack.
2176: x_msg_count := FND_MSG_PUB.count_msg;
2177: IF x_msg_count > 0 THEN
2178: RAISE FND_API.G_EXC_ERROR;
2179: END IF;
2180:

Line 2203: FND_MSG_PUB.ADD;

2199: IF (p_x_documents_tbl(i).REVISION_NO IS NULL AND p_x_documents_tbl(i).dml_operation <> G_DML_DELETE)
2200: THEN
2201: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_NO_REV');
2202: FND_MESSAGE.Set_Token('DOC', p_x_documents_tbl(i).DOCUMENT_NO);
2203: FND_MSG_PUB.ADD;
2204: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2205: THEN
2206: fnd_log.message
2207: (

Line 2217: x_msg_count := FND_MSG_PUB.count_msg;

2213: END IF;
2214: END LOOP;
2215:
2216: -- Check Error Message stack.
2217: x_msg_count := FND_MSG_PUB.count_msg;
2218: IF x_msg_count > 0 THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221:

Line 2259: x_msg_count := FND_MSG_PUB.count_msg;

2255: END IF;
2256: -- API body ends here
2257:
2258: -- Check Error Message stack.
2259: x_msg_count := FND_MSG_PUB.count_msg;
2260: IF x_msg_count > 0 THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263:

Line 2271: FND_MSG_PUB.count_and_get

2267: COMMIT WORK;
2268: END IF;
2269:
2270: -- Standard call to get message count and if count is 1, get message info
2271: FND_MSG_PUB.count_and_get
2272: (
2273: p_count => x_msg_count,
2274: p_data => x_msg_data,
2275: p_encoded => FND_API.G_FALSE

Line 2282: FND_MSG_PUB.count_and_get

2278: EXCEPTION
2279: WHEN FND_API.G_EXC_ERROR THEN
2280: x_return_status := FND_API.G_RET_STS_ERROR;
2281: Rollback to Process_Documents_SP;
2282: FND_MSG_PUB.count_and_get
2283: (
2284: p_count => x_msg_count,
2285: p_data => x_msg_data,
2286: p_encoded => FND_API.G_FALSE

Line 2292: FND_MSG_PUB.count_and_get

2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: Rollback to Process_Documents_SP;
2292: FND_MSG_PUB.count_and_get
2293: (
2294: p_count => x_msg_count,
2295: p_data => x_msg_data,
2296: p_encoded => FND_API.G_FALSE

Line 2302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2298:
2299: WHEN OTHERS THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: Rollback to Process_Documents_SP;
2302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2303: THEN
2304: FND_MSG_PUB.add_exc_msg
2305: (
2306: p_pkg_name => G_PKG_NAME,

Line 2304: FND_MSG_PUB.add_exc_msg

2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: Rollback to Process_Documents_SP;
2302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2303: THEN
2304: FND_MSG_PUB.add_exc_msg
2305: (
2306: p_pkg_name => G_PKG_NAME,
2307: p_procedure_name => 'Process_Documents',
2308: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2311: FND_MSG_PUB.count_and_get

2307: p_procedure_name => 'Process_Documents',
2308: p_error_text => SUBSTR(SQLERRM,1,240)
2309: );
2310: END IF;
2311: FND_MSG_PUB.count_and_get
2312: (
2313: p_count => x_msg_count,
2314: p_data => x_msg_data,
2315: p_encoded => FND_API.G_FALSE

Line 2378: FND_MSG_PUB.Initialize;

2374:
2375: -- Initialize message list if p_init_msg_list is set to TRUE
2376: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2377: THEN
2378: FND_MSG_PUB.Initialize;
2379: END IF;
2380:
2381: -- Initialize API return status to success
2382: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2404: FND_MSG_PUB.ADD;

2400: l_header_status := Get_MC_Status(p_nodes_tbl(i).relationship_id, null);
2401: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
2402: THEN
2403: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
2404: FND_MSG_PUB.ADD;
2405: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2406: THEN
2407: fnd_log.message
2408: (

Line 2433: FND_MSG_PUB.ADD;

2429: IF (get_item_group_det%NOTFOUND)
2430: THEN
2431: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2432: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_id);
2433: FND_MSG_PUB.ADD;
2434: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2435: THEN
2436: fnd_log.message
2437: (

Line 2449: FND_MSG_PUB.ADD;

2445: l_item_group_id := p_nodes_tbl(i).item_group_id;
2446: ELSE
2447: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2448: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
2449: FND_MSG_PUB.ADD;
2450: END IF;
2451:
2452: END IF;
2453: CLOSE get_item_group_det;

Line 2462: FND_MSG_PUB.ADD;

2458: IF (get_item_group_csr%NOTFOUND)
2459: THEN
2460: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2461: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_name);
2462: FND_MSG_PUB.ADD;
2463: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2464: THEN
2465: fnd_log.message
2466: (

Line 2475: FND_MSG_PUB.ADD;

2471: END IF;
2472: ELSIF l_type_code <> 'TRACKED' THEN
2473: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2474: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
2475: FND_MSG_PUB.ADD;
2476: END IF;
2477: CLOSE get_item_group_csr;
2478: ELSE
2479: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_NULL');

Line 2480: FND_MSG_PUB.ADD;

2476: END IF;
2477: CLOSE get_item_group_csr;
2478: ELSE
2479: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_NULL');
2480: FND_MSG_PUB.ADD;
2481: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2482: THEN
2483: fnd_log.message
2484: (

Line 2503: x_msg_count := FND_MSG_PUB.count_msg;

2499: );
2500: END IF;
2501:
2502: -- Check Error Message stack.
2503: x_msg_count := FND_MSG_PUB.count_msg;
2504: IF x_msg_count > 0 THEN
2505: RAISE FND_API.G_EXC_ERROR;
2506: END IF;
2507:

Line 2536: x_msg_count := FND_MSG_PUB.count_msg;

2532: END IF;
2533: -- API body ends here
2534:
2535: -- Check Error Message stack.
2536: x_msg_count := FND_MSG_PUB.count_msg;
2537: IF x_msg_count > 0 THEN
2538: RAISE FND_API.G_EXC_ERROR;
2539: END IF;
2540:

Line 2548: FND_MSG_PUB.count_and_get

2544: COMMIT WORK;
2545: END IF;
2546:
2547: -- Standard call to get message count and if count is 1, get message info
2548: FND_MSG_PUB.count_and_get
2549: (
2550: p_count => x_msg_count,
2551: p_data => x_msg_data,
2552: p_encoded => FND_API.G_FALSE

Line 2559: FND_MSG_PUB.count_and_get

2555: EXCEPTION
2556: WHEN FND_API.G_EXC_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_ERROR;
2558: Rollback to Associate_Item_Group_SP;
2559: FND_MSG_PUB.count_and_get
2560: (
2561: p_count => x_msg_count,
2562: p_data => x_msg_data,
2563: p_encoded => FND_API.G_FALSE

Line 2569: FND_MSG_PUB.count_and_get

2565:
2566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2568: Rollback to Associate_Item_Group_SP;
2569: FND_MSG_PUB.count_and_get
2570: (
2571: p_count => x_msg_count,
2572: p_data => x_msg_data,
2573: p_encoded => FND_API.G_FALSE

Line 2579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2575:
2576: WHEN OTHERS THEN
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578: Rollback to Associate_Item_Group_SP;
2579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2580: THEN
2581: FND_MSG_PUB.add_exc_msg
2582: (
2583: p_pkg_name => G_PKG_NAME,

Line 2581: FND_MSG_PUB.add_exc_msg

2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578: Rollback to Associate_Item_Group_SP;
2579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2580: THEN
2581: FND_MSG_PUB.add_exc_msg
2582: (
2583: p_pkg_name => G_PKG_NAME,
2584: p_procedure_name => 'Associate_Item_Group',
2585: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2588: FND_MSG_PUB.count_and_get

2584: p_procedure_name => 'Associate_Item_Group',
2585: p_error_text => SUBSTR(SQLERRM,1,240)
2586: );
2587: END IF;
2588: FND_MSG_PUB.count_and_get
2589: (
2590: p_count => x_msg_count,
2591: p_data => x_msg_data,
2592: p_encoded => FND_API.G_FALSE

Line 2620: FND_MSG_PUB.ADD;

2616: FETCH check_node_exists INTO l_dummy_number;
2617: IF (check_node_exists%NOTFOUND)
2618: THEN
2619: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');
2620: FND_MSG_PUB.ADD;
2621: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2622: THEN
2623: fnd_log.message
2624: (

Line 2635: FND_MSG_PUB.ADD;

2631: RAISE FND_API.G_EXC_ERROR;
2632: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
2633: THEN
2634: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
2635: FND_MSG_PUB.ADD;
2636: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2637: THEN
2638: fnd_log.message
2639: (

Line 2758: FND_MSG_PUB.ADD;

2754: IF (get_node_details%NOTFOUND)
2755: THEN
2756: -- 2a. Validate that the parent node exists
2757: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_INVALID');
2758: FND_MSG_PUB.ADD;
2759: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2760: THEN
2761: fnd_log.message
2762: (

Line 2778: FND_MSG_PUB.ADD;

2774: -- 2c. Validate that the parent node has quantity = 1 [only in this can a child node be added to the parent position]
2775: IF (l_qty <> 1)
2776: THEN
2777: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_QTY_INV');
2778: FND_MSG_PUB.ADD;
2779: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2780: THEN
2781: fnd_log.message
2782: (

Line 2794: FND_MSG_PUB.ADD;

2790: -- 2d. Validate for the parent node active_end_date > SYSDATE
2791: IF (trunc(nvl(l_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
2792: THEN
2793: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_DATE_INV');
2794: FND_MSG_PUB.ADD;
2795: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2796: THEN
2797: fnd_log.message
2798: (

Line 2812: FND_MSG_PUB.ADD;

2808: FETCH check_subconfig_assos INTO l_dummy_varchar;
2809: IF (check_subconfig_assos%FOUND)
2810: THEN
2811: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_HAS_SUBMC');
2812: FND_MSG_PUB.ADD;
2813: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2814: THEN
2815: fnd_log.message
2816: (

Line 2832: FND_MSG_PUB.ADD;

2828: IF (check_dup_pos_ref%FOUND)
2829: THEN
2830: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARCHD_INVALID');
2831: FND_MESSAGE.Set_Token('CHILD', p_x_node_rec.position_ref_meaning);
2832: FND_MSG_PUB.ADD;
2833: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2834: THEN
2835: fnd_log.message
2836: (

Line 2853: FND_MSG_PUB.ADD;

2849: FETCH check_topnode_exists INTO l_dummy_varchar;
2850: IF (check_topnode_exists%FOUND)
2851: THEN
2852: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_EXISTS');
2853: FND_MSG_PUB.ADD;
2854: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2855: THEN
2856: fnd_log.message
2857: (

Line 2876: FND_MSG_PUB.ADD;

2872: IF (p_x_node_rec.position_ref_meaning IS NULL)
2873: THEN
2874: -- This is a mandatory field, hence throw error
2875: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_NULL');
2876: FND_MSG_PUB.ADD;
2877: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2878: THEN
2879: fnd_log.message
2880: (

Line 2899: FND_MSG_PUB.ADD;

2895: IF NOT (l_ret_val)
2896: THEN
2897: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_INVALID');
2898: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2899: FND_MSG_PUB.ADD;
2900: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2901: THEN
2902: fnd_log.message
2903: (

Line 2917: FND_MSG_PUB.ADD;

2913: IF (p_x_node_rec.position_necessity_code IS NULL)
2914: THEN
2915: -- This is a mandatory field, hence throw error
2916: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_NULL');
2917: FND_MSG_PUB.ADD;
2918: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2919: THEN
2920: fnd_log.message
2921: (

Line 2932: FND_MSG_PUB.ADD;

2928: THEN
2929: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');
2930: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2931: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
2932: FND_MSG_PUB.ADD;
2933: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2934: THEN
2935: fnd_log.message
2936: (

Line 2955: FND_MSG_PUB.ADD;

2951: IF (get_item_group_id%NOTFOUND)
2952: THEN
2953: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2954: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);
2955: FND_MSG_PUB.ADD;
2956: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2957: THEN
2958: fnd_log.message
2959: (

Line 2977: FND_MSG_PUB.ADD;

2973: FETCH check_item_assos_qty INTO l_dummy_varchar;
2974: IF (check_item_assos_qty%FOUND)
2975: THEN
2976: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEM_ASSOS_QTY_INV');
2977: FND_MSG_PUB.ADD;
2978: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2979: THEN
2980: fnd_log.message
2981: (

Line 2996: FND_MSG_PUB.ADD;

2992: IF (l_ig_type <> 'TRACKED')
2993: THEN
2994: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2995: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);
2996: FND_MSG_PUB.ADD;
2997: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2998: THEN
2999: fnd_log.message
3000: (

Line 3013: FND_MSG_PUB.ADD;

3009: IF (l_ig_status = 'REMOVED')
3010: THEN
3011: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_STS_INV');
3012: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);
3013: FND_MSG_PUB.ADD;
3014: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3015: THEN
3016: fnd_log.message
3017: (

Line 3036: FND_MSG_PUB.ADD;

3032: IF (p_x_node_rec.quantity IS NULL)
3033: THEN
3034: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_NULL');
3035: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3036: FND_MSG_PUB.ADD;
3037: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3038: THEN
3039: fnd_log.message
3040: (

Line 3051: FND_MSG_PUB.ADD;

3047: THEN
3048: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_INVALID');
3049: FND_MESSAGE.Set_Token('QTY', p_x_node_rec.quantity);
3050: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3051: FND_MSG_PUB.ADD;
3052: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3053: THEN
3054: fnd_log.message
3055: (

Line 3069: FND_MSG_PUB.ADD;

3065: IF (check_child_exists%FOUND)
3066: THEN
3067: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PAR_QTY_INV');
3068: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3069: FND_MSG_PUB.ADD;
3070: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3071: THEN
3072: fnd_log.message
3073: (

Line 3088: FND_MSG_PUB.ADD;

3084: IF (p_x_node_rec.display_order IS NULL)
3085: THEN
3086: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_NULL');
3087: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3088: FND_MSG_PUB.ADD;
3089: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3090: THEN
3091: fnd_log.message
3092: (

Line 3103: FND_MSG_PUB.ADD;

3099: THEN
3100: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_INVALID');
3101: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3102: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3103: FND_MSG_PUB.ADD;
3104: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3105: THEN
3106: fnd_log.message
3107: (

Line 3122: FND_MSG_PUB.ADD;

3118: THEN
3119: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_EXISTS');
3120: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3121: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3122: FND_MSG_PUB.ADD;
3123: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3124: THEN
3125: fnd_log.message
3126: (

Line 3141: FND_MSG_PUB.ADD;

3137: IF (p_x_node_rec.uom_code IS NULL)
3138: THEN
3139: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');
3140: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3141: FND_MSG_PUB.ADD;
3142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3143: THEN
3144: fnd_log.message
3145: (

Line 3159: FND_MSG_PUB.ADD;

3155: THEN
3156: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3157: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3158: FND_MESSAGE.Set_Token('UOM', p_x_node_rec.uom_code);
3159: FND_MSG_PUB.ADD;
3160: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3161: THEN
3162: fnd_log.message
3163: (

Line 3187: FND_MSG_PUB.ADD;

3183:
3184: IF (G_TRUNC_DATE >= trunc(nvl(l_end_date, G_SYSDATE + 1)))
3185: THEN
3186: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_DATE_INV');
3187: FND_MSG_PUB.ADD;
3188: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3189: THEN
3190: fnd_log.message
3191: (

Line 3202: FND_MSG_PUB.ADD;

3198:
3199: IF (p_x_node_rec.active_start_date IS NOT NULL AND trunc(nvl(l_start_date, G_SYSDATE)) <> trunc(p_x_node_rec.active_start_date) AND trunc(p_x_node_rec.active_start_date) < G_TRUNC_DATE)
3200: THEN
3201: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
3202: FND_MSG_PUB.ADD;
3203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3204: THEN
3205: fnd_log.message
3206: (

Line 3217: FND_MSG_PUB.ADD;

3213:
3214: IF (trunc(nvl(l_end_date, G_SYSDATE)) <> trunc(nvl(p_x_node_rec.active_end_date, G_SYSDATE)) AND trunc(nvl(p_x_node_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
3215: THEN
3216: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
3217: FND_MSG_PUB.ADD;
3218: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3219: THEN
3220: fnd_log.message
3221: (

Line 3233: FND_MSG_PUB.ADD;

3229: THEN
3230: IF (trunc(nvl(p_x_node_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)
3231: THEN
3232: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
3233: FND_MSG_PUB.ADD;
3234: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3235: THEN
3236: fnd_log.message
3237: (

Line 3248: FND_MSG_PUB.ADD;

3244:
3245: IF (trunc(nvl(p_x_node_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
3246: THEN
3247: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
3248: FND_MSG_PUB.ADD;
3249: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3250: THEN
3251: fnd_log.message
3252: (

Line 3264: FND_MSG_PUB.ADD;

3260:
3261: IF (p_x_node_rec.operation_flag <> G_DML_COPY AND trunc(nvl(p_x_node_rec.active_end_date, nvl(p_x_node_rec.active_start_date, G_SYSDATE) + 1)) <= trunc(nvl(p_x_node_rec.active_start_date, G_SYSDATE)))
3262: THEN
3263: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
3264: FND_MSG_PUB.ADD;
3265: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3266: THEN
3267: fnd_log.message
3268: (

Line 3298: FND_MSG_PUB.ADD;

3294: FETCH check_counter_exists INTO l_dummy_number;
3295: IF (check_counter_exists%NOTFOUND)
3296: THEN
3297: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTR_NOT_FOUND');
3298: FND_MSG_PUB.ADD;
3299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3300: THEN
3301: fnd_log.message
3302: (

Line 3313: FND_MSG_PUB.ADD;

3309: RAISE FND_API.G_EXC_ERROR;
3310: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
3311: THEN
3312: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
3313: FND_MSG_PUB.ADD;
3314: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3315: THEN
3316: fnd_log.message
3317: (

Line 3366: FND_MSG_PUB.ADD;

3362: IF (p_counter_rule_rec.uom_code IS NULL)
3363: THEN
3364: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');
3365: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3366: FND_MSG_PUB.ADD;
3367: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3368: THEN
3369: fnd_log.message
3370: (

Line 3384: FND_MSG_PUB.ADD;

3380: THEN
3381: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3382: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3383: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3384: FND_MSG_PUB.ADD;
3385: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3386: THEN
3387: fnd_log.message
3388: (

Line 3403: FND_MSG_PUB.ADD;

3399: IF (p_counter_rule_rec.rule_code IS NULL)
3400: THEN
3401: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_NULL');
3402: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3403: FND_MSG_PUB.ADD;
3404: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3405: THEN
3406: fnd_log.message
3407: (

Line 3418: FND_MSG_PUB.ADD;

3414: THEN
3415: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_INVALID');
3416: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3417: FND_MESSAGE.Set_Token('RULE_CODE', p_counter_rule_rec.rule_meaning);
3418: FND_MSG_PUB.ADD;
3419: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3420: THEN
3421: fnd_log.message
3422: (

Line 3439: FND_MSG_PUB.ADD;

3435: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTRRULE_EXISTS');
3436: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3437: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3438: FND_MESSAGE.Set_Token('RULE', p_counter_rule_rec.rule_code);
3439: FND_MSG_PUB.ADD;
3440: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3441: THEN
3442: fnd_log.message
3443: (

Line 3458: FND_MSG_PUB.ADD;

3454: THEN
3455: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RATIO_INVALID');
3456: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3457: FND_MESSAGE.Set_Token('RATIO', p_counter_rule_rec.ratio);
3458: FND_MSG_PUB.ADD;
3459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3460: THEN
3461: fnd_log.message
3462: (

Line 3492: FND_MSG_PUB.ADD;

3488: FETCH check_submc_exists INTO l_dummy_number;
3489: IF (check_submc_exists%NOTFOUND)
3490: THEN
3491: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NOT_FOUND');
3492: FND_MSG_PUB.ADD;
3493: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3494: THEN
3495: fnd_log.message
3496: (

Line 3507: FND_MSG_PUB.ADD;

3503: RAISE FND_API.G_EXC_ERROR;
3504: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
3505: THEN
3506: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
3507: FND_MSG_PUB.ADD;
3508: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3509: THEN
3510: fnd_log.message
3511: (

Line 3548: FND_MSG_PUB.ADD;

3544: FETCH check_priority_dup_exists INTO l_priority;
3545: IF (check_priority_dup_exists%FOUND)
3546: THEN
3547: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');
3548: FND_MSG_PUB.ADD;
3549: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3550: THEN
3551: fnd_log.message
3552: (

Line 3626: FND_MSG_PUB.ADD;

3622:
3623: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
3624: FND_MESSAGE.Set_Token('MC', l_mc_name);
3625: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
3626: FND_MSG_PUB.ADD;
3627: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3628: THEN
3629: fnd_log.message
3630: (

Line 3676: FND_MSG_PUB.ADD;

3672: FETCH get_node_mc_status INTO l_status;
3673: IF (get_node_mc_status%NOTFOUND)
3674: THEN
3675: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_FOUND');
3676: FND_MSG_PUB.ADD;
3677: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3678: THEN
3679: fnd_log.message
3680: (

Line 3697: FND_MSG_PUB.ADD;

3693: FETCH get_mc_status INTO l_status;
3694: IF (get_mc_status%NOTFOUND)
3695: THEN
3696: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_FOUND');
3697: FND_MSG_PUB.ADD;
3698: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3699: THEN
3700: fnd_log.message
3701: (

Line 3861: l_msg_count := FND_MSG_PUB.count_msg;

3857: -- Validate UOM, Rule and Ratio for the counter rule
3858: Validate_Counter_Rule(p_x_counter_rule_rec);
3859:
3860: -- Check Error Message stack.
3861: l_msg_count := FND_MSG_PUB.count_msg;
3862: IF l_msg_count > 0 THEN
3863: RAISE FND_API.G_EXC_ERROR;
3864: END IF;
3865:

Line 4000: l_msg_count := FND_MSG_PUB.count_msg;

3996: -- Validate UOM, Rule and Ratio for the counter rule
3997: Validate_Counter_Rule(p_x_counter_rule_rec);
3998:
3999: -- Check Error Message stack.
4000: l_msg_count := FND_MSG_PUB.count_msg;
4001: IF l_msg_count > 0 THEN
4002: RAISE FND_API.G_EXC_ERROR;
4003: END IF;
4004:

Line 4174: FND_MSG_PUB.ADD;

4170: FETCH check_root_node INTO l_dummy_varchar;
4171: IF (check_root_node%FOUND)
4172: THEN
4173: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_TOP_NODE');
4174: FND_MSG_PUB.ADD;
4175: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4176: THEN
4177: fnd_log.message
4178: (

Line 4193: FND_MSG_PUB.ADD;

4189: FETCH check_leaf_node INTO l_dummy_varchar;
4190: IF (check_leaf_node%FOUND)
4191: THEN
4192: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4193: FND_MSG_PUB.ADD;
4194: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4195: THEN
4196: fnd_log.message
4197: (

Line 4212: FND_MSG_PUB.ADD;

4208: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4209: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4210: THEN
4211: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4212: FND_MSG_PUB.ADD;
4213: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4214: THEN
4215: fnd_log.message
4216: (

Line 4232: FND_MSG_PUB.ADD;

4228: IF (check_submc_exists%FOUND)
4229: THEN
4230: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');
4231: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);
4232: FND_MSG_PUB.ADD;
4233: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4234: THEN
4235: fnd_log.message
4236: (

Line 4265: FND_MSG_PUB.ADD;

4261: CLOSE get_mc_details;
4262: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4263: FND_MESSAGE.Set_Token('MC', l_mc_name);
4264: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4265: FND_MSG_PUB.ADD;
4266: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4267: THEN
4268: fnd_log.message
4269: (

Line 4279: l_msg_count := FND_MSG_PUB.count_msg;

4275: END IF;
4276:
4277:
4278: -- Check Error Message stack.
4279: l_msg_count := FND_MSG_PUB.count_msg;
4280: IF l_msg_count > 0 THEN
4281: RAISE FND_API.G_EXC_ERROR;
4282: END IF;
4283:

Line 4288: FND_MSG_PUB.ADD;

4284: -- Validate dates for the subconfig association
4285: IF (trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)
4286: THEN
4287: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4288: FND_MSG_PUB.ADD;
4289: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4290: THEN
4291: fnd_log.message
4292: (

Line 4303: FND_MSG_PUB.ADD;

4299:
4300: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
4301: THEN
4302: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4303: FND_MSG_PUB.ADD;
4304: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4305: THEN
4306: fnd_log.message
4307: (

Line 4318: FND_MSG_PUB.ADD;

4314:
4315: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE) + 1)) <= trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)))
4316: THEN
4317: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4318: FND_MSG_PUB.ADD;
4319: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4320: THEN
4321: fnd_log.message
4322: (

Line 4334: FND_MSG_PUB.ADD;

4330: IF (p_x_subconfig_rec.priority IS NULL)
4331: THEN
4332: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4333: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4334: FND_MSG_PUB.ADD;
4335: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4336: THEN
4337: fnd_log.message
4338: (

Line 4347: FND_MSG_PUB.ADD;

4343: END IF;
4344: ELSIF (p_x_subconfig_rec.priority <= 0)
4345: THEN
4346: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4347: FND_MSG_PUB.ADD;
4348: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4349: THEN
4350: fnd_log.message
4351: (

Line 4360: l_msg_count := FND_MSG_PUB.count_msg;

4356: END IF;
4357: END IF;
4358:
4359: -- Check Error Message stack.
4360: l_msg_count := FND_MSG_PUB.count_msg;
4361: IF l_msg_count > 0 THEN
4362: RAISE FND_API.G_EXC_ERROR;
4363: END IF;
4364:

Line 4497: FND_MSG_PUB.ADD;

4493: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4494: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4495: THEN
4496: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4497: FND_MSG_PUB.ADD;
4498: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4499: THEN
4500: fnd_log.message
4501: (

Line 4520: FND_MSG_PUB.ADD;

4516: -- Should be able to unexpire an expired subconfiguration association
4517: IF (G_TRUNC_DATE >= trunc(nvl(l_end_date, G_SYSDATE + 1)))
4518: THEN
4519: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_DATE_INV');
4520: FND_MSG_PUB.ADD;
4521: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4522: THEN
4523: fnd_log.message
4524: (

Line 4536: FND_MSG_PUB.ADD;

4532:
4533: IF (p_x_subconfig_rec.active_start_date IS NOT NULL AND trunc(nvl(l_start_date, G_SYSDATE)) <> trunc(p_x_subconfig_rec.active_start_date) AND trunc(p_x_subconfig_rec.active_start_date) < G_TRUNC_DATE)
4534: THEN
4535: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4536: FND_MSG_PUB.ADD;
4537: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4538: THEN
4539: fnd_log.message
4540: (

Line 4551: FND_MSG_PUB.ADD;

4547:
4548: IF (trunc(nvl(l_end_date, G_SYSDATE)) <> trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE)) AND trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
4549: THEN
4550: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4551: FND_MSG_PUB.ADD;
4552: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4553: THEN
4554: fnd_log.message
4555: (

Line 4566: FND_MSG_PUB.ADD;

4562:
4563: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE) + 1)) <= trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)))
4564: THEN
4565: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4566: FND_MSG_PUB.ADD;
4567: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4568: THEN
4569: fnd_log.message
4570: (

Line 4583: FND_MSG_PUB.ADD;

4579: IF (p_x_subconfig_rec.priority IS NULL)
4580: THEN
4581: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4582: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4583: FND_MSG_PUB.ADD;
4584: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4585: THEN
4586: fnd_log.message
4587: (

Line 4596: FND_MSG_PUB.ADD;

4592: END IF;
4593: ELSIF (p_x_subconfig_rec.priority <= 0)
4594: THEN
4595: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4596: FND_MSG_PUB.ADD;
4597: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4598: THEN
4599: fnd_log.message
4600: (

Line 4610: l_msg_count := FND_MSG_PUB.count_msg;

4606:
4607: END IF;
4608:
4609: -- Check Error Message stack.
4610: l_msg_count := FND_MSG_PUB.count_msg;
4611: IF l_msg_count > 0 THEN
4612: RAISE FND_API.G_EXC_ERROR;
4613: END IF;
4614:

Line 4777: l_msg_count := FND_MSG_PUB.count_msg;

4773: -- Validate p_dest_rel_id exists
4774: Validate_Node_Exists(p_dest_rel_id, null);
4775:
4776: -- Check Error Message stack.
4777: l_msg_count := FND_MSG_PUB.count_msg;
4778: IF l_msg_count > 0 THEN
4779: RAISE FND_API.G_EXC_ERROR;
4780: END IF;
4781:

Line 4804: FND_MSG_PUB.ADD;

4800: FETCH check_leaf_node INTO l_dummy_varchar;
4801: IF (check_leaf_node%FOUND)
4802: THEN
4803: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4804: FND_MSG_PUB.ADD;
4805: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4806: THEN
4807: fnd_log.message
4808: (

Line 4840: FND_MSG_PUB.ADD;

4836: CLOSE get_mc_details;
4837: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4838: FND_MESSAGE.Set_Token('MC', l_mc_name);
4839: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4840: FND_MSG_PUB.ADD;
4841: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4842: THEN
4843: fnd_log.message
4844: (

Line 4852: l_msg_count := FND_MSG_PUB.count_msg;

4848: );
4849: END IF;
4850: END IF;
4851: -- Check Error Message stack.
4852: l_msg_count := FND_MSG_PUB.count_msg;
4853: IF l_msg_count > 0 THEN
4854: RAISE FND_API.G_EXC_ERROR;
4855: END IF;
4856: