DBA Data[Home] [Help]

APPS.PO_LINES_SV dependencies on PO_MESSAGE_S

Line 96: po_message_s.sql_error('document type is invalid', x_progress, sqlcode);

92: p_token_value => l_type_name);
93:
94: ELSE
95: x_progress:= '020';
96: po_message_s.sql_error('document type is invalid', x_progress, sqlcode);
97:
98: END IF;
99: END IF; --p_skip_validation = 'Y'
100: /*

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

128: EXCEPTION
129:
130: WHEN OTHERS THEN
131: --dbms_output.put_line('In exception');
132: po_message_s.sql_error('delete_line', x_progress, sqlcode);
133: raise;
134:
135:
136: END delete_line;

Line 198: po_message_s.sql_error('delete_all_lines', X_progress, sqlcode);

194:
195: EXCEPTION
196: WHEN OTHERS THEN
197: --dbms_output.put_line('In exception');
198: po_message_s.sql_error('delete_all_lines', X_progress, sqlcode);
199: raise;
200: END delete_all_lines;
201:
202: /*===========================================================================

Line 249: po_message_s.sql_error('delete_children', X_progress, sqlcode);

245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: --dbms_output.put_line('In exception');
249: po_message_s.sql_error('delete_children', X_progress, sqlcode);
250: raise;
251: END delete_children;
252: /*===========================================================================
253:

Line 429: po_message_s.sql_error('val_delete', x_progress, sqlcode);

425: -- There are no shipments for the given line
426: X_allow_delete := 'Y';
427:
428: WHEN OTHERS THEN
429: po_message_s.sql_error('val_delete', x_progress, sqlcode);
430: raise;
431: END check_line_deletion_allowed;
432:
433:

Line 507: po_message_s.app_error('PO_PO_USE_CANCEL_ON_ENCUMB_PO');

503: IF (l_some_dists_reserved_flag = 'N') THEN
504: x_allow_delete := 'Y';
505: ELSE
506: x_allow_delete := 'N';
507: po_message_s.app_error('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
508: END IF;
509: END IF;
510: --
511:

Line 515: po_message_s.app_error('PO_PO_USE_CANCEL_ON_APRVD_PO3',p_token,p_token_value);

511:
512:
513: ELSE
514: --Bug 3453216. Updated the message name and set the token values
515: po_message_s.app_error('PO_PO_USE_CANCEL_ON_APRVD_PO3',p_token,p_token_value);
516: END IF;
517:
518: --dbms_output.put_line('Allow delete = '||X_allow_delete);
519:

Line 528: po_message_s.sql_error('val_delete', x_progress, sqlcode);

524: X_allow_delete := 'Y';
525:
526: WHEN OTHERS THEN
527: --dbms_output.put_line('In VAL exception');
528: po_message_s.sql_error('val_delete', x_progress, sqlcode);
529: raise;
530: END val_line_delete;
531:
532: /*===========================================================================

Line 575: po_message_s.app_error('PO_PO_REL_EXCEEDS_QTY',

571: ** If the quantity ordered is less than the quantity released, a message
572: ** is displayed.
573: */
574: IF (X_ordered_lt_released = 'Y') THEN
575: po_message_s.app_error('PO_PO_REL_EXCEEDS_QTY',
576: 'SCHEDULED_QTY', TO_CHAR(X_quantity_released));
577: END IF;
578:
579: --dbms_output.put_line ('Ordered < Released = '||X_ordered_lt_released);

Line 584: po_message_s.sql_error('val_update', x_progress, sqlcode);

580: --dbms_output.put_line ('Quantity released = '||X_quantity_released);
581:
582: EXCEPTION
583: WHEN OTHERS THEN
584: po_message_s.sql_error('val_update', x_progress, sqlcode);
585: raise;
586: END val_update;
587:
588: /*===========================================================================

Line 1041: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);

1037: --dbms_output.put_line('No data found');
1038: null;
1039: WHEN OTHERS THEN
1040: --dbms_output.put_line('In Val Approval Status First exception');
1041: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);
1042: raise;
1043: END;
1044:
1045:

Line 1138: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);

1134: --dbms_output.put_line('No data found');
1135: return(TRUE);
1136: WHEN OTHERS THEN
1137: --dbms_output.put_line('In Val Approval Status exception');
1138: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);
1139: raise;
1140: END val_approval_status;
1141:
1142: /*===========================================================================

Line 1178: po_message_s.sql_error('update_released_quantity', x_progress, sqlcode);

1174: END IF;
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: po_message_s.sql_error('update_released_quantity', x_progress, sqlcode);
1179: raise;
1180: END update_released_quantity;
1181:
1182: END PO_LINES_SV;