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

Line 46: -- Call PO_ASL_API_PVT.reject_asl_record for the records in case any

42: -- This will determine whether to do insert or update.
43: -- Create will throw error if you are passing duplicate asl.
44: -- Update will throw error if asl does not exists.
45: -- Call Validation interface to perform field validations
46: -- Call PO_ASL_API_PVT.reject_asl_record for the records in case any
47: -- validation error.
48:
49: --Parameters:
50:

Line 78: po_asl_api_pvt.log('START ::: po_asl_api_grp.process');

74: l_entity_name1 po_tbl_varchar30;
75: l_reject_reason1 po_tbl_varchar2000;
76:
77: BEGIN
78: po_asl_api_pvt.log('START ::: po_asl_api_grp.process');
79: po_asl_api_pvt.log('p_session_key:' || p_session_key);
80: g_session_key := p_session_key;
81: --Determine Create/Update when mode is Sync
82: UPDATE po_approved_supplier_list_gt GT

Line 79: po_asl_api_pvt.log('p_session_key:' || p_session_key);

75: l_reject_reason1 po_tbl_varchar2000;
76:
77: BEGIN
78: po_asl_api_pvt.log('START ::: po_asl_api_grp.process');
79: po_asl_api_pvt.log('p_session_key:' || p_session_key);
80: g_session_key := p_session_key;
81: --Determine Create/Update when mode is Sync
82: UPDATE po_approved_supplier_list_gt GT
83: SET GT.process_action =

Line 93: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

89: p_vendor_site_id => GT.vendor_site_id
90: )
91: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_SYNC;
92: l_progress := 5;
93: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
94:
95: --Populate asl ids in case of update
96: /* RR: Review Perf */
97: UPDATE po_approved_supplier_list_gt GT

Line 110: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

106: AND Nvl(GT.vendor_site_id,-1)= Nvl(PASL.vendor_site_id,-1)
107: AND ROWNUM < 2)
108: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE;
109: l_progress := 10;
110: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
111:
112: --Populate asl ids in case of create
113: UPDATE po_approved_supplier_list_gt GT
114: SET asl_id = po_approved_supplier_list_s.NEXTVAL

Line 118: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

114: SET asl_id = po_approved_supplier_list_s.NEXTVAL
115: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;
116:
117: l_progress := 15;
118: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
119:
120: UPDATE po_asl_attributes_gt PAA
121: SET asl_id = (SELECT asl_id
122: FROM po_approved_supplier_list_gt PASL

Line 127: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

123: WHERE PASL.user_key = PAA.user_key
124: AND ROWNUM < 2);
125:
126: l_progress := 20;
127: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
128:
129: UPDATE po_asl_documents_gt PAD
130: SET asl_id = (SELECT asl_id
131: FROM po_approved_supplier_list_gt PASL

Line 136: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

132: WHERE PASL.user_key = PAD.user_key
133: AND ROWNUM < 2);
134:
135: l_progress := 25;
136: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
137:
138: UPDATE chv_authorizations_gt CHV
139: SET reference_id = (SELECT asl_id
140: FROM po_approved_supplier_list_gt PASL

Line 145: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

141: WHERE PASL.user_key = CHV.user_key
142: AND ROWNUM < 2);
143:
144: l_progress := 30;
145: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
146:
147: UPDATE po_supplier_item_capacity_gt PSIC
148: SET asl_id = (SELECT asl_id
149: FROM po_approved_supplier_list_gt PASL

Line 154: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

150: WHERE PASL.user_key = PSIC.user_key
151: AND ROWNUM < 2);
152:
153: l_progress := 35;
154: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
155:
156: UPDATE po_supplier_item_tolerance_gt PSIT
157: SET asl_id = (SELECT asl_id
158: FROM po_approved_supplier_list_gt PASL

Line 163: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

159: WHERE PASL.user_key = PSIT.user_key
160: AND ROWNUM < 2);
161:
162: l_progress := 40;
163: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
164:
165: /*--Populate capacity id in case of update and
166: --Capacity's process action is ADD
167: UPDATE po_supplier_item_capacity_gt PSIC

Line 171: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);*/

167: UPDATE po_supplier_item_capacity_gt PSIC
168: SET capacity_id = po_supplier_item_capacity_s.NEXTVAL
169: WHERE process_action = PO_ASL_API_PUB.g_ACTION_ADD;
170: l_progress := 42;
171: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);*/
172:
173: --Reject records if asl exist when mode is Create
174: SELECT user_key ,
175: 'po_approved_supplier_list_gt' ,

Line 573: po_asl_api_pvt.log('PO_ASL_API_GRP Rejected Rec count:'

569: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
570: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
571: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
572:
573: po_asl_api_pvt.log('PO_ASL_API_GRP Rejected Rec count:'
574: || l_user_key_tbl1.count);
575:
576: --call po_asl_api_pvt.reject_asl_record for above rejected records
577: IF l_user_key_tbl1.Count > 0

Line 576: --call po_asl_api_pvt.reject_asl_record for above rejected records

572:
573: po_asl_api_pvt.log('PO_ASL_API_GRP Rejected Rec count:'
574: || l_user_key_tbl1.count);
575:
576: --call po_asl_api_pvt.reject_asl_record for above rejected records
577: IF l_user_key_tbl1.Count > 0
578: THEN
579: po_asl_api_pvt.reject_asl_record(
580: p_user_key_tbl => l_user_key_tbl1,

Line 579: po_asl_api_pvt.reject_asl_record(

575:
576: --call po_asl_api_pvt.reject_asl_record for above rejected records
577: IF l_user_key_tbl1.Count > 0
578: THEN
579: po_asl_api_pvt.reject_asl_record(
580: p_user_key_tbl => l_user_key_tbl1,
581: p_rejection_reason => l_reject_reason1,
582: p_entity_name => l_entity_name1,
583: p_session_key => g_session_key,

Line 621: po_asl_api_pvt.process(

617: x_return_msg => x_return_msg
618: );
619: l_progress := 99;
620: --call the po_asl_api_pub.process for the next steps.
621: po_asl_api_pvt.process(
622: p_session_key => p_session_key,
623: x_return_status => x_return_status,
624: x_return_msg => x_return_msg
625: );

Line 627: po_asl_api_pvt.log('END ::: po_asl_api_grp.process');

623: x_return_status => x_return_status,
624: x_return_msg => x_return_msg
625: );
626: l_progress := 100;
627: po_asl_api_pvt.log('END ::: po_asl_api_grp.process');
628:
629: EXCEPTION
630:
631: WHEN OTHERS THEN

Line 633: po_asl_api_pvt.log('po_asl_api_grp.process : when others exception at '

629: EXCEPTION
630:
631: WHEN OTHERS THEN
632:
633: po_asl_api_pvt.log('po_asl_api_grp.process : when others exception at '
634: || l_progress || ';' || SQLERRM );
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: x_return_msg := SQLERRM;
637:

Line 672: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_asl_gt');

668: l_entity_name1 po_tbl_varchar30;
669: l_reject_reason1 po_tbl_varchar2000;
670:
671: BEGIN
672: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_asl_gt');
673: SELECT user_key ,
674: entity ,
675: msg
676: BULK COLLECT INTO

Line 842: --call po_asl_api_pvt.reject_asl_record for above rejected records

838:
839: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
840: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
841: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
842: --call po_asl_api_pvt.reject_asl_record for above rejected records
843: po_asl_api_pvt.log('validate_asl_gt: reject count:' || l_user_key_tbl1.Count);
844: IF l_user_key_tbl1.Count > 0
845: THEN
846: po_asl_api_pvt.reject_asl_record(

Line 843: po_asl_api_pvt.log('validate_asl_gt: reject count:' || l_user_key_tbl1.Count);

839: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
840: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
841: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
842: --call po_asl_api_pvt.reject_asl_record for above rejected records
843: po_asl_api_pvt.log('validate_asl_gt: reject count:' || l_user_key_tbl1.Count);
844: IF l_user_key_tbl1.Count > 0
845: THEN
846: po_asl_api_pvt.reject_asl_record(
847: p_user_key_tbl => l_user_key_tbl1 ,

Line 846: po_asl_api_pvt.reject_asl_record(

842: --call po_asl_api_pvt.reject_asl_record for above rejected records
843: po_asl_api_pvt.log('validate_asl_gt: reject count:' || l_user_key_tbl1.Count);
844: IF l_user_key_tbl1.Count > 0
845: THEN
846: po_asl_api_pvt.reject_asl_record(
847: p_user_key_tbl => l_user_key_tbl1 ,
848: p_rejection_reason=> l_reject_reason1,
849: p_entity_name => l_entity_name1 ,
850: p_session_key => g_session_key ,

Line 857: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_asl_gt');

853: );
854: END IF;
855:
856: l_progress := 100;
857: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_asl_gt');
858:
859: EXCEPTION
860:
861: WHEN OTHERS THEN

Line 863: po_asl_api_pvt.log('validate_asl_gt : when others exception at '

859: EXCEPTION
860:
861: WHEN OTHERS THEN
862:
863: po_asl_api_pvt.log('validate_asl_gt : when others exception at '
864: || l_progress || ';' || SQLERRM );
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: x_return_msg := SQLERRM;
867:

Line 906: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_asl_attr_gt');

902: l_entity_name1 po_tbl_varchar30;
903: l_reject_reason1 po_tbl_varchar2000;
904:
905: BEGIN
906: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_asl_attr_gt');
907: SELECT user_key ,
908: entity ,
909: msg
910: BULK COLLECT INTO

Line 1481: --call po_asl_api_pvt.reject_asl_record for above rejected records

1477: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
1478: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
1479: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
1480:
1481: --call po_asl_api_pvt.reject_asl_record for above rejected records
1482: po_asl_api_pvt.log('validate_asl_attr_gt: reject count:' ||
1483: l_user_key_tbl1.Count);
1484: IF l_user_key_tbl1.Count > 0
1485: THEN

Line 1482: po_asl_api_pvt.log('validate_asl_attr_gt: reject count:' ||

1478: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
1479: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
1480:
1481: --call po_asl_api_pvt.reject_asl_record for above rejected records
1482: po_asl_api_pvt.log('validate_asl_attr_gt: reject count:' ||
1483: l_user_key_tbl1.Count);
1484: IF l_user_key_tbl1.Count > 0
1485: THEN
1486: po_asl_api_pvt.reject_asl_record(

Line 1486: po_asl_api_pvt.reject_asl_record(

1482: po_asl_api_pvt.log('validate_asl_attr_gt: reject count:' ||
1483: l_user_key_tbl1.Count);
1484: IF l_user_key_tbl1.Count > 0
1485: THEN
1486: po_asl_api_pvt.reject_asl_record(
1487: p_user_key_tbl => l_user_key_tbl1,
1488: p_rejection_reason => l_reject_reason1,
1489: p_entity_name => l_entity_name1,
1490: p_session_key => g_session_key,

Line 1497: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_asl_attr_gt');

1493: );
1494: END IF;
1495:
1496: l_progress := 100;
1497: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_asl_attr_gt');
1498:
1499: EXCEPTION
1500:
1501: WHEN OTHERS THEN

Line 1503: po_asl_api_pvt.log('validate_asl_attr_gt : when others exception at '

1499: EXCEPTION
1500:
1501: WHEN OTHERS THEN
1502:
1503: po_asl_api_pvt.log('validate_asl_attr_gt : when others exception at '
1504: || l_progress || ';' || SQLERRM );
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: x_return_msg := SQLERRM;
1507:

Line 1539: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_asl_doc_gt');

1535: l_entity_name po_tbl_varchar30;
1536: l_reject_reason po_tbl_varchar2000;
1537:
1538: BEGIN
1539: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_asl_doc_gt');
1540: SELECT user_key ,
1541: entity ,
1542: msg
1543: BULK COLLECT INTO

Line 1584: --call po_asl_api_pvt.reject_asl_record for above rejected records

1580: AND DOCGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1581: );
1582:
1583: l_progress := 50;
1584: --call po_asl_api_pvt.reject_asl_record for above rejected records
1585: po_asl_api_pvt.log('validate_asl_doc_gt: reject count:' ||
1586: l_user_key_tbl.Count);
1587: IF l_user_key_tbl.Count > 0
1588: THEN

Line 1585: po_asl_api_pvt.log('validate_asl_doc_gt: reject count:' ||

1581: );
1582:
1583: l_progress := 50;
1584: --call po_asl_api_pvt.reject_asl_record for above rejected records
1585: po_asl_api_pvt.log('validate_asl_doc_gt: reject count:' ||
1586: l_user_key_tbl.Count);
1587: IF l_user_key_tbl.Count > 0
1588: THEN
1589: po_asl_api_pvt.reject_asl_record(

Line 1589: po_asl_api_pvt.reject_asl_record(

1585: po_asl_api_pvt.log('validate_asl_doc_gt: reject count:' ||
1586: l_user_key_tbl.Count);
1587: IF l_user_key_tbl.Count > 0
1588: THEN
1589: po_asl_api_pvt.reject_asl_record(
1590: p_user_key_tbl => l_user_key_tbl,
1591: p_rejection_reason => l_reject_reason,
1592: p_entity_name => l_entity_name,
1593: p_session_key => g_session_key,

Line 1600: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_asl_doc_gt');

1596: );
1597: END if;
1598:
1599: l_progress := 100;
1600: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_asl_doc_gt');
1601:
1602: EXCEPTION
1603:
1604: WHEN OTHERS THEN

Line 1606: po_asl_api_pvt.log('validate_asl_doc_gt : when others exception at '

1602: EXCEPTION
1603:
1604: WHEN OTHERS THEN
1605:
1606: po_asl_api_pvt.log('validate_asl_doc_gt : when others exception at '
1607: || l_progress || ';' || SQLERRM );
1608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1609: x_return_msg := SQLERRM;
1610:

Line 1642: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_chv_auth_gt');

1638: l_entity_name po_tbl_varchar30;
1639: l_reject_reason po_tbl_varchar2000;
1640:
1641: BEGIN
1642: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_chv_auth_gt');
1643: SELECT user_key ,
1644: entity ,
1645: msg
1646: BULK COLLECT INTO

Line 1672: --call po_asl_api_pvt.reject_asl_record for above rejected records

1668: );
1669:
1670:
1671: l_progress := 50;
1672: --call po_asl_api_pvt.reject_asl_record for above rejected records
1673: po_asl_api_pvt.log('validate_chv_auth_gt: reject count:' ||
1674: l_user_key_tbl.Count);
1675: IF l_user_key_tbl.Count > 0
1676: THEN

Line 1673: po_asl_api_pvt.log('validate_chv_auth_gt: reject count:' ||

1669:
1670:
1671: l_progress := 50;
1672: --call po_asl_api_pvt.reject_asl_record for above rejected records
1673: po_asl_api_pvt.log('validate_chv_auth_gt: reject count:' ||
1674: l_user_key_tbl.Count);
1675: IF l_user_key_tbl.Count > 0
1676: THEN
1677: po_asl_api_pvt.reject_asl_record(

Line 1677: po_asl_api_pvt.reject_asl_record(

1673: po_asl_api_pvt.log('validate_chv_auth_gt: reject count:' ||
1674: l_user_key_tbl.Count);
1675: IF l_user_key_tbl.Count > 0
1676: THEN
1677: po_asl_api_pvt.reject_asl_record(
1678: p_user_key_tbl => l_user_key_tbl,
1679: p_rejection_reason => l_reject_reason,
1680: p_entity_name => l_entity_name,
1681: p_session_key => g_session_key,

Line 1688: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_chv_auth_gt');

1684: );
1685: END IF;
1686:
1687: l_progress := 100;
1688: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_chv_auth_gt');
1689:
1690: EXCEPTION
1691:
1692: WHEN OTHERS THEN

Line 1694: po_asl_api_pvt.log('validate_chv_auth_gt : when others exception at '

1690: EXCEPTION
1691:
1692: WHEN OTHERS THEN
1693:
1694: po_asl_api_pvt.log('validate_chv_auth_gt : when others exception at '
1695: || l_progress || ';' || SQLERRM );
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: x_return_msg := SQLERRM;
1698:

Line 1733: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_supp_item_cap_gt');

1729: l_entity_name1 po_tbl_varchar30;
1730: l_reject_reason1 po_tbl_varchar2000;
1731:
1732: BEGIN
1733: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_supp_item_cap_gt');
1734: SELECT user_key ,
1735: entity ,
1736: msg
1737: BULK COLLECT INTO

Line 1827: --call po_asl_api_pvt.reject_asl_record for above rejected records

1823: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
1824: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
1825: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
1826:
1827: --call po_asl_api_pvt.reject_asl_record for above rejected records
1828: po_asl_api_pvt.log('validate_supp_item_cap_gt: reject count:' ||
1829: l_user_key_tbl1.Count);
1830: IF l_user_key_tbl1.Count > 0
1831: THEN

Line 1828: po_asl_api_pvt.log('validate_supp_item_cap_gt: reject count:' ||

1824: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
1825: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
1826:
1827: --call po_asl_api_pvt.reject_asl_record for above rejected records
1828: po_asl_api_pvt.log('validate_supp_item_cap_gt: reject count:' ||
1829: l_user_key_tbl1.Count);
1830: IF l_user_key_tbl1.Count > 0
1831: THEN
1832: po_asl_api_pvt.reject_asl_record(

Line 1832: po_asl_api_pvt.reject_asl_record(

1828: po_asl_api_pvt.log('validate_supp_item_cap_gt: reject count:' ||
1829: l_user_key_tbl1.Count);
1830: IF l_user_key_tbl1.Count > 0
1831: THEN
1832: po_asl_api_pvt.reject_asl_record(
1833: p_user_key_tbl => l_user_key_tbl1,
1834: p_rejection_reason => l_reject_reason1,
1835: p_entity_name => l_entity_name1,
1836: p_session_key => g_session_key,

Line 1843: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_supp_item_cap_gt');

1839: );
1840: END IF;
1841:
1842: l_progress := 100;
1843: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_supp_item_cap_gt');
1844:
1845: EXCEPTION
1846:
1847: WHEN OTHERS THEN

Line 1849: po_asl_api_pvt.log('validate_supp_item_cap_gt : when others exception at '

1845: EXCEPTION
1846:
1847: WHEN OTHERS THEN
1848:
1849: po_asl_api_pvt.log('validate_supp_item_cap_gt : when others exception at '
1850: || l_progress || ';' || SQLERRM );
1851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1852: x_return_msg := SQLERRM;
1853:

Line 1885: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_supp_item_tol_gt');

1881: l_entity_name po_tbl_varchar30;
1882: l_reject_reason po_tbl_varchar2000;
1883:
1884: BEGIN
1885: po_asl_api_pvt.log('START ::: po_asl_api_grp.validate_supp_item_tol_gt');
1886: SELECT user_key ,
1887: entity ,
1888: msg
1889: BULK COLLECT INTO

Line 1913: --call po_asl_api_pvt.reject_asl_record for above rejected records

1909: OR PSITGT.tolerance_dsp <= 0
1910: );
1911:
1912: l_progress := 50;
1913: --call po_asl_api_pvt.reject_asl_record for above rejected records
1914: po_asl_api_pvt.log('validate_supp_item_tol_gt: reject count:' ||
1915: l_user_key_tbl.Count);
1916: IF l_user_key_tbl.Count > 0
1917: THEN

Line 1914: po_asl_api_pvt.log('validate_supp_item_tol_gt: reject count:' ||

1910: );
1911:
1912: l_progress := 50;
1913: --call po_asl_api_pvt.reject_asl_record for above rejected records
1914: po_asl_api_pvt.log('validate_supp_item_tol_gt: reject count:' ||
1915: l_user_key_tbl.Count);
1916: IF l_user_key_tbl.Count > 0
1917: THEN
1918: po_asl_api_pvt.reject_asl_record(

Line 1918: po_asl_api_pvt.reject_asl_record(

1914: po_asl_api_pvt.log('validate_supp_item_tol_gt: reject count:' ||
1915: l_user_key_tbl.Count);
1916: IF l_user_key_tbl.Count > 0
1917: THEN
1918: po_asl_api_pvt.reject_asl_record(
1919: p_user_key_tbl => l_user_key_tbl,
1920: p_rejection_reason => l_reject_reason,
1921: p_entity_name => l_entity_name,
1922: p_session_key => g_session_key,

Line 1929: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_supp_item_tol_gt');

1925: );
1926: END IF;
1927:
1928: l_progress := 100;
1929: po_asl_api_pvt.log('END ::: po_asl_api_grp.validate_supp_item_tol_gt');
1930:
1931: EXCEPTION
1932:
1933: WHEN OTHERS THEN

Line 1935: po_asl_api_pvt.log('validate_supp_item_tol_gt : when others exception at '

1931: EXCEPTION
1932:
1933: WHEN OTHERS THEN
1934:
1935: po_asl_api_pvt.log('validate_supp_item_tol_gt : when others exception at '
1936: || l_progress || ';' || SQLERRM );
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: x_return_msg := SQLERRM;
1939:

Line 1984: po_asl_api_pvt.log('START ::: determine_action');

1980: l_process_action VARCHAR2(20);
1981: l_found NUMBER;
1982:
1983: BEGIN
1984: po_asl_api_pvt.log('START ::: determine_action');
1985: po_asl_api_pvt.log('p_item_id' || p_item_id);
1986: po_asl_api_pvt.log('p_category_id' || p_category_id);
1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);

Line 1985: po_asl_api_pvt.log('p_item_id' || p_item_id);

1981: l_found NUMBER;
1982:
1983: BEGIN
1984: po_asl_api_pvt.log('START ::: determine_action');
1985: po_asl_api_pvt.log('p_item_id' || p_item_id);
1986: po_asl_api_pvt.log('p_category_id' || p_category_id);
1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);
1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);

Line 1986: po_asl_api_pvt.log('p_category_id' || p_category_id);

1982:
1983: BEGIN
1984: po_asl_api_pvt.log('START ::: determine_action');
1985: po_asl_api_pvt.log('p_item_id' || p_item_id);
1986: po_asl_api_pvt.log('p_category_id' || p_category_id);
1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);
1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);
1990: l_found := 0;

Line 1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);

1983: BEGIN
1984: po_asl_api_pvt.log('START ::: determine_action');
1985: po_asl_api_pvt.log('p_item_id' || p_item_id);
1986: po_asl_api_pvt.log('p_category_id' || p_category_id);
1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);
1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);
1990: l_found := 0;
1991: l_process_action := PO_ASL_API_PUB.g_ACTION_CREATE;

Line 1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);

1984: po_asl_api_pvt.log('START ::: determine_action');
1985: po_asl_api_pvt.log('p_item_id' || p_item_id);
1986: po_asl_api_pvt.log('p_category_id' || p_category_id);
1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);
1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);
1990: l_found := 0;
1991: l_process_action := PO_ASL_API_PUB.g_ACTION_CREATE;
1992:

Line 1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);

1985: po_asl_api_pvt.log('p_item_id' || p_item_id);
1986: po_asl_api_pvt.log('p_category_id' || p_category_id);
1987: po_asl_api_pvt.log('p_using_organization_id' || p_using_organization_id);
1988: po_asl_api_pvt.log('p_vendor_id' || p_vendor_id);
1989: po_asl_api_pvt.log('p_vendor_site_id' || p_vendor_site_id);
1990: l_found := 0;
1991: l_process_action := PO_ASL_API_PUB.g_ACTION_CREATE;
1992:
1993: SELECT 1 INTO l_found

Line 2009: po_asl_api_pvt.log('process_action:' || l_process_action);

2005: THEN
2006: l_process_action := PO_ASL_API_PUB.g_ACTION_UPDATE;
2007: END IF;
2008:
2009: po_asl_api_pvt.log('process_action:' || l_process_action);
2010: po_asl_api_pvt.log('END ::: determine_action');
2011:
2012: RETURN(l_process_action);
2013: EXCEPTION

Line 2010: po_asl_api_pvt.log('END ::: determine_action');

2006: l_process_action := PO_ASL_API_PUB.g_ACTION_UPDATE;
2007: END IF;
2008:
2009: po_asl_api_pvt.log('process_action:' || l_process_action);
2010: po_asl_api_pvt.log('END ::: determine_action');
2011:
2012: RETURN(l_process_action);
2013: EXCEPTION
2014: WHEN NO_DATA_FOUND THEN

Line 2015: po_asl_api_pvt.log('determine_action : when NO_DATA_FOUND at '

2011:
2012: RETURN(l_process_action);
2013: EXCEPTION
2014: WHEN NO_DATA_FOUND THEN
2015: po_asl_api_pvt.log('determine_action : when NO_DATA_FOUND at '
2016: || SQLERRM );
2017: RETURN(l_process_action);
2018:
2019: WHEN OTHERS THEN

Line 2021: po_asl_api_pvt.log('determine_action : when others exception at '

2017: RETURN(l_process_action);
2018:
2019: WHEN OTHERS THEN
2020:
2021: po_asl_api_pvt.log('determine_action : when others exception at '
2022: || SQLERRM );
2023: RETURN(l_process_action);
2024:
2025: END determine_action;

Line 2067: po_asl_api_pvt.log('START ::: validate_vmi');

2063: l_return_status VARCHAR2(10);
2064:
2065:
2066: BEGIN
2067: po_asl_api_pvt.log('START ::: validate_vmi');
2068: po_asl_api_pvt.log('p_item_id:' || p_item_id);
2069: po_asl_api_pvt.log('p_using_organization_id:' || p_using_organization_id);
2070: po_asl_api_pvt.log('p_vendor_site_id:' || p_vendor_site_id);
2071:

Line 2068: po_asl_api_pvt.log('p_item_id:' || p_item_id);

2064:
2065:
2066: BEGIN
2067: po_asl_api_pvt.log('START ::: validate_vmi');
2068: po_asl_api_pvt.log('p_item_id:' || p_item_id);
2069: po_asl_api_pvt.log('p_using_organization_id:' || p_using_organization_id);
2070: po_asl_api_pvt.log('p_vendor_site_id:' || p_vendor_site_id);
2071:
2072: IF p_using_organization_id <> -1

Line 2069: po_asl_api_pvt.log('p_using_organization_id:' || p_using_organization_id);

2065:
2066: BEGIN
2067: po_asl_api_pvt.log('START ::: validate_vmi');
2068: po_asl_api_pvt.log('p_item_id:' || p_item_id);
2069: po_asl_api_pvt.log('p_using_organization_id:' || p_using_organization_id);
2070: po_asl_api_pvt.log('p_vendor_site_id:' || p_vendor_site_id);
2071:
2072: IF p_using_organization_id <> -1
2073: THEN

Line 2070: po_asl_api_pvt.log('p_vendor_site_id:' || p_vendor_site_id);

2066: BEGIN
2067: po_asl_api_pvt.log('START ::: validate_vmi');
2068: po_asl_api_pvt.log('p_item_id:' || p_item_id);
2069: po_asl_api_pvt.log('p_using_organization_id:' || p_using_organization_id);
2070: po_asl_api_pvt.log('p_vendor_site_id:' || p_vendor_site_id);
2071:
2072: IF p_using_organization_id <> -1
2073: THEN
2074: l_result := PO_THIRD_PARTY_STOCK_GRP.validate_local_asl(

Line 2105: po_asl_api_pvt.log('END ::: validate_vmi -> Result:' || 'T');

2101: END IF;
2102:
2103: IF l_result = TRUE
2104: THEN
2105: po_asl_api_pvt.log('END ::: validate_vmi -> Result:' || 'T');
2106: RETURN 'T';
2107: ELSE
2108: po_asl_api_pvt.log('END ::: validate_vmi -> Result:' || 'F');
2109: RETURN 'F';

Line 2108: po_asl_api_pvt.log('END ::: validate_vmi -> Result:' || 'F');

2104: THEN
2105: po_asl_api_pvt.log('END ::: validate_vmi -> Result:' || 'T');
2106: RETURN 'T';
2107: ELSE
2108: po_asl_api_pvt.log('END ::: validate_vmi -> Result:' || 'F');
2109: RETURN 'F';
2110: END IF;
2111:
2112: EXCEPTION

Line 2115: po_asl_api_pvt.log('validate_vmi : when others exception at ' || SQLERRM );

2111:
2112: EXCEPTION
2113:
2114: WHEN OTHERS THEN
2115: po_asl_api_pvt.log('validate_vmi : when others exception at ' || SQLERRM );
2116: RETURN 'F';
2117:
2118: END validate_vmi;
2119: