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.

[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on FND_LOG

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

433: -- Initialize API return status to success
434:
435: x_return_status :=FND_API.G_RET_STS_SUCCESS;
436:
437: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
438: THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
440: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Begin of Create_Item_Composition');
441: END IF;

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

435: x_return_status :=FND_API.G_RET_STS_SUCCESS;
436:
437: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
438: THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
440: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Begin of Create_Item_Composition');
441: END IF;
442:
443:

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

565:
566:
567: p_x_ic_header_rec.ITEM_COMPOSITION_ID := l_item_composition_id;
568:
569: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
570: THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
572: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'End of Create_Item_Composition');
573: END IF;

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

567: p_x_ic_header_rec.ITEM_COMPOSITION_ID := l_item_composition_id;
568:
569: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
570: THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
572: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'End of Create_Item_Composition');
573: END IF;
574:
575:

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

580: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
581: p_data => x_msg_data,
582: p_encoded => fnd_api.g_false);
583:
584: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
585: THEN
586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
587: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Error in Create_Item_Composition');
588: END IF;

Line 586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

582: p_encoded => fnd_api.g_false);
583:
584: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
585: THEN
586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
587: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Error in Create_Item_Composition');
588: END IF;
589:
590:

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

594: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
595: p_data => x_msg_data,
596: p_encoded => fnd_api.g_false);
597:
598: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
599: THEN
600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
601: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unexpected Error in Create_Item_Composition');
602: END IF;

Line 600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

596: p_encoded => fnd_api.g_false);
597:
598: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
599: THEN
600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
601: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unexpected Error in Create_Item_Composition');
602: END IF;
603:
604: WHEN OTHERS THEN

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

612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
613: p_data => x_msg_data,
614: p_encoded => fnd_api.g_false);
615:
616: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
617: THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
619: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unknown Error in Create_Item_Composition');
620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

614: p_encoded => fnd_api.g_false);
615:
616: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
617: THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
619: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unknown Error in Create_Item_Composition');
620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
621: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', SQLERRM);
622:

Line 620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

616: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
617: THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
619: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unknown Error in Create_Item_Composition');
620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
621: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', SQLERRM);
622:
623: END IF;
624:

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

728: -- Initialize API return status to success
729:
730: x_return_status :=FND_API.G_RET_STS_SUCCESS;
731:
732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
733: THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
735: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Begin of Modify_Item_Composition');
736: END IF;

Line 734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

730: x_return_status :=FND_API.G_RET_STS_SUCCESS;
731:
732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
733: THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
735: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Begin of Modify_Item_Composition');
736: END IF;
737:
738:

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

846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
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', 'End of Modify_Item_Composition');
854: END IF;

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

848:
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', 'End of Modify_Item_Composition');
854: END IF;
855:
856:

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

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

Line 868: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 882: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

878: p_encoded => fnd_api.g_false);
879:
880: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
881: THEN
882: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
883: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unexpected Error in Modify_Item_Composition');
884: END IF;
885:
886: WHEN OTHERS THEN

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

894: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
895: p_data => x_msg_data,
896: p_encoded => fnd_api.g_false);
897:
898: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
899: THEN
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unknown Error in Modify_Item_Composition');
902: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

896: p_encoded => fnd_api.g_false);
897:
898: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
899: THEN
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unknown Error in Modify_Item_Composition');
902: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
903: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', SQLERRM);
904:

Line 902: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

898: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
899: THEN
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unknown Error in Modify_Item_Composition');
902: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
903: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', SQLERRM);
904:
905: END IF;
906:

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

1018: -- Initialize API return status to success
1019:
1020: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1021:
1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1023: THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1025: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Begin of Delete_Item_Composition');
1026: END IF;

Line 1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1020: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1021:
1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1023: THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1025: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Begin of Delete_Item_Composition');
1026: END IF;
1027:
1028:

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

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

Line 1121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1117:
1118:
1119: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1120: THEN
1121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1122: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'End of Delete_Item_Composition');
1123: END IF;
1124:
1125: EXCEPTION

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

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

Line 1135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1145: p_encoded => fnd_api.g_false);
1146:
1147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1148: THEN
1149: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1150: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unexpected Error in Delete_Item_Composition');
1151: END IF;
1152:
1153: WHEN OTHERS THEN

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

