APPS.AHL_MC_NODE_PVT dependencies on FND_LOG

Line 189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: -- API body starts here
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
190: THEN
191: fnd_log.string
192: (
193: fnd_log.level_procedure,

Line 191: fnd_log.string

187:
188: -- API body starts here
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
190: THEN
191: fnd_log.string
192: (
193: fnd_log.level_procedure,
194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
195: 'At the start of PLSQL procedure'

Line 193: fnd_log.level_procedure,

189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
190: THEN
191: fnd_log.string
192: (
193: fnd_log.level_procedure,
194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
195: 'At the start of PLSQL procedure'
196: );
197: END IF;

Line 207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
211: fnd_log.level_exception,

Line 209: fnd_log.message

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: (
211: fnd_log.level_exception,
212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
213: false

Line 211: fnd_log.level_exception,

207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message
210: (
211: fnd_log.level_exception,
212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
213: false
214: );
215: END IF;

Line 247: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
251: fnd_log.level_exception,

Line 249: fnd_log.message

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: (
251: fnd_log.level_exception,
252: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
253: false

Line 251: fnd_log.level_exception,

247: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
248: THEN
249: fnd_log.message
250: (
251: fnd_log.level_exception,
252: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
253: false
254: );
255: END IF;

Line 266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

262: IF x_msg_count > 0 THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
267: THEN
268: fnd_log.string
269: (
270: fnd_log.level_statement,

Line 268: fnd_log.string

264: END IF;
265:
266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
267: THEN
268: fnd_log.string
269: (
270: fnd_log.level_statement,
271: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
272: 'Node validation successful'

Line 270: fnd_log.level_statement,

266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
267: THEN
268: fnd_log.string
269: (
270: fnd_log.level_statement,
271: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
272: 'Node validation successful'
273: );
274: END IF;

Line 364: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

360: --priyan MEL-CDL
361: p_x_node_rec.ata_code
362: );
363:
364: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.string
367: (
368: fnd_log.level_statement,

Line 366: fnd_log.string

362: );
363:
364: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.string
367: (
368: fnd_log.level_statement,
369: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
370: 'Node ['||p_x_node_rec.relationship_id||'] created'

Line 368: fnd_log.level_statement,

364: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
365: THEN
366: fnd_log.string
367: (
368: fnd_log.level_statement,
369: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
370: 'Node ['||p_x_node_rec.relationship_id||'] created'
371: );
372: END IF;

Line 394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

390: IF x_msg_count > 0 THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
395: THEN
396: fnd_log.string
397: (
398: fnd_log.level_statement,

Line 396: fnd_log.string

392: END IF;
393:
394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
395: THEN
396: fnd_log.string
397: (
398: fnd_log.level_statement,
399: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
400: 'Counter rule ['||p_x_counter_rules_tbl(i).ctr_update_rule_id||'] created'

Line 398: fnd_log.level_statement,

394: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
395: THEN
396: fnd_log.string
397: (
398: fnd_log.level_statement,
399: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
400: 'Counter rule ['||p_x_counter_rules_tbl(i).ctr_update_rule_id||'] created'
401: );
402: END IF;

Line 430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

426: IF x_msg_count > 0 THEN
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
431: THEN
432: fnd_log.string
433: (
434: fnd_log.level_statement,

Line 432: fnd_log.string

428: END IF;
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
431: THEN
432: fnd_log.string
433: (
434: fnd_log.level_statement,
435: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
436: 'Counter rule ['||p_x_subconfig_tbl(i).mc_config_relation_id||'] created'

Line 434: fnd_log.level_statement,

430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
431: THEN
432: fnd_log.string
433: (
434: fnd_log.level_statement,
435: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
436: 'Counter rule ['||p_x_subconfig_tbl(i).mc_config_relation_id||'] created'
437: );
438: END IF;

Line 445: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

441: validate_priority(p_x_subconfig_tbl);
442:
443: END IF;
444:
445: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
446: THEN
447: fnd_log.string
448: (
449: fnd_log.level_procedure,

Line 447: fnd_log.string

443: END IF;
444:
445: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
446: THEN
447: fnd_log.string
448: (
449: fnd_log.level_procedure,
450: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
451: 'At the end of PLSQL procedure'

Line 449: fnd_log.level_procedure,

445: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
446: THEN
447: fnd_log.string
448: (
449: fnd_log.level_procedure,
450: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
451: 'At the end of PLSQL procedure'
452: );
453: END IF;

Line 643: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

639: -- Initialize API return status to success
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: -- API body starts here
643: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
644: THEN
645: fnd_log.string
646: (
647: fnd_log.level_procedure,

Line 645: fnd_log.string

641:
642: -- API body starts here
643: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
644: THEN
645: fnd_log.string
646: (
647: fnd_log.level_procedure,
648: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
649: ' At the start of PLSQL procedure'

Line 647: fnd_log.level_procedure,

643: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
644: THEN
645: fnd_log.string
646: (
647: fnd_log.level_procedure,
648: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
649: ' At the start of PLSQL procedure'
650: );
651: END IF;

Line 663: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
667: fnd_log.level_exception,

Line 665: fnd_log.message

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: (
667: fnd_log.level_exception,
668: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
669: false

Line 667: fnd_log.level_exception,

663: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
664: THEN
665: fnd_log.message
666: (
667: fnd_log.level_exception,
668: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
669: false
670: );
671: END IF;

Line 705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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
708: (
709: fnd_log.level_exception,

Line 707: fnd_log.message

703: FND_MSG_PUB.ADD;
704:
705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN
707: fnd_log.message
708: (
709: fnd_log.level_exception,
710: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
711: false

Line 709: fnd_log.level_exception,

705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN
707: fnd_log.message
708: (
709: fnd_log.level_exception,
710: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
711: false
712: );
713: END IF;

Line 726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

722: IF x_msg_count > 0 THEN
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725:
726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
727: THEN
728: fnd_log.string
729: (
730: fnd_log.level_statement,

Line 728: fnd_log.string

724: END IF;
725:
726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
727: THEN
728: fnd_log.string
729: (
730: fnd_log.level_statement,
731: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
732: 'Node validation successful'

Line 730: fnd_log.level_statement,

726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
727: THEN
728: fnd_log.string
729: (
730: fnd_log.level_statement,
731: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
732: 'Node validation successful'
733: );
734: END IF;

Line 776: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

772: ATA_CODE = p_x_node_rec.ata_code
773: WHERE RELATIONSHIP_ID = p_x_node_rec.relationship_id;
774:
775:
776: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
777: THEN
778: fnd_log.string
779: (
780: fnd_log.level_statement,

Line 778: fnd_log.string

774:
775:
776: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
777: THEN
778: fnd_log.string
779: (
780: fnd_log.level_statement,
781: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
782: 'Node ['||p_x_node_rec.relationship_id||'] updated'

Line 780: fnd_log.level_statement,

776: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
777: THEN
778: fnd_log.string
779: (
780: fnd_log.level_statement,
781: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
782: 'Node ['||p_x_node_rec.relationship_id||'] updated'
783: );
784: END IF;

Line 800: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
804: fnd_log.level_exception,

Line 802: fnd_log.message

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: (
804: fnd_log.level_exception,
805: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
806: false

Line 804: fnd_log.level_exception,

800: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
801: THEN
802: fnd_log.message
803: (
804: fnd_log.level_exception,
805: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
806: false
807: );
808: END IF;

Line 825: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
829: fnd_log.level_exception,

Line 827: fnd_log.message

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: (
829: fnd_log.level_exception,
830: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
831: false

Line 829: fnd_log.level_exception,

825: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
826: THEN
827: fnd_log.message
828: (
829: fnd_log.level_exception,
830: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
831: false
832: );
833: END IF;

Line 842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

838: IF x_msg_count > 0 THEN
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
843: THEN
844: fnd_log.string
845: (
846: fnd_log.level_statement,

Line 844: fnd_log.string

840: END IF;
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
843: THEN
844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
848: 'Node validation successful'

Line 846: fnd_log.level_statement,

842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
843: THEN
844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
848: 'Node validation successful'
849: );
850: END IF;

Line 853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

849: );
850: END IF;
851: END IF;
852:
853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
854: THEN
855: fnd_log.string
856: (
857: fnd_log.level_statement,

Line 855: fnd_log.string

851: END IF;
852:
853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
854: THEN
855: fnd_log.string
856: (
857: fnd_log.level_statement,
858: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
859: 'Processing counter rules and subconfig table'

Line 857: fnd_log.level_statement,

853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
854: THEN
855: fnd_log.string
856: (
857: fnd_log.level_statement,
858: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
859: 'Processing counter rules and subconfig table'
860: );
861: END IF;

Line 937: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

933:
934: validate_priority(p_x_subconfig_tbl);
935: END IF;
936:
937: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
938: THEN
939: fnd_log.string
940: (
941: fnd_log.level_procedure,

Line 939: fnd_log.string

935: END IF;
936:
937: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
938: THEN
939: fnd_log.string
940: (
941: fnd_log.level_procedure,
942: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
943: 'At the end of PLSQL procedure'

Line 941: fnd_log.level_procedure,

937: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
938: THEN
939: fnd_log.string
940: (
941: fnd_log.level_procedure,
942: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
943: 'At the end of PLSQL procedure'
944: );
945: END IF;

Line 1143: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141:
1142: -- API body starts here
1143: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1144: THEN
1145: fnd_log.string
1146: (
1147: fnd_log.level_procedure,

Line 1145: fnd_log.string

1141:
1142: -- API body starts here
1143: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1144: THEN
1145: fnd_log.string
1146: (
1147: fnd_log.level_procedure,
1148: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1149: 'At the start of PLSQL procedure'

Line 1147: fnd_log.level_procedure,

1143: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1144: THEN
1145: fnd_log.string
1146: (
1147: fnd_log.level_procedure,
1148: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1149: 'At the start of PLSQL procedure'
1150: );
1151: END IF;

Line 1162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
1166: fnd_log.level_exception,

Line 1164: fnd_log.message

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: (
1166: fnd_log.level_exception,
1167: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1168: false

Line 1166: fnd_log.level_exception,

1162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1163: THEN
1164: fnd_log.message
1165: (
1166: fnd_log.level_exception,
1167: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1168: false
1169: );
1170: END IF;

Line 1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1185: -- 9d. Delete all subconfiguration associations with the current node
1186: DELETE FROM ahl_mc_config_relations
1187: WHERE relationship_id = l_node_csr_rec.relationship_id;
1188:
1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN
1191: fnd_log.string
1192: (
1193: fnd_log.level_statement,

Line 1191: fnd_log.string

1187: WHERE relationship_id = l_node_csr_rec.relationship_id;
1188:
1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN
1191: fnd_log.string
1192: (
1193: fnd_log.level_statement,
1194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1195: 'Detached subconfigs for node ['||l_node_csr_rec.relationship_id||']'

Line 1193: fnd_log.level_statement,

1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN
1191: fnd_log.string
1192: (
1193: fnd_log.level_statement,
1194: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1195: 'Detached subconfigs for node ['||l_node_csr_rec.relationship_id||']'
1196: );
1197: END IF;

Line 1203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1199: -- 9g. Delete all counter rule associations with the current node
1200: DELETE FROM ahl_ctr_update_rules
1201: WHERE relationship_id = l_node_csr_rec.relationship_id;
1202:
1203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1204: THEN
1205: fnd_log.string
1206: (
1207: fnd_log.level_statement,

Line 1205: fnd_log.string

1201: WHERE relationship_id = l_node_csr_rec.relationship_id;
1202:
1203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1204: THEN
1205: fnd_log.string
1206: (
1207: fnd_log.level_statement,
1208: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1209: 'Detached counter rules for node ['||l_node_csr_rec.relationship_id||']'

Line 1207: fnd_log.level_statement,

1203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1204: THEN
1205: fnd_log.string
1206: (
1207: fnd_log.level_statement,
1208: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1209: 'Detached counter rules for node ['||l_node_csr_rec.relationship_id||']'
1210: );
1211: END IF;

Line 1228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1224: x_msg_count => l_msg_count,
1225: x_msg_data => l_msg_data
1226: );
1227:
1228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1229: THEN
1230: fnd_log.string
1231: (
1232: fnd_log.level_statement,

Line 1230: fnd_log.string

1226: );
1227:
1228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1229: THEN
1230: fnd_log.string
1231: (
1232: fnd_log.level_statement,
1233: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1234: 'Deleted document associations for node ['||l_node_csr_rec.relationship_id||']'

Line 1232: fnd_log.level_statement,

1228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1229: THEN
1230: fnd_log.string
1231: (
1232: fnd_log.level_statement,
1233: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1234: 'Deleted document associations for node ['||l_node_csr_rec.relationship_id||']'
1235: );
1236: END IF;

Line 1244: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1240: WHERE relationship_id = l_node_csr_rec.relationship_id;
1241:
1242: END LOOP;
1243:
1244: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1245: THEN
1246: fnd_log.string
1247: (
1248: fnd_log.level_procedure,

Line 1246: fnd_log.string

1242: END LOOP;
1243:
1244: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1245: THEN
1246: fnd_log.string
1247: (
1248: fnd_log.level_procedure,
1249: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1250: 'At the end of PLSQL procedure'

Line 1248: fnd_log.level_procedure,

1244: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1245: THEN
1246: fnd_log.string
1247: (
1248: fnd_log.level_procedure,
1249: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1250: 'At the end of PLSQL procedure'
1251: );
1252: END IF;

Line 1362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1358: -- Initialize API return status to success
1359: x_return_status := FND_API.G_RET_STS_SUCCESS;
1360:
1361: -- API body starts here
1362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1363: THEN
1364: fnd_log.string
1365: (
1366: fnd_log.level_procedure,

Line 1364: fnd_log.string

1360:
1361: -- API body starts here
1362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1363: THEN
1364: fnd_log.string
1365: (
1366: fnd_log.level_procedure,
1367: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1368: 'At the start of PLSQL procedure'

Line 1366: fnd_log.level_procedure,

1362: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1363: THEN
1364: fnd_log.string
1365: (
1366: fnd_log.level_procedure,
1367: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1368: 'At the start of PLSQL procedure'
1369: );
1370: END IF;

Line 1382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
1386: fnd_log.level_exception,

Line 1384: fnd_log.message

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: (
1386: fnd_log.level_exception,
1387: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1388: false

Line 1386: fnd_log.level_exception,

1382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1383: THEN
1384: fnd_log.message
1385: (
1386: fnd_log.level_exception,
1387: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1388: false
1389: );
1390: END IF;

Line 1407: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1403: IF x_msg_count > 0 THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406:
1407: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1408: THEN
1409: fnd_log.string
1410: (
1411: fnd_log.level_statement,

Line 1409: fnd_log.string

1405: END IF;
1406:
1407: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1408: THEN
1409: fnd_log.string
1410: (
1411: fnd_log.level_statement,
1412: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1413: 'Node validation successful... Calling Copy_MC_Nodes'

Line 1411: fnd_log.level_statement,

1407: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1408: THEN
1409: fnd_log.string
1410: (
1411: fnd_log.level_statement,
1412: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1413: 'Node validation successful... Calling Copy_MC_Nodes'
1414: );
1415: END IF;

Line 1446: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1442: WHEN OTHERS THEN
1443: NULL;
1444: END;
1445:
1446: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1447: THEN
1448: fnd_log.string
1449: (
1450: fnd_log.level_procedure,

Line 1448: fnd_log.string

1444: END;
1445:
1446: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1447: THEN
1448: fnd_log.string
1449: (
1450: fnd_log.level_procedure,
1451: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1452: 'At the end of PLSQL procedure'

Line 1450: fnd_log.level_procedure,

1446: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1447: THEN
1448: fnd_log.string
1449: (
1450: fnd_log.level_procedure,
1451: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1452: 'At the end of PLSQL procedure'
1453: );
1454: END IF;

Line 1651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1647: -- Initialize API return status to success
1648: x_return_status := FND_API.G_RET_STS_SUCCESS;
1649:
1650: -- API body starts here
1651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1652: THEN
1653: fnd_log.string
1654: (
1655: fnd_log.level_procedure,

Line 1653: fnd_log.string

1649:
1650: -- API body starts here
1651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1652: THEN
1653: fnd_log.string
1654: (
1655: fnd_log.level_procedure,
1656: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1657: 'At the start of PLSQL procedure'

Line 1655: fnd_log.level_procedure,

1651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1652: THEN
1653: fnd_log.string
1654: (
1655: fnd_log.level_procedure,
1656: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1657: 'At the start of PLSQL procedure'
1658: );
1659: END IF;

Line 1665: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1661: OPEN get_mc_header_id;
1662: FETCH get_mc_header_id INTO l_mc_header_id;
1663: CLOSE get_mc_header_id;
1664:
1665: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1666: THEN
1667: fnd_log.string
1668: (
1669: fnd_log.level_statement,

Line 1667: fnd_log.string

1663: CLOSE get_mc_header_id;
1664:
1665: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1666: THEN
1667: fnd_log.string
1668: (
1669: fnd_log.level_statement,
1670: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1671: 'Starting the copy of the node tree for node ['||p_source_rel_id||'] to node ['||p_dest_rel_id||']'

Line 1669: fnd_log.level_statement,

1665: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1666: THEN
1667: fnd_log.string
1668: (
1669: fnd_log.level_statement,
1670: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1671: 'Starting the copy of the node tree for node ['||p_source_rel_id||'] to node ['||p_dest_rel_id||']'
1672: );
1673: END IF;

Line 1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1875: END IF;
1876:
1877: l_ctr_iterator := 0;
1878:
1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1880: THEN
1881: fnd_log.string
1882: (
1883: fnd_log.level_statement,

Line 1881: fnd_log.string

1877: l_ctr_iterator := 0;
1878:
1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1880: THEN
1881: fnd_log.string
1882: (
1883: fnd_log.level_statement,
1884: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1885: 'Creating new node with parent node ['||l_nodes_tbl(i).parent_relationship_id||'], position reference ['||l_nodes_tbl(i).position_ref_code||']'

Line 1883: fnd_log.level_statement,

1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1880: THEN
1881: fnd_log.string
1882: (
1883: fnd_log.level_statement,
1884: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1885: 'Creating new node with parent node ['||l_nodes_tbl(i).parent_relationship_id||'], position reference ['||l_nodes_tbl(i).position_ref_code||']'
1886: );
1887: END IF;

Line 1899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1895: THEN
1896: l_ctr_iterator := l_ctr_iterator + 1;
1897: l_node_ctr_rules_tbl(l_ctr_iterator) := l_ctr_rules_tbl(j);
1898:
1899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1900: THEN
1901: fnd_log.string
1902: (
1903: fnd_log.level_statement,

Line 1901: fnd_log.string

1897: l_node_ctr_rules_tbl(l_ctr_iterator) := l_ctr_rules_tbl(j);
1898:
1899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1900: THEN
1901: fnd_log.string
1902: (
1903: fnd_log.level_statement,
1904: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1905: 'Creating new counter rule ['||l_node_ctr_rules_tbl(l_ctr_iterator).ctr_update_rule_id||']'

Line 1903: fnd_log.level_statement,

1899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1900: THEN
1901: fnd_log.string
1902: (
1903: fnd_log.level_statement,
1904: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1905: 'Creating new counter rule ['||l_node_ctr_rules_tbl(l_ctr_iterator).ctr_update_rule_id||']'
1906: );
1907: END IF;

Line 1933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1929: IF x_msg_count > 0 THEN
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;
1932:
1933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1934: THEN
1935: fnd_log.string
1936: (
1937: fnd_log.level_statement,

Line 1935: fnd_log.string

1931: END IF;
1932:
1933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1934: THEN
1935: fnd_log.string
1936: (
1937: fnd_log.level_statement,
1938: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1939: 'New Node ['||l_nodes_tbl(i).relationship_id||', '||l_nodes_tbl(i).position_ref_code||'] created'

Line 1937: fnd_log.level_statement,

1933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1934: THEN
1935: fnd_log.string
1936: (
1937: fnd_log.level_statement,
1938: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1939: 'New Node ['||l_nodes_tbl(i).relationship_id||', '||l_nodes_tbl(i).position_ref_code||'] created'
1940: );
1941: END IF;

Line 1950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1946: IF (l_nodes_tbl(x).PARENT_NODE_REC_INDEX = i)
1947: THEN
1948: l_nodes_tbl(x).PARENT_RELATIONSHIP_ID := l_nodes_tbl(i).RELATIONSHIP_ID;
1949:
1950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1951: THEN
1952: fnd_log.string
1953: (
1954: fnd_log.level_statement,

Line 1952: fnd_log.string

1948: l_nodes_tbl(x).PARENT_RELATIONSHIP_ID := l_nodes_tbl(i).RELATIONSHIP_ID;
1949:
1950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1951: THEN
1952: fnd_log.string
1953: (
1954: fnd_log.level_statement,
1955: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1956: 'Populated node ['||l_nodes_tbl(x).position_ref_code||'] with parent relationship id ['||l_nodes_tbl(i).RELATIONSHIP_ID||']'

Line 1954: fnd_log.level_statement,

1950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1951: THEN
1952: fnd_log.string
1953: (
1954: fnd_log.level_statement,
1955: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1956: 'Populated node ['||l_nodes_tbl(x).position_ref_code||'] with parent relationship id ['||l_nodes_tbl(i).RELATIONSHIP_ID||']'
1957: );
1958: END IF;

Line 1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1962:
1963: -- 7m. Iterate through the l_node_tbl table to copy all document and subconfiguration associations
1964: FOR i IN l_nodes_tbl.FIRST..l_nodes_tbl.LAST
1965: LOOP
1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1967: THEN
1968: fnd_log.string
1969: (
1970: fnd_log.level_statement,

Line 1968: fnd_log.string

1964: FOR i IN l_nodes_tbl.FIRST..l_nodes_tbl.LAST
1965: LOOP
1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1967: THEN
1968: fnd_log.string
1969: (
1970: fnd_log.level_statement,
1971: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1972: 'Document associations for node ['||l_old_node_id_tbl(i)||'] copied to node ['||l_nodes_tbl(i).relationship_id||']'

Line 1970: fnd_log.level_statement,

1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1967: THEN
1968: fnd_log.string
1969: (
1970: fnd_log.level_statement,
1971: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1972: 'Document associations for node ['||l_old_node_id_tbl(i)||'] copied to node ['||l_nodes_tbl(i).relationship_id||']'
1973: );
1974: END IF;

Line 1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1993: IF x_msg_count > 0 THEN
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:
1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1998: THEN
1999: fnd_log.string
2000: (
2001: fnd_log.level_statement,

Line 1999: fnd_log.string

1995: END IF;
1996:
1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1998: THEN
1999: fnd_log.string
2000: (
2001: fnd_log.level_statement,
2002: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2003: 'Subconfig associations for node ['||l_old_node_id_tbl(i)||'] copied to node ['||l_nodes_tbl(i).relationship_id||']'

Line 2001: fnd_log.level_statement,

1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1998: THEN
1999: fnd_log.string
2000: (
2001: fnd_log.level_statement,
2002: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2003: 'Subconfig associations for node ['||l_old_node_id_tbl(i)||'] copied to node ['||l_nodes_tbl(i).relationship_id||']'
2004: );
2005: END IF;

Line 2022: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2018: END IF;
2019: END LOOP;
2020: END IF;
2021:
2022: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2023: THEN
2024: fnd_log.string
2025: (
2026: fnd_log.level_procedure,

Line 2024: fnd_log.string

2020: END IF;
2021:
2022: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2023: THEN
2024: fnd_log.string
2025: (
2026: fnd_log.level_procedure,
2027: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2028: 'At the end of PLSQL procedure'

Line 2026: fnd_log.level_procedure,

2022: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2023: THEN
2024: fnd_log.string
2025: (
2026: fnd_log.level_procedure,
2027: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2028: 'At the end of PLSQL procedure'
2029: );
2030: END IF;

Line 2139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2135: -- Initialize API return status to success
2136: x_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: -- API body starts here
2139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2140: THEN
2141: fnd_log.string
2142: (
2143: fnd_log.level_procedure,

Line 2141: fnd_log.string

2137:
2138: -- API body starts here
2139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2140: THEN
2141: fnd_log.string
2142: (
2143: fnd_log.level_procedure,
2144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2145: 'At the start of PLSQL procedure'

Line 2143: fnd_log.level_procedure,

2139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2140: THEN
2141: fnd_log.string
2142: (
2143: fnd_log.level_procedure,
2144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2145: 'At the start of PLSQL procedure'
2146: );
2147: END IF;

Line 2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2162: fnd_log.level_exception,

Line 2160: fnd_log.message

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: (
2162: fnd_log.level_exception,
2163: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2164: false

Line 2162: fnd_log.level_exception,

2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2159: THEN
2160: fnd_log.message
2161: (
2162: fnd_log.level_exception,
2163: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2164: false
2165: );
2166: END IF;

Line 2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2176: IF x_msg_count > 0 THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;
2179:
2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2181: THEN
2182: fnd_log.string
2183: (
2184: fnd_log.level_statement,

Line 2182: fnd_log.string

2178: END IF;
2179:
2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2181: THEN
2182: fnd_log.string
2183: (
2184: fnd_log.level_statement,
2185: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2186: 'Node validation successful'

Line 2184: fnd_log.level_statement,

2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2181: THEN
2182: fnd_log.string
2183: (
2184: fnd_log.level_statement,
2185: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2186: 'Node validation successful'
2187: );
2188: END IF;

Line 2203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2207: fnd_log.level_exception,

Line 2205: fnd_log.message

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: (
2207: fnd_log.level_exception,
2208: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2209: false

Line 2207: fnd_log.level_exception,

2203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2204: THEN
2205: fnd_log.message
2206: (
2207: fnd_log.level_exception,
2208: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2209: false
2210: );
2211: END IF;

Line 2221: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2217: IF x_msg_count > 0 THEN
2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;
2220:
2221: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2222: THEN
2223: fnd_log.string
2224: (
2225: fnd_log.level_statement,

Line 2223: fnd_log.string

2219: END IF;
2220:
2221: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2222: THEN
2223: fnd_log.string
2224: (
2225: fnd_log.level_statement,
2226: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2227: 'Document association validations successful... Calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION'

Line 2225: fnd_log.level_statement,

2221: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2222: THEN
2223: fnd_log.string
2224: (
2225: fnd_log.level_statement,
2226: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2227: 'Document association validations successful... Calling AHL_DI_ASSO_DOC_GEN_PUB.PROCESS_ASSOCIATION'
2228: );
2229: END IF;

Line 2246: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2242: x_msg_data => l_msg_data
2243: );
2244: END IF;
2245:
2246: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2247: THEN
2248: fnd_log.string
2249: (
2250: fnd_log.level_procedure,

Line 2248: fnd_log.string

2244: END IF;
2245:
2246: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2247: THEN
2248: fnd_log.string
2249: (
2250: fnd_log.level_procedure,
2251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2252: 'At the end of PLSQL procedure'

Line 2250: fnd_log.level_procedure,

2246: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2247: THEN
2248: fnd_log.string
2249: (
2250: fnd_log.level_procedure,
2251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2252: 'At the end of PLSQL procedure'
2253: );
2254: END IF;

Line 2383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2379: -- Initialize API return status to success
2380: x_return_status := FND_API.G_RET_STS_SUCCESS;
2381:
2382: -- API body starts here
2383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2384: THEN
2385: fnd_log.string
2386: (
2387: fnd_log.level_procedure,

Line 2385: fnd_log.string

2381:
2382: -- API body starts here
2383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2384: THEN
2385: fnd_log.string
2386: (
2387: fnd_log.level_procedure,
2388: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2389: 'At the start of PLSQL procedure'

Line 2387: fnd_log.level_procedure,

2383: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2384: THEN
2385: fnd_log.string
2386: (
2387: fnd_log.level_procedure,
2388: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2389: 'At the start of PLSQL procedure'
2390: );
2391: END IF;

Line 2403: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2407: fnd_log.level_exception,

Line 2405: fnd_log.message

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: (
2407: fnd_log.level_exception,
2408: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2409: false

Line 2407: fnd_log.level_exception,

2403: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2404: THEN
2405: fnd_log.message
2406: (
2407: fnd_log.level_exception,
2408: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2409: false
2410: );
2411: END IF;

Line 2432: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2436: fnd_log.level_exception,

Line 2434: fnd_log.message

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: (
2436: fnd_log.level_exception,
2437: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2438: false

Line 2436: fnd_log.level_exception,

2432: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2433: THEN
2434: fnd_log.message
2435: (
2436: fnd_log.level_exception,
2437: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2438: false
2439: );
2440: END IF;

Line 2461: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2465: fnd_log.level_exception,

Line 2463: fnd_log.message

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: (
2465: fnd_log.level_exception,
2466: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2467: false

Line 2465: fnd_log.level_exception,

2461: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2462: THEN
2463: fnd_log.message
2464: (
2465: fnd_log.level_exception,
2466: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2467: false
2468: );
2469: END IF;

Line 2479: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2483: fnd_log.level_exception,

Line 2481: fnd_log.message

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: (
2483: fnd_log.level_exception,
2484: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2485: false

Line 2483: fnd_log.level_exception,

2479: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2480: THEN
2481: fnd_log.message
2482: (
2483: fnd_log.level_exception,
2484: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2485: false
2486: );
2487: END IF;

Line 2490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2486: );
2487: END IF;
2488: END IF;
2489:
2490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2491: THEN
2492: fnd_log.string
2493: (
2494: fnd_log.level_statement,

Line 2492: fnd_log.string

2488: END IF;
2489:
2490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2491: THEN
2492: fnd_log.string
2493: (
2494: fnd_log.level_statement,
2495: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2496: 'Validation successful'

Line 2494: fnd_log.level_statement,

2490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2491: THEN
2492: fnd_log.string
2493: (
2494: fnd_log.level_statement,
2495: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2496: 'Validation successful'
2497: );
2498: END IF;

Line 2510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2506: UPDATE ahl_mc_relationships
2507: SET item_group_id = l_item_group_id
2508: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
2509:
2510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2511: THEN
2512: fnd_log.string
2513: (
2514: fnd_log.level_statement,

Line 2512: fnd_log.string

2508: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
2509:
2510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2511: THEN
2512: fnd_log.string
2513: (
2514: fnd_log.level_statement,
2515: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2516: 'Updated MC node ['||p_nodes_tbl(i).relationship_id||'] with new item group id ['||l_item_group_id||']'

Line 2514: fnd_log.level_statement,

2510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2511: THEN
2512: fnd_log.string
2513: (
2514: fnd_log.level_statement,
2515: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2516: 'Updated MC node ['||p_nodes_tbl(i).relationship_id||'] with new item group id ['||l_item_group_id||']'
2517: );
2518: END IF;

Line 2522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2518: END IF;
2519: END LOOP;
2520: END IF;
2521:
2522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2523: THEN
2524: fnd_log.string
2525: (
2526: fnd_log.level_procedure,

Line 2524: fnd_log.string

2520: END IF;
2521:
2522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2523: THEN
2524: fnd_log.string
2525: (
2526: fnd_log.level_procedure,
2527: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2528: 'At the end of PLSQL procedure'

Line 2526: fnd_log.level_procedure,

2522: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2523: THEN
2524: fnd_log.string
2525: (
2526: fnd_log.level_procedure,
2527: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2528: 'At the end of PLSQL procedure'
2529: );
2530: END IF;

Line 2619: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2623: fnd_log.level_exception,

Line 2621: fnd_log.message

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: (
2623: fnd_log.level_exception,
2624: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node_Exists',
2625: false

Line 2623: fnd_log.level_exception,

2619: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2620: THEN
2621: fnd_log.message
2622: (
2623: fnd_log.level_exception,
2624: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node_Exists',
2625: false
2626: );
2627: END IF;

Line 2634: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2638: fnd_log.level_exception,

Line 2636: fnd_log.message

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: (
2638: fnd_log.level_exception,
2639: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node_Exists',
2640: false

Line 2638: fnd_log.level_exception,

2634: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2635: THEN
2636: fnd_log.message
2637: (
2638: fnd_log.level_exception,
2639: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node_Exists',
2640: false
2641: );
2642: END IF;

Line 2756: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2760: fnd_log.level_exception,

Line 2758: fnd_log.message

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: (
2760: fnd_log.level_exception,
2761: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2762: false

Line 2760: fnd_log.level_exception,

2756: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2757: THEN
2758: fnd_log.message
2759: (
2760: fnd_log.level_exception,
2761: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2762: false
2763: );
2764: END IF;

Line 2776: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2780: fnd_log.level_exception,

Line 2778: fnd_log.message

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: (
2780: fnd_log.level_exception,
2781: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2782: false

Line 2780: fnd_log.level_exception,

2776: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2777: THEN
2778: fnd_log.message
2779: (
2780: fnd_log.level_exception,
2781: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2782: false
2783: );
2784: END IF;

Line 2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2796: fnd_log.level_exception,

Line 2794: fnd_log.message

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: (
2796: fnd_log.level_exception,
2797: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2798: false

Line 2796: fnd_log.level_exception,

2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2793: THEN
2794: fnd_log.message
2795: (
2796: fnd_log.level_exception,
2797: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2798: false
2799: );
2800: END IF;

Line 2810: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2814: fnd_log.level_exception,

Line 2812: fnd_log.message

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: (
2814: fnd_log.level_exception,
2815: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2816: false

Line 2814: fnd_log.level_exception,

2810: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2811: THEN
2812: fnd_log.message
2813: (
2814: fnd_log.level_exception,
2815: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2816: false
2817: );
2818: END IF;

Line 2830: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2834: fnd_log.level_exception,

Line 2832: fnd_log.message

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: (
2834: fnd_log.level_exception,
2835: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2836: false

Line 2834: fnd_log.level_exception,

2830: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2831: THEN
2832: fnd_log.message
2833: (
2834: fnd_log.level_exception,
2835: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2836: false
2837: );
2838: END IF;

Line 2851: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2855: fnd_log.level_exception,

Line 2853: fnd_log.message

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: (
2855: fnd_log.level_exception,
2856: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2857: false

Line 2855: fnd_log.level_exception,

2851: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2852: THEN
2853: fnd_log.message
2854: (
2855: fnd_log.level_exception,
2856: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2857: false
2858: );
2859: END IF;

Line 2874: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2878: fnd_log.level_exception,

Line 2876: fnd_log.message

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: (
2878: fnd_log.level_exception,
2879: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2880: false

Line 2878: fnd_log.level_exception,

2874: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2875: THEN
2876: fnd_log.message
2877: (
2878: fnd_log.level_exception,
2879: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2880: false
2881: );
2882: END IF;

Line 2897: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2901: fnd_log.level_exception,

Line 2899: fnd_log.message

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: (
2901: fnd_log.level_exception,
2902: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2903: false

Line 2901: fnd_log.level_exception,

2897: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2898: THEN
2899: fnd_log.message
2900: (
2901: fnd_log.level_exception,
2902: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2903: false
2904: );
2905: END IF;

Line 2915: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2919: fnd_log.level_exception,

Line 2917: fnd_log.message

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: (
2919: fnd_log.level_exception,
2920: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2921: false

Line 2919: fnd_log.level_exception,

2915: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2916: THEN
2917: fnd_log.message
2918: (
2919: fnd_log.level_exception,
2920: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2921: false
2922: );
2923: END IF;

Line 2930: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2934: fnd_log.level_exception,

Line 2932: fnd_log.message

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: (
2934: fnd_log.level_exception,
2935: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2936: false

Line 2934: fnd_log.level_exception,

2930: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2931: THEN
2932: fnd_log.message
2933: (
2934: fnd_log.level_exception,
2935: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2936: false
2937: );
2938: END IF;

Line 2953: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2957: fnd_log.level_exception,

Line 2955: fnd_log.message

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: (
2957: fnd_log.level_exception,
2958: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2959: false

Line 2957: fnd_log.level_exception,

2953: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2954: THEN
2955: fnd_log.message
2956: (
2957: fnd_log.level_exception,
2958: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2959: false
2960: );
2961: END IF;

Line 2975: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2979: fnd_log.level_exception,

Line 2977: fnd_log.message

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: (
2979: fnd_log.level_exception,
2980: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2981: false

Line 2979: fnd_log.level_exception,

2975: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2976: THEN
2977: fnd_log.message
2978: (
2979: fnd_log.level_exception,
2980: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
2981: false
2982: );
2983: END IF;

Line 2994: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
2998: fnd_log.level_exception,

Line 2996: fnd_log.message

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: (
2998: fnd_log.level_exception,
2999: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3000: false

Line 2998: fnd_log.level_exception,

2994: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2995: THEN
2996: fnd_log.message
2997: (
2998: fnd_log.level_exception,
2999: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3000: false
3001: );
3002: END IF;

Line 3011: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3015: fnd_log.level_exception,

Line 3013: fnd_log.message

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: (
3015: fnd_log.level_exception,
3016: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3017: false

Line 3015: fnd_log.level_exception,

3011: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3012: THEN
3013: fnd_log.message
3014: (
3015: fnd_log.level_exception,
3016: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3017: false
3018: );
3019: END IF;

Line 3034: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3038: fnd_log.level_exception,

Line 3036: fnd_log.message

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: (
3038: fnd_log.level_exception,
3039: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3040: false

Line 3038: fnd_log.level_exception,

3034: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3035: THEN
3036: fnd_log.message
3037: (
3038: fnd_log.level_exception,
3039: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3040: false
3041: );
3042: END IF;

Line 3049: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3053: fnd_log.level_exception,

Line 3051: fnd_log.message

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: (
3053: fnd_log.level_exception,
3054: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3055: false

Line 3053: fnd_log.level_exception,

3049: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3050: THEN
3051: fnd_log.message
3052: (
3053: fnd_log.level_exception,
3054: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3055: false
3056: );
3057: END IF;

Line 3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3071: fnd_log.level_exception,

Line 3069: fnd_log.message

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: (
3071: fnd_log.level_exception,
3072: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3073: false

Line 3071: fnd_log.level_exception,

3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3068: THEN
3069: fnd_log.message
3070: (
3071: fnd_log.level_exception,
3072: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3073: false
3074: );
3075: END IF;

Line 3086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3090: fnd_log.level_exception,

Line 3088: fnd_log.message

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: (
3090: fnd_log.level_exception,
3091: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3092: false

Line 3090: fnd_log.level_exception,

3086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3087: THEN
3088: fnd_log.message
3089: (
3090: fnd_log.level_exception,
3091: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3092: false
3093: );
3094: END IF;

Line 3101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3105: fnd_log.level_exception,

Line 3103: fnd_log.message

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: (
3105: fnd_log.level_exception,
3106: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3107: false

Line 3105: fnd_log.level_exception,

3101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3102: THEN
3103: fnd_log.message
3104: (
3105: fnd_log.level_exception,
3106: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3107: false
3108: );
3109: END IF;

Line 3120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3124: fnd_log.level_exception,

Line 3122: fnd_log.message

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: (
3124: fnd_log.level_exception,
3125: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3126: false

Line 3124: fnd_log.level_exception,

3120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3121: THEN
3122: fnd_log.message
3123: (
3124: fnd_log.level_exception,
3125: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3126: false
3127: );
3128: END IF;

Line 3139: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3143: fnd_log.level_exception,

Line 3141: fnd_log.message

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: (
3143: fnd_log.level_exception,
3144: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3145: false

Line 3143: fnd_log.level_exception,

3139: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3140: THEN
3141: fnd_log.message
3142: (
3143: fnd_log.level_exception,
3144: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3145: false
3146: );
3147: END IF;

Line 3157: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3161: fnd_log.level_exception,

Line 3159: fnd_log.message

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: (
3161: fnd_log.level_exception,
3162: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3163: false

Line 3161: fnd_log.level_exception,

3157: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3158: THEN
3159: fnd_log.message
3160: (
3161: fnd_log.level_exception,
3162: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3163: false
3164: );
3165: END IF;

Line 3185: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3189: fnd_log.level_exception,

Line 3187: fnd_log.message

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: (
3189: fnd_log.level_exception,
3190: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3191: false

Line 3189: fnd_log.level_exception,

3185: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3186: THEN
3187: fnd_log.message
3188: (
3189: fnd_log.level_exception,
3190: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3191: false
3192: );
3193: END IF;

Line 3200: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3204: fnd_log.level_exception,

Line 3202: fnd_log.message

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: (
3204: fnd_log.level_exception,
3205: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3206: false

Line 3204: fnd_log.level_exception,

3200: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3201: THEN
3202: fnd_log.message
3203: (
3204: fnd_log.level_exception,
3205: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3206: false
3207: );
3208: END IF;

Line 3215: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3219: fnd_log.level_exception,

Line 3217: fnd_log.message

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: (
3219: fnd_log.level_exception,
3220: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3221: false

Line 3219: fnd_log.level_exception,

3215: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3216: THEN
3217: fnd_log.message
3218: (
3219: fnd_log.level_exception,
3220: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3221: false
3222: );
3223: END IF;

Line 3231: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3235: fnd_log.level_exception,

Line 3233: fnd_log.message

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: (
3235: fnd_log.level_exception,
3236: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3237: false

Line 3235: fnd_log.level_exception,

3231: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3232: THEN
3233: fnd_log.message
3234: (
3235: fnd_log.level_exception,
3236: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3237: false
3238: );
3239: END IF;

Line 3246: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3250: fnd_log.level_exception,

Line 3248: fnd_log.message

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: (
3250: fnd_log.level_exception,
3251: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3252: false

Line 3250: fnd_log.level_exception,

3246: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3247: THEN
3248: fnd_log.message
3249: (
3250: fnd_log.level_exception,
3251: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3252: false
3253: );
3254: END IF;

Line 3262: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3266: fnd_log.level_exception,

Line 3264: fnd_log.message

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: (
3266: fnd_log.level_exception,
3267: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3268: false

Line 3266: fnd_log.level_exception,

3262: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3263: THEN
3264: fnd_log.message
3265: (
3266: fnd_log.level_exception,
3267: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Node',
3268: false
3269: );
3270: END IF;

Line 3296: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3300: fnd_log.level_exception,

Line 3298: fnd_log.message

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: (
3300: fnd_log.level_exception,
3301: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Exists',
3302: false

Line 3300: fnd_log.level_exception,

3296: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3297: THEN
3298: fnd_log.message
3299: (
3300: fnd_log.level_exception,
3301: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Exists',
3302: false
3303: );
3304: END IF;

Line 3311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3315: fnd_log.level_exception,

Line 3313: fnd_log.message

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: (
3315: fnd_log.level_exception,
3316: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Exists',
3317: false

Line 3315: fnd_log.level_exception,

3311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3312: THEN
3313: fnd_log.message
3314: (
3315: fnd_log.level_exception,
3316: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Exists',
3317: false
3318: );
3319: END IF;

Line 3364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3368: fnd_log.level_exception,

Line 3366: fnd_log.message

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: (
3368: fnd_log.level_exception,
3369: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3370: false

Line 3368: fnd_log.level_exception,

3364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3365: THEN
3366: fnd_log.message
3367: (
3368: fnd_log.level_exception,
3369: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3370: false
3371: );
3372: END IF;

Line 3382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3386: fnd_log.level_exception,

Line 3384: fnd_log.message

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: (
3386: fnd_log.level_exception,
3387: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3388: false

Line 3386: fnd_log.level_exception,

3382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3383: THEN
3384: fnd_log.message
3385: (
3386: fnd_log.level_exception,
3387: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3388: false
3389: );
3390: END IF;

Line 3401: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3405: fnd_log.level_exception,

Line 3403: fnd_log.message

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: (
3405: fnd_log.level_exception,
3406: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3407: false

Line 3405: fnd_log.level_exception,

3401: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3402: THEN
3403: fnd_log.message
3404: (
3405: fnd_log.level_exception,
3406: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3407: false
3408: );
3409: END IF;

Line 3416: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3420: fnd_log.level_exception,

Line 3418: fnd_log.message

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: (
3420: fnd_log.level_exception,
3421: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3422: false

Line 3420: fnd_log.level_exception,

3416: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3417: THEN
3418: fnd_log.message
3419: (
3420: fnd_log.level_exception,
3421: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3422: false
3423: );
3424: END IF;

Line 3437: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3441: fnd_log.level_exception,

Line 3439: fnd_log.message

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: (
3441: fnd_log.level_exception,
3442: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3443: false

Line 3441: fnd_log.level_exception,

3437: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3438: THEN
3439: fnd_log.message
3440: (
3441: fnd_log.level_exception,
3442: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3443: false
3444: );
3445: END IF;

Line 3456: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3460: fnd_log.level_exception,

Line 3458: fnd_log.message

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: (
3460: fnd_log.level_exception,
3461: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3462: false

Line 3460: fnd_log.level_exception,

3456: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3457: THEN
3458: fnd_log.message
3459: (
3460: fnd_log.level_exception,
3461: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Counter_Rule',
3462: false
3463: );
3464: END IF;

Line 3490: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3494: fnd_log.level_exception,

Line 3492: fnd_log.message

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: (
3494: fnd_log.level_exception,
3495: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Subconfig_Exists',
3496: false

Line 3494: fnd_log.level_exception,

3490: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3491: THEN
3492: fnd_log.message
3493: (
3494: fnd_log.level_exception,
3495: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Subconfig_Exists',
3496: false
3497: );
3498: END IF;

Line 3505: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3509: fnd_log.level_exception,

Line 3507: fnd_log.message

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: (
3509: fnd_log.level_exception,
3510: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Subconfig_Exists',
3511: false

Line 3509: fnd_log.level_exception,

3505: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3506: THEN
3507: fnd_log.message
3508: (
3509: fnd_log.level_exception,
3510: 'ahl.plsql.'||G_PKG_NAME||'.Validate_Subconfig_Exists',
3511: false
3512: );
3513: END IF;

Line 3546: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3550: fnd_log.level_exception,

Line 3548: fnd_log.message

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: (
3550: fnd_log.level_exception,
3551: 'ahl.plsql.'||G_PKG_NAME||'.Validate_priority',
3552: true

Line 3550: fnd_log.level_exception,

3546: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3547: THEN
3548: fnd_log.message
3549: (
3550: fnd_log.level_exception,
3551: 'ahl.plsql.'||G_PKG_NAME||'.Validate_priority',
3552: true
3553: );
3554: END IF;

Line 3624: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3628: fnd_log.level_exception,

Line 3626: fnd_log.message

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: (
3628: fnd_log.level_exception,
3629: 'ahl.plsql.'||G_PKG_NAME||'.Check_Cyclic_Rel',
3630: false

Line 3628: fnd_log.level_exception,

3624: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3625: THEN
3626: fnd_log.message
3627: (
3628: fnd_log.level_exception,
3629: 'ahl.plsql.'||G_PKG_NAME||'.Check_Cyclic_Rel',
3630: false
3631: );
3632: END IF;

Line 3674: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3678: fnd_log.level_exception,

Line 3676: fnd_log.message

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: (
3678: fnd_log.level_exception,
3679: 'ahl.plsql.'||G_PKG_NAME||'.Get_MC_Status',
3680: false

Line 3678: fnd_log.level_exception,

3674: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3675: THEN
3676: fnd_log.message
3677: (
3678: fnd_log.level_exception,
3679: 'ahl.plsql.'||G_PKG_NAME||'.Get_MC_Status',
3680: false
3681: );
3682: END IF;

Line 3695: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
3699: fnd_log.level_exception,

Line 3697: fnd_log.message

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: (
3699: fnd_log.level_exception,
3700: 'ahl.plsql.'||G_PKG_NAME||'.Get_MC_Status',
3701: false

Line 3699: fnd_log.level_exception,

3695: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3696: THEN
3697: fnd_log.message
3698: (
3699: fnd_log.level_exception,
3700: 'ahl.plsql.'||G_PKG_NAME||'.Get_MC_Status',
3701: false
3702: );
3703: END IF;

Line 3818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

3814:
3815: BEGIN
3816:
3817: -- API body starts here
3818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3819: THEN
3820: fnd_log.string
3821: (
3822: fnd_log.level_procedure,

Line 3820: fnd_log.string

3816:
3817: -- API body starts here
3818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3819: THEN
3820: fnd_log.string
3821: (
3822: fnd_log.level_procedure,
3823: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3824: 'At the start of PLSQL procedure'

Line 3822: fnd_log.level_procedure,

3818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3819: THEN
3820: fnd_log.string
3821: (
3822: fnd_log.level_procedure,
3823: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3824: 'At the start of PLSQL procedure'
3825: );
3826: END IF;

Line 3840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3836: IF l_msg_count > 0 THEN
3837: RAISE FND_API.G_EXC_ERROR;
3838: END IF;
3839:
3840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3841: THEN
3842: fnd_log.string
3843: (
3844: fnd_log.level_statement,

Line 3842: fnd_log.string

3838: END IF;
3839:
3840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3841: THEN
3842: fnd_log.string
3843: (
3844: fnd_log.level_statement,
3845: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3846: 'Counter rule validation successful'

Line 3844: fnd_log.level_statement,

3840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3841: THEN
3842: fnd_log.string
3843: (
3844: fnd_log.level_statement,
3845: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3846: 'Counter rule validation successful'
3847: );
3848: END IF;

Line 3954: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

3950:
3951: BEGIN
3952:
3953: -- API body starts here
3954: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3955: THEN
3956: fnd_log.string
3957: (
3958: fnd_log.level_procedure,

Line 3956: fnd_log.string

3952:
3953: -- API body starts here
3954: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3955: THEN
3956: fnd_log.string
3957: (
3958: fnd_log.level_procedure,
3959: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
3960: 'At the start of PLSQL procedure'

Line 3958: fnd_log.level_procedure,

3954: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3955: THEN
3956: fnd_log.string
3957: (
3958: fnd_log.level_procedure,
3959: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
3960: 'At the start of PLSQL procedure'
3961: );
3962: END IF;

Line 3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3975: IF l_msg_count > 0 THEN
3976: RAISE FND_API.G_EXC_ERROR;
3977: END IF;
3978:
3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3980: THEN
3981: fnd_log.string
3982: (
3983: fnd_log.level_statement,

Line 3981: fnd_log.string

3977: END IF;
3978:
3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3980: THEN
3981: fnd_log.string
3982: (
3983: fnd_log.level_statement,
3984: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3985: 'Counter rule validation successful'

Line 3983: fnd_log.level_statement,

3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3980: THEN
3981: fnd_log.string
3982: (
3983: fnd_log.level_statement,
3984: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
3985: 'Counter rule validation successful'
3986: );
3987: END IF;

Line 4034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4030:
4031: BEGIN
4032:
4033: -- API body starts here
4034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4035: THEN
4036: fnd_log.string
4037: (
4038: fnd_log.level_procedure,

Line 4036: fnd_log.string

4032:
4033: -- API body starts here
4034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4035: THEN
4036: fnd_log.string
4037: (
4038: fnd_log.level_procedure,
4039: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4040: 'At the start of PLSQL procedure'

Line 4038: fnd_log.level_procedure,

4034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4035: THEN
4036: fnd_log.string
4037: (
4038: fnd_log.level_procedure,
4039: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4040: 'At the start of PLSQL procedure'
4041: );
4042: END IF;

Line 4050: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4046:
4047: DELETE FROM ahl_ctr_update_rules
4048: WHERE ctr_update_rule_id = p_ctr_update_rule_id;
4049:
4050: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4051: THEN
4052: fnd_log.string
4053: (
4054: fnd_log.level_procedure,

Line 4052: fnd_log.string

4048: WHERE ctr_update_rule_id = p_ctr_update_rule_id;
4049:
4050: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4051: THEN
4052: fnd_log.string
4053: (
4054: fnd_log.level_procedure,
4055: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4056: 'At the end of PLSQL procedure'

Line 4054: fnd_log.level_procedure,

4050: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4051: THEN
4052: fnd_log.string
4053: (
4054: fnd_log.level_procedure,
4055: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4056: 'At the end of PLSQL procedure'
4057: );
4058: END IF;

Line 4129: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4125:
4126: BEGIN
4127:
4128: -- API body starts here
4129: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4130: THEN
4131: fnd_log.string
4132: (
4133: fnd_log.level_procedure,

Line 4131: fnd_log.string

4127:
4128: -- API body starts here
4129: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4130: THEN
4131: fnd_log.string
4132: (
4133: fnd_log.level_procedure,
4134: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4135: 'At the start of PLSQL procedure'

Line 4133: fnd_log.level_procedure,

4129: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4130: THEN
4131: fnd_log.string
4132: (
4133: fnd_log.level_procedure,
4134: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4135: 'At the start of PLSQL procedure'
4136: );
4137: END IF;

Line 4149: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4153: fnd_log.level_exception,

Line 4151: fnd_log.message

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: (
4153: fnd_log.level_exception,
4154: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4155: false

Line 4153: fnd_log.level_exception,

4149: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4150: THEN
4151: fnd_log.message
4152: (
4153: fnd_log.level_exception,
4154: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4155: false
4156: );
4157: END IF;

Line 4168: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4172: fnd_log.level_exception,

Line 4170: fnd_log.message

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: (
4172: fnd_log.level_exception,
4173: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4174: false

Line 4172: fnd_log.level_exception,

4168: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4169: THEN
4170: fnd_log.message
4171: (
4172: fnd_log.level_exception,
4173: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4174: false
4175: );
4176: END IF;

Line 4187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4191: fnd_log.level_exception,

Line 4189: fnd_log.message

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: (
4191: fnd_log.level_exception,
4192: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4193: false

Line 4191: fnd_log.level_exception,

4187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4188: THEN
4189: fnd_log.message
4190: (
4191: fnd_log.level_exception,
4192: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4193: false
4194: );
4195: END IF;

Line 4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4211: fnd_log.level_exception,

Line 4209: fnd_log.message

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: (
4211: fnd_log.level_exception,
4212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4213: false

Line 4211: fnd_log.level_exception,

4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4208: THEN
4209: fnd_log.message
4210: (
4211: fnd_log.level_exception,
4212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4213: false
4214: );
4215: END IF;

Line 4240: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4244: fnd_log.level_exception,

Line 4242: fnd_log.message

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: (
4244: fnd_log.level_exception,
4245: 'ahl.plsql.'||G_PKG_NAME||'.Check_Cyclic_Rel',
4246: false

Line 4244: fnd_log.level_exception,

4240: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4241: THEN
4242: fnd_log.message
4243: (
4244: fnd_log.level_exception,
4245: 'ahl.plsql.'||G_PKG_NAME||'.Check_Cyclic_Rel',
4246: false
4247: );
4248: END IF;

Line 4263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4267: fnd_log.level_exception,

Line 4265: fnd_log.message

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: (
4267: fnd_log.level_exception,
4268: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4269: false

Line 4267: fnd_log.level_exception,

4263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4264: THEN
4265: fnd_log.message
4266: (
4267: fnd_log.level_exception,
4268: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4269: false
4270: );
4271: END IF;

Line 4278: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4282: fnd_log.level_exception,

Line 4280: fnd_log.message

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: (
4282: fnd_log.level_exception,
4283: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4284: false

Line 4282: fnd_log.level_exception,

4278: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4279: THEN
4280: fnd_log.message
4281: (
4282: fnd_log.level_exception,
4283: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4284: false
4285: );
4286: END IF;

Line 4293: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4297: fnd_log.level_exception,

Line 4295: fnd_log.message

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: (
4297: fnd_log.level_exception,
4298: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4299: false

Line 4297: fnd_log.level_exception,

4293: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4294: THEN
4295: fnd_log.message
4296: (
4297: fnd_log.level_exception,
4298: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4299: false
4300: );
4301: END IF;

Line 4309: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4313: fnd_log.level_exception,

Line 4311: fnd_log.message

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: (
4313: fnd_log.level_exception,
4314: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4315: false

Line 4313: fnd_log.level_exception,

4309: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4310: THEN
4311: fnd_log.message
4312: (
4313: fnd_log.level_exception,
4314: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4315: false
4316: );
4317: END IF;

Line 4322: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4326: fnd_log.level_exception,

Line 4324: fnd_log.message

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: (
4326: fnd_log.level_exception,
4327: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4328: false

Line 4326: fnd_log.level_exception,

4322: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4323: THEN
4324: fnd_log.message
4325: (
4326: fnd_log.level_exception,
4327: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4328: false
4329: );
4330: END IF;

Line 4339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

4335: IF l_msg_count > 0 THEN
4336: RAISE FND_API.G_EXC_ERROR;
4337: END IF;
4338:
4339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4340: THEN
4341: fnd_log.string
4342: (
4343: fnd_log.level_statement,

Line 4341: fnd_log.string

4337: END IF;
4338:
4339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4340: THEN
4341: fnd_log.string
4342: (
4343: fnd_log.level_statement,
4344: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4345: 'Subconfiguration association validation successful'

Line 4343: fnd_log.level_statement,

4339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4340: THEN
4341: fnd_log.string
4342: (
4343: fnd_log.level_statement,
4344: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4345: 'Subconfiguration association validation successful'
4346: );
4347: END IF;

Line 4450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4446:
4447: BEGIN
4448:
4449: -- API body starts here
4450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4451: THEN
4452: fnd_log.string
4453: (
4454: fnd_log.level_procedure,

Line 4452: fnd_log.string

4448:
4449: -- API body starts here
4450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4451: THEN
4452: fnd_log.string
4453: (
4454: fnd_log.level_procedure,
4455: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4456: 'At the start of PLSQL procedure'

Line 4454: fnd_log.level_procedure,

4450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4451: THEN
4452: fnd_log.string
4453: (
4454: fnd_log.level_procedure,
4455: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4456: 'At the start of PLSQL procedure'
4457: );
4458: END IF;

Line 4472: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4476: fnd_log.level_exception,

Line 4474: fnd_log.message

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: (
4476: fnd_log.level_exception,
4477: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4478: false

Line 4476: fnd_log.level_exception,

4472: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4473: THEN
4474: fnd_log.message
4475: (
4476: fnd_log.level_exception,
4477: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4478: false
4479: );
4480: END IF;

Line 4495: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4499: fnd_log.level_exception,

Line 4497: fnd_log.message

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: (
4499: fnd_log.level_exception,
4500: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4501: false

Line 4499: fnd_log.level_exception,

4495: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4496: THEN
4497: fnd_log.message
4498: (
4499: fnd_log.level_exception,
4500: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4501: false
4502: );
4503: END IF;

Line 4511: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4515: fnd_log.level_exception,

Line 4513: fnd_log.message

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: (
4515: fnd_log.level_exception,
4516: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4517: false

Line 4515: fnd_log.level_exception,

4511: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4512: THEN
4513: fnd_log.message
4514: (
4515: fnd_log.level_exception,
4516: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4517: false
4518: );
4519: END IF;

Line 4526: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4530: fnd_log.level_exception,

Line 4528: fnd_log.message

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: (
4530: fnd_log.level_exception,
4531: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4532: false

Line 4530: fnd_log.level_exception,

4526: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4527: THEN
4528: fnd_log.message
4529: (
4530: fnd_log.level_exception,
4531: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4532: false
4533: );
4534: END IF;

Line 4541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4545: fnd_log.level_exception,

Line 4543: fnd_log.message

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: (
4545: fnd_log.level_exception,
4546: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4547: false

Line 4545: fnd_log.level_exception,

4541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4542: THEN
4543: fnd_log.message
4544: (
4545: fnd_log.level_exception,
4546: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4547: false
4548: );
4549: END IF;

Line 4558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4562: fnd_log.level_exception,

Line 4560: fnd_log.message

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: (
4562: fnd_log.level_exception,
4563: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4564: false

Line 4562: fnd_log.level_exception,

4558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4559: THEN
4560: fnd_log.message
4561: (
4562: fnd_log.level_exception,
4563: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4564: false
4565: );
4566: END IF;

Line 4571: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4575: fnd_log.level_exception,

Line 4573: fnd_log.message

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: (
4575: fnd_log.level_exception,
4576: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4577: false

Line 4575: fnd_log.level_exception,

4571: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4572: THEN
4573: fnd_log.message
4574: (
4575: fnd_log.level_exception,
4576: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4577: false
4578: );
4579: END IF;

Line 4589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

4585: IF l_msg_count > 0 THEN
4586: RAISE FND_API.G_EXC_ERROR;
4587: END IF;
4588:
4589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4590: THEN
4591: fnd_log.string
4592: (
4593: fnd_log.level_statement,

Line 4591: fnd_log.string

4587: END IF;
4588:
4589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4590: THEN
4591: fnd_log.string
4592: (
4593: fnd_log.level_statement,
4594: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4595: 'Subconfiguration association validation successful'

Line 4593: fnd_log.level_statement,

4589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4590: THEN
4591: fnd_log.string
4592: (
4593: fnd_log.level_statement,
4594: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4595: 'Subconfiguration association validation successful'
4596: );
4597: END IF;

Line 4645: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4641:
4642: BEGIN
4643:
4644: -- API body starts here
4645: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4646: THEN
4647: fnd_log.string
4648: (
4649: fnd_log.level_procedure,

Line 4647: fnd_log.string

4643:
4644: -- API body starts here
4645: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4646: THEN
4647: fnd_log.string
4648: (
4649: fnd_log.level_procedure,
4650: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4651: 'At the start of PLSQL procedure'

Line 4649: fnd_log.level_procedure,

4645: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4646: THEN
4647: fnd_log.string
4648: (
4649: fnd_log.level_procedure,
4650: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4651: 'At the start of PLSQL procedure'
4652: );
4653: END IF;

Line 4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4657:
4658: DELETE FROM ahl_mc_config_relations
4659: WHERE mc_config_relation_id = p_mc_config_relation_id;
4660:
4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4662: THEN
4663: fnd_log.string
4664: (
4665: fnd_log.level_procedure,

Line 4663: fnd_log.string

4659: WHERE mc_config_relation_id = p_mc_config_relation_id;
4660:
4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4662: THEN
4663: fnd_log.string
4664: (
4665: fnd_log.level_procedure,
4666: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4667: 'At the end of PLSQL procedure'

Line 4665: fnd_log.level_procedure,

4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4662: THEN
4663: fnd_log.string
4664: (
4665: fnd_log.level_procedure,
4666: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4667: 'At the end of PLSQL procedure'
4668: );
4669: END IF;

Line 4734: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4730:
4731: BEGIN
4732:
4733: -- API body starts here
4734: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4735: THEN
4736: fnd_log.string
4737: (
4738: fnd_log.level_procedure,

Line 4736: fnd_log.string

4732:
4733: -- API body starts here
4734: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4735: THEN
4736: fnd_log.string
4737: (
4738: fnd_log.level_procedure,
4739: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4740: 'At the start of PLSQL procedure'

Line 4738: fnd_log.level_procedure,

4734: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4735: THEN
4736: fnd_log.string
4737: (
4738: fnd_log.level_procedure,
4739: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
4740: 'At the start of PLSQL procedure'
4741: );
4742: END IF;

Line 4756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

4752: IF l_msg_count > 0 THEN
4753: RAISE FND_API.G_EXC_ERROR;
4754: END IF;
4755:
4756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4757: THEN
4758: fnd_log.string
4759: (
4760: fnd_log.level_statement,

Line 4758: fnd_log.string

4754: END IF;
4755:
4756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4757: THEN
4758: fnd_log.string
4759: (
4760: fnd_log.level_statement,
4761: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4762: 'Source and destination node validation successful'

Line 4760: fnd_log.level_statement,

4756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4757: THEN
4758: fnd_log.string
4759: (
4760: fnd_log.level_statement,
4761: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4762: 'Source and destination node validation successful'
4763: );
4764: END IF;

Line 4779: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4783: fnd_log.level_exception,

Line 4781: fnd_log.message

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: (
4783: fnd_log.level_exception,
4784: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4785: false

Line 4783: fnd_log.level_exception,

4779: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4780: THEN
4781: fnd_log.message
4782: (
4783: fnd_log.level_exception,
4784: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4785: false
4786: );
4787: END IF;

Line 4815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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: (
4819: fnd_log.level_exception,

Line 4817: fnd_log.message

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: (
4819: fnd_log.level_exception,
4820: 'ahl.plsql.'||G_PKG_NAME||'.Check_Cyclic_Rel',
4821: false

Line 4819: fnd_log.level_exception,

4815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4816: THEN
4817: fnd_log.message
4818: (
4819: fnd_log.level_exception,
4820: 'ahl.plsql.'||G_PKG_NAME||'.Check_Cyclic_Rel',
4821: false
4822: );
4823: END IF;

Line 4831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

4827: IF l_msg_count > 0 THEN
4828: RAISE FND_API.G_EXC_ERROR;
4829: END IF;
4830:
4831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4832: THEN
4833: fnd_log.string
4834: (
4835: fnd_log.level_statement,

Line 4833: fnd_log.string

4829: END IF;
4830:
4831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4832: THEN
4833: fnd_log.string
4834: (
4835: fnd_log.level_statement,
4836: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4837: 'Cyclic relation check for node ['||p_dest_rel_id||'] and subconfiguration ['||l_subconfig_csr_rec.mc_header_id||'] is successful'

Line 4835: fnd_log.level_statement,

4831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4832: THEN
4833: fnd_log.string
4834: (
4835: fnd_log.level_statement,
4836: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4837: 'Cyclic relation check for node ['||p_dest_rel_id||'] and subconfiguration ['||l_subconfig_csr_rec.mc_header_id||'] is successful'
4838: );
4839: END IF;

Line 4910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

4906: l_subconfig_csr_rec.ATTRIBUTE15,
4907: l_subconfig_csr_rec.PRIORITY
4908: );
4909:
4910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4911: THEN
4912: fnd_log.string
4913: (
4914: fnd_log.level_statement,

Line 4912: fnd_log.string

4908: );
4909:
4910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4911: THEN
4912: fnd_log.string
4913: (
4914: fnd_log.level_statement,
4915: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4916: 'Subconfiguration association ['||l_subconfig_csr_rec.mc_config_relation_id||'] copied to ['||l_mc_config_rel_id||']'

Line 4914: fnd_log.level_statement,

4910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
4911: THEN
4912: fnd_log.string
4913: (
4914: fnd_log.level_statement,
4915: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
4916: 'Subconfiguration association ['||l_subconfig_csr_rec.mc_config_relation_id||'] copied to ['||l_mc_config_rel_id||']'
4917: );
4918: END IF;

Line 4922: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

4918: END IF;
4919: END LOOP;
4920: CLOSE get_subconfigs;
4921:
4922: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4923: THEN
4924: fnd_log.string
4925: (
4926: fnd_log.level_procedure,

Line 4924: fnd_log.string

4920: CLOSE get_subconfigs;
4921:
4922: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4923: THEN
4924: fnd_log.string
4925: (
4926: fnd_log.level_procedure,
4927: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4928: 'At the end of PLSQL procedure'

Line 4926: fnd_log.level_procedure,

4922: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4923: THEN
4924: fnd_log.string
4925: (
4926: fnd_log.level_procedure,
4927: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
4928: 'At the end of PLSQL procedure'
4929: );
4930: END IF;