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_INTERFACE_S dependencies on PO_MESSAGE_S

Line 592: po_message_s.sql_error('CREATE_DOCUMENTS wrapper',l_progress,sqlcode);

588: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
589: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
590: p_progress => l_progress);
591: END IF;
592: po_message_s.sql_error('CREATE_DOCUMENTS wrapper',l_progress,sqlcode);
593: raise;
594: END create_documents;
595: --
596:

Line 677: PO_MESSAGE_S.sql_error (routine => 'CREATE_DOCUMENTS',

673: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
674: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
675: p_progress => l_progress);
676: END IF;
677: PO_MESSAGE_S.sql_error (routine => 'CREATE_DOCUMENTS',
678: location => l_progress,
679: error_code => SQLCODE
680: );
681: RAISE;

Line 1059: po_message_s.sql_error('CREATE_DOCUMENTS',l_progress,sqlcode);

1055: IF (l_org_context_changed = 'Y') THEN
1056: PO_MOAC_UTILS_PVT.set_org_context(l_original_operating_unit_id) ; --
1057: END IF;
1058: --
1059: po_message_s.sql_error('CREATE_DOCUMENTS',l_progress,sqlcode);
1060: raise;
1061: end;
1062: else
1063: if g_sourcing_errorcode =2 then

Line 1178: po_message_s.sql_error('CREATE_DOCUMENTS',l_progress,sqlcode);

1174: PO_MOAC_UTILS_PVT.set_org_context(l_original_operating_unit_id) ; --
1175: END IF;
1176: --
1177:
1178: po_message_s.sql_error('CREATE_DOCUMENTS',l_progress,sqlcode);
1179:
1180: --
1181: --No need to raise as we are setting the return status and error msg
1182: --raise;

Line 2636: po_message_s.sql_error('CREATE_PO',l_progress,sqlcode);

2632: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
2633: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
2634: p_progress => l_progress);
2635: END IF;
2636: po_message_s.sql_error('CREATE_PO',l_progress,sqlcode);
2637: if interface_cursor%isopen then
2638: CLOSE interface_cursor;
2639: end if;
2640: --togeorge 11/20/2001

Line 2848: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);

2844: p_progress => l_progress
2845: );
2846: END IF;
2847: wrapup(interface.interface_header_id);
2848: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
2849: raise;
2850: END;
2851: ELSE
2852: l_requesting_ou_id := g_hdr_requesting_ou_id;

Line 3136: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);

3132: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
3133: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3134: p_progress => l_progress);
3135: END IF;
3136: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
3137: wrapup(interface.interface_header_id);
3138: raise;
3139: END;
3140:

Line 3240: po_message_s.sql_error('Get Item/Org defaults',l_progress,sqlcode);

3236: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3237: p_progress => l_progress);
3238: END IF;
3239: wrapup(x_interface_header_id);
3240: po_message_s.sql_error('Get Item/Org defaults',l_progress,sqlcode);
3241: raise;
3242: end;
3243:
3244: l_progress := '160';

Line 3290: po_message_s.sql_error('Get Item/Master org defaults',l_progress,sqlcode);

3286: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3287: p_progress => l_progress);
3288: END IF;
3289: wrapup(x_interface_header_id);
3290: po_message_s.sql_error('Get Item/Master org defaults',l_progress,sqlcode);
3291: raise;
3292: end;
3293: ELSE -- added by jbalakri for bug 2348729
3294: /* this case will reach when the item_id is null */

Line 3334: po_message_s.sql_error('Get Line type default',l_progress,sqlcode);

3330: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3331: p_progress => l_progress);
3332: END IF;
3333: wrapup(x_interface_header_id);
3334: po_message_s.sql_error('Get Line type default',l_progress,sqlcode);
3335: raise;
3336: end;
3337:
3338: l_progress := '180';

Line 3367: po_message_s.sql_error('Get vendor default',l_progress,sqlcode);

3363: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3364: p_progress => l_progress);
3365: END IF;
3366: wrapup(x_interface_header_id);
3367: po_message_s.sql_error('Get vendor default',l_progress,sqlcode);
3368: raise;
3369: End;
3370:
3371: l_progress := '190';

Line 3406: po_message_s.sql_error('Get po system default',l_progress,sqlcode);

3402: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3403: p_progress => l_progress);
3404: END IF;
3405: wrapup(x_interface_header_id);
3406: po_message_s.sql_error('Get po system default',l_progress,sqlcode);
3407: raise;
3408: End;
3409: -- Bug: 1322342 If not defined at po system option level also then
3410:

Line 3643: po_message_s.sql_error('Get un number,hazard class defaults'

3639: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
3640: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3641: p_progress => l_progress);
3642: END IF;
3643: po_message_s.sql_error('Get un number,hazard class defaults'
3644: ,l_progress, sqlcode);
3645: raise;
3646: end;
3647:

Line 3661: po_message_s.sql_error('Get UOM for amount based lines- defaults', l_progress, sqlcode);

3657: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
3658: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3659: p_progress => l_progress);
3660: END IF;
3661: po_message_s.sql_error('Get UOM for amount based lines- defaults', l_progress, sqlcode);
3662: raise;
3663: end;
3664: else
3665: x_unit_of_measure :=interface.unit_meas_lookup_code;

Line 4283: po_message_s.sql_error('Get Item/Org defaults',l_progress,sqlcode);

4279: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4280: p_progress => l_progress);
4281: END IF;
4282: wrapup(x_interface_header_id);
4283: po_message_s.sql_error('Get Item/Org defaults',l_progress,sqlcode);
4284: raise;
4285: end;
4286: l_progress := '470';
4287: -- Bug: 1702702

Line 4317: po_message_s.sql_error('Get Item/Master org defaults',l_progress,sqlcode);

4313: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4314: p_progress => l_progress);
4315: END IF;
4316: wrapup(x_interface_header_id);
4317: po_message_s.sql_error('Get Item/Master org defaults',l_progress,sqlcode);
4318: raise;
4319: end;
4320: ELSE -- added by jbalakri for bug 2348729
4321:

Line 4354: po_message_s.sql_error('Get Line type default',l_progress,sqlcode);

4350: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4351: p_progress => l_progress);
4352: END IF;
4353: wrapup(x_interface_header_id);
4354: po_message_s.sql_error('Get Line type default',l_progress,sqlcode);
4355: raise;
4356: end;
4357:
4358: l_progress := '490';

Line 4387: po_message_s.sql_error('Get vendor default',l_progress,sqlcode);

4383: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4384: p_progress => l_progress);
4385: END IF;
4386: wrapup(x_interface_header_id);
4387: po_message_s.sql_error('Get vendor default',l_progress,sqlcode);
4388: raise;
4389: End;
4390:
4391: l_progress := '500';

Line 4426: po_message_s.sql_error('Get po system default',l_progress,sqlcode);

4422: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4423: p_progress => l_progress);
4424: END IF;
4425: wrapup(x_interface_header_id);
4426: po_message_s.sql_error('Get po system default',l_progress,sqlcode);
4427: raise;
4428: End;
4429:
4430: l_progress := '510';

Line 5181: po_message_s.sql_error('CREATE_LINE', l_progress,sqlcode);

5177: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
5178: p_token => l_progress,
5179: p_message => 'Create_line : Inside No data found : Match blanket line is not N');
5180: END IF;
5181: po_message_s.sql_error('CREATE_LINE', l_progress,sqlcode);
5182: wrapup(x_interface_header_id);
5183: raise;
5184:
5185: END IF;

Line 5189: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);

5185: END IF;
5186: --handle update_req_pool_fail exception
5187: --
5188: WHEN update_req_pool_fail then
5189: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
5190: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
5191: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
5192: p_token => l_progress,
5193: p_message => 'Create_documents: update_req_pool_fail exception : SQLCODE '||sqlcode);

Line 5204: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);

5200: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5201: p_progress => l_progress);
5202: END IF;
5203: wrapup(x_interface_header_id);
5204: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
5205: raise;
5206:
5207: END create_line;
5208:

Line 5368: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);

5364: IF g_debug_unexp THEN
5365: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5366: p_progress => l_progress);
5367: END IF;
5368: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
5369: wrapup(interface.interface_header_id);
5370: raise;
5371: END;
5372: END IF;

Line 5418: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);

5414: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
5415: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5416: p_progress => l_progress);
5417: END IF;
5418: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
5419: wrapup(interface.interface_header_id);
5420: raise;
5421: END;
5422:

Line 5499: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);

5495: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
5496: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5497: p_progress => l_progress);
5498: END IF;
5499: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
5500: wrapup(interface.interface_header_id);
5501: raise;
5502: END;
5503:

Line 5537: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);

5533: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
5534: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5535: p_progress => l_progress);
5536: END IF;
5537: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
5538: wrapup(interface.interface_header_id);
5539: raise;
5540: END;
5541: END IF;

Line 5751: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);

5747: 'N',
5748: x_return_code,
5749: 'Y') then
5750:
5751: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
5752:
5753: END IF;
5754: /* Bug 4016505 End */
5755: ELSE

Line 5770: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);

5766: 'N',
5767: x_return_code,
5768: 'Y') then
5769:
5770: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
5771:
5772: END IF;
5773: /* Bug 4016505 End */
5774: END IF;

Line 5795: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);

5791: 'N',
5792: x_return_code,
5793: 'Y') then
5794:
5795: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
5796:
5797: END IF;
5798:
5799: END IF;

Line 5829: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);

5825: 'N',
5826: x_return_code,
5827: 'N') then
5828:
5829: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
5830: END IF;
5831: /* Bug 4016505 End */
5832: ELSE
5833: x_doctype := 'PO';

Line 5846: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);

5842: 'PO',
5843: 'N',
5844: x_return_code,
5845: 'N') then
5846: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
5847: END IF;
5848: /* Bug 4016505 End */
5849: END IF;
5850:

Line 5864: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);

5860: 'N',
5861: x_return_code,
5862: 'N') then
5863:
5864: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
5865:
5866: END IF;
5867:
5868: END IF;

Line 6458: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);

6454: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
6455: p_progress => l_progress);
6456: END IF;
6457: wrapup(interface.interface_header_id);
6458: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
6459: raise;
6460: END create_shipment;
6461:
6462: /* ============================================================================

Line 6712: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);

6708: IF g_debug_unexp THEN
6709: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
6710: p_progress => l_progress);
6711: END IF;
6712: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
6713: wrapup(interface.interface_header_id);
6714: raise;
6715: END;
6716: END IF;

Line 6758: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,sqlcode);

6754: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
6755: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
6756: p_progress => l_progress);
6757: END IF;
6758: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,sqlcode);
6759: wrapup(interface.interface_header_id);
6760: raise;
6761: END;
6762:

Line 7183: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,sqlcode);

7179: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7180: p_progress => l_progress);
7181: END IF;
7182: wrapup(interface.interface_header_id);
7183: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,sqlcode);
7184: raise;
7185: END create_distributions;
7186:
7187:

Line 7662: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);

7658: p_progress => l_progress);
7659: END IF;
7660: wrapup(x_interface_header_id);
7661:
7662: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);
7663: po_message_s.sql_show_error;
7664: po_message_s.clear;
7665: CLOSE interface_cursor;
7666: --togeorge 11/20/2001

Line 7663: po_message_s.sql_show_error;

7659: END IF;
7660: wrapup(x_interface_header_id);
7661:
7662: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);
7663: po_message_s.sql_show_error;
7664: po_message_s.clear;
7665: CLOSE interface_cursor;
7666: --togeorge 11/20/2001
7667: -- Bug 1349801

Line 7664: po_message_s.clear;

7660: wrapup(x_interface_header_id);
7661:
7662: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);
7663: po_message_s.sql_show_error;
7664: po_message_s.clear;
7665: CLOSE interface_cursor;
7666: --togeorge 11/20/2001
7667: -- Bug 1349801
7668: -- Added a Rollback when a Exception was raised

Line 7761: po_message_s.sql_error('GET SYSTEM DEFAULTS',l_progress,sqlcode);

7757: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7758: p_progress => l_progress);
7759: END IF;
7760: wrapup(interface.interface_header_id);
7761: po_message_s.sql_error('GET SYSTEM DEFAULTS',l_progress,sqlcode);
7762: raise;
7763:
7764: END get_system_defaults;
7765:

Line 7831: po_message_s.sql_error('GET INVOICE MATCH OPTION',l_progress,sqlcode);

7827: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7828: p_progress => l_progress);
7829: END IF;
7830: wrapup(interface.interface_header_id);
7831: po_message_s.sql_error('GET INVOICE MATCH OPTION',l_progress,sqlcode);
7832: raise;
7833:
7834: END get_invoice_match_option;
7835:

Line 8384: PO_MESSAGE_S.sql_error(l_api_name, l_progress, sqlcode);

8380: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
8381: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
8382: p_progress => l_progress);
8383: END IF;
8384: PO_MESSAGE_S.sql_error(l_api_name, l_progress, sqlcode);
8385: RAISE;
8386: END generate_shared_proc_accounts; --)
8387: --< Shared Proc FPJ End >
8388:

Line 9808: po_message_s.sql_error('SETUP INTERFACE TABLES',l_progress,sqlcode);

9804: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
9805: p_progress => l_progress);
9806: END IF;
9807: wrapup(x_interface_header_id);
9808: po_message_s.sql_error('SETUP INTERFACE TABLES',l_progress,sqlcode);
9809: raise;
9810: END SETUP_INTERFACE_TABLES;
9811:
9812:

Line 11671: po_message_s.sql_error('GROUP INTERFACE LINES',l_progress,sqlcode);

11667: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
11668: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
11669: p_progress => l_progress||'_main');
11670: END IF;
11671: po_message_s.sql_error('GROUP INTERFACE LINES',l_progress,sqlcode);
11672: wrapup(x_interface_header_id);
11673: raise;
11674: END group_interface_lines;
11675:

Line 12706: po_message_s.sql_error('get_shipment_num',l_progress,sqlcode);

12702: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
12703: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
12704: p_progress => l_progress);
12705: END IF;
12706: po_message_s.sql_error('get_shipment_num',l_progress,sqlcode);
12707: wrapup(x_interface_header_id);
12708: raise;
12709: END get_shipment_num;
12710:

Line 12928: po_message_s.sql_error('update_shipment',l_progress,sqlcode);

12924: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
12925: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
12926: p_progress => l_progress);
12927: END IF;
12928: po_message_s.sql_error('update_shipment',l_progress,sqlcode);
12929: wrapup(x_interface_header_id);
12930: raise;
12931:
12932: END update_shipment;

Line 13264: po_message_s.sql_error('Exception of create_price_break()', l_progress,sqlcode);

13260: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13261: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
13262: p_progress => l_progress);
13263: END IF;
13264: po_message_s.sql_error('Exception of create_price_break()', l_progress,sqlcode);
13265: FND_MSG_PUB.Add;
13266: RAISE unexpected_create_pb_err;
13267: end;
13268:

Line 13449: po_message_s.sql_error('Exception of create_price_break()', l_progress, sqlcode);

13445: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13446: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
13447: p_progress => l_progress);
13448: END IF;
13449: po_message_s.sql_error('Exception of create_price_break()', l_progress, sqlcode);
13450: FND_MSG_PUB.Add;
13451: RAISE unexpected_create_pb_err;
13452: end;
13453:

Line 13961: po_message_s.sql_error('GET_RATE_FOR_REQ_PRICE',l_progress,sqlcode);

13957: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13958: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
13959: p_progress => l_progress);
13960: END IF;
13961: po_message_s.sql_error('GET_RATE_FOR_REQ_PRICE',l_progress,sqlcode);
13962: END get_rate_for_req_price;
13963: --
13964:
13965: