DBA Data[Home] [Help]

APPS.POS_COMPARE_REVISIONS dependencies on PO_MESSAGE_S

Line 45: PO_MESSAGE_S.SQL_ERROR(

41: COMMIT;
42:
43: EXCEPTION
44: WHEN others THEN
45: PO_MESSAGE_S.SQL_ERROR(
46: 'PO_COMPARE_REVISIONS.PURGE',
47: v_progress,
48: sqlcode );
49: RAISE;

Line 94: PO_MESSAGE_S.SQL_ERROR(

90: EXCEPTION
91: WHEN no_data_found THEN
92: RETURN NULL;
93: WHEN others THEN
94: PO_MESSAGE_S.SQL_ERROR(
95: 'PO_COMPARE_REVISIONS.GET_UN_NUMBER',
96: v_progress,
97: sqlcode );
98: RAISE;

Line 151: PO_MESSAGE_S.SQL_ERROR(

147: EXCEPTION
148: WHEN no_data_found THEN
149: RETURN NULL;
150: WHEN others THEN
151: PO_MESSAGE_S.SQL_ERROR(
152: 'PO_COMPARE_REVISIONS.GET_ITEM_NUMBER',
153: v_progress,
154: sqlcode );
155: RAISE;

Line 200: PO_MESSAGE_S.SQL_ERROR(

196: EXCEPTION
197: WHEN no_data_found THEN
198: RETURN NULL;
199: WHEN others THEN
200: PO_MESSAGE_S.SQL_ERROR(
201: 'PO_COMPARE_REVISIONS.GET_HAZARD_CLASS',
202: v_progress,
203: sqlcode );
204: RAISE;

Line 249: PO_MESSAGE_S.SQL_ERROR(

245: EXCEPTION
246: WHEN no_data_found THEN
247: RETURN NULL;
248: WHEN others THEN
249: PO_MESSAGE_S.SQL_ERROR(
250: 'PO_COMPARE_REVISIONS.GET_AP_TERMS',
251: v_progress,
252: sqlcode );
253: RAISE;

Line 302: PO_MESSAGE_S.SQL_ERROR(

298: EXCEPTION
299: WHEN no_data_found THEN
300: RETURN NULL;
301: WHEN others THEN
302: PO_MESSAGE_S.SQL_ERROR(
303: 'PO_COMPARE_REVISIONS.GET_BUYER',
304: v_progress,
305: sqlcode );
306: RAISE;

Line 359: PO_MESSAGE_S.SQL_ERROR(

355: EXCEPTION
356: WHEN no_data_found THEN
357: RETURN NULL;
358: WHEN others THEN
359: PO_MESSAGE_S.SQL_ERROR(
360: 'PO_COMPARE_REVISIONS.GET_ORG_NAME',
361: v_progress,
362: sqlcode );
363: RAISE;

Line 414: PO_MESSAGE_S.SQL_ERROR(

410: EXCEPTION
411: WHEN no_data_found THEN
412: RETURN NULL;
413: WHEN others THEN
414: PO_MESSAGE_S.SQL_ERROR(
415: 'PO_COMPARE_REVISIONS.GET_VENDOR_CONTACT',
416: v_progress,
417: sqlcode );
418: RAISE;

Line 464: PO_MESSAGE_S.SQL_ERROR(

460: WHEN no_data_found THEN
461: RETURN NULL;
462:
463: WHEN others THEN
464: PO_MESSAGE_S.SQL_ERROR(
465: 'PO_COMPARE_REVISIONS.GET_LOCATION',
466: v_progress,
467: sqlcode );
468: RAISE;

Line 511: PO_MESSAGE_S.SQL_ERROR(

507: EXCEPTION
508: WHEN no_data_found THEN
509: RETURN NULL;
510: WHEN others THEN
511: PO_MESSAGE_S.SQL_ERROR(
512: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_HEADER',
513: v_progress,
514: sqlcode );
515: RAISE;

Line 558: PO_MESSAGE_S.SQL_ERROR(

554: EXCEPTION
555: WHEN no_data_found THEN
556: RETURN NULL;
557: WHEN others THEN
558: PO_MESSAGE_S.SQL_ERROR(
559: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_LINE',
560: v_progress,
561: sqlcode );
562: RAISE;

Line 609: PO_MESSAGE_S.SQL_ERROR(

605: EXCEPTION
606: WHEN no_data_found THEN
607: RETURN NULL;
608: WHEN others THEN
609: PO_MESSAGE_S.SQL_ERROR(
610: 'PO_COMPARE_REVISIONS.GET_PO_LOOKUP',
611: v_progress,
612: sqlcode );
613: RAISE;

Line 656: PO_MESSAGE_S.SQL_ERROR(

652: WHEN no_data_found THEN
653: RETURN NULL;
654:
655: WHEN others THEN
656: PO_MESSAGE_S.SQL_ERROR(
657: 'PO_COMPARE_REVISIONS.GET_VENDOR_SITE',
658: v_progress,
659: sqlcode );
660: RAISE;

Line 701: PO_MESSAGE_S.SQL_ERROR(

697: WHEN no_data_found THEN
698: RETURN NULL;
699:
700: WHEN others THEN
701: PO_MESSAGE_S.SQL_ERROR(
702: 'PO_COMPARE_REVISIONS.GET_PRICEDIFF_TYPE',
703: v_progress,
704: sqlcode );
705: RAISE;

Line 896: PO_MESSAGE_S.SQL_ERROR(

892: --COMMIT;
893:
894: EXCEPTION
895: WHEN others THEN
896: PO_MESSAGE_S.SQL_ERROR(
897: 'PO_COMPARE_REVISIONS.INSERT_CHANGES',
898: v_progress,
899: sqlcode );
900: RAISE;

Line 968: PO_MESSAGE_S.SQL_ERROR(

964: END IF;
965:
966: EXCEPTION
967: WHEN others THEN
968: PO_MESSAGE_S.SQL_ERROR(
969: 'PO_COMPARE_REVISIONS.VERIFY_NO_DIFFERENCES',
970: v_progress,
971: sqlcode );
972: RAISE;

Line 1784: PO_MESSAGE_S.SQL_ERROR(

1780: end if;
1781:
1782: EXCEPTION
1783: WHEN others THEN
1784: PO_MESSAGE_S.SQL_ERROR(
1785: 'PO_COMPARE_REVISIONS.COMPARE_HEADERS',
1786: v_progress,
1787: sqlcode );
1788: RAISE;

Line 2150: PO_MESSAGE_S.SQL_ERROR(

2146: END IF;
2147:
2148: EXCEPTION
2149: WHEN others THEN
2150: PO_MESSAGE_S.SQL_ERROR(
2151: 'PO_COMPARE_REVISIONS.COMPARE_RELEASES',
2152: v_progress,
2153: sqlcode );
2154: RAISE;

Line 2415: PO_MESSAGE_S.SQL_ERROR(

2411:
2412:
2413: EXCEPTION
2414: WHEN others THEN
2415: PO_MESSAGE_S.SQL_ERROR(
2416: 'PO_COMPARE_REVISIONS.COMPARE_PDIFS',
2417: v_progress,
2418: sqlcode );
2419: RAISE;

Line 2566: PO_MESSAGE_S.SQL_ERROR(

2562:
2563:
2564: EXCEPTION
2565: WHEN others THEN
2566: PO_MESSAGE_S.SQL_ERROR(
2567: 'PO_COMPARE_REVISIONS.COMPARE_GA_ORG_ASSIGNMENTS',
2568: v_progress,
2569: sqlcode );
2570: RAISE;

Line 3812: PO_MESSAGE_S.SQL_ERROR(

3808: --end complex work
3809:
3810: EXCEPTION
3811: WHEN others THEN
3812: PO_MESSAGE_S.SQL_ERROR(
3813: 'PO_COMPARE_REVISIONS.COMPARE_LINES',
3814: v_progress,
3815: sqlcode );
3816: RAISE;

Line 4633: PO_MESSAGE_S.SQL_ERROR(

4629:
4630: */
4631: EXCEPTION
4632: WHEN others THEN
4633: PO_MESSAGE_S.SQL_ERROR(
4634: 'PO_COMPARE_REVISIONS.COMPARE_LOCATIONS',
4635: v_progress,
4636: sqlcode );
4637: RAISE;

Line 4874: PO_MESSAGE_S.SQL_ERROR(

4870: END IF;
4871:
4872: EXCEPTION
4873: WHEN others THEN
4874: PO_MESSAGE_S.SQL_ERROR(
4875: 'PO_COMPARE_REVISIONS.PO_COMPARE_DISTRIBUTIONS',
4876: v_progress,
4877: sqlcode );
4878: RAISE;

Line 4926: PO_MESSAGE_S.SQL_ERROR(

4922: EXCEPTION
4923: WHEN no_data_found THEN
4924: RETURN NULL;
4925: WHEN others THEN
4926: PO_MESSAGE_S.SQL_ERROR(
4927: 'PO_COMPARE_REVISIONS.GET_CHARGE_ACCOUNT',
4928: v_progress,
4929: sqlcode );
4930: RAISE;

Line 4975: PO_MESSAGE_S.SQL_ERROR(

4971: EXCEPTION
4972: WHEN no_data_found THEN
4973: RETURN NULL;
4974: WHEN others THEN
4975: PO_MESSAGE_S.SQL_ERROR(
4976: 'PO_COMPARE_REVISIONS.GET_REQUESTOR',
4977: v_progress,
4978: sqlcode );
4979: RAISE;

Line 5026: PO_MESSAGE_S.SQL_ERROR(

5022: EXCEPTION
5023: WHEN no_data_found THEN
5024: RETURN NULL;
5025: WHEN others THEN
5026: PO_MESSAGE_S.SQL_ERROR(
5027: 'PO_COMPARE_REVISIONS.GET_SHOPPING_CATEGORY',
5028: v_progress,
5029: sqlcode );
5030: RAISE;

Line 5077: PO_MESSAGE_S.SQL_ERROR(

5073: EXCEPTION
5074: WHEN no_data_found THEN
5075: RETURN NULL;
5076: WHEN others THEN
5077: PO_MESSAGE_S.SQL_ERROR(
5078: 'PO_COMPARE_REVISIONS.GET_OWNER',
5079: v_progress,
5080: sqlcode );
5081: RAISE;

Line 5104: PO_MESSAGE_S.SQL_ERROR(

5100: RETURN p_nextval;
5101:
5102: EXCEPTION
5103: WHEN others THEN
5104: PO_MESSAGE_S.SQL_ERROR(
5105: 'PO_COMPARE_REVISIONS.GET_NEXTVAL',
5106: '112',
5107: sqlcode );
5108: RAISE;

Line 5149: PO_MESSAGE_S.SQL_ERROR(

5145: EXCEPTION
5146: WHEN no_data_found THEN
5147: RETURN NULL;
5148: WHEN others THEN
5149: PO_MESSAGE_S.SQL_ERROR(
5150: 'PO_COMPARE_REVISIONS.GET_JOB',
5151: v_progress,
5152: sqlcode );
5153: RAISE;

Line 5197: PO_MESSAGE_S.SQL_ERROR(

5193: EXCEPTION
5194: WHEN no_data_found THEN
5195: RETURN NULL;
5196: WHEN others THEN
5197: PO_MESSAGE_S.SQL_ERROR(
5198: 'PO_COMPARE_REVISIONS.GET_ITEM',
5199: v_progress,
5200: sqlcode );
5201: RAISE;