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.PO_ASL_API_PVT dependencies on PO_ASL_API_PVT

Line 1: PACKAGE BODY PO_ASL_API_PVT AS

1: PACKAGE BODY PO_ASL_API_PVT AS
2: /* $Header: PO_ASL_API_PVT.plb 120.2.12020000.2 2013/02/11 13:53:34 vegajula noship $*/
3:
4: g_session_key NUMBER;
5:

Line 2: /* $Header: PO_ASL_API_PVT.plb 120.2.12020000.2 2013/02/11 13:53:34 vegajula noship $*/

1: PACKAGE BODY PO_ASL_API_PVT AS
2: /* $Header: PO_ASL_API_PVT.plb 120.2.12020000.2 2013/02/11 13:53:34 vegajula noship $*/
3:
4: g_session_key NUMBER;
5:
6: --------------------------------------------------------------------------------

Line 36: PO_ASL_API_PVT.Log('START ::: PO_ASL_API_PVT.process ');

32: IS
33: l_progress NUMBER := 0;
34:
35: BEGIN
36: PO_ASL_API_PVT.Log('START ::: PO_ASL_API_PVT.process ');
37: PO_ASL_API_PVT.Log('p_session_key:' || p_session_key);
38: g_session_key := p_session_key;
39: --create/update/delete records in the base tables for the non rejected
40: --records in the gt tables.

Line 37: PO_ASL_API_PVT.Log('p_session_key:' || p_session_key);

33: l_progress NUMBER := 0;
34:
35: BEGIN
36: PO_ASL_API_PVT.Log('START ::: PO_ASL_API_PVT.process ');
37: PO_ASL_API_PVT.Log('p_session_key:' || p_session_key);
38: g_session_key := p_session_key;
39: --create/update/delete records in the base tables for the non rejected
40: --records in the gt tables.
41:

Line 126: process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED

122: program_update_date ,
123: Decode(disable_flag,'Y','Y','N')
124: FROM po_approved_supplier_list_gt
125: WHERE process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
126: process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED
127: );
128: po_asl_api_pvt.log('number of rows inserted into po_approved_supplier_list:'
129: || SQL%ROWCOUNT);
130: l_progress := 10;

Line 128: po_asl_api_pvt.log('number of rows inserted into po_approved_supplier_list:'

124: FROM po_approved_supplier_list_gt
125: WHERE process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
126: process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED
127: );
128: po_asl_api_pvt.log('number of rows inserted into po_approved_supplier_list:'
129: || SQL%ROWCOUNT);
130: l_progress := 10;
131:
132: INSERT INTO po_asl_attributes

Line 267: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED) AND

263: FROM po_asl_attributes_gt
264: WHERE user_key IN
265: (SELECT user_key
266: FROM po_approved_supplier_list_gt
267: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED) AND
268: process_action = PO_ASL_API_PUB.g_ACTION_ADD
269: );
270: po_asl_api_pvt.log('number of rows inserted into po_asl_attributes:'
271: || SQL%ROWCOUNT);

Line 270: po_asl_api_pvt.log('number of rows inserted into po_asl_attributes:'

266: FROM po_approved_supplier_list_gt
267: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED) AND
268: process_action = PO_ASL_API_PUB.g_ACTION_ADD
269: );
270: po_asl_api_pvt.log('number of rows inserted into po_asl_attributes:'
271: || SQL%ROWCOUNT);
272: l_progress := 15;
273:
274: INSERT INTO po_asl_attributes

Line 406: WHERE PASL.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED AND

402: NULL ,
403: NULL ,
404: NULL
405: FROM po_approved_supplier_list_gt PASL
406: WHERE PASL.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED AND
407: PASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
408: (Upper(PASL.vendor_business_type) = 'MANUFACTURER' OR
409: NOT EXISTS
410: (SELECT PAA.user_key

Line 414: po_asl_api_pvt.log('number of DEFAULT rows inserted into po_asl_attributes:'

410: (SELECT PAA.user_key
411: FROM po_asl_attributes_gt PAA
412: WHERE PAA.user_key = PASL.user_key))
413: );
414: po_asl_api_pvt.log('number of DEFAULT rows inserted into po_asl_attributes:'
415: || SQL%ROWCOUNT);
416: l_progress := 18;
417:
418: INSERT INTO po_asl_documents

Line 489: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

485: FROM po_asl_documents_gt
486: WHERE user_key IN
487: (SELECT user_key
488: FROM po_approved_supplier_list_gt
489: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
490: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
491: );
492: po_asl_api_pvt.log('number of rows inserted into po_asl_documents:'
493: || SQL%ROWCOUNT);

Line 492: po_asl_api_pvt.log('number of rows inserted into po_asl_documents:'

488: FROM po_approved_supplier_list_gt
489: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
490: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
491: );
492: po_asl_api_pvt.log('number of rows inserted into po_asl_documents:'
493: || SQL%ROWCOUNT);
494: l_progress := 20;
495:
496: INSERT INTO chv_authorizations

Line 565: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

561: FROM chv_authorizations_gt
562: WHERE user_key IN
563: (SELECT user_key
564: FROM po_approved_supplier_list_gt
565: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
566: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
567: );
568: po_asl_api_pvt.log('number of rows inserted into chv_authorizations:'
569: || SQL%ROWCOUNT);

Line 568: po_asl_api_pvt.log('number of rows inserted into chv_authorizations:'

564: FROM po_approved_supplier_list_gt
565: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
566: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
567: );
568: po_asl_api_pvt.log('number of rows inserted into chv_authorizations:'
569: || SQL%ROWCOUNT);
570: l_progress := 25;
571:
572: INSERT INTO po_supplier_item_capacity

Line 641: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

637: FROM po_supplier_item_capacity_gt PSIC
638: WHERE user_key IN
639: (SELECT user_key
640: FROM po_approved_supplier_list_gt
641: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
642: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
643: );
644: po_asl_api_pvt.log('number of rows inserted into po_supplier_item_capacity:'
645: || SQL%ROWCOUNT);

Line 644: po_asl_api_pvt.log('number of rows inserted into po_supplier_item_capacity:'

640: FROM po_approved_supplier_list_gt
641: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
642: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
643: );
644: po_asl_api_pvt.log('number of rows inserted into po_supplier_item_capacity:'
645: || SQL%ROWCOUNT);
646: l_progress := 30;
647:
648: INSERT INTO po_supplier_item_tolerance

Line 713: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

709: FROM po_supplier_item_tolerance_gt
710: WHERE user_key IN
711: (SELECT user_key
712: FROM po_approved_supplier_list_gt
713: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
714: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
715: );
716: po_asl_api_pvt.log('Num of rows inserted into po_supplier_item_tolerance:'
717: || SQL%ROWCOUNT);

Line 716: po_asl_api_pvt.log('Num of rows inserted into po_supplier_item_tolerance:'

712: FROM po_approved_supplier_list_gt
713: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
714: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
715: );
716: po_asl_api_pvt.log('Num of rows inserted into po_supplier_item_tolerance:'
717: || SQL%ROWCOUNT);
718: l_progress := 35;
719: ------------------------------CREATE MODE END---------------------------------
720:

Line 785: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

781: fnd_global.LOGIN_ID
782: FROM po_approved_supplier_list_gt ASLGT
783: WHERE PASL.asl_id = ASLGT.asl_id
784: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
785: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
786: WHERE PASL.asl_id IN
787: (SELECT ASLGT.asl_id
788: FROM po_approved_supplier_list_gt ASLGT
789: WHERE PASL.asl_id = ASLGT.asl_id

Line 791: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

787: (SELECT ASLGT.asl_id
788: FROM po_approved_supplier_list_gt ASLGT
789: WHERE PASL.asl_id = ASLGT.asl_id
790: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
791: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
792:
793: po_asl_api_pvt.log('number of rows updated in po_approved_supplier_list:'
794: || SQL%ROWCOUNT);
795: l_progress := 40;

Line 793: po_asl_api_pvt.log('number of rows updated in po_approved_supplier_list:'

789: WHERE PASL.asl_id = ASLGT.asl_id
790: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
791: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
792:
793: po_asl_api_pvt.log('number of rows updated in po_approved_supplier_list:'
794: || SQL%ROWCOUNT);
795: l_progress := 40;
796:
797: UPDATE po_asl_attributes PAA

Line 914: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

910: AND PAAGT.asl_id = PAA.asl_id
911: AND PAAGT.using_organization_id = PAA.using_organization_id
912: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
913: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
914: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
915: WHERE (PAA.asl_id, PAA.using_organization_id) IN
916: (SELECT PAAGT.asl_id, PAAGT.using_organization_id
917: FROM po_asl_attributes_gt PAAGT,
918: po_approved_supplier_list_gt ASLGT

Line 924: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

920: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
921: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
922: AND PAAGT.asl_id = PAA.asl_id
923: AND PAAGT.using_organization_id = PAA.using_organization_id
924: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
925:
926: po_asl_api_pvt.log('number of rows updated in po_asl_attributes:'
927: || SQL%ROWCOUNT);
928: l_progress := 45;

Line 926: po_asl_api_pvt.log('number of rows updated in po_asl_attributes:'

922: AND PAAGT.asl_id = PAA.asl_id
923: AND PAAGT.using_organization_id = PAA.using_organization_id
924: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
925:
926: po_asl_api_pvt.log('number of rows updated in po_asl_attributes:'
927: || SQL%ROWCOUNT);
928: l_progress := 45;
929:
930: UPDATE po_asl_documents PAD

Line 988: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

984: AND PADGT.using_organization_id = PAD.using_organization_id
985: AND PADGT.document_header_id = PAD.document_header_id
986: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
987: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
988: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
989: WHERE (PAD.asl_id, PAD.using_organization_id, PAD.document_header_id) IN
990: (SELECT PADGT.asl_id, PADGT.using_organization_id, PADGT.document_header_id
991: FROM po_asl_documents_gt PADGT,
992: po_approved_supplier_list_gt ASLGT

Line 999: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

995: AND PADGT.using_organization_id = PAD.using_organization_id
996: AND PADGT.document_header_id = PAD.document_header_id
997: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
998: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
999: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1000:
1001: po_asl_api_pvt.log('number of rows updated in po_asl_documents:'
1002: || SQL%ROWCOUNT);
1003: l_progress := 50;

Line 1001: po_asl_api_pvt.log('number of rows updated in po_asl_documents:'

997: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
998: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
999: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1000:
1001: po_asl_api_pvt.log('number of rows updated in po_asl_documents:'
1002: || SQL%ROWCOUNT);
1003: l_progress := 50;
1004:
1005: UPDATE chv_authorizations CHV

Line 1064: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

1060: AND CHVGT.authorization_code = CHV.authorization_code
1061: AND CHVGT.authorization_sequence_dsp = CHV.authorization_sequence
1062: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1063: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1064: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1065: WHERE (CHV.reference_id, CHV.using_organization_id,
1066: CHV.authorization_code, CHV.authorization_sequence) IN
1067: (SELECT CHVGT.reference_id ,
1068: CHVGT.using_organization_id ,

Line 1080: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1076: AND CHVGT.authorization_code = CHV.authorization_code
1077: AND CHVGT.authorization_sequence_dsp = CHV.authorization_sequence
1078: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1079: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1080: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1081:
1082: po_asl_api_pvt.log('number of rows updated in chv_authorizations:'
1083: || SQL%ROWCOUNT);
1084: l_progress := 55;

Line 1082: po_asl_api_pvt.log('number of rows updated in chv_authorizations:'

1078: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1079: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1080: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1081:
1082: po_asl_api_pvt.log('number of rows updated in chv_authorizations:'
1083: || SQL%ROWCOUNT);
1084: l_progress := 55;
1085:
1086: UPDATE po_supplier_item_capacity PSIC

Line 1145: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

1141: AND GT.from_date_dsp = PSIC.from_date
1142: AND Nvl(GT.to_date_dsp, SYSDATE) = Nvl(PSIC.To_Date, SYSDATE)
1143: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1144: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1145: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1146: WHERE (PSIC.asl_id, PSIC.using_organization_id,
1147: PSIC.from_date, PSIC.To_Date) IN
1148: (SELECT GT.asl_id ,
1149: GT.using_organization_id ,

Line 1161: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1157: AND GT.from_date_dsp = PSIC.from_date
1158: AND Nvl(GT.to_date_dsp, SYSDATE) = Nvl(PSIC.To_Date, SYSDATE)
1159: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1160: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1161: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1162:
1163: po_asl_api_pvt.log('number of rows updated in po_supplier_item_capacity:'
1164: || SQL%ROWCOUNT);
1165: l_progress := 60;

Line 1163: po_asl_api_pvt.log('number of rows updated in po_supplier_item_capacity:'

1159: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1160: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1161: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1162:
1163: po_asl_api_pvt.log('number of rows updated in po_supplier_item_capacity:'
1164: || SQL%ROWCOUNT);
1165: l_progress := 60;
1166:
1167: UPDATE po_supplier_item_tolerance PSIT

Line 1224: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

1220: AND GT.tolerance_dsp = PSIT.tolerance
1221: AND GT.number_of_days_dsp = PSIT.number_of_days
1222: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1223: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1224: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1225: WHERE (PSIT.asl_id, PSIT.using_organization_id,
1226: PSIT.tolerance, PSIT.number_of_days) IN
1227: (SELECT GT.asl_id ,
1228: GT.using_organization_id ,

Line 1240: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1236: AND GT.tolerance_dsp = PSIT.tolerance
1237: AND GT.number_of_days_dsp = PSIT.number_of_days
1238: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1239: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1240: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1241:
1242: po_asl_api_pvt.log('number of rows updated in po_supplier_item_tolerance:'
1243: || SQL%ROWCOUNT);
1244: l_progress := 65;

Line 1242: po_asl_api_pvt.log('number of rows updated in po_supplier_item_tolerance:'

1238: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1239: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1240: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1241:
1242: po_asl_api_pvt.log('number of rows updated in po_supplier_item_tolerance:'
1243: || SQL%ROWCOUNT);
1244: l_progress := 65;
1245: ------------------------------UPDATE MODE ENDS--------------------------------
1246:

Line 1258: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1254: WHERE ASLGT.user_key = PAAGT.user_key
1255: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1256: AND PAAGT.asl_id = PAA.asl_id
1257: AND PAAGT.using_organization_id = PAA.using_organization_id
1258: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1259:
1260: po_asl_api_pvt.log('number of rows deleted from po_asl_attributes:'
1261: || SQL%ROWCOUNT);
1262: l_progress := 70;

Line 1260: po_asl_api_pvt.log('number of rows deleted from po_asl_attributes:'

1256: AND PAAGT.asl_id = PAA.asl_id
1257: AND PAAGT.using_organization_id = PAA.using_organization_id
1258: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1259:
1260: po_asl_api_pvt.log('number of rows deleted from po_asl_attributes:'
1261: || SQL%ROWCOUNT);
1262: l_progress := 70;
1263:
1264: DELETE FROM po_asl_documents PAD

Line 1276: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1272: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1273: AND PADGT.asl_id = PAD.asl_id
1274: AND PADGT.using_organization_id = PAD.using_organization_id
1275: AND PADGT.document_header_id = PAD.document_header_id
1276: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1277:
1278: po_asl_api_pvt.log('1.number of rows deleted from po_asl_documents:'
1279: || SQL%ROWCOUNT);
1280: l_progress := 73;

Line 1278: po_asl_api_pvt.log('1.number of rows deleted from po_asl_documents:'

1274: AND PADGT.using_organization_id = PAD.using_organization_id
1275: AND PADGT.document_header_id = PAD.document_header_id
1276: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1277:
1278: po_asl_api_pvt.log('1.number of rows deleted from po_asl_documents:'
1279: || SQL%ROWCOUNT);
1280: l_progress := 73;
1281: --Delete documents, if asl_attributes doesn't exist
1282: DELETE FROM po_asl_documents PAD

Line 1295: po_asl_api_pvt.log('2.number of rows deleted from po_asl_documents:'

1291: FROM po_approved_supplier_list_gt ASLGT
1292: WHERE ASLGT.asl_id = PAD.asl_id
1293: AND ASLGT.using_organization_id = PAD.using_organization_id);
1294:
1295: po_asl_api_pvt.log('2.number of rows deleted from po_asl_documents:'
1296: || SQL%ROWCOUNT);
1297:
1298: l_progress := 75;
1299:

Line 1312: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1308: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1309: AND CHVGT.reference_id = CHV.reference_id
1310: AND CHVGT.using_organization_id = CHV.using_organization_id
1311: AND CHVGT.authorization_code = CHV.authorization_code
1312: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1313:
1314: po_asl_api_pvt.log('1.number of rows deleted from chv_authorizations:'
1315: || SQL%ROWCOUNT);
1316: l_progress := 77;

Line 1314: po_asl_api_pvt.log('1.number of rows deleted from chv_authorizations:'

1310: AND CHVGT.using_organization_id = CHV.using_organization_id
1311: AND CHVGT.authorization_code = CHV.authorization_code
1312: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1313:
1314: po_asl_api_pvt.log('1.number of rows deleted from chv_authorizations:'
1315: || SQL%ROWCOUNT);
1316: l_progress := 77;
1317:
1318: --Delete authorizations, if asl_attributes modified with

Line 1336: po_asl_api_pvt.log('2.number of rows deleted from chv_authorizations:'

1332: FROM po_approved_supplier_list_gt ASLGT
1333: WHERE aslgt.asl_id = CHV.reference_id
1334: AND ASLGT.using_organization_id = CHV.using_organization_id);
1335:
1336: po_asl_api_pvt.log('2.number of rows deleted from chv_authorizations:'
1337: || SQL%ROWCOUNT);
1338: l_progress := 79;
1339:
1340: --Delete authorizations, if asl_attributes doesn't exist

Line 1354: po_asl_api_pvt.log('3.number of rows deleted from chv_authorizations:'

1350: FROM po_approved_supplier_list_gt ASLGT
1351: WHERE ASLGT.asl_id = CHV.reference_id
1352: AND ASLGT.using_organization_id = CHV.using_organization_id);
1353:
1354: po_asl_api_pvt.log('3.number of rows deleted from chv_authorizations:'
1355: || SQL%ROWCOUNT);
1356: l_progress := 80;
1357:
1358: DELETE FROM po_supplier_item_capacity PSIC

Line 1373: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1369: AND GT.from_date_dsp = PSIC.from_date
1370: AND Nvl(GT.to_date_dsp, SYSDATE)= Nvl(PSIC.To_Date, SYSDATE)
1371: AND GT.capacity_per_day_dsp = PSIC.capacity_per_day
1372: AND GT.using_organization_id = PSIC.using_organization_id
1373: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1374:
1375: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_capacity:'
1376: || SQL%ROWCOUNT);
1377: l_progress := 85;

Line 1375: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_capacity:'

1371: AND GT.capacity_per_day_dsp = PSIC.capacity_per_day
1372: AND GT.using_organization_id = PSIC.using_organization_id
1373: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1374:
1375: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_capacity:'
1376: || SQL%ROWCOUNT);
1377: l_progress := 85;
1378:
1379: --Delete capacity, if asl_attributes modified with enable_vmi_flag unchekced

Line 1397: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_capacity:'

1393: WHERE ASLGT.asl_id = PSIC.asl_id
1394: AND ASLGT.using_organization_id = PSIC.using_organization_id);
1395:
1396: l_progress := 88;
1397: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_capacity:'
1398: || SQL%ROWCOUNT);
1399:
1400: --Delete capacities, if asl_attributes doesn't exist
1401: DELETE FROM po_supplier_item_capacity PSIC

Line 1414: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_capacity:'

1410: FROM po_approved_supplier_list_gt ASLGT
1411: WHERE ASLGT.asl_id = PSIC.asl_id
1412: AND ASLGT.using_organization_id = PSIC.using_organization_id);
1413:
1414: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_capacity:'
1415: || SQL%ROWCOUNT);
1416: l_progress := 90;
1417:
1418: DELETE FROM po_supplier_item_tolerance PSIT

Line 1432: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

1428: AND GT.asl_id = PSIT.asl_id
1429: AND GT.using_organization_id = PSIT.using_organization_id
1430: AND GT.number_of_days_dsp = PSIT.number_of_days
1431: AND GT.tolerance_dsp = PSIT.tolerance
1432: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1433:
1434: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_tolerance:'
1435: || SQL%ROWCOUNT);
1436: l_progress := 95;

Line 1434: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_tolerance:'

1430: AND GT.number_of_days_dsp = PSIT.number_of_days
1431: AND GT.tolerance_dsp = PSIT.tolerance
1432: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1433:
1434: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_tolerance:'
1435: || SQL%ROWCOUNT);
1436: l_progress := 95;
1437:
1438: --Delete tolerance, if asl_attributes modified with enable_vmi_flag unchekced

Line 1456: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_tolerance:'

1452: WHERE ASLGT.asl_id = PSIT.asl_id
1453: AND ASLGT.using_organization_id = PSIT.using_organization_id);
1454:
1455: l_progress := 97;
1456: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_tolerance:'
1457: || SQL%ROWCOUNT);
1458:
1459: --Delete tolerance, if asl_attributes doesn't exist
1460: DELETE FROM po_supplier_item_tolerance PSIT

Line 1473: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_tolerance:'

1469: FROM po_approved_supplier_list_gt ASLGT
1470: WHERE ASLGT.asl_id = PSIT.asl_id
1471: AND ASLGT.using_organization_id = PSIT.using_organization_id);
1472:
1473: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_tolerance:'
1474: || SQL%ROWCOUNT);
1475: l_progress := 98;
1476: ------------------------------DELETE MODE END---------------------------------
1477:

Line 1480: SET process_status = PO_ASL_API_PVT.g_STATUS_SUCCESS

1476: ------------------------------DELETE MODE END---------------------------------
1477:
1478: --Update process_status column to 'Processed' in GT table
1479: UPDATE po_approved_supplier_list_gt
1480: SET process_status = PO_ASL_API_PVT.g_STATUS_SUCCESS
1481: WHERE process_status = PO_ASL_API_PVT.g_STATUS_PENDING;
1482:
1483: po_asl_api_pvt.log('status count of success from pending:' || SQL%ROWCOUNT);
1484: l_progress := 100;

Line 1481: WHERE process_status = PO_ASL_API_PVT.g_STATUS_PENDING;

1477:
1478: --Update process_status column to 'Processed' in GT table
1479: UPDATE po_approved_supplier_list_gt
1480: SET process_status = PO_ASL_API_PVT.g_STATUS_SUCCESS
1481: WHERE process_status = PO_ASL_API_PVT.g_STATUS_PENDING;
1482:
1483: po_asl_api_pvt.log('status count of success from pending:' || SQL%ROWCOUNT);
1484: l_progress := 100;
1485: PO_ASL_API_PVT.Log('END ::: PO_ASL_API_PVT.process ');

Line 1483: po_asl_api_pvt.log('status count of success from pending:' || SQL%ROWCOUNT);

1479: UPDATE po_approved_supplier_list_gt
1480: SET process_status = PO_ASL_API_PVT.g_STATUS_SUCCESS
1481: WHERE process_status = PO_ASL_API_PVT.g_STATUS_PENDING;
1482:
1483: po_asl_api_pvt.log('status count of success from pending:' || SQL%ROWCOUNT);
1484: l_progress := 100;
1485: PO_ASL_API_PVT.Log('END ::: PO_ASL_API_PVT.process ');
1486:
1487: EXCEPTION

Line 1485: PO_ASL_API_PVT.Log('END ::: PO_ASL_API_PVT.process ');

1481: WHERE process_status = PO_ASL_API_PVT.g_STATUS_PENDING;
1482:
1483: po_asl_api_pvt.log('status count of success from pending:' || SQL%ROWCOUNT);
1484: l_progress := 100;
1485: PO_ASL_API_PVT.Log('END ::: PO_ASL_API_PVT.process ');
1486:
1487: EXCEPTION
1488:
1489: WHEN OTHERS THEN

Line 1491: PO_ASL_API_PVT.Log('PO_ASL_API_PVT.process : when others exception at '

1487: EXCEPTION
1488:
1489: WHEN OTHERS THEN
1490:
1491: PO_ASL_API_PVT.Log('PO_ASL_API_PVT.process : when others exception at '
1492: || l_progress || ';' || SQLERRM );
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494: x_return_msg := SQLERRM;
1495: END process;

Line 1535: PO_ASL_API_PVT.Log('START ::: reject_asl_record ');

1531: l_progress NUMBER := 0;
1532:
1533: BEGIN
1534: x_return_msg := NULL;
1535: PO_ASL_API_PVT.Log('START ::: reject_asl_record ');
1536: PO_ASL_API_PVT.Log(p_user_key_tbl);
1537: PO_ASL_API_PVT.Log(p_rejection_reason);
1538: PO_ASL_API_PVT.Log(p_entity_name);
1539:

Line 1536: PO_ASL_API_PVT.Log(p_user_key_tbl);

1532:
1533: BEGIN
1534: x_return_msg := NULL;
1535: PO_ASL_API_PVT.Log('START ::: reject_asl_record ');
1536: PO_ASL_API_PVT.Log(p_user_key_tbl);
1537: PO_ASL_API_PVT.Log(p_rejection_reason);
1538: PO_ASL_API_PVT.Log(p_entity_name);
1539:
1540: --Reject the records in po_approved_supplier_list_gt

Line 1537: PO_ASL_API_PVT.Log(p_rejection_reason);

1533: BEGIN
1534: x_return_msg := NULL;
1535: PO_ASL_API_PVT.Log('START ::: reject_asl_record ');
1536: PO_ASL_API_PVT.Log(p_user_key_tbl);
1537: PO_ASL_API_PVT.Log(p_rejection_reason);
1538: PO_ASL_API_PVT.Log(p_entity_name);
1539:
1540: --Reject the records in po_approved_supplier_list_gt
1541: FORALL l_index IN 1 .. p_user_key_tbl.Count

Line 1538: PO_ASL_API_PVT.Log(p_entity_name);

1534: x_return_msg := NULL;
1535: PO_ASL_API_PVT.Log('START ::: reject_asl_record ');
1536: PO_ASL_API_PVT.Log(p_user_key_tbl);
1537: PO_ASL_API_PVT.Log(p_rejection_reason);
1538: PO_ASL_API_PVT.Log(p_entity_name);
1539:
1540: --Reject the records in po_approved_supplier_list_gt
1541: FORALL l_index IN 1 .. p_user_key_tbl.Count
1542: UPDATE po_approved_supplier_list_gt PAST

Line 1543: SET PAST.process_status = PO_ASL_API_PVT.g_STATUS_REJECTED

1539:
1540: --Reject the records in po_approved_supplier_list_gt
1541: FORALL l_index IN 1 .. p_user_key_tbl.Count
1542: UPDATE po_approved_supplier_list_gt PAST
1543: SET PAST.process_status = PO_ASL_API_PVT.g_STATUS_REJECTED
1544: WHERE PAST.user_key = p_user_key_tbl(l_index);
1545:
1546: PO_ASL_API_PVT.Log('reject_asl_record update rowcount:' || SQL%ROWCOUNT);
1547: l_progress := 50;

Line 1546: PO_ASL_API_PVT.Log('reject_asl_record update rowcount:' || SQL%ROWCOUNT);

1542: UPDATE po_approved_supplier_list_gt PAST
1543: SET PAST.process_status = PO_ASL_API_PVT.g_STATUS_REJECTED
1544: WHERE PAST.user_key = p_user_key_tbl(l_index);
1545:
1546: PO_ASL_API_PVT.Log('reject_asl_record update rowcount:' || SQL%ROWCOUNT);
1547: l_progress := 50;
1548:
1549: --Dump all the errors into po_asl_api_errors
1550: FORALL l_index IN 1 .. p_user_key_tbl.Count

Line 1563: PO_ASL_API_PVT.Log('reject_asl_record insert rowcount:' || SQL%ROWCOUNT);

1559: p_entity_name(l_index) ,
1560: p_rejection_reason(l_index)
1561: );
1562:
1563: PO_ASL_API_PVT.Log('reject_asl_record insert rowcount:' || SQL%ROWCOUNT);
1564: l_progress := 100;
1565:
1566: PO_ASL_API_PVT.Log('END ::: reject_asl_record ');
1567:

Line 1566: PO_ASL_API_PVT.Log('END ::: reject_asl_record ');

1562:
1563: PO_ASL_API_PVT.Log('reject_asl_record insert rowcount:' || SQL%ROWCOUNT);
1564: l_progress := 100;
1565:
1566: PO_ASL_API_PVT.Log('END ::: reject_asl_record ');
1567:
1568: EXCEPTION
1569:
1570: WHEN OTHERS THEN

Line 1572: PO_ASL_API_PVT.Log('reject_asl_record : WHEN OTHERS EXCEPTION at '

1568: EXCEPTION
1569:
1570: WHEN OTHERS THEN
1571:
1572: PO_ASL_API_PVT.Log('reject_asl_record : WHEN OTHERS EXCEPTION at '
1573: || l_progress || ';' || SQLERRM );
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: x_return_msg := SQLERRM;
1576:

Line 2109: END PO_ASL_API_PVT;

2105: END LOOP;
2106: END IF;
2107: END log;
2108:
2109: END PO_ASL_API_PVT;