1161: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1162: p_data => x_msg_data,
1163: p_encoded => fnd_api.g_false);
1164:
1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1166: THEN
1167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1168: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unknown Error in Delete_Item_Composition');
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1163: p_encoded => fnd_api.g_false);
1164:
1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1166: THEN
1167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1168: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unknown Error in Delete_Item_Composition');
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1170: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', SQLERRM);
1171:

Line 1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1165: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1166: THEN
1167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1168: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unknown Error in Delete_Item_Composition');
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1170: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', SQLERRM);
1171:
1172: END IF;
1173:

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

1278: -- Initialize API return status to success
1279:
1280: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1281:
1282: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1283: THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1285: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Begin of Reopen_Item_Composition');
1286: END IF;

Line 1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1280: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1281:
1282: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1283: THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1285: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Begin of Reopen_Item_Composition');
1286: END IF;
1287:
1288: OPEN item_composition_det(p_item_composition_ID);

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

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

Line 1363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1377: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1373: p_encoded => fnd_api.g_false);
1374:
1375: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1376: THEN
1377: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1378: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unexpected Error in Reopen_Item_Composition');
1379: END IF;
1380:
1381: WHEN OTHERS THEN

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

1389: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1390: p_data => x_msg_data,
1391: p_encoded => fnd_api.g_false);
1392:
1393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1394: THEN
1395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1396: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unknown Error in Reopen_Item_Composition');
1397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1391: p_encoded => fnd_api.g_false);
1392:
1393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1394: THEN
1395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1396: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unknown Error in Reopen_Item_Composition');
1397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1398: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', SQLERRM);
1399: END IF;

Line 1397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1394: THEN
1395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1396: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unknown Error in Reopen_Item_Composition');
1397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1398: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', SQLERRM);
1399: END IF;
1400:
1401:

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

1662: -- Initialize API return status to success
1663:
1664: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1665:
1666: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1667: THEN
1668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1669: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Begin Initiate_Item_Comp_Approval');
1670: END IF;

Line 1668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1664: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1665:
1666: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1667: THEN
1668: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1669: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Begin Initiate_Item_Comp_Approval');
1670: END IF;
1671:
1672:

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

1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;
1746:
1747:
1748: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1749: THEN
1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1751: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Updating Item group');
1752: END IF;

Line 1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1746:
1747:
1748: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1749: THEN
1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1751: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Updating Item group');
1752: END IF;
1753:
1754: Update ahl_item_compositions

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

1767: IF l_ACTIVE='Y'
1768: THEN
1769:
1770:
1771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1772: THEN
1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1774: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Calling ahl_generic_aprv_pvt.start_wf_process');
1775: END IF;

Line 1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1769:
1770:
1771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1772: THEN
1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1774: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Calling ahl_generic_aprv_pvt.start_wf_process');
1775: END IF;
1776:
1777: AHL_GENERIC_APRV_PVT.START_WF_PROCESS(

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

1825: ( 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', 'End of 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', 'End of Initiate_Item_Comp_Approval');
1833: END IF;
1834:
1835:

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

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

Line 1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1857: p_encoded => fnd_api.g_false);
1858:
1859: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1860: THEN
1861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1862: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unexpected Error in Initiate_Item_Comp_Approval');
1863: END IF;
1864:
1865: WHEN OTHERS THEN

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

1873: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1874: p_data => x_msg_data,
1875: p_encoded => fnd_api.g_false);
1876:
1877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1878: THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1880: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unknown Error in Initiate_Item_Comp_Approval');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1875: p_encoded => fnd_api.g_false);
1876:
1877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1878: THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1880: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unknown Error in Initiate_Item_Comp_Approval');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1882: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', SQLERRM);
1883:

Line 1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1878: THEN
1879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1880: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unknown Error in Initiate_Item_Comp_Approval');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1882: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', SQLERRM);
1883:
1884: END IF;
1885:

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

1972: -- Initialize API return status to success
1973:
1974: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1975:
1976: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1977: THEN
1978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1979: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Begin of Create_Item_Comp_Revision');
1980: END IF;

Line 1978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1974: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1975:
1976: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1977: THEN
1978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1979: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Begin of Create_Item_Comp_Revision');
1980: END IF;
1981:
1982:

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

2195: WHERE item_composition_id = p_Item_comp_id
2196: AND object_version_number = p_object_version_number;
2197:
2198:
2199: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2200: THEN
2201: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2202: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2203: END IF;

Line 2201: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2197:
2198:
2199: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2200: THEN
2201: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2202: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2203: END IF;
2204:
2205: -- Standard check of p_commit

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

2206: IF FND_API.TO_BOOLEAN(p_commit) THEN
2207: COMMIT WORK;
2208: END IF;
2209:
2210: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2211: THEN
2212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2213: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Create_Item_Comp_Revision');
2214: END IF;

Line 2212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2208: END IF;
2209:
2210: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2211: THEN
2212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2213: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Create_Item_Comp_Revision');
2214: END IF;
2215:
2216:

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

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

Line 2227: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 2240: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

2252: END IF;
2253: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2254: p_data => x_msg_data,
2255: p_encoded => fnd_api.g_false);
2256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2257: THEN
2258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2259: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');
2260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2254: p_data => x_msg_data,
2255: p_encoded => fnd_api.g_false);
2256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2257: THEN
2258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2259: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');
2260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2261: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision',SQLERRM );
2262:

Line 2260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2257: THEN
2258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2259: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');
2260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2261: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision',SQLERRM );
2262:
2263: END IF;
2264:

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

2398: -- Initialize API return status to success
2399:
2400: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2401:
2402: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2403: THEN
2404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2405: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Begin of Approve_Item_Composiiton');
2406: END IF;

Line 2404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2400: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2401:
2402: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2403: THEN
2404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2405: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Begin of Approve_Item_Composiiton');
2406: END IF;
2407:
2408:

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

2448:
2449:
2450: IF l_item_comp_det.link_comp_id IS NULL THEN
2451:
2452: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2453: THEN
2454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2455: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is null');
2456: END IF;

Line 2454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2450: IF l_item_comp_det.link_comp_id IS NULL THEN
2451:
2452: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2453: THEN
2454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2455: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is null');
2456: END IF;
2457:
2458:

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

2466:
2467:
2468: ELSE
2469:
2470: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2471: THEN
2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is not null');
2474: END IF;

Line 2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2468: ELSE
2469:
2470: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2471: THEN
2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is not null');
2474: END IF;
2475:
2476:

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

2635:
2636:
2637: ELSIF l_status = 'APPROVAL_REJECTED' THEN
2638:
2639: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2640: THEN
2641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2642: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Approval Rejected');
2643: END IF;

Line 2641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2637: ELSIF l_status = 'APPROVAL_REJECTED' THEN
2638:
2639: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2640: THEN
2641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2642: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Approval Rejected');
2643: END IF;
2644:
2645: update ahl_item_compositions

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

2652:
2653:
2654: End if;
2655:
2656: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2657: THEN
2658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2659: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'End of Approve_Item_Composiiton');
2660: END IF;

Line 2658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2654: End if;
2655:
2656: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2657: THEN
2658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2659: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'End of Approve_Item_Composiiton');
2660: END IF;
2661:
2662:

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

2668: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2669: p_data => x_msg_data,
2670: p_encoded => fnd_api.g_false);
2671:
2672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2673: THEN
2674: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2675: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Error in Approve_Item_Composiiton');
2676: END IF;

Line 2674: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2670: p_encoded => fnd_api.g_false);
2671:
2672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2673: THEN
2674: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2675: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Error in Approve_Item_Composiiton');
2676: END IF;
2677:
2678:

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

2682: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2683: p_data => x_msg_data,
2684: p_encoded => fnd_api.g_false);
2685:
2686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2687: THEN
2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2689: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unexpected Error in Approve_Item_Composiiton');
2690: END IF;

Line 2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2684: p_encoded => fnd_api.g_false);
2685:
2686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2687: THEN
2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2689: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unexpected Error in Approve_Item_Composiiton');
2690: END IF;
2691:
2692: WHEN OTHERS THEN

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

2700: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2701: p_data => x_msg_data,
2702: p_encoded => fnd_api.g_false);
2703:
2704: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2705: THEN
2706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2707: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unknown Error in Approve_Item_Composiiton');
2708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2702: p_encoded => fnd_api.g_false);
2703:
2704: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2705: THEN
2706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2707: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unknown Error in Approve_Item_Composiiton');
2708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2709: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', SQLERRM);
2710:

Line 2708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2704: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2705: THEN
2706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2707: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unknown Error in Approve_Item_Composiiton');
2708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2709: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', SQLERRM);
2710:
2711: END IF;
2712: