APPS.PO_DISTRIBUTIONS_SV dependencies on PO_MESSAGE_S

Line 36: -- po_message_s.app_error('PO_PO_ENTER_UNIQUE_DIST_NUM');

32:
33: IF (l_is_unique) THEN
34: RETURN TRUE;
35: ELSE
36: -- po_message_s.app_error('PO_PO_ENTER_UNIQUE_DIST_NUM');
37: RETURN(FALSE);
38: END IF;
39:
40: EXCEPTION

Line 43: po_message_s.sql_error('check_unique', x_progress, sqlcode);

39:
40: EXCEPTION
41: WHEN OTHERS THEN
42: --dbms_output.put_line('In Exception');
43: po_message_s.sql_error('check_unique', x_progress, sqlcode);
44: RAISE;
45:
46: END check_unique;
47:

Line 111: PO_MESSAGE_S.sql_error('distribution_num_unique', l_progress, SQLCODE);

107: EXCEPTION
108: WHEN NO_DATA_FOUND THEN
109: RETURN FALSE;
110: WHEN OTHERS THEN
111: PO_MESSAGE_S.sql_error('distribution_num_unique', l_progress, SQLCODE);
112: RAISE;
113: END distribution_num_unique;
114: -- bug3322899 END
115:

Line 143: po_message_s.sql_error('get_max_dist_num', x_progress, sqlcode);

139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: --dbms_output.put_line('In Exception');
143: po_message_s.sql_error('get_max_dist_num', x_progress, sqlcode);
144: RAISE;
145: END get_max_dist_num;
146:
147:

Line 175: po_message_s.sql_error('select_summary', x_progress, sqlcode);

171:
172: EXCEPTION
173: WHEN OTHERS THEN
174: --dbms_output.put_line('In Exception');
175: po_message_s.sql_error('select_summary', x_progress, sqlcode);
176: RAISE;
177: END select_summary;
178:
179:

Line 358: po_message_s.sql_error('post_query', x_progress, sqlcode);

354:
355: EXCEPTION
356: WHEN OTHERS THEN
357: --dbms_output.put_line('In Exception');
358: po_message_s.sql_error('post_query', x_progress, sqlcode);
359: RAISE;
360: END post_query;
361:
362:

Line 387: po_message_s.sql_error('get_dest_type', x_progress, sqlcode);

383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: --dbms_output.put_line('In Exception');
387: po_message_s.sql_error('get_dest_type', x_progress, sqlcode);
388: RAISE;
389: END get_dest_type;
390:
391:

Line 444: po_message_s.sql_error('delete_distributions', x_progress, sqlcode);

440:
441: EXCEPTION
442: WHEN OTHERS THEN
443: --dbms_output.put_line('In Exception');
444: po_message_s.sql_error('delete_distributions', x_progress, sqlcode);
445: RAISE;
446: END delete_distributions;
447:
448: /*===========================================================================

Line 482: po_message_s.sql_error('get_total_dist_qty', X_progress, sqlcode);

478: FETCH C into X_total_quantity;
479: CLOSE C;
480: else
481: X_progress := '030';
482: po_message_s.sql_error('get_total_dist_qty', X_progress, sqlcode);
483: end if;
484: EXCEPTION
485: when others then
486: --dbms_output.put_line('In exception');

Line 487: po_message_s.sql_error('get_total_dist_qty', X_progress, sqlcode);

483: end if;
484: EXCEPTION
485: when others then
486: --dbms_output.put_line('In exception');
487: po_message_s.sql_error('get_total_dist_qty', X_progress, sqlcode);
488: END get_total_dist_qty;
489: /*===========================================================================
490: FUNCTION NAME: test_val_distribution_exists
491: ===========================================================================*/

Line 523: po_message_s.sql_error('val_distribution_exists', X_progress, sqlcode);

519: END IF;
520: EXCEPTION
521: when others then
522: --dbms_output.put_line('In exception');
523: po_message_s.sql_error('val_distribution_exists', X_progress, sqlcode);
524: END val_distribution_exists;
525:
526: /*===================================================================
527: