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

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

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

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

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

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

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

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

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

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

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

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