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

Line 40: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');

36: CLOSE C;
37:
38: EXCEPTION
39: WHEN app_exception.record_lock_exception THEN
40: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');
41:
42: WHEN OTHERS THEN
43: -- dbms_output.put_line('In Exception');
44: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_BUYER_UPDATE', x_progress, sqlcode);

Line 44: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_BUYER_UPDATE', x_progress, sqlcode);

40: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');
41:
42: WHEN OTHERS THEN
43: -- dbms_output.put_line('In Exception');
44: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_BUYER_UPDATE', x_progress, sqlcode);
45: RAISE;
46: END;
47:
48:

Line 100: po_message_s.sql_error('delete_line', x_progress, sqlcode);

96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: -- dbms_output.put_line('In exception');
100: po_message_s.sql_error('delete_line', x_progress, sqlcode);
101: raise;
102: END delete_line;
103:
104: /*===========================================================================

Line 135: po_message_s.sql_error('delete_children', x_progress, sqlcode);

131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: -- dbms_output.put_line('In exception');
135: po_message_s.sql_error('delete_children', x_progress, sqlcode);
136: raise;
137: END delete_children;
138:
139:

Line 181: po_message_s.sql_error('val_reqs_po_shipment', X_progress, sqlcode);

177: AND nvl(POLL.cancel_flag, 'N') = 'N');
178: ELSE
179: /* DEBUG - show error message */
180: X_progress := '015';
181: po_message_s.sql_error('val_reqs_po_shipment', X_progress, sqlcode);
182: END IF;
183:
184: IF X_row_exists > 0 THEN
185: RETURN (FALSE);

Line 194: po_message_s.sql_error('val_reqs_po_shipment', X_progress, sqlcode);

190: -- dbms_output.put_line('Exit val_reqs_po_shipment');
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: po_message_s.sql_error('val_reqs_po_shipment', X_progress, sqlcode);
195: RAISE;
196:
197: END val_reqs_po_shipment;
198:

Line 267: po_message_s.sql_error('val_reqs_oe_shipment', X_progress, sqlcode);

263: PORL.requisition_line_id ) > 0 ;
264: ELSE
265: /* DEBUG - show error message */
266: X_progress := '015';
267: po_message_s.sql_error('val_reqs_oe_shipment', X_progress, sqlcode);
268: END IF;
269:
270: IF X_row_exists > 0 THEN
271: RETURN (FALSE);

Line 295: po_message_s.sql_error('val_reqs_oe_shipment', X_progress, sqlcode);

291: -- dbms_output.put_line('Exit val_reqs_oe_shipment');
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: po_message_s.sql_error('val_reqs_oe_shipment', X_progress, sqlcode);
296: RAISE;
297:
298: END val_reqs_oe_shipment;
299:

Line 353: po_message_s.sql_error('val_reqs_qty_delivered', X_progress, sqlcode);

349: End Bug# 5414478*/
350: ELSE
351: /* DEBUG - show error message */
352: X_progress := '015';
353: po_message_s.sql_error('val_reqs_qty_delivered', X_progress, sqlcode);
354: END IF;
355:
356: IF X_row_exists > 0 THEN
357: RETURN (FALSE);

Line 366: po_message_s.sql_error('val_reqs_qty_delivered', X_progress, sqlcode);

362: -- dbms_output.put_line('Exit val_reqs_qty_delivered');
363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: po_message_s.sql_error('val_reqs_qty_delivered', X_progress, sqlcode);
367: RAISE;
368:
369: END val_reqs_qty_delivered;
370:

Line 448: po_message_s.sql_error('update_reqs_lines_incomplete', X_progress, sqlcode);

444: ELSE
445: /* DEBUG - show error message */
446: X_req_control_error_rc := 'Y';
447: X_progress := '015';
448: po_message_s.sql_error('update_reqs_lines_incomplete', X_progress, sqlcode);
449: END IF;
450:
451: -- dbms_output.put_line('Exit update_reqs_lines_incomplete');
452:

Line 457: po_message_s.sql_error('update_reqs_lines_incomplete', X_progress, sqlcode);

453: EXCEPTION
454:
455: WHEN OTHERS THEN
456: X_req_control_error_rc := 'Y';
457: po_message_s.sql_error('update_reqs_lines_incomplete', X_progress, sqlcode);
458: RAISE;
459:
460:
461: END update_reqs_lines_incomplete;

Line 679: po_message_s.sql_error('update_reqs_lines_status', X_progress, sqlcode);

675: EXCEPTION
676:
677: WHEN OTHERS THEN
678: X_req_control_error_rc := 'Y';
679: po_message_s.sql_error('update_reqs_lines_status', X_progress, sqlcode);
680: RAISE;
681:
682: END update_reqs_lines_status;
683:

Line 917: po_message_s.sql_error('remove_req_from_po', x_progress, l_msg_data);

913: l_return_status := FND_API.g_ret_sts_success;
914: END IF;
915:
916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
917: po_message_s.sql_error('remove_req_from_po', x_progress, l_msg_data);
918: END IF;
919:
920: END LOOP;
921: --

Line 925: po_message_s.sql_error('remove_req_from_po', x_progress, sqlcode);

921: --
922:
923: EXCEPTION
924: WHEN OTHERS THEN
925: po_message_s.sql_error('remove_req_from_po', x_progress, sqlcode);
926:
927: END remove_req_from_po;
928:
929:

Line 1053: po_message_s.sql_error('val_dest_details', x_progress, sqlcode);

1049:
1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: po_message_s.sql_error('val_dest_details', x_progress, sqlcode);
1054: RAISE;
1055:
1056: END val_dest_details;
1057:

Line 1126: po_message_s.sql_error('val_src_type',x_progress,sqlcode);

1122: END IF;
1123:
1124: exception
1125: when others then
1126: po_message_s.sql_error('val_src_type',x_progress,sqlcode);
1127: raise;
1128:
1129: end val_src_type;
1130:

Line 1214: po_message_s.sql_error('update_transferred_to_oe_flag',

1210:
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: -- dbms_output.put_line('In exception');
1214: po_message_s.sql_error('update_transferred_to_oe_flag',
1215: x_progress, sqlcode);
1216: raise;
1217: END update_transferred_to_oe_flag;
1218:

Line 1320: PO_MESSAGE_S.sql_error('UPDATE_REQS_IN_POOL_FLAG',x_progress,sqlcode);

1316: EXCEPTION
1317:
1318: WHEN OTHERS THEN
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1320: PO_MESSAGE_S.sql_error('UPDATE_REQS_IN_POOL_FLAG',x_progress,sqlcode);
1321:
1322: END update_reqs_in_pool_flag;
1323:
1324: --

Line 1413: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);

1409:
1410: Else
1411: /* DEBUG - show error message */
1412: X_progress := '080';
1413: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1414: End If; /* If X_wsh_return */
1415:
1416: END LOOP;
1417:

Line 1421: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);

1417:
1418: Else
1419: /* DEBUG - show error message */
1420: X_progress := '090';
1421: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1422:
1423: End If; /* If X_oe_return */
1424:
1425: /* Nothing stuck in mti */

Line 1432: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);

1428:
1429: ELSE
1430: /* DEBUG - show error message */
1431: X_progress := '999';
1432: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1433: End IF; /* IF X_req_header_id */
1434:
1435: EXCEPTION
1436: WHEN OTHERS THEN

Line 1437: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);

1433: End IF; /* IF X_req_header_id */
1434:
1435: EXCEPTION
1436: WHEN OTHERS THEN
1437: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1438: RAISE;
1439:
1440: END val_oe_shipment_in_proc;
1441:

Line 1480: po_message_s.sql_error('val_reqs_qty_received', X_progress, sqlcode);

1476:
1477: ELSE
1478: /* DEBUG - show error message */
1479: X_progress := '015';
1480: po_message_s.sql_error('val_reqs_qty_received', X_progress, sqlcode);
1481: END IF;
1482:
1483: IF X_row_exists > 0 THEN
1484: RETURN (FALSE);

Line 1491: po_message_s.sql_error('val_reqs_qty_received', X_progress, sqlcode);

1487: END IF;
1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: po_message_s.sql_error('val_reqs_qty_received', X_progress, sqlcode);
1492: RAISE;
1493:
1494: END val_reqs_qty_received;
1495:

Line 1879: PO_MESSAGE_S.add_exc_msg

1875:
1876: EXCEPTION WHEN OTHERS THEN
1877:
1878: RAISE;
1879: PO_MESSAGE_S.add_exc_msg
1880: ( p_pkg_name => 'PO_REQ_LINES_SV',
1881: p_procedure_name => 'update_req_for_linked_po_count' || '.' || x_progress
1882: );
1883:

Line 2057: PO_MESSAGE_S.add_exc_msg

2053:
2054: EXCEPTION WHEN OTHERS THEN
2055:
2056: x_progress := 100;
2057: PO_MESSAGE_S.add_exc_msg
2058: ( p_pkg_name => 'PO_REQ_LINES_SV',
2059: p_procedure_name => 'update_reqs_in_pool_flag' || '.' || x_progress
2060: );
2061: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';