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 588: po_message_s.sql_error('CREATE_DOCUMENTS wrapper',l_progress,sqlcode);

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

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

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

Line 773: PO_MESSAGE_S.sql_error (routine => 'CREATE_DOCUMENTS_CLM',

769: IF g_debug_unexp THEN
770: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
771: p_progress => l_progress);
772: END IF;
773: PO_MESSAGE_S.sql_error (routine => 'CREATE_DOCUMENTS_CLM',
774: location => l_progress,
775: error_code => SQLCODE
776: );
777: RAISE;

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

1249: IF (l_org_context_changed = 'Y') THEN
1250: PO_MOAC_UTILS_PVT.set_org_context(l_original_operating_unit_id) ; --
1251: END IF;
1252: --
1253: po_message_s.sql_error('CREATE_DOCUMENTS',l_progress,sqlcode);
1254: raise;
1255: end;
1256: else
1257: if g_sourcing_errorcode =2 then

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

1368: PO_MOAC_UTILS_PVT.set_org_context(l_original_operating_unit_id) ; --
1369: END IF;
1370: --
1371:
1372: po_message_s.sql_error('CREATE_DOCUMENTS',l_progress,sqlcode);
1373:
1374: --
1375: --No need to raise as we are setting the return status and error msg
1376: --raise;

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

2965: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
2966: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
2967: p_progress => l_progress);
2968: END IF;
2969: po_message_s.sql_error('CREATE_PO',l_progress,sqlcode);
2970: if interface_cursor%isopen then
2971: CLOSE interface_cursor;
2972: end if;
2973: --togeorge 11/20/2001

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

3187: p_progress => l_progress
3188: );
3189: END IF;
3190: wrapup(interface.interface_header_id);
3191: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
3192: raise;
3193: END;
3194: ELSE
3195: l_requesting_ou_id := g_hdr_requesting_ou_id;

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

3476: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
3477: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3478: p_progress => l_progress);
3479: END IF;
3480: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
3481: wrapup(interface.interface_header_id);
3482: raise;
3483: END;
3484:

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

3600: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3601: p_progress => l_progress);
3602: END IF;
3603: wrapup(x_interface_header_id);
3604: po_message_s.sql_error('Get Item/Org defaults',l_progress,sqlcode);
3605: raise;
3606: end;
3607:
3608: l_progress := '160';

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

3650: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3651: p_progress => l_progress);
3652: END IF;
3653: wrapup(x_interface_header_id);
3654: po_message_s.sql_error('Get Item/Master org defaults',l_progress,sqlcode);
3655: raise;
3656: end;
3657: ELSE -- added by jbalakri for bug 2348729
3658: /* this case will reach when the item_id is null */

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

3694: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3695: p_progress => l_progress);
3696: END IF;
3697: wrapup(x_interface_header_id);
3698: po_message_s.sql_error('Get Line type default',l_progress,sqlcode);
3699: raise;
3700: end;
3701:
3702: l_progress := '180';

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

3727: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3728: p_progress => l_progress);
3729: END IF;
3730: wrapup(x_interface_header_id);
3731: po_message_s.sql_error('Get vendor default',l_progress,sqlcode);
3732: raise;
3733: End;
3734:
3735: l_progress := '190';

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

3766: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3767: p_progress => l_progress);
3768: END IF;
3769: wrapup(x_interface_header_id);
3770: po_message_s.sql_error('Get po system default',l_progress,sqlcode);
3771: raise;
3772: End;
3773: -- Bug: 1322342 If not defined at po system option level also then
3774:

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

4005: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
4006: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4007: p_progress => l_progress);
4008: END IF;
4009: po_message_s.sql_error('Get un number,hazard class defaults'
4010: ,l_progress, sqlcode);
4011: raise;
4012: end;
4013:

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

4023: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
4024: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4025: p_progress => l_progress);
4026: END IF;
4027: po_message_s.sql_error('Get UOM for amount based lines- defaults', l_progress, sqlcode);
4028: raise;
4029: end;
4030: else
4031: x_unit_of_measure :=interface.unit_meas_lookup_code;

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

4706: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4707: p_progress => l_progress);
4708: END IF;
4709: wrapup(x_interface_header_id);
4710: po_message_s.sql_error('Get Item/Org defaults',l_progress,sqlcode);
4711: raise;
4712: end;
4713: l_progress := '470';
4714: -- Bug: 1702702

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

4740: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4741: p_progress => l_progress);
4742: END IF;
4743: wrapup(x_interface_header_id);
4744: po_message_s.sql_error('Get Item/Master org defaults',l_progress,sqlcode);
4745: raise;
4746: end;
4747: ELSE -- added by jbalakri for bug 2348729
4748:

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

4777: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4778: p_progress => l_progress);
4779: END IF;
4780: wrapup(x_interface_header_id);
4781: po_message_s.sql_error('Get Line type default',l_progress,sqlcode);
4782: raise;
4783: end;
4784:
4785: l_progress := '490';

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

4810: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4811: p_progress => l_progress);
4812: END IF;
4813: wrapup(x_interface_header_id);
4814: po_message_s.sql_error('Get vendor default',l_progress,sqlcode);
4815: raise;
4816: End;
4817:
4818: l_progress := '500';

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

4849: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
4850: p_progress => l_progress);
4851: END IF;
4852: wrapup(x_interface_header_id);
4853: po_message_s.sql_error('Get po system default',l_progress,sqlcode);
4854: raise;
4855: End;
4856:
4857: l_progress := '510';

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

5637: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
5638: p_token => l_progress,
5639: p_message => 'Create_line : Inside No data found : Match blanket line is not N');
5640: END IF;
5641: po_message_s.sql_error('CREATE_LINE', l_progress,sqlcode);
5642: wrapup(x_interface_header_id);
5643: raise;
5644:
5645: END IF;

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

5645: END IF;
5646: --handle update_req_pool_fail exception
5647: --
5648: WHEN update_req_pool_fail then
5649: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
5650: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
5651: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
5652: p_token => l_progress,
5653: p_message => 'Create_documents: update_req_pool_fail exception : SQLCODE '||sqlcode);

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

5660: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5661: p_progress => l_progress);
5662: END IF;
5663: wrapup(x_interface_header_id);
5664: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
5665: raise;
5666:
5667: END create_line;
5668:

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

5841: IF g_debug_unexp THEN
5842: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5843: p_progress => l_progress);
5844: END IF;
5845: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
5846: wrapup(interface.interface_header_id);
5847: raise;
5848: END;
5849: END IF;

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

5891: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
5892: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5893: p_progress => l_progress);
5894: END IF;
5895: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
5896: wrapup(interface.interface_header_id);
5897: raise;
5898: END;
5899:

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

5972: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
5973: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
5974: p_progress => l_progress);
5975: END IF;
5976: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
5977: wrapup(interface.interface_header_id);
5978: raise;
5979: END;
5980:

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

6010: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
6011: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
6012: p_progress => l_progress);
6013: END IF;
6014: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
6015: wrapup(interface.interface_header_id);
6016: raise;
6017: END;
6018: END IF;

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

6244: 'N',
6245: x_return_code,
6246: 'Y') then
6247:
6248: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
6249:
6250: END IF;
6251: /* Bug 4016505 End */
6252: ELSE

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

6263: 'N',
6264: x_return_code,
6265: 'Y') then
6266:
6267: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
6268:
6269: END IF;
6270: /* Bug 4016505 End */
6271: END IF;

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

6290: 'N',
6291: x_return_code,
6292: 'Y') then
6293:
6294: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
6295:
6296: END IF;*/
6297: /*bug 12673501 ends*/
6298: END IF;

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

6324: 'N',
6325: x_return_code,
6326: 'N') then
6327:
6328: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
6329: END IF;
6330: /* Bug 4016505 End */
6331: ELSE
6332: x_doctype := 'PO';

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

6341: 'PO',
6342: 'N',
6343: x_return_code,
6344: 'N') then
6345: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
6346: END IF;
6347: /* Bug 4016505 End */
6348: END IF;
6349:

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

6360: 'N',
6361: x_return_code,
6362: 'N') then
6363:
6364: po_message_s.sql_error('CLOSE_PO',l_progress,sqlcode);
6365:
6366: END IF;*/
6367: /*bug 12673501 ends*/
6368: END IF;

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

7032: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7033: p_progress => l_progress);
7034: END IF;
7035: wrapup(interface.interface_header_id);
7036: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,sqlcode);
7037: raise;
7038: END create_shipment;
7039:
7040: /* ============================================================================

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

7286: IF g_debug_unexp THEN
7287: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7288: p_progress => l_progress);
7289: END IF;
7290: po_message_s.sql_error('CREATE_LINE',l_progress,sqlcode);
7291: wrapup(interface.interface_header_id);
7292: raise;
7293: END;
7294: END IF;

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

7332: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
7333: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7334: p_progress => l_progress);
7335: END IF;
7336: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,sqlcode);
7337: wrapup(interface.interface_header_id);
7338: raise;
7339: END;
7340:

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

7774: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
7775: p_progress => l_progress);
7776: END IF;
7777: wrapup(interface.interface_header_id);
7778: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,sqlcode);
7779: raise;
7780: END create_distributions;
7781:
7782:

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

8265: p_progress => l_progress);
8266: END IF;
8267: wrapup(x_interface_header_id);
8268:
8269: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);
8270: po_message_s.sql_show_error;
8271: po_message_s.clear;
8272: CLOSE interface_cursor;
8273: --togeorge 11/20/2001

Line 8270: po_message_s.sql_show_error;

8266: END IF;
8267: wrapup(x_interface_header_id);
8268:
8269: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);
8270: po_message_s.sql_show_error;
8271: po_message_s.clear;
8272: CLOSE interface_cursor;
8273: --togeorge 11/20/2001
8274: -- Bug 1349801

Line 8271: po_message_s.clear;

8267: wrapup(x_interface_header_id);
8268:
8269: po_message_s.sql_error('CREATE_RFQ',l_progress,sqlcode);
8270: po_message_s.sql_show_error;
8271: po_message_s.clear;
8272: CLOSE interface_cursor;
8273: --togeorge 11/20/2001
8274: -- Bug 1349801
8275: -- Added a Rollback when a Exception was raised

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

8364: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
8365: p_progress => l_progress);
8366: END IF;
8367: wrapup(interface.interface_header_id);
8368: po_message_s.sql_error('GET SYSTEM DEFAULTS',l_progress,sqlcode);
8369: raise;
8370:
8371: END get_system_defaults;
8372:

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

8434: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
8435: p_progress => l_progress);
8436: END IF;
8437: wrapup(interface.interface_header_id);
8438: po_message_s.sql_error('GET INVOICE MATCH OPTION',l_progress,sqlcode);
8439: raise;
8440:
8441: END get_invoice_match_option;
8442:

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

8987: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
8988: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
8989: p_progress => l_progress);
8990: END IF;
8991: PO_MESSAGE_S.sql_error(l_api_name, l_progress, sqlcode);
8992: RAISE;
8993: END generate_shared_proc_accounts; --)
8994: --< Shared Proc FPJ End >
8995:

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

10434: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
10435: p_progress => l_progress);
10436: END IF;
10437: wrapup(x_interface_header_id);
10438: po_message_s.sql_error('SETUP INTERFACE TABLES',l_progress,sqlcode);
10439: raise;
10440: END SETUP_INTERFACE_TABLES;
10441:
10442:

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

12308: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
12309: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
12310: p_progress => l_progress||'_main');
12311: END IF;
12312: po_message_s.sql_error('GROUP INTERFACE LINES',l_progress,sqlcode);
12313: wrapup(x_interface_header_id);
12314: raise;
12315: END group_interface_lines;
12316:

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

13460: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13461: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
13462: p_progress => l_progress);
13463: END IF;
13464: po_message_s.sql_error('get_shipment_num',l_progress,sqlcode);
13465: wrapup(x_interface_header_id);
13466: raise;
13467: END get_shipment_num;
13468:

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

13682: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13683: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
13684: p_progress => l_progress);
13685: END IF;
13686: po_message_s.sql_error('update_shipment',l_progress,sqlcode);
13687: wrapup(x_interface_header_id);
13688: raise;
13689:
13690: END update_shipment;

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

14162: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
14163: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
14164: p_progress => l_progress);
14165: END IF;
14166: po_message_s.sql_error('Exception of create_price_break()', l_progress,sqlcode);
14167: FND_MSG_PUB.Add;
14168: RAISE unexpected_create_pb_err;
14169: end;
14170:

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

14347: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
14348: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
14349: p_progress => l_progress);
14350: END IF;
14351: po_message_s.sql_error('Exception of create_price_break()', l_progress, sqlcode);
14352: FND_MSG_PUB.Add;
14353: RAISE unexpected_create_pb_err;
14354: end;
14355:

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

14863: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
14864: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
14865: p_progress => l_progress);
14866: END IF;
14867: po_message_s.sql_error('GET_RATE_FOR_REQ_PRICE',l_progress,sqlcode);
14868: END get_rate_for_req_price;
14869: --
14870:
14871: