DBA Data[Home] [Help]

APPS.PO_AP_PURGE_PVT dependencies on FND_LOG_MESSAGES

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

175:
176: l_api_name CONSTANT VARCHAR2(50) := 'seed_records';
177: l_api_version CONSTANT NUMBER := 1.0;
178: l_progress VARCHAR2(3);
179: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
180: G_MODULE_PREFIX || l_api_name || '.';
181: l_msg_idx NUMBER;
182:
183: BEGIN

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

360: l_api_name CONSTANT VARCHAR2(50) := 'filter_records';
361: l_api_version CONSTANT NUMBER := 1.0;
362: l_progress VARCHAR2(3);
363: l_return_status VARCHAR2(1);
364: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
365: G_MODULE_PREFIX || l_api_name || '.';
366: l_msg_idx NUMBER;
367:
368: BEGIN

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

592: l_api_name CONSTANT VARCHAR2(50) := 'confirm_records';
593: l_api_version CONSTANT NUMBER := 1.0;
594: l_progress VARCHAR2(3);
595: l_return_status VARCHAR2(1);
596: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
597: G_MODULE_PREFIX || l_api_name || '.';
598: l_msg_idx NUMBER;
599: BEGIN
600:

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

748: l_api_name CONSTANT VARCHAR2(50) := 'summarize_records';
749: l_api_version CONSTANT NUMBER := 1.0;
750: l_progress VARCHAR2(3);
751: l_return_status VARCHAR2(1);
752: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
753: G_MODULE_PREFIX || l_api_name || '.';
754:
755: l_req_lower_limit NUMBER;
756: l_req_upper_limit NUMBER;

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

996: l_api_name CONSTANT VARCHAR2(50) := 'delete_records';
997: l_api_version CONSTANT NUMBER := 1.0;
998: l_progress VARCHAR2(3);
999: l_return_status VARCHAR2(1);
1000: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1001: G_MODULE_PREFIX || l_api_name || '.';
1002: l_msg_idx NUMBER;
1003:
1004: l_req_lower_limit NUMBER;

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

1191:
1192: l_api_name CONSTANT VARCHAR2(50) := 'delete_purge_lists';
1193: l_api_version CONSTANT NUMBER := 1.0;
1194: l_progress VARCHAR2(3);
1195: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1196: G_MODULE_PREFIX || l_api_name || '.';
1197: l_msg_idx NUMBER;
1198:
1199: BEGIN

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

1317: l_api_name CONSTANT VARCHAR2(50) := 'delete_history_tables';
1318: l_api_version CONSTANT NUMBER := 1.0;
1319: l_progress VARCHAR2(3);
1320: l_return_status VARCHAR2(1);
1321: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1322: G_MODULE_PREFIX || l_api_name || '.';
1323: l_msg_idx NUMBER;
1324:
1325: BEGIN

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

1462: l_api_name VARCHAR2(50) := 'count_po_rows';
1463: l_api_version NUMBER := 1.0;
1464: l_progress VARCHAR2(3);
1465: l_return_status VARCHAR2(1);
1466: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1467: G_MODULE_PREFIX || l_api_name || '.';
1468: l_msg_idx NUMBER;
1469:
1470: BEGIN

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

1601: ) IS
1602:
1603: l_api_name CONSTANT VARCHAR2(50) := 'seed_simple_req';
1604: l_progress VARCHAR2(3);
1605: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1606: G_MODULE_PREFIX || l_api_name || '.';
1607:
1608: BEGIN
1609: l_progress := '000';

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

1740:
1741: l_api_name CONSTANT VARCHAR2(50) := 'seed_po';
1742: l_progress VARCHAR2(3);
1743: l_return_status VARCHAR2(1);
1744: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1745: G_MODULE_PREFIX || l_api_name || '.';
1746:
1747: BEGIN
1748:

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

2050: l_api_name CONSTANT VARCHAR2(50) := 'set_product_inst_status';
2051: l_api_version CONSTANT NUMBER := 1.0;
2052: l_progress VARCHAR2(3);
2053: l_return_status VARCHAR2(1);
2054: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2055: G_MODULE_PREFIX || l_api_name || '.';
2056:
2057: BEGIN
2058:

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

2215: ) IS
2216:
2217: l_api_name VARCHAR2(50) := 'get_installation_status';
2218: l_progress VARCHAR2(3);
2219: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2220: G_MODULE_PREFIX || l_api_name || '.';
2221:
2222: l_inst_check VARCHAR2(1);
2223: l_dummy VARCHAR2(1);

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

2308: )IS
2309:
2310: l_api_name VARCHAR2(50) := 'filter_referenced_req';
2311: l_progress VARCHAR2(3);
2312: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2313: G_MODULE_PREFIX || l_api_name || '.';
2314:
2315: l_return_status VARCHAR2(1);
2316:

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

2493:
2494: l_api_name VARCHAR2(50) := 'filter_referenced_po';
2495: l_progress VARCHAR2(3);
2496: l_return_status VARCHAR2(1);
2497: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2498: G_MODULE_PREFIX || l_api_name || '.';
2499:
2500: BEGIN
2501:

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

2754: ) IS
2755:
2756: l_api_name VARCHAR2(50) := 'filter_dependent_po_req_list';
2757: l_progress VARCHAR2(3);
2758: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2759: G_MODULE_PREFIX || l_api_name || '.';
2760:
2761: l_po_count NUMBER;
2762: l_req_count NUMBER;

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

2970: ) IS
2971:
2972: l_api_name VARCHAR2(50) := 'filter_dependent_po_ap_list';
2973: l_progress VARCHAR2(3);
2974: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2975: G_MODULE_PREFIX || l_api_name || '.';
2976:
2977: l_po_count NUMBER;
2978:

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

3084: ) IS
3085:
3086: l_api_name VARCHAR2(50) := 'remove_filtered_records';
3087: l_progress VARCHAR2(3);
3088: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3089: G_MODULE_PREFIX || l_api_name || '.';
3090:
3091: BEGIN
3092:

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

3189: ) IS
3190:
3191: l_api_name VARCHAR2(50) := 'confirm_simple_req';
3192: l_progress VARCHAR2(3);
3193: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3194: G_MODULE_PREFIX || l_api_name || '.';
3195:
3196: BEGIN
3197:

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

3328: ) IS
3329:
3330: l_api_name VARCHAR2(50) := 'confirm_po';
3331: l_progress VARCHAR2(3);
3332: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3333: G_MODULE_PREFIX || l_api_name || '.';
3334:
3335: BEGIN
3336:

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

3621: ) IS
3622:
3623: l_api_name VARCHAR2(50) := 'get_purge_list_range';
3624: l_progress VARCHAR2(3);
3625: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3626: G_MODULE_PREFIX || l_api_name || '.';
3627:
3628: BEGIN
3629:

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

3741: ) IS
3742:
3743: l_api_name VARCHAR2(50) := 'summarize_reqs';
3744: l_progress VARCHAR2(3);
3745: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3746: G_MODULE_PREFIX || l_api_name || '.';
3747:
3748: l_range_inserted VARCHAR2(1);
3749: l_range_low NUMBER;

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

3944: ) IS
3945:
3946: l_api_name VARCHAR2(50) := 'summarize_pos';
3947: l_progress VARCHAR2(3);
3948: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3949: G_MODULE_PREFIX || l_api_name || '.';
3950:
3951: l_range_inserted VARCHAR2(1);
3952: l_range_low NUMBER;

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

4405:
4406: l_api_name VARCHAR2(50) := 'delete_reqs';
4407: l_progress VARCHAR2(3);
4408: l_return_status VARCHAR2(1);
4409: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
4410: G_MODULE_PREFIX || l_api_name || '.';
4411:
4412: l_range_low NUMBER;
4413: l_range_high NUMBER;

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

4661: --
4662:
4663: l_api_name VARCHAR2(50) := 'delete_pos';
4664: l_progress VARCHAR2(3);
4665: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
4666: G_MODULE_PREFIX || l_api_name || '.';
4667:
4668: -- bug3209532
4669: l_pos_dynamic_call VARCHAR2(2000);