APPS.GMF_PERIODCLOSE_PUB dependencies on FND_MSG_PUB

Line 72: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

68:
69: -- Check for message level threshold
70: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
71:
72: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
73: THEN
74: FND_MSG_PUB.Add_Exc_Msg(
75: p_pkg_name => G_PKG_NAME,
76: p_procedure_name => l_api_name,

Line 74: FND_MSG_PUB.Add_Exc_Msg(

70: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
71:
72: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
73: THEN
74: FND_MSG_PUB.Add_Exc_Msg(
75: p_pkg_name => G_PKG_NAME,
76: p_procedure_name => l_api_name,
77: p_error_text => SUBSTR(
78: l_stmt_num||':'||

Line 307: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: ROLLBACK TO Get_PendingTcount_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg(
310: p_pkg_name => G_PKG_NAME,
311: p_procedure_name => l_api_name,

Line 309: FND_MSG_PUB.Add_Exc_Msg(

305: ROLLBACK TO Get_PendingTcount_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg(
310: p_pkg_name => G_PKG_NAME,
311: p_procedure_name => l_api_name,
312: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
313: );

Line 413: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

409:
410: -- Check for message level threshold
411: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
412:
413: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
414: THEN
415: FND_MSG_PUB.Add_Exc_Msg(
416: p_pkg_name => G_PKG_NAME,
417: p_procedure_name => l_api_name,

Line 415: FND_MSG_PUB.Add_Exc_Msg(

411: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
412:
413: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
414: THEN
415: FND_MSG_PUB.Add_Exc_Msg(
416: p_pkg_name => G_PKG_NAME,
417: p_procedure_name => l_api_name,
418: p_error_text => SUBSTR(
419: l_stmt_num||':'||

Line 518: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: WHEN OTHERS THEN
516: ROLLBACK TO Verify_PeriodClose_PUB;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg(
521: p_pkg_name => G_PKG_NAME,
522: p_procedure_name => l_api_name,

Line 520: FND_MSG_PUB.Add_Exc_Msg(

516: ROLLBACK TO Verify_PeriodClose_PUB;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg(
521: p_pkg_name => G_PKG_NAME,
522: p_procedure_name => l_api_name,
523: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
524: );

Line 587: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

583:
584: -- Check for message level threshold
585: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
586:
587: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
588: THEN
589: FND_MSG_PUB.Add_Exc_Msg(
590: p_pkg_name => G_PKG_NAME,
591: p_procedure_name => l_api_name,

Line 589: FND_MSG_PUB.Add_Exc_Msg(

585: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
586:
587: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
588: THEN
589: FND_MSG_PUB.Add_Exc_Msg(
590: p_pkg_name => G_PKG_NAME,
591: p_procedure_name => l_api_name,
592: p_error_text => SUBSTR(
593: l_stmt_num||':'||

Line 678: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

674: WHEN OTHERS THEN
675: ROLLBACK TO Close_Period_PUB;
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: x_close_failed := TRUE;
678: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg(
681: p_pkg_name => G_PKG_NAME,
682: p_procedure_name => l_api_name,

Line 680: FND_MSG_PUB.Add_Exc_Msg(

676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: x_close_failed := TRUE;
678: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg(
681: p_pkg_name => G_PKG_NAME,
682: p_procedure_name => l_api_name,
683: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
684: );