DBA Data[Home] [Help]

APPS.PO_AP_PURGE_UTIL_PVT dependencies on FND_LOG_MESSAGES

Line 166: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

162: ) IS
163:
164: l_api_name CONSTANT VARCHAR2(50) := 'seed_po';
165: l_progress VARCHAR2(3);
166: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
167: G_MODULE_PREFIX || l_api_name || '.';
168:
169: BEGIN
170:

Line 458: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

454:
455: l_api_name VARCHAR2(50) := 'filter_more_referenced_po';
456: l_progress VARCHAR2(3);
457: l_return_status VARCHAR2(1);
458: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
459: G_MODULE_PREFIX || l_api_name || '.';
460:
461: BEGIN
462:

Line 536: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

532:
533: l_api_name VARCHAR2(50) := 'filter_more_referenced_po';
534: l_progress VARCHAR2(3);
535: l_return_status VARCHAR2(1);
536: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
537: G_MODULE_PREFIX || l_api_name || '.';
538:
539: BEGIN
540:

Line 661: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

657:
658: l_api_name VARCHAR2(50) := 'delete_req_related_records';
659: l_progress VARCHAR2(3);
660: l_return_status VARCHAR2(1);
661: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
662: G_MODULE_PREFIX || l_api_name || '.';
663:
664: BEGIN
665:

Line 787: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

783:
784: l_api_name VARCHAR2(50) := 'delete_po_related_records';
785: l_progress VARCHAR2(3);
786: l_return_status VARCHAR2(1);
787: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
788: G_MODULE_PREFIX || l_api_name || '.';
789:
790: BEGIN
791:

Line 993: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

989: ) IS
990:
991: l_api_name VARCHAR2(50) := 'filter_req_pon_validation';
992: l_progress VARCHAR2(3);
993: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
994: G_MODULE_PREFIX || l_api_name || '.';
995:
996: l_in_rec PON_PO_INTEGRATION_GRP.PURGE_IN_RECTYPE;
997: l_out_rec PON_PO_INTEGRATION_GRP.PURGE_OUT_RECTYPE;

Line 1136: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1132: ) IS
1133:
1134: l_api_name VARCHAR2(50) := 'filter_po_fte_validation';
1135: l_progress VARCHAR2(3);
1136: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1137: G_MODULE_PREFIX || l_api_name || '.';
1138:
1139: CURSOR c_po_list IS
1140: SELECT po_header_id

Line 1299: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1295: ) IS
1296:
1297: l_api_name VARCHAR2(50) := 'filter_po_cst_validation';
1298: l_progress VARCHAR2(3);
1299: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1300: G_MODULE_PREFIX || l_api_name || '.';
1301:
1302: CURSOR c_po_list IS
1303: SELECT po_header_id

Line 1444: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1440: ) IS
1441:
1442: l_api_name VARCHAR2(50) := 'filter_po_oe_validation';
1443: l_progress VARCHAR2(3);
1444: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1445: G_MODULE_PREFIX || l_api_name || '.';
1446:
1447: l_hdr_id_tbl OE_DROP_SHIP_GRP.PO_ENTITY_ID_TBL_TYPE;
1448: l_purge_allowed_tbl OE_DROP_SHIP_GRP.VAL_STATUS_TBL_TYPE;

Line 1615: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1611: ) IS
1612:
1613: l_api_name VARCHAR2(50) := 'filter_po_pon_validation';
1614: l_progress VARCHAR2(3);
1615: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1616: G_MODULE_PREFIX || l_api_name || '.';
1617:
1618: l_in_rec PON_PO_INTEGRATION_GRP.PURGE_IN_RECTYPE;
1619: l_out_rec PON_PO_INTEGRATION_GRP.PURGE_OUT_RECTYPE;

Line 1759: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1755: ) IS
1756:
1757: l_api_name VARCHAR2(50) := 'filter_po_hr_validation';
1758: l_progress VARCHAR2(3);
1759: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1760: G_MODULE_PREFIX || l_api_name || '.';
1761:
1762: l_in_tbl HR_PO_INFO.g_table_numbers_t;
1763: l_out_tbl HR_PO_INFO.g_table_numbers_t;

Line 1891: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1887: ) IS
1888:
1889: l_api_name VARCHAR2(50) := 'delete_asl_ref';
1890: l_progress VARCHAR2(3);
1891: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1892: G_MODULE_PREFIX || l_api_name || '.';
1893:
1894: BEGIN
1895:

Line 1980: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1976: ) IS
1977:
1978: l_api_name VARCHAR2(50) := 'delete_org_assignments';
1979: l_progress VARCHAR2(3);
1980: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1981: G_MODULE_PREFIX || l_api_name || '.';
1982:
1983: BEGIN
1984:

Line 2094: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2090:
2091: l_api_name VARCHAR2(50) := 'delete_drop_ship_po_links';
2092: l_progress VARCHAR2(3);
2093: l_return_status VARCHAR2(1);
2094: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2095: G_MODULE_PREFIX || l_api_name || '.';
2096:
2097: l_po_hdr_tbl OE_DROP_SHIP_GRP.PO_ENTITY_ID_TBL_TYPE;
2098:

Line 2217: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2213:
2214: l_api_name VARCHAR2(50) := 'delete_fte';
2215: l_progress VARCHAR2(3);
2216: l_return_status VARCHAR2(1);
2217: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2218: G_MODULE_PREFIX || l_api_name || '.';
2219:
2220: l_fte_in_rec WSH_PO_INTG_TYPES_GRP.purge_in_rectype;
2221: l_msg_count NUMBER;

Line 2351: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2347:
2348: l_api_name VARCHAR2(50) := 'delete_pon';
2349: l_progress VARCHAR2(3);
2350: l_return_status VARCHAR2(1);
2351: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2352: G_MODULE_PREFIX || l_api_name || '.';
2353:
2354: l_in_rec PON_PO_INTEGRATION_GRP.purge_in_rectype;
2355: l_msg_count NUMBER;

Line 2479: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2475:
2476: l_api_name VARCHAR2(50) := 'delete_contract_terms';
2477: l_progress VARCHAR2(3);
2478: l_return_status VARCHAR2(1);
2479: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2480: G_MODULE_PREFIX || l_api_name || '.';
2481:
2482: l_header_tbl OKC_TERMS_UTIL_GRP.doc_tbl_type;
2483: l_msg_count NUMBER;

Line 2639: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2635:
2636: l_api_name VARCHAR2(50) := 'delete_price_differentials';
2637: l_progress VARCHAR2(3);
2638: l_return_status VARCHAR2(1);
2639: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2640: G_MODULE_PREFIX || l_api_name || '.';
2641:
2642: BEGIN
2643:

Line 2844: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2840:
2841: l_api_name VARCHAR2(50) := 'delete_attr_values';
2842: l_progress VARCHAR2(3);
2843: l_return_status VARCHAR2(1);
2844: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2845: G_MODULE_PREFIX || l_api_name || '.';
2846:
2847: BEGIN
2848:

Line 2989: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2985: ) IS
2986:
2987: l_api_name VARCHAR2(50) := 'delete_req_attachments';
2988: l_progress VARCHAR2(3);
2989: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2990: G_MODULE_PREFIX || l_api_name || '.';
2991:
2992: CURSOR c_req_header IS
2993: SELECT PPRL.requisition_header_id

Line 3114: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3110: ) IS
3111:
3112: l_api_name VARCHAR2(50) := 'delete_po_attachments';
3113: l_progress VARCHAR2(3);
3114: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3115: G_MODULE_PREFIX || l_api_name || '.';
3116:
3117: CURSOR c_po_header IS
3118: SELECT PPL.po_header_id

Line 3322: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3318: ) IS
3319:
3320: l_api_name VARCHAR2(50) := 'delete_drafts';
3321: l_progress VARCHAR2(3);
3322: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3323: G_MODULE_PREFIX || l_api_name || '.';
3324:
3325: l_dft_id_tbl PO_TBL_NUMBER;
3326:

Line 3423: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3419: ) IS
3420:
3421: l_api_name VARCHAR2(50) := 'delete_po_approval_list';
3422: l_progress VARCHAR2(3);
3423: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3424: G_MODULE_PREFIX || l_api_name || '.';
3425: BEGIN
3426:
3427: l_progress := '000';

Line 3526: --Function: Put the record count of the purge table into FND_LOG_MESSAGES,

3522: --Modifies:
3523: -- None
3524: --Locks:
3525: -- None
3526: --Function: Put the record count of the purge table into FND_LOG_MESSAGES,
3527: -- if logging is turned on
3528: --Parameters:
3529: --IN:
3530: --p_module