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 266: po_message_s.sql_error('val_reqs_oe_shipment', X_progress, sqlcode);

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

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

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

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

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

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

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

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

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

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

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

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

596: EXCEPTION
597:
598: WHEN OTHERS THEN
599: X_req_control_error_rc := 'Y';
600: po_message_s.sql_error('update_reqs_lines_status', X_progress, sqlcode);
601: RAISE;
602:
603: END update_reqs_lines_status;
604:

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

770: l_return_status := FND_API.g_ret_sts_success;
771: END IF;
772:
773: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: po_message_s.sql_error('remove_req_from_po', x_progress, l_msg_data);
775: END IF;
776:
777: END LOOP;
778: --

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

779:
780: EXCEPTION
781: WHEN OTHERS THEN
782: -- dbms_output.put_line('In exception');
783: po_message_s.sql_error('remove_req_from_po', x_progress, sqlcode);
784:
785: END remove_req_from_po;
786:
787:

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

907:
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: po_message_s.sql_error('val_dest_details', x_progress, sqlcode);
912: RAISE;
913:
914: END val_dest_details;
915:

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

980: END IF;
981:
982: exception
983: when others then
984: po_message_s.sql_error('val_src_type',x_progress,sqlcode);
985: raise;
986:
987: end val_src_type;
988:

Line 1072: po_message_s.sql_error('update_transferred_to_oe_flag',

1068:
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: -- dbms_output.put_line('In exception');
1072: po_message_s.sql_error('update_transferred_to_oe_flag',
1073: x_progress, sqlcode);
1074: raise;
1075: END update_transferred_to_oe_flag;
1076:

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

1160: EXCEPTION
1161:
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: PO_MESSAGE_S.sql_error('UPDATE_REQS_IN_POOL_FLAG',x_progress,sqlcode);
1165:
1166: END update_reqs_in_pool_flag;
1167:
1168: --

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

1253:
1254: Else
1255: /* DEBUG - show error message */
1256: X_progress := '080';
1257: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1258: End If; /* If X_wsh_return */
1259:
1260: END LOOP;
1261:

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

1261:
1262: Else
1263: /* DEBUG - show error message */
1264: X_progress := '090';
1265: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1266:
1267: End If; /* If X_oe_return */
1268:
1269: /* Nothing stuck in mti */

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

1272:
1273: ELSE
1274: /* DEBUG - show error message */
1275: X_progress := '999';
1276: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1277: End IF; /* IF X_req_header_id */
1278:
1279: EXCEPTION
1280: WHEN OTHERS THEN

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

1277: End IF; /* IF X_req_header_id */
1278:
1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: po_message_s.sql_error('val_oe_shipment_in_proc', X_progress, sqlcode);
1282: RAISE;
1283:
1284: END val_oe_shipment_in_proc;
1285:

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

1320:
1321: ELSE
1322: /* DEBUG - show error message */
1323: X_progress := '015';
1324: po_message_s.sql_error('val_reqs_qty_received', X_progress, sqlcode);
1325: END IF;
1326:
1327: IF X_row_exists > 0 THEN
1328: RETURN (FALSE);

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

1331: END IF;
1332:
1333: EXCEPTION
1334: WHEN OTHERS THEN
1335: po_message_s.sql_error('val_reqs_qty_received', X_progress, sqlcode);
1336: RAISE;
1337:
1338: END val_reqs_qty_received;
1339: