DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_MESSAGE_S

Line 93: po_message_s.sql_error('Exception of CHECK_PO_ARCHIVE()',

89: END IF; /*x_revision_num = l_arch_revision_num*/
90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: po_message_s.sql_error('Exception of CHECK_PO_ARCHIVE()',
94: l_progress , sqlcode);
95: FND_MSG_PUB.Add;
96: IF (G_FND_DEBUG = 'Y') THEN
97: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 173: po_message_s.sql_error('Exception of CHECK_RELEASE_ARCHIVE()',

169: END IF; /*x_revision_num = l_arch_revision_num*/
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: po_message_s.sql_error('Exception of CHECK_RELEASE_ARCHIVE()',
174: l_progress , sqlcode);
175: FND_MSG_PUB.Add;
176: IF (G_FND_DEBUG = 'Y') THEN
177: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 548: po_message_s.sql_error('Exception of ARCHIVE_HEADER()',

544: l_progress := '030';
545:
546: EXCEPTION
547: WHEN OTHERS THEN
548: po_message_s.sql_error('Exception of ARCHIVE_HEADER()',
549: l_progress , sqlcode);
550: FND_MSG_PUB.Add;
551: IF (G_FND_DEBUG = 'Y') THEN
552: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 813: po_message_s.sql_error('Exception of ARCHIVE_RELEASE()',

809: l_progress := '030';
810:
811: EXCEPTION
812: WHEN OTHERS THEN
813: po_message_s.sql_error('Exception of ARCHIVE_RELEASE()',
814: l_progress , sqlcode);
815: FND_MSG_PUB.Add;
816: IF (G_FND_DEBUG = 'Y') THEN
817: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1324: po_message_s.sql_error('Exception of ARCHIVE_LINES()',

1320: l_progress := '030';
1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: po_message_s.sql_error('Exception of ARCHIVE_LINES()',
1325: l_progress , sqlcode);
1326: FND_MSG_PUB.Add;
1327: IF (G_FND_DEBUG = 'Y') THEN
1328: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1848: po_message_s.sql_error('Exception of ARCHIVE_LINE_LOCATIONS()',

1844: l_progress := '030';
1845:
1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: po_message_s.sql_error('Exception of ARCHIVE_LINE_LOCATIONS()',
1849: l_progress , sqlcode);
1850: FND_MSG_PUB.Add;
1851: IF (G_FND_DEBUG = 'Y') THEN
1852: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2258: po_message_s.sql_error('Exception of ARCHIVE_DISTRIBUTIONS()',

2254: l_progress := '030';
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: po_message_s.sql_error('Exception of ARCHIVE_DISTRIBUTIONS()',
2259: l_progress , sqlcode);
2260: FND_MSG_PUB.Add;
2261: IF (G_FND_DEBUG = 'Y') THEN
2262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2399: po_message_s.sql_error('Exception of ARCHIVE_ORG_ASSIGNMENTS()',

2395: l_progress := '030';
2396:
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: po_message_s.sql_error('Exception of ARCHIVE_ORG_ASSIGNMENTS()',
2400: l_progress , sqlcode);
2401: FND_MSG_PUB.Add;
2402: IF (G_FND_DEBUG = 'Y') THEN
2403: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2569: po_message_s.sql_error('Exception of ARCHIVE_PRICE_DIFFS()',

2565: l_progress := '030';
2566:
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569: po_message_s.sql_error('Exception of ARCHIVE_PRICE_DIFFS()',
2570: l_progress , sqlcode);
2571: FND_MSG_PUB.Add;
2572: IF (G_FND_DEBUG = 'Y') THEN
2573: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2722: po_message_s.sql_error('Exception of ARCHIVE_CONTRACT_TERMS()',

2718: l_progress := '050';
2719:
2720: EXCEPTION
2721: WHEN OTHERS THEN
2722: po_message_s.sql_error('Exception of ARCHIVE_CONTRACT_TERMS()',
2723: l_progress , sqlcode);
2724: FND_MSG_PUB.Add;
2725: IF (G_FND_DEBUG = 'Y') THEN
2726: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3207: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.is_line_archived','000',sqlcode);

3203:
3204: EXCEPTION
3205:
3206: WHEN OTHERS THEN
3207: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.is_line_archived','000',sqlcode);
3208: RAISE;
3209:
3210: END is_line_archived;
3211:

Line 3262: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.is_line_location_archived','000',sqlcode);

3258:
3259: EXCEPTION
3260:
3261: WHEN OTHERS THEN
3262: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.is_line_location_archived','000',sqlcode);
3263: RAISE;
3264:
3265: END is_line_location_archived;
3266:

Line 3317: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.is_price_differential_archived','000',sqlcode);

3313:
3314: EXCEPTION
3315:
3316: WHEN OTHERS THEN
3317: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.is_price_differential_archived','000',sqlcode);
3318: RAISE;
3319:
3320: END is_price_differential_archived;
3321:

Line 3370: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.get_archive_mode','000',sqlcode);

3366: RETURN l_archive_mode;
3367:
3368: EXCEPTION
3369: WHEN OTHERS THEN
3370: PO_MESSAGE_S.sql_error('PO_DOCUMENT_ARCHIVE_PVT.get_archive_mode','000',sqlcode);
3371: RAISE;
3372: END;
3373:
3374: -------------------------------------------------------------------------------