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 2157: FND_MSG_PUB.ADD;

2153: -- 6i. Validate that the config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
2154: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
2155: THEN
2156: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_STS_INV');
2157: FND_MSG_PUB.ADD;
2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2159: THEN
2160: fnd_log.message
2161: (

Line 2175: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 2202: FND_MSG_PUB.ADD;

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

Line 2216: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 2258: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 2270: FND_MSG_PUB.count_and_get

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

Line 2281: FND_MSG_PUB.count_and_get

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

Line 2291: FND_MSG_PUB.count_and_get

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

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

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

Line 2303: FND_MSG_PUB.add_exc_msg

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

Line 2310: FND_MSG_PUB.count_and_get

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

Line 2376: FND_MSG_PUB.Initialize;

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

Line 2402: FND_MSG_PUB.ADD;

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

Line 2431: FND_MSG_PUB.ADD;

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

Line 2447: FND_MSG_PUB.ADD;

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

Line 2460: FND_MSG_PUB.ADD;

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

Line 2473: FND_MSG_PUB.ADD;

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

Line 2478: FND_MSG_PUB.ADD;

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

Line 2501: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 2534: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 2546: FND_MSG_PUB.count_and_get

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

Line 2557: FND_MSG_PUB.count_and_get

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

Line 2567: FND_MSG_PUB.count_and_get

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

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

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

Line 2579: FND_MSG_PUB.add_exc_msg

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

Line 2586: FND_MSG_PUB.count_and_get

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

Line 2618: FND_MSG_PUB.ADD;

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

Line 2633: FND_MSG_PUB.ADD;

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

Line 2755: FND_MSG_PUB.ADD;

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

Line 2775: FND_MSG_PUB.ADD;

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

Line 2791: FND_MSG_PUB.ADD;

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

Line 2809: FND_MSG_PUB.ADD;

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

Line 2829: FND_MSG_PUB.ADD;

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

Line 2850: FND_MSG_PUB.ADD;

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

Line 2873: FND_MSG_PUB.ADD;

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

Line 2896: FND_MSG_PUB.ADD;

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

Line 2914: FND_MSG_PUB.ADD;

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

Line 2929: FND_MSG_PUB.ADD;

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

Line 2952: FND_MSG_PUB.ADD;

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

Line 2974: FND_MSG_PUB.ADD;

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

Line 2993: FND_MSG_PUB.ADD;

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

Line 3010: FND_MSG_PUB.ADD;

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

Line 3033: FND_MSG_PUB.ADD;

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

Line 3048: FND_MSG_PUB.ADD;

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

Line 3066: FND_MSG_PUB.ADD;

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

Line 3085: FND_MSG_PUB.ADD;

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

Line 3100: FND_MSG_PUB.ADD;

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

Line 3119: FND_MSG_PUB.ADD;

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

Line 3138: FND_MSG_PUB.ADD;

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

Line 3156: FND_MSG_PUB.ADD;

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

Line 3184: FND_MSG_PUB.ADD;

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

Line 3199: FND_MSG_PUB.ADD;

3195:
3196: 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)
3197: THEN
3198: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
3199: FND_MSG_PUB.ADD;
3200: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3201: THEN
3202: fnd_log.message
3203: (

Line 3214: FND_MSG_PUB.ADD;

3210:
3211: 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)
3212: THEN
3213: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
3214: FND_MSG_PUB.ADD;
3215: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3216: THEN
3217: fnd_log.message
3218: (

Line 3230: FND_MSG_PUB.ADD;

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

Line 3245: FND_MSG_PUB.ADD;

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

Line 3261: FND_MSG_PUB.ADD;

3257:
3258: 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)))
3259: THEN
3260: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
3261: FND_MSG_PUB.ADD;
3262: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3263: THEN
3264: fnd_log.message
3265: (

Line 3295: FND_MSG_PUB.ADD;

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

Line 3310: FND_MSG_PUB.ADD;

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

Line 3363: FND_MSG_PUB.ADD;

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

Line 3381: FND_MSG_PUB.ADD;

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

Line 3400: FND_MSG_PUB.ADD;

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

Line 3415: FND_MSG_PUB.ADD;

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

Line 3436: FND_MSG_PUB.ADD;

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

Line 3455: FND_MSG_PUB.ADD;

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

Line 3489: FND_MSG_PUB.ADD;

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

Line 3504: FND_MSG_PUB.ADD;

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

Line 3545: FND_MSG_PUB.ADD;

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

Line 3623: FND_MSG_PUB.ADD;

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

Line 3673: FND_MSG_PUB.ADD;

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

Line 3694: FND_MSG_PUB.ADD;

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

Line 3835: l_msg_count := FND_MSG_PUB.count_msg;

3831: -- Validate UOM, Rule and Ratio for the counter rule
3832: Validate_Counter_Rule(p_x_counter_rule_rec);
3833:
3834: -- Check Error Message stack.
3835: l_msg_count := FND_MSG_PUB.count_msg;
3836: IF l_msg_count > 0 THEN
3837: RAISE FND_API.G_EXC_ERROR;
3838: END IF;
3839:

Line 3974: l_msg_count := FND_MSG_PUB.count_msg;

3970: -- Validate UOM, Rule and Ratio for the counter rule
3971: Validate_Counter_Rule(p_x_counter_rule_rec);
3972:
3973: -- Check Error Message stack.
3974: l_msg_count := FND_MSG_PUB.count_msg;
3975: IF l_msg_count > 0 THEN
3976: RAISE FND_API.G_EXC_ERROR;
3977: END IF;
3978:

Line 4148: FND_MSG_PUB.ADD;

4144: FETCH check_root_node INTO l_dummy_varchar;
4145: IF (check_root_node%FOUND)
4146: THEN
4147: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_TOP_NODE');
4148: FND_MSG_PUB.ADD;
4149: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4150: THEN
4151: fnd_log.message
4152: (

Line 4167: FND_MSG_PUB.ADD;

4163: FETCH check_leaf_node INTO l_dummy_varchar;
4164: IF (check_leaf_node%FOUND)
4165: THEN
4166: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4167: FND_MSG_PUB.ADD;
4168: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4169: THEN
4170: fnd_log.message
4171: (

Line 4186: FND_MSG_PUB.ADD;

4182: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4183: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4184: THEN
4185: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4186: FND_MSG_PUB.ADD;
4187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4188: THEN
4189: fnd_log.message
4190: (

Line 4206: FND_MSG_PUB.ADD;

4202: IF (check_submc_exists%FOUND)
4203: THEN
4204: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');
4205: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);
4206: FND_MSG_PUB.ADD;
4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4208: THEN
4209: fnd_log.message
4210: (

Line 4239: FND_MSG_PUB.ADD;

4235: CLOSE get_mc_details;
4236: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4237: FND_MESSAGE.Set_Token('MC', l_mc_name);
4238: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4239: FND_MSG_PUB.ADD;
4240: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4241: THEN
4242: fnd_log.message
4243: (

Line 4253: l_msg_count := FND_MSG_PUB.count_msg;

4249: END IF;
4250:
4251:
4252: -- Check Error Message stack.
4253: l_msg_count := FND_MSG_PUB.count_msg;
4254: IF l_msg_count > 0 THEN
4255: RAISE FND_API.G_EXC_ERROR;
4256: END IF;
4257:

Line 4262: FND_MSG_PUB.ADD;

4258: -- Validate dates for the subconfig association
4259: IF (trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)
4260: THEN
4261: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4262: FND_MSG_PUB.ADD;
4263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4264: THEN
4265: fnd_log.message
4266: (

Line 4277: FND_MSG_PUB.ADD;

4273:
4274: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
4275: THEN
4276: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4277: FND_MSG_PUB.ADD;
4278: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4279: THEN
4280: fnd_log.message
4281: (

Line 4292: FND_MSG_PUB.ADD;

4288:
4289: 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)))
4290: THEN
4291: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4292: FND_MSG_PUB.ADD;
4293: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4294: THEN
4295: fnd_log.message
4296: (

Line 4308: FND_MSG_PUB.ADD;

4304: IF (p_x_subconfig_rec.priority IS NULL)
4305: THEN
4306: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4307: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4308: FND_MSG_PUB.ADD;
4309: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4310: THEN
4311: fnd_log.message
4312: (

Line 4321: FND_MSG_PUB.ADD;

4317: END IF;
4318: ELSIF (p_x_subconfig_rec.priority <= 0)
4319: THEN
4320: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4321: FND_MSG_PUB.ADD;
4322: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4323: THEN
4324: fnd_log.message
4325: (

Line 4334: l_msg_count := FND_MSG_PUB.count_msg;

4330: END IF;
4331: END IF;
4332:
4333: -- Check Error Message stack.
4334: l_msg_count := FND_MSG_PUB.count_msg;
4335: IF l_msg_count > 0 THEN
4336: RAISE FND_API.G_EXC_ERROR;
4337: END IF;
4338:

Line 4471: FND_MSG_PUB.ADD;

4467: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4468: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4469: THEN
4470: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4471: FND_MSG_PUB.ADD;
4472: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4473: THEN
4474: fnd_log.message
4475: (

Line 4494: FND_MSG_PUB.ADD;

4490: -- Should be able to unexpire an expired subconfiguration association
4491: IF (G_TRUNC_DATE >= trunc(nvl(l_end_date, G_SYSDATE + 1)))
4492: THEN
4493: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_DATE_INV');
4494: FND_MSG_PUB.ADD;
4495: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4496: THEN
4497: fnd_log.message
4498: (

Line 4510: FND_MSG_PUB.ADD;

4506:
4507: 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)
4508: THEN
4509: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4510: FND_MSG_PUB.ADD;
4511: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4512: THEN
4513: fnd_log.message
4514: (

Line 4525: FND_MSG_PUB.ADD;

4521:
4522: 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)
4523: THEN
4524: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4525: FND_MSG_PUB.ADD;
4526: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4527: THEN
4528: fnd_log.message
4529: (

Line 4540: FND_MSG_PUB.ADD;

4536:
4537: 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)))
4538: THEN
4539: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4540: FND_MSG_PUB.ADD;
4541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4542: THEN
4543: fnd_log.message
4544: (

Line 4557: FND_MSG_PUB.ADD;

4553: IF (p_x_subconfig_rec.priority IS NULL)
4554: THEN
4555: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4556: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4557: FND_MSG_PUB.ADD;
4558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4559: THEN
4560: fnd_log.message
4561: (

Line 4570: FND_MSG_PUB.ADD;

4566: END IF;
4567: ELSIF (p_x_subconfig_rec.priority <= 0)
4568: THEN
4569: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4570: FND_MSG_PUB.ADD;
4571: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4572: THEN
4573: fnd_log.message
4574: (

Line 4584: l_msg_count := FND_MSG_PUB.count_msg;

4580:
4581: END IF;
4582:
4583: -- Check Error Message stack.
4584: l_msg_count := FND_MSG_PUB.count_msg;
4585: IF l_msg_count > 0 THEN
4586: RAISE FND_API.G_EXC_ERROR;
4587: END IF;
4588:

Line 4751: l_msg_count := FND_MSG_PUB.count_msg;

4747: -- Validate p_dest_rel_id exists
4748: Validate_Node_Exists(p_dest_rel_id, null);
4749:
4750: -- Check Error Message stack.
4751: l_msg_count := FND_MSG_PUB.count_msg;
4752: IF l_msg_count > 0 THEN
4753: RAISE FND_API.G_EXC_ERROR;
4754: END IF;
4755:

Line 4778: FND_MSG_PUB.ADD;

4774: FETCH check_leaf_node INTO l_dummy_varchar;
4775: IF (check_leaf_node%FOUND)
4776: THEN
4777: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4778: FND_MSG_PUB.ADD;
4779: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4780: THEN
4781: fnd_log.message
4782: (

Line 4814: FND_MSG_PUB.ADD;

4810: CLOSE get_mc_details;
4811: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4812: FND_MESSAGE.Set_Token('MC', l_mc_name);
4813: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4814: FND_MSG_PUB.ADD;
4815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4816: THEN
4817: fnd_log.message
4818: (

Line 4826: l_msg_count := FND_MSG_PUB.count_msg;

4822: );
4823: END IF;
4824: END IF;
4825: -- Check Error Message stack.
4826: l_msg_count := FND_MSG_PUB.count_msg;
4827: IF l_msg_count > 0 THEN
4828: RAISE FND_API.G_EXC_ERROR;
4829: END IF;
4830: