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.IBE_SHOP_LIST_PVT dependencies on IBE_UTIL

Line 341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

337: j PLS_INTEGER := 1; -- index for x_qte_line_detail_tbl
338: l_list_line_tbl_index PLS_INTEGER;
339: l_line_id NUMBER;
340: BEGIN
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_Util.Debug('Set_List_Lines_From_List_Lines(+)...');
343: END IF;
344: x_list_line_id_map_tbl := jtf_number_table();
345: x_list_line_index_tbl := jtf_number_table();

Line 342: IBE_Util.Debug('Set_List_Lines_From_List_Lines(+)...');

338: l_list_line_tbl_index PLS_INTEGER;
339: l_line_id NUMBER;
340: BEGIN
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_Util.Debug('Set_List_Lines_From_List_Lines(+)...');
343: END IF;
344: x_list_line_id_map_tbl := jtf_number_table();
345: x_list_line_index_tbl := jtf_number_table();
346:

Line 525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

521: i := i + 1;
522: END IF;
523: END LOOP;
524:
525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
526: IBE_Util.Debug('Set_List_Lines_From_List_Lines(-)...');
527: END IF;
528: END Set_List_Lines_From_List_Lines;
529:

Line 526: IBE_Util.Debug('Set_List_Lines_From_List_Lines(-)...');

522: END IF;
523: END LOOP;
524:
525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
526: IBE_Util.Debug('Set_List_Lines_From_List_Lines(-)...');
527: END IF;
528: END Set_List_Lines_From_List_Lines;
529:
530: PROCEDURE Delete_Config_From_Shp_List(

Line 575: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

571: END IF;
572: LOOP
573: FETCH C_GET_CONFIG_LINES INTO l_line_config_id, l_line_config_revnum;
574: EXIT WHEN C_GET_CONFIG_LINES%NOTFOUND;
575: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
576: IBE_Util.Debug('Calling Delete_Configuration for' || l_line_config_id || ', ' || l_line_config_revnum);
577: END IF;
578: CZ_CF_API.delete_configuration(
579: config_hdr_id => l_line_config_id ,

Line 576: IBE_Util.Debug('Calling Delete_Configuration for' || l_line_config_id || ', ' || l_line_config_revnum);

572: LOOP
573: FETCH C_GET_CONFIG_LINES INTO l_line_config_id, l_line_config_revnum;
574: EXIT WHEN C_GET_CONFIG_LINES%NOTFOUND;
575: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
576: IBE_Util.Debug('Calling Delete_Configuration for' || l_line_config_id || ', ' || l_line_config_revnum);
577: END IF;
578: CZ_CF_API.delete_configuration(
579: config_hdr_id => l_line_config_id ,
580: config_rev_nbr => l_line_config_revnum,

Line 640: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

636:
637: -- Initialize API return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
641: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(+)');
642: -- API body
643:
644: IBE_Util.Debug('Delete Configuration Using list ids - Start');

Line 641: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(+)');

637: -- Initialize API return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
641: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(+)');
642: -- API body
643:
644: IBE_Util.Debug('Delete Configuration Using list ids - Start');
645: END IF;

Line 644: IBE_Util.Debug('Delete Configuration Using list ids - Start');

640: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
641: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(+)');
642: -- API body
643:
644: IBE_Util.Debug('Delete Configuration Using list ids - Start');
645: END IF;
646: Delete_Config_From_Shp_List(
647: p_shp_list_ids => p_shop_list_ids,
648: p_shp_list_line_ids => NULL,

Line 655: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

651: p_return_value => l_return_value);
652: IF l_return_value = 0 THEN
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
656: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '
657: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
658: END IF;
659:

Line 656: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '

652: IF l_return_value = 0 THEN
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
656: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '
657: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
658: END IF;
659:
660: FOR i IN 1..p_shop_list_ids.count LOOP

Line 697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

693: END;
694: END LOOP;
695:
696: -- End of API body.
697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
698: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(-)');
699: END IF;
700:
701: -- Standard check of p_commit.

Line 698: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(-)');

694: END LOOP;
695:
696: -- End of API body.
697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
698: IBE_Util.Debug('IBE_Shop_List_PVT.Delete(-)');
699: END IF;
700:
701: -- Standard check of p_commit.
702: IF FND_API.To_Boolean( p_commit ) THEN

Line 791: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

787:
788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
792: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(+)');
793: -- API body
794:
795: IBE_Util.Debug('Delete Configuration Using list ids - Start');

Line 792: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(+)');

788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
792: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(+)');
793: -- API body
794:
795: IBE_Util.Debug('Delete Configuration Using list ids - Start');
796: END IF;

Line 795: IBE_Util.Debug('Delete Configuration Using list ids - Start');

791: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
792: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(+)');
793: -- API body
794:
795: IBE_Util.Debug('Delete Configuration Using list ids - Start');
796: END IF;
797: Delete_Config_From_Shp_List(
798: p_shp_list_ids => p_shop_list_ids,
799: p_shp_list_line_ids => NULL,

Line 806: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

802: p_return_value => l_return_value);
803: IF l_return_value = 0 THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
807: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '
808: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
809: END IF;
810:

Line 807: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '

803: IF l_return_value = 0 THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
807: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '
808: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
809: END IF;
810:
811: FOR i IN 1..p_shop_list_ids.count LOOP

Line 848: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

844: END IF;
845: END LOOP;
846:
847: -- End of API body.
848: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
849: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(-)');
850: END IF;
851:
852: -- Standard check of p_commit.

Line 849: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(-)');

845: END LOOP;
846:
847: -- End of API body.
848: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
849: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_All_Lines(-)');
850: END IF;
851:
852: -- Standard check of p_commit.
853: IF FND_API.To_Boolean( p_commit ) THEN

Line 915: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

911: BEGIN
912: -- DBMS_OUTPUT.PUT_LINE('Inside Delete_line p_Shp_List_Item_Id = ' || p_Shp_List_Item_Id);
913: -- DBMS_OUTPUT.PUT_LINE('Inside Delete_line p_object_version_number = ' || p_object_version_number);
914:
915: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
916: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Line(+)...');
917: END IF;
918:
919: l_shp_list_item_id_tbl := jtf_number_table();

Line 916: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Line(+)...');

912: -- DBMS_OUTPUT.PUT_LINE('Inside Delete_line p_Shp_List_Item_Id = ' || p_Shp_List_Item_Id);
913: -- DBMS_OUTPUT.PUT_LINE('Inside Delete_line p_object_version_number = ' || p_object_version_number);
914:
915: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
916: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Line(+)...');
917: END IF;
918:
919: l_shp_list_item_id_tbl := jtf_number_table();
920:

Line 1013: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1009:
1010: -- Initialize API return status to success
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1013: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1014: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(+)');
1015: END IF;
1016: -- API body
1017:

Line 1014: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(+)');

1010: -- Initialize API return status to success
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1013: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1014: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(+)');
1015: END IF;
1016: -- API body
1017:
1018: l_count := p_shop_list_line_ids.COUNT;

Line 1022: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1018: l_count := p_shop_list_line_ids.COUNT;
1019:
1020: -- DBMS_OUTPUT.PUT_LINE('L_COUNT = ' || l_count);
1021: -- DBMS_OUTPUT.PUT_LINE('l_shop_list_id = ' || l_shop_list_id);
1022: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1023: IBE_Util.Debug('Delete Configuration Using line ids - Start');
1024: END IF;
1025: Delete_Config_From_Shp_List(
1026: p_shp_list_ids => NULL,

Line 1023: IBE_Util.Debug('Delete Configuration Using line ids - Start');

1019:
1020: -- DBMS_OUTPUT.PUT_LINE('L_COUNT = ' || l_count);
1021: -- DBMS_OUTPUT.PUT_LINE('l_shop_list_id = ' || l_shop_list_id);
1022: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1023: IBE_Util.Debug('Delete Configuration Using line ids - Start');
1024: END IF;
1025: Delete_Config_From_Shp_List(
1026: p_shp_list_ids => NULL,
1027: p_shp_list_line_ids => p_shop_list_line_ids,

Line 1035: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1031:
1032: IF l_return_value = 0 THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1036: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '
1037: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1038: END IF;
1039:

Line 1036: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '

1032: IF l_return_value = 0 THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1036: IBE_Util.Debug('Done CZ_CF_API.delete_configuration at '
1037: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1038: END IF;
1039:
1040: -- select shp_list_id to update object_version_number of the list

Line 1085: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: -- End of API body.
1085: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1086: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(-)');
1087: END IF;
1088:
1089: -- Standard check of p_commit.

Line 1086: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(-)');

1082: END IF;
1083:
1084: -- End of API body.
1085: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1086: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Lines(-)');
1087: END IF;
1088:
1089: -- Standard check of p_commit.
1090: IF FND_API.To_Boolean( p_commit ) THEN

Line 1173: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1169:
1170: -- Initialize API return status to success
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1174: IBE_Util.Debug('IBE_Shop_List_PVT.Save(+)');
1175: END IF;
1176: --dbms_output.put_line('IBE_Shop_List_PVT.Save(+)');
1177: -- API body

Line 1174: IBE_Util.Debug('IBE_Shop_List_PVT.Save(+)');

1170: -- Initialize API return status to success
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1174: IBE_Util.Debug('IBE_Shop_List_PVT.Save(+)');
1175: END IF;
1176: --dbms_output.put_line('IBE_Shop_List_PVT.Save(+)');
1177: -- API body
1178:

Line 1457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1453: --dbms_output.put_line('After saving related lines');
1454:
1455: END IF;
1456: -- End of API body.
1457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1458: IBE_Util.Debug('IBE_Shop_List_PVT.Save(-)');
1459: END IF;
1460: --dbms_output.put_line('IBE_Shop_List_PVT.Save(-)');
1461:

Line 1458: IBE_Util.Debug('IBE_Shop_List_PVT.Save(-)');

1454:
1455: END IF;
1456: -- End of API body.
1457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1458: IBE_Util.Debug('IBE_Shop_List_PVT.Save(-)');
1459: END IF;
1460: --dbms_output.put_line('IBE_Shop_List_PVT.Save(-)');
1461:
1462: -- Standard check of p_commit.

Line 1525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1521: BEGIN
1522: -- Initialize API return status to success
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524:
1525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1526: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(+)');
1527: END IF;
1528:
1529: -- API body

Line 1526: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(+)');

1522: -- Initialize API return status to success
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524:
1525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1526: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(+)');
1527: END IF;
1528:
1529: -- API body
1530: FOR i IN 1..px_sl_line_tbl.COUNT LOOP

Line 1535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1531: IF px_sl_line_tbl(i).item_type_code = 'MDL' THEN
1532: l_old_config_header_id := px_sl_line_tbl(i).config_header_id;
1533: l_old_config_revision_num := px_sl_line_tbl(i).config_revision_num;
1534:
1535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1536: IBE_Util.Debug('old config header id = '|| l_old_config_header_id);
1537: IBE_Util.Debug('old config revision NUMBER = '|| l_old_config_revision_num);
1538: IBE_Util.Debug('Call CZ_CONFIG_API_PUB.copy_configuration at'
1539: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));

Line 1536: IBE_Util.Debug('old config header id = '|| l_old_config_header_id);

1532: l_old_config_header_id := px_sl_line_tbl(i).config_header_id;
1533: l_old_config_revision_num := px_sl_line_tbl(i).config_revision_num;
1534:
1535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1536: IBE_Util.Debug('old config header id = '|| l_old_config_header_id);
1537: IBE_Util.Debug('old config revision NUMBER = '|| l_old_config_revision_num);
1538: IBE_Util.Debug('Call CZ_CONFIG_API_PUB.copy_configuration at'
1539: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1540: END IF;

Line 1537: IBE_Util.Debug('old config revision NUMBER = '|| l_old_config_revision_num);

1533: l_old_config_revision_num := px_sl_line_tbl(i).config_revision_num;
1534:
1535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1536: IBE_Util.Debug('old config header id = '|| l_old_config_header_id);
1537: IBE_Util.Debug('old config revision NUMBER = '|| l_old_config_revision_num);
1538: IBE_Util.Debug('Call CZ_CONFIG_API_PUB.copy_configuration at'
1539: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1540: END IF;
1541:

Line 1538: IBE_Util.Debug('Call CZ_CONFIG_API_PUB.copy_configuration at'

1534:
1535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1536: IBE_Util.Debug('old config header id = '|| l_old_config_header_id);
1537: IBE_Util.Debug('old config revision NUMBER = '|| l_old_config_revision_num);
1538: IBE_Util.Debug('Call CZ_CONFIG_API_PUB.copy_configuration at'
1539: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1540: END IF;
1541:
1542: --ER#4025142

Line 1558: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1554: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1559: IBE_Util.Debug('Done CZ_CONFIG_API_PUB.Copy_Configuration at'
1560: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1561: END IF;
1562:

Line 1559: IBE_Util.Debug('Done CZ_CONFIG_API_PUB.Copy_Configuration at'

1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1559: IBE_Util.Debug('Done CZ_CONFIG_API_PUB.Copy_Configuration at'
1560: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1561: END IF;
1562:
1563: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1563: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1559: IBE_Util.Debug('Done CZ_CONFIG_API_PUB.Copy_Configuration at'
1560: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1561: END IF;
1562:
1563: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1564: IBE_Util.Debug('new config header id = '|| l_new_config_header_id);
1565: IBE_Util.Debug('new config revision NUMBER = '|| l_new_config_revision_num);
1566: END IF;
1567:

Line 1564: IBE_Util.Debug('new config header id = '|| l_new_config_header_id);

1560: || TO_CHAR(SYSDATE, 'mm/dd/yyyy:hh24:MI:SS'));
1561: END IF;
1562:
1563: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1564: IBE_Util.Debug('new config header id = '|| l_new_config_header_id);
1565: IBE_Util.Debug('new config revision NUMBER = '|| l_new_config_revision_num);
1566: END IF;
1567:
1568: -- update all other dtl table

Line 1565: IBE_Util.Debug('new config revision NUMBER = '|| l_new_config_revision_num);

1561: END IF;
1562:
1563: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1564: IBE_Util.Debug('new config header id = '|| l_new_config_header_id);
1565: IBE_Util.Debug('new config revision NUMBER = '|| l_new_config_revision_num);
1566: END IF;
1567:
1568: -- update all other dtl table
1569: FOR j IN 1..px_sl_line_tbl.COUNT LOOP

Line 1580: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1576: END IF;
1577: END LOOP;
1578: -- End of API body.
1579:
1580: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1581: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(-)');
1582: END IF;
1583:
1584: -- Standard call to get message count and IF count is 1, get message info.

Line 1581: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(-)');

1577: END LOOP;
1578: -- End of API body.
1579:
1580: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1581: IBE_Util.Debug('IBE_Shop_List_PVT.Update_Config_Item_Lines(-)');
1582: END IF;
1583:
1584: -- Standard call to get message count and IF count is 1, get message info.
1585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1659:
1660: -- Initialize API return status to success
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1664: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(+)');
1665: END IF;
1666: -- API body
1667:

Line 1664: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(+)');

1660: -- Initialize API return status to success
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1664: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(+)');
1665: END IF;
1666: -- API body
1667:
1668: -- IF p_sl_header_rec.shp_list_id is not null, i.e. mode will be either 'ADDTO' or 'REPLACE'.

Line 1803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1799:
1800: --dbms_output.put_line('After Save...');
1801:
1802: -- End of API body.
1803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1804: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(-)');
1805: END IF;
1806: --dbms_output.put_line('IBE_Shop_List_PVT.Save_List_From_Items(-)');
1807:

Line 1804: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(-)');

1800: --dbms_output.put_line('After Save...');
1801:
1802: -- End of API body.
1803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1804: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Items(-)');
1805: END IF;
1806: --dbms_output.put_line('IBE_Shop_List_PVT.Save_List_From_Items(-)');
1807:
1808: -- Standard check of p_commit.

Line 1942: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1938:
1939: -- Initialize API return status to success
1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1943: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(+)');
1944: END IF;
1945: -- API body
1946:

Line 1943: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(+)');

1939: -- Initialize API return status to success
1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1943: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(+)');
1944: END IF;
1945: -- API body
1946:
1947:

Line 2041: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2037: l_sl_header_rec.attribute15
2038: FROM aso_quote_headers
2039: WHERE quote_header_id = p_quote_header_id;
2040: */
2041: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2042: IBE_Util.Debug('IBE_Shop_List_PVT pl1-' || p_quote_header_id);
2043: END IF;
2044:
2045: OPEN l_csr FOR SELECT AQL.quote_line_id ,

Line 2042: IBE_Util.Debug('IBE_Shop_List_PVT pl1-' || p_quote_header_id);

2038: FROM aso_quote_headers
2039: WHERE quote_header_id = p_quote_header_id;
2040: */
2041: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2042: IBE_Util.Debug('IBE_Shop_List_PVT pl1-' || p_quote_header_id);
2043: END IF;
2044:
2045: OPEN l_csr FOR SELECT AQL.quote_line_id ,
2046: AQL.inventory_item_id ,

Line 2115: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2111: if (l_pricing_line_type_indicator = 'F') then
2112: l_PRG_configHdrId_tbl.EXTEND;
2113: l_PRG_configHdrId_tbl(l_PRG_configHdrId_tbl.LAST) := l_config_header_id;
2114:
2115: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2116: IBE_Util.Debug('IBE_Shop_List_PVT: FreeLine! l_PRG_configHdrId=' || l_config_header_id);
2117: end if;
2118: end if;
2119:

Line 2116: IBE_Util.Debug('IBE_Shop_List_PVT: FreeLine! l_PRG_configHdrId=' || l_config_header_id);

2112: l_PRG_configHdrId_tbl.EXTEND;
2113: l_PRG_configHdrId_tbl(l_PRG_configHdrId_tbl.LAST) := l_config_header_id;
2114:
2115: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2116: IBE_Util.Debug('IBE_Shop_List_PVT: FreeLine! l_PRG_configHdrId=' || l_config_header_id);
2117: end if;
2118: end if;
2119:
2120: -- check to see if the config child's parent is a PRG

Line 2123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2119:
2120: -- check to see if the config child's parent is a PRG
2121: l_checkPRGChild := Find_Index(l_config_header_id, l_PRG_configHdrId_tbl);
2122: if (l_checkPRGChild <> 0) then
2123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2124: IBE_Util.Debug('IBE_Shop_List_PVT: l_config_header_id is that of the PRG MDL!');
2125: end if;
2126: l_PRGchildren_lineId_tbl.EXTEND;
2127: l_PRGchildren_lineId_tbl(l_PRGchildren_lineId_tbl.LAST) := l_quote_line_Id;

Line 2124: IBE_Util.Debug('IBE_Shop_List_PVT: l_config_header_id is that of the PRG MDL!');

2120: -- check to see if the config child's parent is a PRG
2121: l_checkPRGChild := Find_Index(l_config_header_id, l_PRG_configHdrId_tbl);
2122: if (l_checkPRGChild <> 0) then
2123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2124: IBE_Util.Debug('IBE_Shop_List_PVT: l_config_header_id is that of the PRG MDL!');
2125: end if;
2126: l_PRGchildren_lineId_tbl.EXTEND;
2127: l_PRGchildren_lineId_tbl(l_PRGchildren_lineId_tbl.LAST) := l_quote_line_Id;
2128: end if;

Line 2135: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2131: if ((l_item_type_code <> 'SRV') and
2132: ((l_pricing_line_type_indicator is null) or (l_pricing_line_type_indicator <> 'F')) and
2133: ((l_config_header_id is null) or (l_checkPRGChild = 0)) ) then
2134:
2135: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2136: IBE_Util.Debug('IBE_Shop_List_PVT: !SRV and !PRG');
2137: end if;
2138:
2139: l_sl_line_tbl(i).inventory_item_id := l_inventory_item_id;

Line 2136: IBE_Util.Debug('IBE_Shop_List_PVT: !SRV and !PRG');

2132: ((l_pricing_line_type_indicator is null) or (l_pricing_line_type_indicator <> 'F')) and
2133: ((l_config_header_id is null) or (l_checkPRGChild = 0)) ) then
2134:
2135: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2136: IBE_Util.Debug('IBE_Shop_List_PVT: !SRV and !PRG');
2137: end if;
2138:
2139: l_sl_line_tbl(i).inventory_item_id := l_inventory_item_id;
2140: l_sl_line_tbl(i).quantity := l_quantity;

Line 2198: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2194: EXIT WHEN l_csr_rel%NOTFOUND;
2195:
2196: l_checkPRGChild := Find_Index(l_quote_line_id, l_PRGchildren_lineId_tbl);
2197: -- 3/26/03: avoid saving SRV info
2198: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2199: IBE_Util.Debug('IBE_Shop_List_PVT: l_checkPRGChild='||l_checkPRGChild);
2200: end if;
2201:
2202: if ((l_relationship_type_code <> 'SERVICE') and (l_checkPRGChild = 0)) then

Line 2199: IBE_Util.Debug('IBE_Shop_List_PVT: l_checkPRGChild='||l_checkPRGChild);

2195:
2196: l_checkPRGChild := Find_Index(l_quote_line_id, l_PRGchildren_lineId_tbl);
2197: -- 3/26/03: avoid saving SRV info
2198: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2199: IBE_Util.Debug('IBE_Shop_List_PVT: l_checkPRGChild='||l_checkPRGChild);
2200: end if;
2201:
2202: if ((l_relationship_type_code <> 'SERVICE') and (l_checkPRGChild = 0)) then
2203:

Line 2204: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2200: end if;
2201:
2202: if ((l_relationship_type_code <> 'SERVICE') and (l_checkPRGChild = 0)) then
2203:
2204: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2205: IBE_Util.Debug('IBE_Shop_List_PVT: relationship -- !SRV and !PRG');
2206: end if;
2207:
2208: l_sl_line_rel_tbl(j).line_index

Line 2205: IBE_Util.Debug('IBE_Shop_List_PVT: relationship -- !SRV and !PRG');

2201:
2202: if ((l_relationship_type_code <> 'SERVICE') and (l_checkPRGChild = 0)) then
2203:
2204: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2205: IBE_Util.Debug('IBE_Shop_List_PVT: relationship -- !SRV and !PRG');
2206: end if;
2207:
2208: l_sl_line_rel_tbl(j).line_index
2209: := Find_Index(l_quote_line_id, l_quote_line_id_tbl, l_quote_line_index_tbl);

Line 2299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2295:
2296: --dbms_output.put_line('After Save...');
2297:
2298: -- End of API body.
2299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2300: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(-)');
2301: END IF;
2302:
2303: -- Standard check of p_commit.

Line 2300: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(-)');

2296: --dbms_output.put_line('After Save...');
2297:
2298: -- End of API body.
2299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2300: IBE_Util.Debug('IBE_Shop_List_PVT.Save_List_From_Quote(-)');
2301: END IF;
2302:
2303: -- Standard check of p_commit.
2304: IF FND_API.To_Boolean( p_commit ) THEN

Line 2394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2390: l_line_id NUMBER;
2391: l_component_code VARCHAR2(1000);
2392:
2393: BEGIN
2394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2395: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(+)...');
2396: END IF;
2397: x_list_line_id_map_tbl := jtf_number_table();
2398: x_qte_line_index_tbl := jtf_number_table();

Line 2395: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(+)...');

2391: l_component_code VARCHAR2(1000);
2392:
2393: BEGIN
2394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2395: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(+)...');
2396: END IF;
2397: x_list_line_id_map_tbl := jtf_number_table();
2398: x_qte_line_index_tbl := jtf_number_table();
2399:

Line 2548: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2544: * which means that we are safe to add a new line
2545: */
2546: ELSE
2547: -- added on 5/21/03: SBM -- don't populate Configuration Children lines
2548: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2549: IBE_Util.Debug('Else not STD and combine items');
2550: END IF;
2551:
2552: if ((l_config_header_id is null) or (l_item_type_code = 'MDL') ) then

Line 2549: IBE_Util.Debug('Else not STD and combine items');

2545: */
2546: ELSE
2547: -- added on 5/21/03: SBM -- don't populate Configuration Children lines
2548: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2549: IBE_Util.Debug('Else not STD and combine items');
2550: END IF;
2551:
2552: if ((l_config_header_id is null) or (l_item_type_code = 'MDL') ) then
2553:

Line 2554: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2550: END IF;
2551:
2552: if ((l_config_header_id is null) or (l_item_type_code = 'MDL') ) then
2553:
2554: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2555: IBE_Util.Debug('if non-config or MDL: j='||j);
2556: END IF;
2557:
2558: x_qte_line_tbl(i).operation_code := 'CREATE';

Line 2555: IBE_Util.Debug('if non-config or MDL: j='||j);

2551:
2552: if ((l_config_header_id is null) or (l_item_type_code = 'MDL') ) then
2553:
2554: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2555: IBE_Util.Debug('if non-config or MDL: j='||j);
2556: END IF;
2557:
2558: x_qte_line_tbl(i).operation_code := 'CREATE';
2559: x_qte_line_tbl(i).quote_header_id := p_quote_header_id;

Line 2592: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2588: --x_qte_line_tbl(i).currency_code := p_currency_code;-- Bug fix 3378817
2589: x_contMDL := 'Y';
2590: END IF;
2591:
2592: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2593: IBE_Util.Debug('for configuration items ,: j='||j ||'and i='||i);
2594: END IF;
2595: --x_qte_line_tbl(i).price_list_id := p_price_list_id;-- Bug fix 3378817
2596:

Line 2593: IBE_Util.Debug('for configuration items ,: j='||j ||'and i='||i);

2589: x_contMDL := 'Y';
2590: END IF;
2591:
2592: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2593: IBE_Util.Debug('for configuration items ,: j='||j ||'and i='||i);
2594: END IF;
2595: --x_qte_line_tbl(i).price_list_id := p_price_list_id;-- Bug fix 3378817
2596:
2597: x_qte_line_detail_tbl(j).qte_line_index := i;

Line 2641: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2637: END IF; -- if or
2638: END IF;
2639:
2640: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2641: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2642: IBE_Util.Debug('l_item_type_code='||l_item_type_code);
2643: END IF;
2644: x_ql_line_codes.extend;
2645: if (l_item_type_code = 'SVA') then

Line 2642: IBE_Util.Debug('l_item_type_code='||l_item_type_code);

2638: END IF;
2639:
2640: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2641: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2642: IBE_Util.Debug('l_item_type_code='||l_item_type_code);
2643: END IF;
2644: x_ql_line_codes.extend;
2645: if (l_item_type_code = 'SVA') then
2646: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2646: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2642: IBE_Util.Debug('l_item_type_code='||l_item_type_code);
2643: END IF;
2644: x_ql_line_codes.extend;
2645: if (l_item_type_code = 'SVA') then
2646: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2647: IBE_Util.Debug('l_item_type_code=SVA!');
2648: END IF;
2649: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.SERVICEABLE_LINE_CODE;
2650:

Line 2647: IBE_Util.Debug('l_item_type_code=SVA!');

2643: END IF;
2644: x_ql_line_codes.extend;
2645: if (l_item_type_code = 'SVA') then
2646: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2647: IBE_Util.Debug('l_item_type_code=SVA!');
2648: END IF;
2649: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.SERVICEABLE_LINE_CODE;
2650:
2651: elsif (l_item_type_code = 'STD') then

Line 2652: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2648: END IF;
2649: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.SERVICEABLE_LINE_CODE;
2650:
2651: elsif (l_item_type_code = 'STD') then
2652: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2653: IBE_Util.Debug('l_item_type_code=STD!');
2654: END IF;
2655: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.STANDARD_LINE_CODE;
2656: end if;

Line 2653: IBE_Util.Debug('l_item_type_code=STD!');

2649: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.SERVICEABLE_LINE_CODE;
2650:
2651: elsif (l_item_type_code = 'STD') then
2652: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2653: IBE_Util.Debug('l_item_type_code=STD!');
2654: END IF;
2655: x_ql_line_codes(x_ql_line_codes.LAST) := IBE_QUOTE_SAVE_PVT.STANDARD_LINE_CODE;
2656: end if;
2657:

Line 2661: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2657:
2658: END IF; -- if (l_item_type_code <> 'SRV') then
2659: END LOOP;
2660:
2661: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2662: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines: x_contMDL='||x_contMDL);
2663: END IF;
2664:
2665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2662: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines: x_contMDL='||x_contMDL);

2658: END IF; -- if (l_item_type_code <> 'SRV') then
2659: END LOOP;
2660:
2661: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2662: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines: x_contMDL='||x_contMDL);
2663: END IF;
2664:
2665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2666: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(-)...');

Line 2665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2661: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2662: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines: x_contMDL='||x_contMDL);
2663: END IF;
2664:
2665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2666: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(-)...');
2667: END IF;
2668: END Set_Qte_Lines_From_List_Lines;
2669:

Line 2666: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(-)...');

2662: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines: x_contMDL='||x_contMDL);
2663: END IF;
2664:
2665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2666: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(-)...');
2667: END IF;
2668: END Set_Qte_Lines_From_List_Lines;
2669:
2670:

Line 2758: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2754:
2755: -- Initialize API return status to success
2756: x_return_status := FND_API.G_RET_STS_SUCCESS;
2757:
2758: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2759: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(+)');
2760: END IF;
2761: --dbms_output.put_line('IBE_Shop_List_PVT.Save_Quote_From_List_Items(+)');
2762: -- API body

Line 2759: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(+)');

2755: -- Initialize API return status to success
2756: x_return_status := FND_API.G_RET_STS_SUCCESS;
2757:
2758: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2759: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(+)');
2760: END IF;
2761: --dbms_output.put_line('IBE_Shop_List_PVT.Save_Quote_From_List_Items(+)');
2762: -- API body
2763:

Line 2844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2840: x_ql_line_codes => l_ql_line_codes ,
2841: x_contMDL => lx_contMDL);
2842:
2843: if (l_ql_line_codes is not null) then
2844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2845: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- l_ql_line_codes is not null!='||l_ql_line_codes(1));
2846: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- lx_contMDL='||lx_contMDL);
2847: END IF;
2848: end if;

Line 2845: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- l_ql_line_codes is not null!='||l_ql_line_codes(1));

2841: x_contMDL => lx_contMDL);
2842:
2843: if (l_ql_line_codes is not null) then
2844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2845: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- l_ql_line_codes is not null!='||l_ql_line_codes(1));
2846: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- lx_contMDL='||lx_contMDL);
2847: END IF;
2848: end if;
2849:

Line 2846: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- lx_contMDL='||lx_contMDL);

2842:
2843: if (l_ql_line_codes is not null) then
2844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2845: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- l_ql_line_codes is not null!='||l_ql_line_codes(1));
2846: IBE_Util.Debug('back from Set_Qte_Lines_From_List_Lines -- lx_contMDL='||lx_contMDL);
2847: END IF;
2848: end if;
2849:
2850: --dbms_output.put_line('back from Set_Qte_Lines_From_List_Lines()..');

Line 2887: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2883: -- if the lx_contMDL = Y, then there must be at least a MDL in the shop list
2884: -- 1) make the first transaction call (Save) not do a pricing call
2885: l_control_rec := p_control_rec;
2886: if (lx_contMDL = 'Y') then
2887: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2888: IBE_Util.Debug('Coming back from update_config_item_lines: lx_contMDL is Y');
2889: END IF;
2890: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;
2891: end if;

Line 2888: IBE_Util.Debug('Coming back from update_config_item_lines: lx_contMDL is Y');

2884: -- 1) make the first transaction call (Save) not do a pricing call
2885: l_control_rec := p_control_rec;
2886: if (lx_contMDL = 'Y') then
2887: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2888: IBE_Util.Debug('Coming back from update_config_item_lines: lx_contMDL is Y');
2889: END IF;
2890: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;
2891: end if;
2892:

Line 2900: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2896: OPEN c_get_promo_details(p_promocode,p_q_header_rec.currency_code);
2897: FETCH c_get_promo_details INTO l_pricing_attribute1;
2898: CLOSE c_get_promo_details;
2899:
2900: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2901: IBE_Util.Debug('promocode = '||p_promocode||',currency code = '||p_q_header_rec.currency_code||'and pricing attribute1='||l_pricing_attribute1);
2902: END IF;
2903:
2904: IF l_pricing_attribute1 is not null THEN

Line 2901: IBE_Util.Debug('promocode = '||p_promocode||',currency code = '||p_q_header_rec.currency_code||'and pricing attribute1='||l_pricing_attribute1);

2897: FETCH c_get_promo_details INTO l_pricing_attribute1;
2898: CLOSE c_get_promo_details;
2899:
2900: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2901: IBE_Util.Debug('promocode = '||p_promocode||',currency code = '||p_q_header_rec.currency_code||'and pricing attribute1='||l_pricing_attribute1);
2902: END IF;
2903:
2904: IF l_pricing_attribute1 is not null THEN
2905: l_Hd_Price_Attributes_Tbl(1).pricing_attribute1 := l_pricing_attribute1;

Line 2953: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2949: -- 1) get line det record from 1st index of line det Tbl
2950: if (lx_contMDL = 'Y') then
2951: for i in 1..l_qte_line_detail_tbl.count loop
2952: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;
2953: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2954: IBE_Util.Debug('Begin ASO_CFG_PUB.get_config_details');
2955: END IF;
2956:
2957: l_qte_line_detail_indx := l_qte_line_detail_tbl(i).qte_line_index;

Line 2954: IBE_Util.Debug('Begin ASO_CFG_PUB.get_config_details');

2950: if (lx_contMDL = 'Y') then
2951: for i in 1..l_qte_line_detail_tbl.count loop
2952: l_control_rec := aso_quote_pub.G_MISS_Control_Rec;
2953: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2954: IBE_Util.Debug('Begin ASO_CFG_PUB.get_config_details');
2955: END IF;
2956:
2957: l_qte_line_detail_indx := l_qte_line_detail_tbl(i).qte_line_index;
2958: l_qte_line_detail_tbl(i).quote_line_id := lx_Qte_Line_Tbl(l_qte_line_detail_indx).quote_line_id;

Line 2959: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2955: END IF;
2956:
2957: l_qte_line_detail_indx := l_qte_line_detail_tbl(i).qte_line_index;
2958: l_qte_line_detail_tbl(i).quote_line_id := lx_Qte_Line_Tbl(l_qte_line_detail_indx).quote_line_id;
2959: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2960: IBE_Util.Debug('l_qte_line_detail_indx='||l_qte_line_detail_indx);
2961: END IF;
2962:
2963: -- make the Last transaction call do a pricing call

Line 2960: IBE_Util.Debug('l_qte_line_detail_indx='||l_qte_line_detail_indx);

2956:
2957: l_qte_line_detail_indx := l_qte_line_detail_tbl(i).qte_line_index;
2958: l_qte_line_detail_tbl(i).quote_line_id := lx_Qte_Line_Tbl(l_qte_line_detail_indx).quote_line_id;
2959: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2960: IBE_Util.Debug('l_qte_line_detail_indx='||l_qte_line_detail_indx);
2961: END IF;
2962:
2963: -- make the Last transaction call do a pricing call
2964: if (i = l_qte_line_detail_tbl.count) then

Line 2965: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2961: END IF;
2962:
2963: -- make the Last transaction call do a pricing call
2964: if (i = l_qte_line_detail_tbl.count) then
2965: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2966: IBE_Util.Debug('This is the last item in the line details record -- making a pricing call');
2967: END IF;
2968: l_control_rec := p_control_rec;
2969: end if;

Line 2966: IBE_Util.Debug('This is the last item in the line details record -- making a pricing call');

2962:
2963: -- make the Last transaction call do a pricing call
2964: if (i = l_qte_line_detail_tbl.count) then
2965: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2966: IBE_Util.Debug('This is the last item in the line details record -- making a pricing call');
2967: END IF;
2968: l_control_rec := p_control_rec;
2969: end if;
2970:

Line 2988: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

2984: x_return_status => x_return_status,
2985: x_msg_count => x_msg_count,
2986: x_msg_data => x_msg_data
2987: );
2988: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2989: IBE_Util.Debug('End ASO_CFG_PUB.get_config_details');
2990: END IF;
2991:
2992: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2989: IBE_Util.Debug('End ASO_CFG_PUB.get_config_details');

2985: x_msg_count => x_msg_count,
2986: x_msg_data => x_msg_data
2987: );
2988: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2989: IBE_Util.Debug('End ASO_CFG_PUB.get_config_details');
2990: END IF;
2991:
2992: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;

Line 3030: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

3026: END IF;
3027:
3028: x_q_header_id := lx_quote_header_id;
3029: -- End of API body.
3030: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3031: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(-)');
3032: END IF;
3033:
3034: -- Standard check of p_commit.

Line 3031: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(-)');

3027:
3028: x_q_header_id := lx_quote_header_id;
3029: -- End of API body.
3030: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3031: IBE_Util.Debug('IBE_Shop_List_PVT.Save_Quote_From_List_Items(-)');
3032: END IF;
3033:
3034: -- Standard check of p_commit.
3035: IF FND_API.To_Boolean( p_commit ) THEN