APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_MSG_PUB

Line 1793: FND_MSG_PUB.Initialize;

1789: IF l_enabled_flag = 'Y' THEN
1790:
1791: l_progress := '704';
1792: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before calling PO_UDA_SUBMISSION_CHECK');
1793: FND_MSG_PUB.Initialize;
1794:
1795: PO_UDA_DEFAULTING_PKG.PO_UDA_SUBMISSION_CHECK
1796: (
1797: p_po_header_id => l_document_id

Line 1892: l_msg_count := FND_MSG_PUB.Count_Msg;

1888: END IF;
1889:
1890: l_progress := '709';
1891: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before logging the online failure report');
1892: l_msg_count := FND_MSG_PUB.Count_Msg;
1893:
1894: IF l_failure THEN
1895: FOR msg_counter IN 1 ..l_msg_count
1896: LOOP

Line 1925: FND_MSG_PUB.get (msg_counter, FND_API.g_false),

1921: 0,
1922: 0,
1923: 0,
1924: p_sequence,
1925: FND_MSG_PUB.get (msg_counter, FND_API.g_false),
1926: 'UDA Attr Sub Check Failure',
1927: 'E'
1928: );
1929:

Line 1930: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Submission check has status ' || FND_MSG_PUB.get (msg_counter, FND_API.g_false));

1926: 'UDA Attr Sub Check Failure',
1927: 'E'
1928: );
1929:
1930: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Submission check has status ' || FND_MSG_PUB.get (msg_counter, FND_API.g_false));
1931:
1932: END LOOP;
1933: END IF;
1934: END IF;

Line 3190: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

3186: WHEN FND_API.G_EXC_ERROR THEN
3187: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
3188: x_return_status := FND_API.G_RET_STS_ERROR;
3189: x_sub_check_status := FND_API.G_RET_STS_ERROR;
3190: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
3191: p_encoded => 'F');
3192:
3193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3194: ROLLBACK TO PO_SUBMISSION_CHECK_SP;

Line 3197: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

3193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3194: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
3195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3196: x_sub_check_status := FND_API.G_RET_STS_ERROR;
3197: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
3198: p_encoded => 'F');
3199:
3200: WHEN OTHERS THEN
3201: ROLLBACK TO PO_SUBMISSION_CHECK_SP;

Line 3204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3200: WHEN OTHERS THEN
3201: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
3202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3203: x_sub_check_status := FND_API.G_RET_STS_ERROR;
3204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3205: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
3206: END IF;
3207:
3208: IF (g_debug_unexp) THEN

Line 3205: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

3201: ROLLBACK TO PO_SUBMISSION_CHECK_SP;
3202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3203: x_sub_check_status := FND_API.G_RET_STS_ERROR;
3204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3205: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
3206: END IF;
3207:
3208: IF (g_debug_unexp) THEN
3209: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3409: WHEN OTHERS THEN
3410: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
3411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3412: x_sub_check_status := FND_API.G_RET_STS_ERROR;
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3414: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
3415: END IF;
3416:
3417: IF ( g_debug_unexp ) THEN

Line 3414: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

3410: ROLLBACK TO POST_SUBMISSION_CHECK_SP;
3411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3412: x_sub_check_status := FND_API.G_RET_STS_ERROR;
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3414: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
3415: END IF;
3416:
3417: IF ( g_debug_unexp ) THEN
3418: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3989: FND_MSG_PUB.Add;

3985: l_textline := l_textline || SQLERRM();
3986: END IF;
3987: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
3988: fnd_message.set_token('ERROR',l_textline);
3989: FND_MSG_PUB.Add;
3990: l_progress := '014';
3991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3992: END IF;
3993: END IF;

Line 4011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4008:
4009: WHEN OTHERS THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4012: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
4013: END IF;
4014:
4015: IF (g_debug_unexp) THEN

Line 4012: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

4008:
4009: WHEN OTHERS THEN
4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4012: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
4013: END IF;
4014:
4015: IF (g_debug_unexp) THEN
4016: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 5713: FND_MSG_PUB.Add;

5709: l_textline := l_textline || SQLERRM();
5710: END IF;
5711: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
5712: fnd_message.set_token('ERROR',l_textline);
5713: FND_MSG_PUB.Add;
5714: l_progress := '025';
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: END IF;
5717: END IF;

Line 5874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5870:
5871: WHEN OTHERS THEN
5872:
5873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5875: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
5876: END IF;
5877:
5878: IF (g_debug_unexp) THEN

Line 5875: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

5871: WHEN OTHERS THEN
5872:
5873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5874: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5875: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
5876: END IF;
5877:
5878: IF (g_debug_unexp) THEN
5879: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 7102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

7098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7099:
7100: WHEN OTHERS THEN
7101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7103: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
7104: END IF;
7105:
7106: IF (g_debug_unexp) THEN

Line 7103: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

7099:
7100: WHEN OTHERS THEN
7101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7103: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
7104: END IF;
7105:
7106: IF (g_debug_unexp) THEN
7107: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 8166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

8162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8163:
8164: WHEN OTHERS THEN
8165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
8168: END IF;
8169:
8170: IF (g_debug_unexp) THEN

Line 8167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

8163:
8164: WHEN OTHERS THEN
8165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8167: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
8168: END IF;
8169:
8170: IF (g_debug_unexp) THEN
8171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 9632: FND_MSG_PUB.Add;

9628: l_textline := l_textline || SQLERRM();
9629: END IF;
9630: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
9631: fnd_message.set_token('ERROR',l_textline);
9632: FND_MSG_PUB.Add;
9633: l_progress := '025';
9634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9635: END IF;
9636: END IF;

Line 10302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

10298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10299:
10300: WHEN OTHERS THEN
10301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10303: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10304: END IF;
10305:
10306: IF (g_debug_unexp) THEN

Line 10303: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

10299:
10300: WHEN OTHERS THEN
10301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10303: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10304: END IF;
10305:
10306: IF (g_debug_unexp) THEN
10307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 10401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

10397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10398:
10399: WHEN OTHERS THEN
10400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10402: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10403: END IF;
10404:
10405: IF (g_debug_unexp) THEN

Line 10402: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

10398:
10399: WHEN OTHERS THEN
10400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10402: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10403: END IF;
10404:
10405: IF (g_debug_unexp) THEN
10406: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 10729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

10725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10726:
10727: WHEN OTHERS THEN
10728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10730: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10731: END IF;
10732:
10733: IF (g_debug_unexp) THEN

Line 10730: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

10726:
10727: WHEN OTHERS THEN
10728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10730: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
10731: END IF;
10732:
10733: IF (g_debug_unexp) THEN
10734: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 11193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

11189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11190:
11191: WHEN OTHERS THEN
11192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11194: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11195: END IF;
11196:
11197: IF (g_debug_unexp) THEN

Line 11194: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

11190:
11191: WHEN OTHERS THEN
11192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11194: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11195: END IF;
11196:
11197: IF (g_debug_unexp) THEN
11198: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 11353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

11349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11350:
11351: WHEN OTHERS THEN
11352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11354: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11355: END IF;
11356:
11357: IF (g_debug_unexp) THEN

Line 11354: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

11350:
11351: WHEN OTHERS THEN
11352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11354: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11355: END IF;
11356:
11357: IF (g_debug_unexp) THEN
11358: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 11682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

11678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11679:
11680: WHEN OTHERS THEN
11681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11683: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11684: END IF;
11685:
11686: IF (g_debug_unexp) THEN

Line 11683: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

11679:
11680: WHEN OTHERS THEN
11681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
11683: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
11684: END IF;
11685:
11686: IF (g_debug_unexp) THEN
11687: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 12591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

12587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12588:
12589: WHEN OTHERS THEN
12590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
12592: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
12593: END IF;
12594:
12595: IF (g_debug_unexp) THEN

Line 12592: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

12588:
12589: WHEN OTHERS THEN
12590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
12592: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
12593: END IF;
12594:
12595: IF (g_debug_unexp) THEN
12596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 13087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

13083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13084:
13085: WHEN OTHERS THEN
13086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13088: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13089: END IF;
13090:
13091: IF (g_debug_unexp) THEN

Line 13088: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

13084:
13085: WHEN OTHERS THEN
13086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13088: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13089: END IF;
13090:
13091: IF (g_debug_unexp) THEN
13092: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 13226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

13222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13223:
13224: WHEN OTHERS THEN
13225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13227: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13228: END IF;
13229:
13230: IF (g_debug_unexp) THEN

Line 13227: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

13223:
13224: WHEN OTHERS THEN
13225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13227: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13228: END IF;
13229:
13230: IF (g_debug_unexp) THEN
13231: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 13337: l_textline := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

13333: END IF;
13334:
13335: IF l_return_status = FND_API.G_RET_STS_ERROR
13336: THEN
13337: l_textline := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
13338: p_encoded => 'F');
13339:
13340: IF l_textline = NULL THEN
13341: l_textline := FND_MESSAGE.GET_STRING('IGC',

Line 13346: FND_MSG_PUB.Delete_Msg(p_msg_index => FND_MSG_PUB.G_LAST);

13342: 'IGC_MULT_FISCAL_YEARS');
13343: END IF;
13344: --Deleting msg so that we can always use G_Last to get the
13345: --message we want
13346: FND_MSG_PUB.Delete_Msg(p_msg_index => FND_MSG_PUB.G_LAST);
13347: l_progress := '003';
13348: INSERT INTO PO_ONLINE_REPORT_TEXT_GT (online_report_id,
13349: last_update_login,
13350: last_updated_by,

Line 13389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

13385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13386:
13387: WHEN OTHERS THEN
13388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13391: END IF;
13392:
13393: IF (g_debug_unexp) THEN

Line 13390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

13386:
13387: WHEN OTHERS THEN
13388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13391: END IF;
13392:
13393: IF (g_debug_unexp) THEN
13394: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 13654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

13650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13651:
13652: WHEN OTHERS THEN
13653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13655: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13656: END IF;
13657:
13658: IF (g_debug_unexp) THEN

Line 13655: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

13651:
13652: WHEN OTHERS THEN
13653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13655: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
13656: END IF;
13657:
13658: IF (g_debug_unexp) THEN
13659: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 14167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

14163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14164:
14165: WHEN OTHERS THEN
14166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
14168: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
14169: END IF;
14170:
14171: IF (g_debug_unexp) THEN

Line 14168: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

14164:
14165: WHEN OTHERS THEN
14166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
14168: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
14169: END IF;
14170:
14171: IF (g_debug_unexp) THEN
14172: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 14572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

14568:
14569: WHEN OTHERS THEN
14570:
14571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
14573: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
14574: END IF;
14575:
14576: IF (g_debug_unexp) THEN

Line 14573: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

14569: WHEN OTHERS THEN
14570:
14571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
14573: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
14574: END IF;
14575:
14576: IF (g_debug_unexp) THEN
14577: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 15020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

15016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15017:
15018: WHEN OTHERS THEN
15019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15021: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15022: END IF;
15023:
15024: IF (g_debug_unexp) THEN

Line 15021: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

15017:
15018: WHEN OTHERS THEN
15019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15021: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15022: END IF;
15023:
15024: IF (g_debug_unexp) THEN
15025: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 15248: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

15244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15245:
15246: WHEN OTHERS THEN
15247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15248: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15249: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15250: END IF;
15251:
15252: IF (g_debug_unexp) THEN

Line 15249: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

15245:
15246: WHEN OTHERS THEN
15247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15248: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15249: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15250: END IF;
15251:
15252: IF (g_debug_unexp) THEN
15253: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 15424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

15420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15421:
15422: WHEN OTHERS THEN
15423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15425: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15426: END IF;
15427:
15428: IF (g_debug_unexp) THEN

Line 15425: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

15421:
15422: WHEN OTHERS THEN
15423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15425: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15426: END IF;
15427:
15428: IF (g_debug_unexp) THEN
15429: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 15757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

15753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15754:
15755: WHEN OTHERS THEN
15756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15758: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15759: END IF;
15760:
15761: IF (g_debug_unexp) THEN

Line 15758: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

15754:
15755: WHEN OTHERS THEN
15756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
15758: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
15759: END IF;
15760:
15761: IF (g_debug_unexp) THEN
15762: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 16124: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

16120: END IF;
16121:
16122: EXCEPTION
16123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16124: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
16125: p_encoded => 'F');
16126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16127: x_where_clause := NULL;
16128: WHEN FND_API.G_EXC_ERROR THEN

Line 16129: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

16125: p_encoded => 'F');
16126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16127: x_where_clause := NULL;
16128: WHEN FND_API.G_EXC_ERROR THEN
16129: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
16130: p_encoded => 'F');
16131: x_return_status := FND_API.G_RET_STS_ERROR;
16132: x_where_clause := NULL;
16133: WHEN OTHERS THEN

Line 16134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

16130: p_encoded => 'F');
16131: x_return_status := FND_API.G_RET_STS_ERROR;
16132: x_where_clause := NULL;
16133: WHEN OTHERS THEN
16134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
16135: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
16136: END IF;
16137:
16138: IF (g_debug_unexp) THEN

Line 16135: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

16131: x_return_status := FND_API.G_RET_STS_ERROR;
16132: x_where_clause := NULL;
16133: WHEN OTHERS THEN
16134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
16135: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
16136: END IF;
16137:
16138: IF (g_debug_unexp) THEN
16139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 16146: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

16142: || l_progress || ' SQL CODE is '||sqlcode);
16143: END IF;
16144: END IF;
16145:
16146: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
16147: p_encoded => 'F');
16148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16149: x_where_clause := NULL;
16150:

Line 16390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

16386: WHEN FND_API.G_EXC_ERROR THEN
16387: x_return_status := FND_API.G_RET_STS_ERROR;
16388: WHEN OTHERS THEN
16389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
16391:
16392: END check_updatable;
16393:
16394: -------------------------------------------------------------------------------

Line 16568: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

16564: WHEN FND_API.G_EXC_ERROR THEN
16565: x_return_status := FND_API.G_RET_STS_ERROR;
16566: WHEN OTHERS THEN
16567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16568: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
16569:
16570: END check_reservable;
16571:
16572: -------------------------------------------------------------------------------

Line 16737: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

16733: WHEN FND_API.G_EXC_ERROR THEN
16734: x_return_status := FND_API.G_RET_STS_ERROR;
16735: WHEN OTHERS THEN
16736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16737: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
16738:
16739: END check_unreservable;
16740:
16741: -------------------------------------------------------------------------------

Line 16903: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

16899: WHEN FND_API.G_EXC_ERROR THEN
16900: x_return_status := FND_API.G_RET_STS_ERROR;
16901: WHEN OTHERS THEN
16902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16903: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
16904:
16905: END get_status;
16906:
16907: -------------------------------------------------------------------------------

Line 17126: FND_MSG_PUB.Add;

17122:
17123: IF x_return_status is null THEN -- no valid check status request specified
17124: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
17125: FND_MESSAGE.set_token('ERROR_TEXT', 'No Valid p_mode specified !');
17126: FND_MSG_PUB.Add;
17127: RAISE FND_API.G_EXC_ERROR;
17128: END IF;
17129:
17130: EXCEPTION

Line 17137: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

17133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
17134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17135: WHEN OTHERS THEN
17136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17137: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
17138:
17139: END po_status_check;
17140:
17141:

Line 21270: FND_MSG_PUB.add;

21266: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
21267: d_progress := 40;
21268: -- : FILL IN THE MESSAGES
21269: FND_MESSAGE.set_name('PO','CWPOTODOMESSAGE');
21270: FND_MSG_PUB.add;
21271: END IF;
21272: END IF;
21273:
21274: d_progress := 50;

Line 22869: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

22865: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
22866:
22867: EXCEPTION
22868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
22869: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
22870: P_ENCODED => 'F');
22871: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
22872:
22873: WHEN FND_API.G_EXC_ERROR THEN

Line 22874: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

22870: P_ENCODED => 'F');
22871: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
22872:
22873: WHEN FND_API.G_EXC_ERROR THEN
22874: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
22875: P_ENCODED => 'F');
22876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
22877:
22878: WHEN OTHERS THEN

Line 22879: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

22875: P_ENCODED => 'F');
22876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
22877:
22878: WHEN OTHERS THEN
22879: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
22880: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
22881: END IF;
22882:
22883: IF (G_DEBUG_UNEXP) THEN

Line 22880: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);

22876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
22877:
22878: WHEN OTHERS THEN
22879: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
22880: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
22881: END IF;
22882:
22883: IF (G_DEBUG_UNEXP) THEN
22884: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 22891: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

22887: || L_PROGRESS || ' SQL CODE IS '||SQLCODE);
22888: END IF;
22889: END IF;
22890:
22891: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
22892: P_ENCODED => 'F');
22893: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
22894:
22895: END PO_ACCOUNTS_CHECK;

Line 23013: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

23009: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
23010:
23011: EXCEPTION
23012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
23013: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
23014: P_ENCODED => 'F');
23015: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
23016:
23017: WHEN FND_API.G_EXC_ERROR THEN

Line 23018: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

23014: P_ENCODED => 'F');
23015: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
23016:
23017: WHEN FND_API.G_EXC_ERROR THEN
23018: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
23019: P_ENCODED => 'F');
23020: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
23021:
23022: WHEN OTHERS THEN

Line 23023: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

23019: P_ENCODED => 'F');
23020: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
23021:
23022: WHEN OTHERS THEN
23023: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
23024: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
23025: END IF;
23026:
23027: IF (G_DEBUG_UNEXP) THEN

Line 23024: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);

23020: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
23021:
23022: WHEN OTHERS THEN
23023: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
23024: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
23025: END IF;
23026:
23027: IF (G_DEBUG_UNEXP) THEN
23028: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 23035: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

23031: || L_PROGRESS || ' SQL CODE IS '||SQLCODE);
23032: END IF;
23033: END IF;
23034:
23035: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
23036: P_ENCODED => 'F');
23037: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
23038:
23039: END;

Line 23331: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

23327: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
23328:
23329: EXCEPTION
23330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
23331: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
23332: P_ENCODED => 'F');
23333: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
23334:
23335: WHEN FND_API.G_EXC_ERROR THEN

Line 23336: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

23332: P_ENCODED => 'F');
23333: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
23334:
23335: WHEN FND_API.G_EXC_ERROR THEN
23336: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
23337: P_ENCODED => 'F');
23338: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
23339:
23340: WHEN OTHERS THEN

Line 23341: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

23337: P_ENCODED => 'F');
23338: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
23339:
23340: WHEN OTHERS THEN
23341: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
23342: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
23343: END IF;
23344:
23345: IF (G_DEBUG_UNEXP) THEN

Line 23342: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);

23338: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
23339:
23340: WHEN OTHERS THEN
23341: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
23342: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
23343: END IF;
23344:
23345: IF (G_DEBUG_UNEXP) THEN
23346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 23354: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

23350: ' SQL CODE IS ' || SQLCODE);
23351: END IF;
23352: END IF;
23353:
23354: X_MSG_DATA := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
23355: P_ENCODED => 'F');
23356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
23357:
23358: END PO_ACRN_CHECK;

Line 24368: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

24364: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
24365:
24366: EXCEPTION
24367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
24368: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
24369: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
24370:
24371: WHEN FND_API.G_EXC_ERROR THEN
24372: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

Line 24372: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

24368: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
24369: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
24370:
24371: WHEN FND_API.G_EXC_ERROR THEN
24372: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
24373: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
24374:
24375: WHEN OTHERS THEN
24376:

Line 24378: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

24374:
24375: WHEN OTHERS THEN
24376:
24377: -- SQLStmtGetText(mycontext, l_dyn_string, size1, size2 );
24378: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
24379: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, L_API_NAME );
24380: END IF;
24381:
24382: IF( G_DEBUG_UNEXP ) THEN

Line 24379: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, L_API_NAME );

24375: WHEN OTHERS THEN
24376:
24377: -- SQLStmtGetText(mycontext, l_dyn_string, size1, size2 );
24378: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
24379: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, L_API_NAME );
24380: END IF;
24381:
24382: IF( G_DEBUG_UNEXP ) THEN
24383: IF( FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED ) THEN

Line 24393: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST,

24389: SQLCODE );
24390: END IF;
24391: END IF;
24392:
24393: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST,
24394: P_ENCODED => 'F' );
24395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
24396:
24397: END PO_VALIDATE_ACCOUNTS;

Line 24606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

24602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
24603:
24604: WHEN OTHERS THEN
24605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
24606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
24607: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
24608: END IF;
24609:
24610: IF (g_debug_unexp) THEN

Line 24607: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

24603:
24604: WHEN OTHERS THEN
24605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
24606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
24607: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
24608: END IF;
24609:
24610: IF (g_debug_unexp) THEN
24611: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 24940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

24936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
24937:
24938: WHEN OTHERS THEN
24939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
24940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
24941: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
24942: END IF;
24943:
24944: IF (g_debug_unexp) THEN

Line 24941: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

24937:
24938: WHEN OTHERS THEN
24939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
24940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
24941: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
24942: END IF;
24943:
24944: IF (g_debug_unexp) THEN
24945: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 25225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

25221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25222:
25223: WHEN OTHERS THEN
25224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
25226: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
25227: END IF;
25228:
25229: IF (g_debug_unexp) THEN

Line 25226: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

25222:
25223: WHEN OTHERS THEN
25224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
25226: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
25227: END IF;
25228:
25229: IF (g_debug_unexp) THEN
25230: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 25555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

25551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25552:
25553: WHEN OTHERS THEN
25554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
25556: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
25557: END IF;
25558:
25559: IF (g_debug_unexp) THEN

Line 25556: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

25552:
25553: WHEN OTHERS THEN
25554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
25556: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
25557: END IF;
25558:
25559: IF (g_debug_unexp) THEN
25560: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 25732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

25728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25729:
25730: WHEN OTHERS THEN
25731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
25733: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
25734: END IF;
25735:
25736: IF (g_debug_unexp) THEN

Line 25733: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

25729:
25730: WHEN OTHERS THEN
25731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
25732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
25733: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
25734: END IF;
25735:
25736: IF (g_debug_unexp) THEN
25737: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 26400: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

26396:
26397: EXCEPTION
26398:
26399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
26400: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
26401: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
26402:
26403: WHEN FND_API.G_EXC_ERROR THEN
26404: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

Line 26404: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

26400: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
26401: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
26402:
26403: WHEN FND_API.G_EXC_ERROR THEN
26404: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
26405: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
26406:
26407: WHEN OTHERS THEN
26408:

Line 26410: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

26406:
26407: WHEN OTHERS THEN
26408:
26409: -- SQLStmtGetText(mycontext, l_dyn_string, size1, size2 );
26410: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
26411: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, L_API_NAME );
26412: END IF;
26413:
26414: IF( G_DEBUG_UNEXP ) THEN

Line 26411: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, L_API_NAME );

26407: WHEN OTHERS THEN
26408:
26409: -- SQLStmtGetText(mycontext, l_dyn_string, size1, size2 );
26410: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
26411: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, L_API_NAME );
26412: END IF;
26413:
26414: IF( G_DEBUG_UNEXP ) THEN
26415: IF( FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED ) THEN

Line 26425: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );

26421: SQLCODE );
26422: END IF;
26423: END IF;
26424:
26425: X_MSG_DATA := FND_MSG_PUB.GET( P_MSG_INDEX => FND_MSG_PUB.G_LAST, P_ENCODED => 'F' );
26426: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
26427:
26428: END check_accrue_on_receipt;
26429: