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 410: PO_MESSAGE_S.SQL_ERROR(

406: EXCEPTION
407: WHEN no_data_found THEN
408: RETURN NULL;
409: WHEN others THEN
410: PO_MESSAGE_S.SQL_ERROR(
411: 'PO_COMPARE_REVISIONS.GET_VENDOR_CONTACT',
412: v_progress,
413: sqlcode );
414: RAISE;

Line 460: PO_MESSAGE_S.SQL_ERROR(

456: WHEN no_data_found THEN
457: RETURN NULL;
458:
459: WHEN others THEN
460: PO_MESSAGE_S.SQL_ERROR(
461: 'PO_COMPARE_REVISIONS.GET_LOCATION',
462: v_progress,
463: sqlcode );
464: RAISE;

Line 507: PO_MESSAGE_S.SQL_ERROR(

503: EXCEPTION
504: WHEN no_data_found THEN
505: RETURN NULL;
506: WHEN others THEN
507: PO_MESSAGE_S.SQL_ERROR(
508: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_HEADER',
509: v_progress,
510: sqlcode );
511: RAISE;

Line 554: PO_MESSAGE_S.SQL_ERROR(

550: EXCEPTION
551: WHEN no_data_found THEN
552: RETURN NULL;
553: WHEN others THEN
554: PO_MESSAGE_S.SQL_ERROR(
555: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_LINE',
556: v_progress,
557: sqlcode );
558: RAISE;

Line 605: PO_MESSAGE_S.SQL_ERROR(

601: EXCEPTION
602: WHEN no_data_found THEN
603: RETURN NULL;
604: WHEN others THEN
605: PO_MESSAGE_S.SQL_ERROR(
606: 'PO_COMPARE_REVISIONS.GET_PO_LOOKUP',
607: v_progress,
608: sqlcode );
609: RAISE;

Line 652: PO_MESSAGE_S.SQL_ERROR(

648: WHEN no_data_found THEN
649: RETURN NULL;
650:
651: WHEN others THEN
652: PO_MESSAGE_S.SQL_ERROR(
653: 'PO_COMPARE_REVISIONS.GET_VENDOR_SITE',
654: v_progress,
655: sqlcode );
656: RAISE;

Line 697: PO_MESSAGE_S.SQL_ERROR(

693: WHEN no_data_found THEN
694: RETURN NULL;
695:
696: WHEN others THEN
697: PO_MESSAGE_S.SQL_ERROR(
698: 'PO_COMPARE_REVISIONS.GET_PRICEDIFF_TYPE',
699: v_progress,
700: sqlcode );
701: RAISE;

Line 892: PO_MESSAGE_S.SQL_ERROR(

888: --COMMIT;
889:
890: EXCEPTION
891: WHEN others THEN
892: PO_MESSAGE_S.SQL_ERROR(
893: 'PO_COMPARE_REVISIONS.INSERT_CHANGES',
894: v_progress,
895: sqlcode );
896: RAISE;

Line 964: PO_MESSAGE_S.SQL_ERROR(

960: END IF;
961:
962: EXCEPTION
963: WHEN others THEN
964: PO_MESSAGE_S.SQL_ERROR(
965: 'PO_COMPARE_REVISIONS.VERIFY_NO_DIFFERENCES',
966: v_progress,
967: sqlcode );
968: RAISE;

Line 1780: PO_MESSAGE_S.SQL_ERROR(

1776: end if;
1777:
1778: EXCEPTION
1779: WHEN others THEN
1780: PO_MESSAGE_S.SQL_ERROR(
1781: 'PO_COMPARE_REVISIONS.COMPARE_HEADERS',
1782: v_progress,
1783: sqlcode );
1784: RAISE;

Line 2146: PO_MESSAGE_S.SQL_ERROR(

2142: END IF;
2143:
2144: EXCEPTION
2145: WHEN others THEN
2146: PO_MESSAGE_S.SQL_ERROR(
2147: 'PO_COMPARE_REVISIONS.COMPARE_RELEASES',
2148: v_progress,
2149: sqlcode );
2150: RAISE;

Line 2411: PO_MESSAGE_S.SQL_ERROR(

2407:
2408:
2409: EXCEPTION
2410: WHEN others THEN
2411: PO_MESSAGE_S.SQL_ERROR(
2412: 'PO_COMPARE_REVISIONS.COMPARE_PDIFS',
2413: v_progress,
2414: sqlcode );
2415: RAISE;

Line 2562: PO_MESSAGE_S.SQL_ERROR(

2558:
2559:
2560: EXCEPTION
2561: WHEN others THEN
2562: PO_MESSAGE_S.SQL_ERROR(
2563: 'PO_COMPARE_REVISIONS.COMPARE_GA_ORG_ASSIGNMENTS',
2564: v_progress,
2565: sqlcode );
2566: RAISE;

Line 3808: PO_MESSAGE_S.SQL_ERROR(

3804: --end complex work
3805:
3806: EXCEPTION
3807: WHEN others THEN
3808: PO_MESSAGE_S.SQL_ERROR(
3809: 'PO_COMPARE_REVISIONS.COMPARE_LINES',
3810: v_progress,
3811: sqlcode );
3812: RAISE;

Line 4627: PO_MESSAGE_S.SQL_ERROR(

4623:
4624: */
4625: EXCEPTION
4626: WHEN others THEN
4627: PO_MESSAGE_S.SQL_ERROR(
4628: 'PO_COMPARE_REVISIONS.COMPARE_LOCATIONS',
4629: v_progress,
4630: sqlcode );
4631: RAISE;

Line 4868: PO_MESSAGE_S.SQL_ERROR(

4864: END IF;
4865:
4866: EXCEPTION
4867: WHEN others THEN
4868: PO_MESSAGE_S.SQL_ERROR(
4869: 'PO_COMPARE_REVISIONS.PO_COMPARE_DISTRIBUTIONS',
4870: v_progress,
4871: sqlcode );
4872: RAISE;

Line 4920: PO_MESSAGE_S.SQL_ERROR(

4916: EXCEPTION
4917: WHEN no_data_found THEN
4918: RETURN NULL;
4919: WHEN others THEN
4920: PO_MESSAGE_S.SQL_ERROR(
4921: 'PO_COMPARE_REVISIONS.GET_CHARGE_ACCOUNT',
4922: v_progress,
4923: sqlcode );
4924: RAISE;

Line 4969: PO_MESSAGE_S.SQL_ERROR(

4965: EXCEPTION
4966: WHEN no_data_found THEN
4967: RETURN NULL;
4968: WHEN others THEN
4969: PO_MESSAGE_S.SQL_ERROR(
4970: 'PO_COMPARE_REVISIONS.GET_REQUESTOR',
4971: v_progress,
4972: sqlcode );
4973: RAISE;

Line 5020: PO_MESSAGE_S.SQL_ERROR(

5016: EXCEPTION
5017: WHEN no_data_found THEN
5018: RETURN NULL;
5019: WHEN others THEN
5020: PO_MESSAGE_S.SQL_ERROR(
5021: 'PO_COMPARE_REVISIONS.GET_SHOPPING_CATEGORY',
5022: v_progress,
5023: sqlcode );
5024: RAISE;

Line 5071: PO_MESSAGE_S.SQL_ERROR(

5067: EXCEPTION
5068: WHEN no_data_found THEN
5069: RETURN NULL;
5070: WHEN others THEN
5071: PO_MESSAGE_S.SQL_ERROR(
5072: 'PO_COMPARE_REVISIONS.GET_OWNER',
5073: v_progress,
5074: sqlcode );
5075: RAISE;

Line 5098: PO_MESSAGE_S.SQL_ERROR(

5094: RETURN p_nextval;
5095:
5096: EXCEPTION
5097: WHEN others THEN
5098: PO_MESSAGE_S.SQL_ERROR(
5099: 'PO_COMPARE_REVISIONS.GET_NEXTVAL',
5100: '112',
5101: sqlcode );
5102: RAISE;

Line 5143: PO_MESSAGE_S.SQL_ERROR(

5139: EXCEPTION
5140: WHEN no_data_found THEN
5141: RETURN NULL;
5142: WHEN others THEN
5143: PO_MESSAGE_S.SQL_ERROR(
5144: 'PO_COMPARE_REVISIONS.GET_JOB',
5145: v_progress,
5146: sqlcode );
5147: RAISE;

Line 5191: PO_MESSAGE_S.SQL_ERROR(

5187: EXCEPTION
5188: WHEN no_data_found THEN
5189: RETURN NULL;
5190: WHEN others THEN
5191: PO_MESSAGE_S.SQL_ERROR(
5192: 'PO_COMPARE_REVISIONS.GET_ITEM',
5193: v_progress,
5194: sqlcode );
5195: RAISE;