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_PUB dependencies on PO_ASL_API_PUB

Line 1: PACKAGE BODY po_asl_api_pub AS

1: PACKAGE BODY po_asl_api_pub AS
2: /* $Header: PO_ASL_API_PUB.plb 120.3.12020000.2 2013/02/11 13:18:27 vegajula noship $ */
3:
4: g_session_key NUMBER;
5:

Line 2: /* $Header: PO_ASL_API_PUB.plb 120.3.12020000.2 2013/02/11 13:18:27 vegajula noship $ */

1: PACKAGE BODY po_asl_api_pub AS
2: /* $Header: PO_ASL_API_PUB.plb 120.3.12020000.2 2013/02/11 13:18:27 vegajula noship $ */
3:
4: g_session_key NUMBER;
5:
6: PROCEDURE dump_to_asl_gtt(

Line 328: --call the po_asl_api_pub.process for the next steps.

324: RAISE parent_key_not_found;
325: END IF;
326:
327: l_progress := 80;
328: --call the po_asl_api_pub.process for the next steps.
329: po_asl_api_pub.process(
330: x_return_status => x_return_status,
331: x_return_msg => x_return_msg
332: );

Line 329: po_asl_api_pub.process(

325: END IF;
326:
327: l_progress := 80;
328: --call the po_asl_api_pub.process for the next steps.
329: po_asl_api_pub.process(
330: x_return_status => x_return_status,
331: x_return_msg => x_return_msg
332: );
333:

Line 435: po_asl_api_pvt.log('START ::: po_asl_api_pub.process');

431: IS
432: l_progress NUMBER := 0;
433:
434: BEGIN
435: po_asl_api_pvt.log('START ::: po_asl_api_pub.process');
436: x_return_msg := NULL;
437:
438: --derive the id fields based on the display values provided
439: --updating po_approved_supplier_list_gt to derive id fields

Line 513: po_asl_api_pvt.log('END ::: po_asl_api_pub.process ');

509: x_return_msg => x_return_msg
510: );
511:
512: l_progress := 100;
513: po_asl_api_pvt.log('END ::: po_asl_api_pub.process ');
514:
515: EXCEPTION
516:
517: WHEN OTHERS THEN

Line 519: po_asl_api_pvt.log('po_asl_api_pub.process : when others exception at '

515: EXCEPTION
516:
517: WHEN OTHERS THEN
518:
519: po_asl_api_pvt.log('po_asl_api_pub.process : when others exception at '
520: || l_progress || ';' || SQLERRM );
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: x_return_msg := SQLERRM;
523: END process;

Line 1196: po_asl_api_pub.g_action_add,

1192: g_session_key ,
1193: p_capacity_rec.user_key(l_index) ,
1194: p_capacity_rec.process_action(l_index) ,
1195: Decode(p_capacity_rec.process_action(l_index),
1196: po_asl_api_pub.g_action_add,
1197: po_supplier_item_capacity_s.NEXTVAL, NULL),
1198: NULL ,
1199: p_capacity_rec.using_organization_id(l_index) ,
1200: p_capacity_rec.using_organization_dsp(l_index) ,

Line 2021: (PO_ASL_API_PUB.g_ACTION_CREATE,

2017: 'po_approved_supplier_list_gt' AS entity ,
2018: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2019: FROM po_approved_supplier_list_gt
2020: WHERE process_action NOT IN
2021: (PO_ASL_API_PUB.g_ACTION_CREATE,
2022: PO_ASL_API_PUB.g_ACTION_UPDATE,
2023: PO_ASL_API_PUB.g_ACTION_SYNC)
2024: OR process_action IS NULL
2025: );

Line 2022: PO_ASL_API_PUB.g_ACTION_UPDATE,

2018: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2019: FROM po_approved_supplier_list_gt
2020: WHERE process_action NOT IN
2021: (PO_ASL_API_PUB.g_ACTION_CREATE,
2022: PO_ASL_API_PUB.g_ACTION_UPDATE,
2023: PO_ASL_API_PUB.g_ACTION_SYNC)
2024: OR process_action IS NULL
2025: );
2026:

Line 2023: PO_ASL_API_PUB.g_ACTION_SYNC)

