APPS.PO_COMPARE_REVISIONS dependencies on PO_COMPARE_REVISIONS

Line 1: PACKAGE BODY po_compare_revisions AS

1: PACKAGE BODY po_compare_revisions AS
2: /* $Header: POXPOCMB.pls 120.2 2010/11/29 07:48:53 lswamina ship $ */
3:
4: /*********************************************************************
5: * NAME

Line 46: 'PO_COMPARE_REVISIONS.PURGE',

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;
50:

Line 95: 'PO_COMPARE_REVISIONS.GET_UN_NUMBER',

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;
99:

Line 152: 'PO_COMPARE_REVISIONS.GET_ITEM_NUMBER',

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;
156:

Line 201: 'PO_COMPARE_REVISIONS.GET_HAZARD_CLASS',

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;
205:

Line 250: 'PO_COMPARE_REVISIONS.GET_AP_TERMS',

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;
254:

Line 303: 'PO_COMPARE_REVISIONS.GET_BUYER',

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;
307:

Line 357: 'PO_COMPARE_REVISIONS.GET_VENDOR_CONTACT',

353: WHEN no_data_found THEN
354: RETURN NULL;
355: WHEN others THEN
356: PO_MESSAGE_S.SQL_ERROR(
357: 'PO_COMPARE_REVISIONS.GET_VENDOR_CONTACT',
358: v_progress,
359: sqlcode );
360: RAISE;
361:

Line 407: 'PO_COMPARE_REVISIONS.GET_LOCATION',

403: RETURN NULL;
404:
405: WHEN others THEN
406: PO_MESSAGE_S.SQL_ERROR(
407: 'PO_COMPARE_REVISIONS.GET_LOCATION',
408: v_progress,
409: sqlcode );
410: RAISE;
411:

Line 454: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_HEADER',

450: WHEN no_data_found THEN
451: RETURN NULL;
452: WHEN others THEN
453: PO_MESSAGE_S.SQL_ERROR(
454: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_HEADER',
455: v_progress,
456: sqlcode );
457: RAISE;
458:

Line 501: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_LINE',

497: WHEN no_data_found THEN
498: RETURN NULL;
499: WHEN others THEN
500: PO_MESSAGE_S.SQL_ERROR(
501: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_LINE',
502: v_progress,
503: sqlcode );
504: RAISE;
505:

Line 552: 'PO_COMPARE_REVISIONS.GET_PO_LOOKUP',

548: WHEN no_data_found THEN
549: RETURN NULL;
550: WHEN others THEN
551: PO_MESSAGE_S.SQL_ERROR(
552: 'PO_COMPARE_REVISIONS.GET_PO_LOOKUP',
553: v_progress,
554: sqlcode );
555: RAISE;
556:

Line 599: 'PO_COMPARE_REVISIONS.GET_VENDOR_SITE',

595: RETURN NULL;
596:
597: WHEN others THEN
598: PO_MESSAGE_S.SQL_ERROR(
599: 'PO_COMPARE_REVISIONS.GET_VENDOR_SITE',
600: v_progress,
601: sqlcode );
602: RAISE;
603:

Line 775: 'PO_COMPARE_REVISIONS.INSERT_CHANGES',

771:
772: EXCEPTION
773: WHEN others THEN
774: PO_MESSAGE_S.SQL_ERROR(
775: 'PO_COMPARE_REVISIONS.INSERT_CHANGES',
776: v_progress,
777: sqlcode );
778: RAISE;
779:

Line 847: 'PO_COMPARE_REVISIONS.VERIFY_NO_DIFFERENCES',

843:
844: EXCEPTION
845: WHEN others THEN
846: PO_MESSAGE_S.SQL_ERROR(
847: 'PO_COMPARE_REVISIONS.VERIFY_NO_DIFFERENCES',
848: v_progress,
849: sqlcode );
850: RAISE;
851:

Line 1500: 'PO_COMPARE_REVISIONS.COMPARE_HEADERS',

1496:
1497: EXCEPTION
1498: WHEN others THEN
1499: PO_MESSAGE_S.SQL_ERROR(
1500: 'PO_COMPARE_REVISIONS.COMPARE_HEADERS',
1501: v_progress,
1502: sqlcode );
1503: RAISE;
1504:

Line 1812: 'PO_COMPARE_REVISIONS.COMPARE_RELEASES',

1808:
1809: EXCEPTION
1810: WHEN others THEN
1811: PO_MESSAGE_S.SQL_ERROR(
1812: 'PO_COMPARE_REVISIONS.COMPARE_RELEASES',
1813: v_progress,
1814: sqlcode );
1815: RAISE;
1816:

Line 2527: 'PO_COMPARE_REVISIONS.COMPARE_LINES',

2523:
2524: EXCEPTION
2525: WHEN others THEN
2526: PO_MESSAGE_S.SQL_ERROR(
2527: 'PO_COMPARE_REVISIONS.COMPARE_LINES',
2528: v_progress,
2529: sqlcode );
2530: RAISE;
2531:

Line 2924: 'PO_COMPARE_REVISIONS.COMPARE_LOCATIONS',

2920:
2921: EXCEPTION
2922: WHEN others THEN
2923: PO_MESSAGE_S.SQL_ERROR(
2924: 'PO_COMPARE_REVISIONS.COMPARE_LOCATIONS',
2925: v_progress,
2926: sqlcode );
2927: RAISE;
2928:

Line 3160: 'PO_COMPARE_REVISIONS.PO_COMPARE_DISTRIBUTIONS',

3156:
3157: EXCEPTION
3158: WHEN others THEN
3159: PO_MESSAGE_S.SQL_ERROR(
3160: 'PO_COMPARE_REVISIONS.PO_COMPARE_DISTRIBUTIONS',
3161: v_progress,
3162: sqlcode );
3163: RAISE;
3164:

Line 3212: 'PO_COMPARE_REVISIONS.GET_CHARGE_ACCOUNT',

3208: WHEN no_data_found THEN
3209: RETURN NULL;
3210: WHEN others THEN
3211: PO_MESSAGE_S.SQL_ERROR(
3212: 'PO_COMPARE_REVISIONS.GET_CHARGE_ACCOUNT',
3213: v_progress,
3214: sqlcode );
3215: RAISE;
3216:

Line 3219: END po_compare_revisions;

3215: RAISE;
3216:
3217: END get_charge_account;
3218:
3219: END po_compare_revisions;