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 115.18 2002/11/23 02:50:02 sbull 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 354: 'PO_COMPARE_REVISIONS.GET_VENDOR_CONTACT',

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

Line 404: 'PO_COMPARE_REVISIONS.GET_LOCATION',

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

Line 451: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_HEADER',

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

Line 498: 'PO_COMPARE_REVISIONS.GET_SOURCE_QUOTATION_LINE',

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

Line 549: 'PO_COMPARE_REVISIONS.GET_PO_LOOKUP',

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

Line 596: 'PO_COMPARE_REVISIONS.GET_VENDOR_SITE',

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

Line 772: 'PO_COMPARE_REVISIONS.INSERT_CHANGES',

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

Line 844: 'PO_COMPARE_REVISIONS.VERIFY_NO_DIFFERENCES',

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

Line 1497: 'PO_COMPARE_REVISIONS.COMPARE_HEADERS',

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

Line 1809: 'PO_COMPARE_REVISIONS.COMPARE_RELEASES',

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

Line 2524: 'PO_COMPARE_REVISIONS.COMPARE_LINES',

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

Line 2921: 'PO_COMPARE_REVISIONS.COMPARE_LOCATIONS',

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

Line 3157: 'PO_COMPARE_REVISIONS.PO_COMPARE_DISTRIBUTIONS',

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

Line 3209: 'PO_COMPARE_REVISIONS.GET_CHARGE_ACCOUNT',

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

Line 3216: END po_compare_revisions;

3212: RAISE;
3213:
3214: END get_charge_account;
3215:
3216: END po_compare_revisions;