2019: FROM po_approved_supplier_list_gt
2020: WHERE process_action NOT IN
2021: (PO_ASL_API_PUB.g_ACTION_CREATE,
2022: PO_ASL_API_PUB.g_ACTION_UPDATE,
2023: PO_ASL_API_PUB.g_ACTION_SYNC)
2024: OR process_action IS NULL
2025: );
2026:
2027: l_progress := 50;

Line 2241: (PO_ASL_API_PUB.g_ACTION_ADD,

2237: 'po_asl_attributes_gt' AS entity ,
2238: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2239: FROM po_asl_attributes_gt
2240: WHERE process_action NOT IN
2241: (PO_ASL_API_PUB.g_ACTION_ADD,
2242: PO_ASL_API_PUB.g_ACTION_UPDATE,
2243: PO_ASL_API_PUB.g_ACTION_DELETE)
2244: OR process_action IS NULL
2245:

Line 2242: PO_ASL_API_PUB.g_ACTION_UPDATE,

2238: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2239: FROM po_asl_attributes_gt
2240: WHERE process_action NOT IN
2241: (PO_ASL_API_PUB.g_ACTION_ADD,
2242: PO_ASL_API_PUB.g_ACTION_UPDATE,
2243: PO_ASL_API_PUB.g_ACTION_DELETE)
2244: OR process_action IS NULL
2245:
2246: UNION ALL

Line 2243: PO_ASL_API_PUB.g_ACTION_DELETE)

2239: FROM po_asl_attributes_gt
2240: WHERE process_action NOT IN
2241: (PO_ASL_API_PUB.g_ACTION_ADD,
2242: PO_ASL_API_PUB.g_ACTION_UPDATE,
2243: PO_ASL_API_PUB.g_ACTION_DELETE)
2244: OR process_action IS NULL
2245:
2246: UNION ALL
2247: --Reject records if ASL Process action is create and attribute's process

Line 2255: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

2251: fnd_message.get_string('PO','INVALID_PAA_ACTION') AS msg
2252: FROM po_asl_attributes_gt PAA,
2253: po_approved_supplier_list_gt ASL
2254: WHERE ASL.user_key = PAA.user_key
2255: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2256: AND PAA.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2257: );
2258:
2259: l_progress := 50;

Line 2256: AND PAA.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

2252: FROM po_asl_attributes_gt PAA,
2253: po_approved_supplier_list_gt ASL
2254: WHERE ASL.user_key = PAA.user_key
2255: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2256: AND PAA.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2257: );
2258:
2259: l_progress := 50;
2260: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 2397: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

2393: fnd_message.get_string('PO','INVALID_PAD_ACTION') AS msg
2394: FROM po_asl_documents_gt PAD,
2395: po_approved_supplier_list_gt ASL
2396: WHERE ASL.user_key = PAD.user_key
2397: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2398: AND PAD.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2399:
2400: UNION ALL
2401: --Reject records if ASL Process action is create and authorization's process

Line 2398: AND PAD.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

2394: FROM po_asl_documents_gt PAD,
2395: po_approved_supplier_list_gt ASL
2396: WHERE ASL.user_key = PAD.user_key
2397: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2398: AND PAD.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2399:
2400: UNION ALL
2401: --Reject records if ASL Process action is create and authorization's process
2402: --action is delete/update

Line 2409: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

2405: fnd_message.get_string('PO','INVALID_CHV_ACTION') AS msg
2406: FROM chv_authorizations_gt CHV,
2407: po_approved_supplier_list_gt ASL
2408: WHERE ASL.user_key = CHV.user_key
2409: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2410: AND CHV.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2411:
2412: UNION ALL
2413: --Reject records if ASL Process action is create and capacity's process

Line 2410: AND CHV.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

2406: FROM chv_authorizations_gt CHV,
2407: po_approved_supplier_list_gt ASL
2408: WHERE ASL.user_key = CHV.user_key
2409: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2410: AND CHV.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2411:
2412: UNION ALL
2413: --Reject records if ASL Process action is create and capacity's process
2414: --action is delete/update

Line 2421: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

2417: fnd_message.get_string('PO','INVALID_CAP_ACTION') AS msg
2418: FROM po_supplier_item_capacity_gt CAP,
2419: po_approved_supplier_list_gt ASL
2420: WHERE ASL.user_key = CAP.user_key
2421: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2422: AND CAP.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2423:
2424: UNION ALL
2425: --Reject records if ASL Process action is create and tolerance's process

Line 2422: AND CAP.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

2418: FROM po_supplier_item_capacity_gt CAP,
2419: po_approved_supplier_list_gt ASL
2420: WHERE ASL.user_key = CAP.user_key
2421: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2422: AND CAP.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2423:
2424: UNION ALL
2425: --Reject records if ASL Process action is create and tolerance's process
2426: --action is delete/update

Line 2433: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

2429: fnd_message.get_string('PO','INVALID_TOL_ACTION') AS msg
2430: FROM po_supplier_item_tolerance_gt TOL,
2431: po_approved_supplier_list_gt ASL
2432: WHERE ASL.user_key = TOL.user_key
2433: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2434: AND TOL.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2435: );
2436:
2437: l_progress := 20;

Line 2434: AND TOL.process_action <> PO_ASL_API_PUB.g_ACTION_ADD

2430: FROM po_supplier_item_tolerance_gt TOL,
2431: po_approved_supplier_list_gt ASL
2432: WHERE ASL.user_key = TOL.user_key
2433: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2434: AND TOL.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2435: );
2436:
2437: l_progress := 20;
2438: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 2507: (PO_ASL_API_PUB.g_ACTION_ADD ,

2503: 'po_asl_documents_gt' AS entity ,
2504: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2505: FROM po_asl_documents_gt
2506: WHERE process_action NOT IN
2507: (PO_ASL_API_PUB.g_ACTION_ADD ,
2508: PO_ASL_API_PUB.g_ACTION_UPDATE,
2509: PO_ASL_API_PUB.g_ACTION_DELETE)
2510: OR process_action IS NULL
2511:

Line 2508: PO_ASL_API_PUB.g_ACTION_UPDATE,

2504: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2505: FROM po_asl_documents_gt
2506: WHERE process_action NOT IN
2507: (PO_ASL_API_PUB.g_ACTION_ADD ,
2508: PO_ASL_API_PUB.g_ACTION_UPDATE,
2509: PO_ASL_API_PUB.g_ACTION_DELETE)
2510: OR process_action IS NULL
2511:
2512: UNION

Line 2509: PO_ASL_API_PUB.g_ACTION_DELETE)

2505: FROM po_asl_documents_gt
2506: WHERE process_action NOT IN
2507: (PO_ASL_API_PUB.g_ACTION_ADD ,
2508: PO_ASL_API_PUB.g_ACTION_UPDATE,
2509: PO_ASL_API_PUB.g_ACTION_DELETE)
2510: OR process_action IS NULL
2511:
2512: UNION
2513:

Line 2519: (PO_ASL_API_PUB.g_ACTION_ADD ,

2515: 'chv_authorizations_gt' AS entity ,
2516: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2517: FROM chv_authorizations_gt
2518: WHERE process_action NOT IN
2519: (PO_ASL_API_PUB.g_ACTION_ADD ,
2520: PO_ASL_API_PUB.g_ACTION_UPDATE,
2521: PO_ASL_API_PUB.g_ACTION_DELETE)
2522: OR process_action IS NULL
2523:

Line 2520: PO_ASL_API_PUB.g_ACTION_UPDATE,

2516: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2517: FROM chv_authorizations_gt
2518: WHERE process_action NOT IN
2519: (PO_ASL_API_PUB.g_ACTION_ADD ,
2520: PO_ASL_API_PUB.g_ACTION_UPDATE,
2521: PO_ASL_API_PUB.g_ACTION_DELETE)
2522: OR process_action IS NULL
2523:
2524: UNION

Line 2521: PO_ASL_API_PUB.g_ACTION_DELETE)

2517: FROM chv_authorizations_gt
2518: WHERE process_action NOT IN
2519: (PO_ASL_API_PUB.g_ACTION_ADD ,
2520: PO_ASL_API_PUB.g_ACTION_UPDATE,
2521: PO_ASL_API_PUB.g_ACTION_DELETE)
2522: OR process_action IS NULL
2523:
2524: UNION
2525:

Line 2531: (PO_ASL_API_PUB.g_ACTION_ADD ,

2527: 'po_supplier_item_capacity_gt' AS entity ,
2528: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2529: FROM po_supplier_item_capacity_gt
2530: WHERE process_action NOT IN
2531: (PO_ASL_API_PUB.g_ACTION_ADD ,
2532: PO_ASL_API_PUB.g_ACTION_UPDATE,
2533: PO_ASL_API_PUB.g_ACTION_DELETE)
2534: OR process_action IS NULL
2535:

Line 2532: PO_ASL_API_PUB.g_ACTION_UPDATE,

2528: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2529: FROM po_supplier_item_capacity_gt
2530: WHERE process_action NOT IN
2531: (PO_ASL_API_PUB.g_ACTION_ADD ,
2532: PO_ASL_API_PUB.g_ACTION_UPDATE,
2533: PO_ASL_API_PUB.g_ACTION_DELETE)
2534: OR process_action IS NULL
2535:
2536: UNION

Line 2533: PO_ASL_API_PUB.g_ACTION_DELETE)

2529: FROM po_supplier_item_capacity_gt
2530: WHERE process_action NOT IN
2531: (PO_ASL_API_PUB.g_ACTION_ADD ,
2532: PO_ASL_API_PUB.g_ACTION_UPDATE,
2533: PO_ASL_API_PUB.g_ACTION_DELETE)
2534: OR process_action IS NULL
2535:
2536: UNION
2537:

Line 2543: (PO_ASL_API_PUB.g_ACTION_ADD ,

2539: 'po_supplier_item_tolerance_gt' AS entity ,
2540: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2541: FROM po_supplier_item_tolerance_gt
2542: WHERE process_action NOT IN
2543: (PO_ASL_API_PUB.g_ACTION_ADD ,
2544: PO_ASL_API_PUB.g_ACTION_UPDATE,
2545: PO_ASL_API_PUB.g_ACTION_DELETE)
2546: OR process_action IS NULL
2547: );

Line 2544: PO_ASL_API_PUB.g_ACTION_UPDATE,

2540: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2541: FROM po_supplier_item_tolerance_gt
2542: WHERE process_action NOT IN
2543: (PO_ASL_API_PUB.g_ACTION_ADD ,
2544: PO_ASL_API_PUB.g_ACTION_UPDATE,
2545: PO_ASL_API_PUB.g_ACTION_DELETE)
2546: OR process_action IS NULL
2547: );
2548: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 2545: PO_ASL_API_PUB.g_ACTION_DELETE)

2541: FROM po_supplier_item_tolerance_gt
2542: WHERE process_action NOT IN
2543: (PO_ASL_API_PUB.g_ACTION_ADD ,
2544: PO_ASL_API_PUB.g_ACTION_UPDATE,
2545: PO_ASL_API_PUB.g_ACTION_DELETE)
2546: OR process_action IS NULL
2547: );
2548: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
2549: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;

Line 3039: END po_asl_api_pub;

3035: RETURN NULL;
3036:
3037: END get_doc_line_id;
3038:
3039: END po_asl_api_pub;