eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MC_ITEM_COMP_PVT dependencies on FND_LOG

Line 428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

424: -- Initialize API return status to success
425:
426: x_return_status :=FND_API.G_RET_STS_SUCCESS;
427:
428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
429: THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
431: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Begin of Create_Item_Composition');
432: END IF;

Line 430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

426: x_return_status :=FND_API.G_RET_STS_SUCCESS;
427:
428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
429: THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
431: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Begin of Create_Item_Composition');
432: END IF;
433:
434:

Line 560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

556:
557:
558: p_x_ic_header_rec.ITEM_COMPOSITION_ID := l_item_composition_id;
559:
560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
561: THEN
562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
563: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'End of Create_Item_Composition');
564: END IF;

Line 562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

558: p_x_ic_header_rec.ITEM_COMPOSITION_ID := l_item_composition_id;
559:
560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
561: THEN
562: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
563: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'End of Create_Item_Composition');
564: END IF;
565:
566:

Line 575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

571: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
572: p_data => x_msg_data,
573: p_encoded => fnd_api.g_false);
574:
575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
576: THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
578: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Error in Create_Item_Composition');
579: END IF;

Line 577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

573: p_encoded => fnd_api.g_false);
574:
575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
576: THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
578: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Error in Create_Item_Composition');
579: END IF;
580:
581:

Line 589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
586: p_data => x_msg_data,
587: p_encoded => fnd_api.g_false);
588:
589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
590: THEN
591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
592: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unexpected Error in Create_Item_Composition');
593: END IF;

Line 591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

587: p_encoded => fnd_api.g_false);
588:
589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
590: THEN
591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
592: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unexpected Error in Create_Item_Composition');
593: END IF;
594:
595: WHEN OTHERS THEN

Line 607: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

603: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => fnd_api.g_false);
606:
607: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
608: THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
610: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unknown Error in Create_Item_Composition');
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

605: p_encoded => fnd_api.g_false);
606:
607: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
608: THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
610: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unknown Error in Create_Item_Composition');
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
612: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', SQLERRM);
613:

Line 611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

607: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
608: THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
610: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unknown Error in Create_Item_Composition');
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
612: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', SQLERRM);
613:
614: END IF;
615:

Line 721: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

717: -- Initialize API return status to success
718:
719: x_return_status :=FND_API.G_RET_STS_SUCCESS;
720:
721: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
722: THEN
723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
724: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Begin of Modify_Item_Composition');
725: END IF;

Line 723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

719: x_return_status :=FND_API.G_RET_STS_SUCCESS;
720:
721: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
722: THEN
723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
724: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Begin of Modify_Item_Composition');
725: END IF;
726:
727:

Line 834: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

830: RAISE FND_API.G_EXC_ERROR;
831: END IF;
832:
833:
834: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
835: THEN
836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
837: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'End of Modify_Item_Composition');
838: END IF;

Line 836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

832:
833:
834: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
835: THEN
836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
837: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'End of Modify_Item_Composition');
838: END IF;
839:
840:

Line 850: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

846: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
847: p_data => x_msg_data,
848: p_encoded => fnd_api.g_false);
849:
850: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
851: THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
853: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Error in Modify_Item_Composition');
854: END IF;

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

848: p_encoded => fnd_api.g_false);
849:
850: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
851: THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
853: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Error in Modify_Item_Composition');
854: END IF;
855:
856:

Line 864: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
861: p_data => x_msg_data,
862: p_encoded => fnd_api.g_false);
863:
864: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
865: THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
867: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unexpected Error in Modify_Item_Composition');
868: END IF;

Line 866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

862: p_encoded => fnd_api.g_false);
863:
864: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
865: THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
867: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unexpected Error in Modify_Item_Composition');
868: END IF;
869:
870: WHEN OTHERS THEN

Line 882: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

878: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
879: p_data => x_msg_data,
880: p_encoded => fnd_api.g_false);
881:
882: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
883: THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
885: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unknown Error in Modify_Item_Composition');
886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

880: p_encoded => fnd_api.g_false);
881:
882: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
883: THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
885: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unknown Error in Modify_Item_Composition');
886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
887: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', SQLERRM);
888:

Line 886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

882: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
883: THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
885: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unknown Error in Modify_Item_Composition');
886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
887: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', SQLERRM);
888:
889: END IF;
890:

Line 1006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1002: -- Initialize API return status to success
1003:
1004: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1005:
1006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1007: THEN
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1009: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Begin of Delete_Item_Composition');
1010: END IF;

Line 1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1004: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1005:
1006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1007: THEN
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1009: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Begin of Delete_Item_Composition');
1010: END IF;
1011:
1012:

Line 1103: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1099: END IF;
1100:
1101:
1102:
1103: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1104: THEN
1105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1106: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'End of Delete_Item_Composition');
1107: END IF;

Line 1105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1101:
1102:
1103: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1104: THEN
1105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1106: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'End of Delete_Item_Composition');
1107: END IF;
1108:
1109: EXCEPTION

Line 1117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1113: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1114: p_data => x_msg_data,
1115: p_encoded => fnd_api.g_false);
1116:
1117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1118: THEN
1119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1120: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Error in Delete_Item_Composition');
1121: END IF;

Line 1119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1115: p_encoded => fnd_api.g_false);
1116:
1117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1118: THEN
1119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1120: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Error in Delete_Item_Composition');
1121: END IF;
1122:
1123:

Line 1131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1127: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1128: p_data => x_msg_data,
1129: p_encoded => fnd_api.g_false);
1130:
1131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1132: THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1134: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unexpected Error in Delete_Item_Composition');
1135: END IF;

Line 1133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1129: p_encoded => fnd_api.g_false);
1130:
1131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1132: THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1134: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unexpected Error in Delete_Item_Composition');
1135: END IF;
1136:
1137: WHEN OTHERS THEN

Line 1149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1145: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1146: p_data => x_msg_data,
1147: p_encoded => fnd_api.g_false);
1148:
1149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1152: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unknown Error in Delete_Item_Composition');
1153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1147: p_encoded => fnd_api.g_false);
1148:
1149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1152: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unknown Error in Delete_Item_Composition');
1153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1154: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', SQLERRM);
1155:

Line 1153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1152: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unknown Error in Delete_Item_Composition');
1153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1154: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', SQLERRM);
1155:
1156: END IF;
1157:

Line 1266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1262: -- Initialize API return status to success
1263:
1264: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1265:
1266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1267: THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1269: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Begin of Reopen_Item_Composition');
1270: END IF;

Line 1268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1264: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1265:
1266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1267: THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1269: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Begin of Reopen_Item_Composition');
1270: END IF;
1271:
1272: OPEN item_composition_det(p_item_composition_ID);

Line 1345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1341: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => fnd_api.g_false);
1344:
1345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1346: THEN
1347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1348: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Error in Reopen_Item_Composition');
1349: END IF;

Line 1347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1343: p_encoded => fnd_api.g_false);
1344:
1345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1346: THEN
1347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1348: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Error in Reopen_Item_Composition');
1349: END IF;
1350:
1351:

Line 1359: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1355: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1356: p_data => x_msg_data,
1357: p_encoded => fnd_api.g_false);
1358:
1359: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1360: THEN
1361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1362: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unexpected Error in Reopen_Item_Composition');
1363: END IF;

Line 1361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1357: p_encoded => fnd_api.g_false);
1358:
1359: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1360: THEN
1361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1362: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unexpected Error in Reopen_Item_Composition');
1363: END IF;
1364:
1365: WHEN OTHERS THEN

Line 1377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1373: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1374: p_data => x_msg_data,
1375: p_encoded => fnd_api.g_false);
1376:
1377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1378: THEN
1379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1380: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unknown Error in Reopen_Item_Composition');
1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1375: p_encoded => fnd_api.g_false);
1376:
1377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1378: THEN
1379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1380: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unknown Error in Reopen_Item_Composition');
1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1382: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', SQLERRM);
1383: END IF;

Line 1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1378: THEN
1379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1380: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unknown Error in Reopen_Item_Composition');
1381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1382: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', SQLERRM);
1383: END IF;
1384:
1385:

Line 1650: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1646: -- Initialize API return status to success
1647:
1648: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1649:
1650: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1651: THEN
1652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1653: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Begin Initiate_Item_Comp_Approval');
1654: END IF;

Line 1652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1648: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1649:
1650: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1651: THEN
1652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1653: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Begin Initiate_Item_Comp_Approval');
1654: END IF;
1655:
1656:

Line 1732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730:
1731:
1732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1733: THEN
1734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1735: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Updating Item group');
1736: END IF;

Line 1734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1730:
1731:
1732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1733: THEN
1734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1735: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Updating Item group');
1736: END IF;
1737:
1738: Update ahl_item_compositions

Line 1755: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1751: IF l_ACTIVE='Y'
1752: THEN
1753:
1754:
1755: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1756: THEN
1757: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1758: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Calling ahl_generic_aprv_pvt.start_wf_process');
1759: END IF;

Line 1757: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1753:
1754:
1755: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1756: THEN
1757: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1758: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Calling ahl_generic_aprv_pvt.start_wf_process');
1759: END IF;
1760:
1761: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(

Line 1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1809: ( p_count => x_msg_count,
1810: p_data => x_msg_data,
1811: p_encoded => fnd_api.g_false);
1812:
1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1814: THEN
1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1816: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'End of Initiate_Item_Comp_Approval');
1817: END IF;

Line 1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1811: p_encoded => fnd_api.g_false);
1812:
1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1814: THEN
1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1816: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'End of Initiate_Item_Comp_Approval');
1817: END IF;
1818:
1819:

Line 1829: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1825: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1826: p_data => x_msg_data,
1827: p_encoded => fnd_api.g_false);
1828:
1829: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1830: THEN
1831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1832: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Error in Initiate_Item_Comp_Approval');
1833: END IF;

Line 1831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1827: p_encoded => fnd_api.g_false);
1828:
1829: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1830: THEN
1831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1832: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Error in Initiate_Item_Comp_Approval');
1833: END IF;
1834:
1835:

Line 1843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1839: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1840: p_data => x_msg_data,
1841: p_encoded => fnd_api.g_false);
1842:
1843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1844: THEN
1845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1846: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unexpected Error in Initiate_Item_Comp_Approval');
1847: END IF;

Line 1845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1841: p_encoded => fnd_api.g_false);
1842:
1843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1844: THEN
1845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1846: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unexpected Error in Initiate_Item_Comp_Approval');
1847: END IF;
1848:
1849: WHEN OTHERS THEN

Line 1861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1857: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1858: p_data => x_msg_data,
1859: p_encoded => fnd_api.g_false);
1860:
1861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1862: THEN
1863: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1864: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unknown Error in Initiate_Item_Comp_Approval');
1865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1863: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1859: p_encoded => fnd_api.g_false);
1860:
1861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1862: THEN
1863: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1864: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unknown Error in Initiate_Item_Comp_Approval');
1865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1866: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', SQLERRM);
1867:

Line 1865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1862: THEN
1863: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1864: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unknown Error in Initiate_Item_Comp_Approval');
1865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1866: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', SQLERRM);
1867:
1868: END IF;
1869:

Line 1960: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

1956: -- Initialize API return status to success
1957:
1958: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1959:
1960: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1961: THEN
1962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1963: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Begin of Create_Item_Comp_Revision');
1964: END IF;

Line 1962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1958: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1959:
1960: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1961: THEN
1962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1963: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Begin of Create_Item_Comp_Revision');
1964: END IF;
1965:
1966:

Line 2183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2179: WHERE item_composition_id = p_Item_comp_id
2180: AND object_version_number = p_object_version_number;
2181:
2182:
2183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2184: THEN
2185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2186: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2187: END IF;

Line 2185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2181:
2182:
2183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2184: THEN
2185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2186: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2187: END IF;
2188:
2189: -- Standard check of p_commit

Line 2194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2190: IF FND_API.TO_BOOLEAN(p_commit) THEN
2191: COMMIT WORK;
2192: END IF;
2193:
2194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2195: THEN
2196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2197: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Create_Item_Comp_Revision');
2198: END IF;

Line 2196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2192: END IF;
2193:
2194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2195: THEN
2196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2197: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Create_Item_Comp_Revision');
2198: END IF;
2199:
2200:

Line 2209: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2205: Rollback to Create_Item_Comp_Revision;
2206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2207: p_data => x_msg_data,
2208: p_encoded => fnd_api.g_false);
2209: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2210: THEN
2211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2212: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Error in Create_Item_Comp_Revision');
2213: END IF;

Line 2211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2207: p_data => x_msg_data,
2208: p_encoded => fnd_api.g_false);
2209: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2210: THEN
2211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2212: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Error in Create_Item_Comp_Revision');
2213: END IF;
2214:
2215:

Line 2222: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2218: Rollback to Create_Item_Comp_Revision;
2219: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2220: p_data => x_msg_data,
2221: p_encoded => fnd_api.g_false);
2222: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2223: THEN
2224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2225: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unecpected Error in Create_Item_Comp_Revision');
2226: END IF;

Line 2224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2220: p_data => x_msg_data,
2221: p_encoded => fnd_api.g_false);
2222: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2223: THEN
2224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2225: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unecpected Error in Create_Item_Comp_Revision');
2226: END IF;
2227:
2228:

Line 2240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2236: END IF;
2237: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2238: p_data => x_msg_data,
2239: p_encoded => fnd_api.g_false);
2240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2241: THEN
2242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2243: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');
2244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2238: p_data => x_msg_data,
2239: p_encoded => fnd_api.g_false);
2240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2241: THEN
2242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2243: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');
2244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2245: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision',SQLERRM );
2246:

Line 2244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2241: THEN
2242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2243: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');
2244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2245: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision',SQLERRM );
2246:
2247: END IF;
2248:

Line 2345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2341: -- Initialize API return status to success
2342:
2343: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2344:
2345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2346: THEN
2347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2348: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Begin of Approve_Item_Composiiton');
2349: END IF;

Line 2347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2343: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2344:
2345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2346: THEN
2347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2348: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Begin of Approve_Item_Composiiton');
2349: END IF;
2350:
2351:

Line 2395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2391:
2392:
2393: IF l_item_comp_det.link_comp_id IS NULL THEN
2394:
2395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2396: THEN
2397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2398: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is null');
2399: END IF;

Line 2397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2393: IF l_item_comp_det.link_comp_id IS NULL THEN
2394:
2395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2396: THEN
2397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2398: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is null');
2399: END IF;
2400:
2401:

Line 2413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2409:
2410:
2411: ELSE
2412:
2413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2414: THEN
2415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2416: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is not null');
2417: END IF;

Line 2415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2411: ELSE
2412:
2413: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2414: THEN
2415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2416: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is not null');
2417: END IF;
2418:
2419:

Line 2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2502:
2503:
2504: ELSIF l_status = 'APPROVAL_REJECTED' THEN
2505:
2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2507: THEN
2508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2509: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Approval Rejected');
2510: END IF;

Line 2508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2504: ELSIF l_status = 'APPROVAL_REJECTED' THEN
2505:
2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2507: THEN
2508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2509: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Approval Rejected');
2510: END IF;
2511:
2512: update ahl_item_compositions

Line 2523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2519:
2520:
2521: End if;
2522:
2523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2524: THEN
2525: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2526: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'End of Approve_Item_Composiiton');
2527: END IF;

Line 2525: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2521: End if;
2522:
2523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2524: THEN
2525: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2526: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'End of Approve_Item_Composiiton');
2527: END IF;
2528:
2529:

Line 2539: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2535: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2536: p_data => x_msg_data,
2537: p_encoded => fnd_api.g_false);
2538:
2539: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2540: THEN
2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2542: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Error in Approve_Item_Composiiton');
2543: END IF;

Line 2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2537: p_encoded => fnd_api.g_false);
2538:
2539: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2540: THEN
2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2542: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Error in Approve_Item_Composiiton');
2543: END IF;
2544:
2545:

Line 2553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2549: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2550: p_data => x_msg_data,
2551: p_encoded => fnd_api.g_false);
2552:
2553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2554: THEN
2555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2556: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unexpected Error in Approve_Item_Composiiton');
2557: END IF;

Line 2555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2551: p_encoded => fnd_api.g_false);
2552:
2553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2554: THEN
2555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2556: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unexpected Error in Approve_Item_Composiiton');
2557: END IF;
2558:
2559: WHEN OTHERS THEN

Line 2571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2567: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2568: p_data => x_msg_data,
2569: p_encoded => fnd_api.g_false);
2570:
2571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2572: THEN
2573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2574: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unknown Error in Approve_Item_Composiiton');
2575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2569: p_encoded => fnd_api.g_false);
2570:
2571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2572: THEN
2573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2574: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unknown Error in Approve_Item_Composiiton');
2575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2576: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', SQLERRM);
2577:

Line 2575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2572: THEN
2573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2574: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unknown Error in Approve_Item_Composiiton');
2575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2576: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', SQLERRM);
2577:
2578: END IF;
2579: