DBA Data[Home] [Help]

APPS.PO_ASL_API_GRP dependencies on PO_ASL_API_GRP

Line 1: PACKAGE BODY PO_ASL_API_GRP AS

1: PACKAGE BODY PO_ASL_API_GRP AS
2: /* $Header: PO_ASL_API_GRP.plb 120.3.12020000.2 2013/02/11 13:40:48 vegajula noship $ */
3:
4: g_session_key NUMBER;
5:

Line 2: /* $Header: PO_ASL_API_GRP.plb 120.3.12020000.2 2013/02/11 13:40:48 vegajula noship $ */

1: PACKAGE BODY PO_ASL_API_GRP AS
2: /* $Header: PO_ASL_API_GRP.plb 120.3.12020000.2 2013/02/11 13:40:48 vegajula noship $ */
3:
4: g_session_key NUMBER;
5:
6: PROCEDURE validate_asl_gt(

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 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 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 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 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 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 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 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 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 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 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 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 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 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 2120: END PO_ASL_API_GRP;

2116: RETURN 'F';
2117:
2118: END validate_vmi;
2119:
2120: END PO_ASL_API_GRP;