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 139: po_message_s.sql_error('delete_line', x_progress, sqlcode);

135: EXCEPTION
136:
137: WHEN OTHERS THEN
138: --dbms_output.put_line('In exception');
139: po_message_s.sql_error('delete_line', x_progress, sqlcode);
140: raise;
141:
142:
143: END delete_line;

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

219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: --dbms_output.put_line('In exception');
223: po_message_s.sql_error('delete_all_lines', X_progress, sqlcode);
224: raise;
225: END delete_all_lines;
226:
227: /*===========================================================================

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

285:
286: EXCEPTION
287: WHEN OTHERS THEN
288: --dbms_output.put_line('In exception');
289: po_message_s.sql_error('delete_children', X_progress, sqlcode);
290: raise;
291: END delete_children;
292: /*===========================================================================
293:

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

465: -- There are no shipments for the given line
466: X_allow_delete := 'Y';
467:
468: WHEN OTHERS THEN
469: po_message_s.sql_error('val_delete', x_progress, sqlcode);
470: raise;
471: END check_line_deletion_allowed;
472:
473:

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

534: FROM po_lines_all pol
535: WHERE pol.from_line_id = X_po_line_id ;
536:
537: IF ( X_allow_delete = 'N' ) THEN
538: po_message_s.app_error('PO_PO_USE_CANCEL_ON_APRVD_PO3',p_token,p_token_value);
539: RETURN ;
540: END IF ;
541: END IF;
542:

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

557: IF (l_some_dists_reserved_flag = 'N') THEN
558: x_allow_delete := 'Y';
559: ELSE
560: x_allow_delete := 'N';
561: po_message_s.app_error('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
562: END IF;
563: END IF;
564: --
565:

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

565:
566:
567: ELSE
568: --Bug 3453216. Updated the message name and set the token values
569: po_message_s.app_error('PO_PO_USE_CANCEL_ON_APRVD_PO3',p_token,p_token_value);
570: END IF;
571:
572: --dbms_output.put_line('Allow delete = '||X_allow_delete);
573:

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

578: X_allow_delete := 'Y';
579:
580: WHEN OTHERS THEN
581: --dbms_output.put_line('In VAL exception');
582: po_message_s.sql_error('val_delete', x_progress, sqlcode);
583: raise;
584: END val_line_delete;
585:
586: /*===========================================================================

Line 629: po_message_s.app_error('PO_PO_REL_EXCEEDS_QTY',

625: ** If the quantity ordered is less than the quantity released, a message
626: ** is displayed.
627: */
628: IF (X_ordered_lt_released = 'Y') THEN
629: po_message_s.app_error('PO_PO_REL_EXCEEDS_QTY',
630: 'SCHEDULED_QTY', TO_CHAR(X_quantity_released));
631: END IF;
632:
633: --dbms_output.put_line ('Ordered < Released = '||X_ordered_lt_released);

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

634: --dbms_output.put_line ('Quantity released = '||X_quantity_released);
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: po_message_s.sql_error('val_update', x_progress, sqlcode);
639: raise;
640: END val_update;
641:
642: /*===========================================================================

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

1091: --dbms_output.put_line('No data found');
1092: null;
1093: WHEN OTHERS THEN
1094: --dbms_output.put_line('In Val Approval Status First exception');
1095: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);
1096: raise;
1097: END;
1098:
1099:

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

1188: --dbms_output.put_line('No data found');
1189: return(TRUE);
1190: WHEN OTHERS THEN
1191: --dbms_output.put_line('In Val Approval Status exception');
1192: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);
1193: raise;
1194: END val_approval_status;
1195:
1196: /*===========================================================================

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

1229: END IF;
1230:
1231: EXCEPTION
1232: WHEN OTHERS THEN
1233: po_message_s.sql_error('update_released_quantity', x_progress, sqlcode);
1234: raise;
1235: END update_released_quantity;
1236:
1237: END PO_LINES_SV;