eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on FND_MSG_PUB

Line 62: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

58:
59: -- Check for message level threshold
60: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
61:
62: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
63: THEN
64: FND_MSG_PUB.Add_Exc_Msg(
65: p_pkg_name => G_PKG_NAME,
66: p_procedure_name => l_api_name,

Line 64: FND_MSG_PUB.Add_Exc_Msg(

60: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
61:
62: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
63: THEN
64: FND_MSG_PUB.Add_Exc_Msg(
65: p_pkg_name => G_PKG_NAME,
66: p_procedure_name => l_api_name,
67: p_error_text => SUBSTR(
68: l_stmt_num||':'||

Line 361: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: WHEN OTHERS THEN
359: ROLLBACK TO Get_PendingTcount_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg(
364: p_pkg_name => G_PKG_NAME,
365: p_procedure_name => l_api_name,

Line 363: FND_MSG_PUB.Add_Exc_Msg(

359: ROLLBACK TO Get_PendingTcount_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg(
364: p_pkg_name => G_PKG_NAME,
365: p_procedure_name => l_api_name,
366: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
367: );

Line 480: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

476:
477: -- Check for message level threshold
478: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
479:
480: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
481: THEN
482: FND_MSG_PUB.Add_Exc_Msg(
483: p_pkg_name => G_PKG_NAME,
484: p_procedure_name => l_api_name,

Line 482: FND_MSG_PUB.Add_Exc_Msg(

478: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
479:
480: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
481: THEN
482: FND_MSG_PUB.Add_Exc_Msg(
483: p_pkg_name => G_PKG_NAME,
484: p_procedure_name => l_api_name,
485: p_error_text => SUBSTR(
486: l_stmt_num||':'||

Line 556: FND_MSG_PUB.ADD;

552: OPEN c_org_acct_unique;
553: FETCH c_org_acct_unique INTO l_test;
554: IF c_org_acct_unique%FOUND THEN
555: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
556: FND_MSG_PUB.ADD;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: CLOSE c_org_acct_unique;
560:

Line 692: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

688: IF INSTRB(SQLERRM,'ORG_ACCT_PERIODS_U2') <> 0 THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: ELSE
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
693: THEN
694: FND_MSG_PUB.Add_Exc_Msg(
695: p_pkg_name => G_PKG_NAME,
696: p_procedure_name => l_api_name,

Line 694: FND_MSG_PUB.Add_Exc_Msg(

690: ELSE
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
693: THEN
694: FND_MSG_PUB.Add_Exc_Msg(
695: p_pkg_name => G_PKG_NAME,
696: p_procedure_name => l_api_name,
697: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
698: );

Line 716: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

712:
713: WHEN OTHERS THEN
714: ROLLBACK TO Open_Period_PUB;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
717: THEN
718: FND_MSG_PUB.Add_Exc_Msg(
719: p_pkg_name => G_PKG_NAME,
720: p_procedure_name => l_api_name,

Line 718: FND_MSG_PUB.Add_Exc_Msg(

714: ROLLBACK TO Open_Period_PUB;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
717: THEN
718: FND_MSG_PUB.Add_Exc_Msg(
719: p_pkg_name => G_PKG_NAME,
720: p_procedure_name => l_api_name,
721: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
722: );

Line 813: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

809:
810: -- Check for message level threshold
811: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
812:
813: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
814: THEN
815: FND_MSG_PUB.Add_Exc_Msg(
816: p_pkg_name => G_PKG_NAME,
817: p_procedure_name => l_api_name,

Line 815: FND_MSG_PUB.Add_Exc_Msg(

811: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
812:
813: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
814: THEN
815: FND_MSG_PUB.Add_Exc_Msg(
816: p_pkg_name => G_PKG_NAME,
817: p_procedure_name => l_api_name,
818: p_error_text => SUBSTR(
819: l_stmt_num||':'||

Line 907: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN
905: ROLLBACK TO Verify_PeriodClose_PUB;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg(
910: p_pkg_name => G_PKG_NAME,
911: p_procedure_name => l_api_name,

Line 909: FND_MSG_PUB.Add_Exc_Msg(

905: ROLLBACK TO Verify_PeriodClose_PUB;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg(
910: p_pkg_name => G_PKG_NAME,
911: p_procedure_name => l_api_name,
912: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
913: );

Line 976: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

972: l_stmt_num := 10;
973: -- Check for message level threshold
974: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
975:
976: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
977: THEN
978: FND_MSG_PUB.Add_Exc_Msg(
979: p_pkg_name => G_PKG_NAME,
980: p_procedure_name => l_api_name,

Line 978: FND_MSG_PUB.Add_Exc_Msg(

974: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
975:
976: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
977: THEN
978: FND_MSG_PUB.Add_Exc_Msg(
979: p_pkg_name => G_PKG_NAME,
980: p_procedure_name => l_api_name,
981: p_error_text => SUBSTR(
982: l_stmt_num||':'||

Line 1243: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1239: WHEN OTHERS THEN
1240: ROLLBACK TO Close_Period_PUB;
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: raise_application_error(-20000, 'statement ' || l_stmt_num || ':' || SQLERRM);
1243: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1244: THEN
1245: FND_MSG_PUB.Add_Exc_Msg(
1246: p_pkg_name => G_PKG_NAME,
1247: p_procedure_name => l_api_name,

Line 1245: FND_MSG_PUB.Add_Exc_Msg(

1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: raise_application_error(-20000, 'statement ' || l_stmt_num || ':' || SQLERRM);
1243: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1244: THEN
1245: FND_MSG_PUB.Add_Exc_Msg(
1246: p_pkg_name => G_PKG_NAME,
1247: p_procedure_name => l_api_name,
1248: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
1249: );

Line 1305: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

1301:
1302: -- Check for message level threshold
1303: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1304:
1305: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1306: THEN
1307: FND_MSG_PUB.Add_Exc_Msg(
1308: p_pkg_name => G_PKG_NAME,
1309: p_procedure_name => l_api_name,

Line 1307: FND_MSG_PUB.Add_Exc_Msg(

1303: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1304:
1305: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1306: THEN
1307: FND_MSG_PUB.Add_Exc_Msg(
1308: p_pkg_name => G_PKG_NAME,
1309: p_procedure_name => l_api_name,
1310: p_error_text => SUBSTR(
1311: l_stmt_num||':'||

Line 1399: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: WHEN OTHERS THEN
1397: ROLLBACK TO Update_EndDate_PUB;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1400: THEN
1401: FND_MSG_PUB.Add_Exc_Msg(
1402: p_pkg_name => G_PKG_NAME,
1403: p_procedure_name => l_api_name,

Line 1401: FND_MSG_PUB.Add_Exc_Msg(

1397: ROLLBACK TO Update_EndDate_PUB;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1400: THEN
1401: FND_MSG_PUB.Add_Exc_Msg(
1402: p_pkg_name => G_PKG_NAME,
1403: p_procedure_name => l_api_name,
1404: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
1405: );

Line 1443: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

1439:
1440: -- Check for message level threshold
1441: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1442:
1443: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1444: THEN
1445: FND_MSG_PUB.Add_Exc_Msg(
1446: p_pkg_name => G_PKG_NAME,
1447: p_procedure_name => l_api_name,

Line 1445: FND_MSG_PUB.Add_Exc_Msg(

1441: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1442:
1443: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1444: THEN
1445: FND_MSG_PUB.Add_Exc_Msg(
1446: p_pkg_name => G_PKG_NAME,
1447: p_procedure_name => l_api_name,
1448: p_error_text => SUBSTR(
1449: l_stmt_num||':'||

Line 1472: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: WHEN OTHERS THEN
1470: ROLLBACK TO Revert_PeriodStatus_PUB;
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1473: THEN
1474: FND_MSG_PUB.Add_Exc_Msg(
1475: p_pkg_name => G_PKG_NAME,
1476: p_procedure_name => l_api_name,

Line 1474: FND_MSG_PUB.Add_Exc_Msg(

1470: ROLLBACK TO Revert_PeriodStatus_PUB;
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1473: THEN
1474: FND_MSG_PUB.Add_Exc_Msg(
1475: p_pkg_name => G_PKG_NAME,
1476: p_procedure_name => l_api_name,
1477: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
1478: );

Line 1541: FND_MSG_PUB.Initialize;

1537:
1538: -- Check for message level threshold
1539: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1540:
1541: FND_MSG_PUB.Initialize;
1542:
1543: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1544: THEN
1545: FND_MSG_PUB.Add_Exc_Msg(

Line 1543: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

1539: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1540:
1541: FND_MSG_PUB.Initialize;
1542:
1543: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1544: THEN
1545: FND_MSG_PUB.Add_Exc_Msg(
1546: p_pkg_name => G_PKG_NAME,
1547: p_procedure_name => l_api_name,

Line 1545: FND_MSG_PUB.Add_Exc_Msg(

1541: FND_MSG_PUB.Initialize;
1542:
1543: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1544: THEN
1545: FND_MSG_PUB.Add_Exc_Msg(
1546: p_pkg_name => G_PKG_NAME,
1547: p_procedure_name => l_api_name,
1548: p_error_text => SUBSTR(
1549: l_stmt_num||':'||

Line 1591: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1587: p_to_date,
1588: l_legal_entity);
1589: END IF;
1590:
1591: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1592: THEN
1593: FND_MSG_PUB.Add_Exc_Msg(
1594: p_pkg_name => G_PKG_NAME,
1595: p_procedure_name => l_api_name,

Line 1593: FND_MSG_PUB.Add_Exc_Msg(

1589: END IF;
1590:
1591: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1592: THEN
1593: FND_MSG_PUB.Add_Exc_Msg(
1594: p_pkg_name => G_PKG_NAME,
1595: p_procedure_name => l_api_name,
1596: p_error_text => l_stmt_num||': Using start date of ' || to_char(l_period_start_date,'DD-MON-YYYY HH24:MI:SS')
1597: );

Line 1598: FND_MSG_PUB.Add_Exc_Msg(

1594: p_pkg_name => G_PKG_NAME,
1595: p_procedure_name => l_api_name,
1596: p_error_text => l_stmt_num||': Using start date of ' || to_char(l_period_start_date,'DD-MON-YYYY HH24:MI:SS')
1597: );
1598: FND_MSG_PUB.Add_Exc_Msg(
1599: p_pkg_name => G_PKG_NAME,
1600: p_procedure_name => l_api_name,
1601: p_error_text => l_stmt_num||': Using to date of ' || to_char(l_to_date,'DD-MON-YYYY HH24:MI:SS')
1602: );

Line 1631: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1627: AND acct_period_id = p_period_id);
1628:
1629: IF (l_resummarize > 0) THEN
1630:
1631: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1632: THEN
1633: FND_MSG_PUB.Add_Exc_Msg(
1634: p_pkg_name => G_PKG_NAME,
1635: p_procedure_name => l_api_name,

Line 1633: FND_MSG_PUB.Add_Exc_Msg(

1629: IF (l_resummarize > 0) THEN
1630:
1631: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1632: THEN
1633: FND_MSG_PUB.Add_Exc_Msg(
1634: p_pkg_name => G_PKG_NAME,
1635: p_procedure_name => l_api_name,
1636: p_error_text => l_stmt_num||': Resummarizing: data exists in CPCS for org/period '
1637: ||p_org_id || '/' || p_period_id

Line 1700: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1696: l_prior_end_date := INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(
1697: l_le_prior_end_date,
1698: l_legal_entity);
1699:
1700: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1701: THEN
1702: FND_MSG_PUB.Add_Exc_Msg(
1703: p_pkg_name => G_PKG_NAME,
1704: p_procedure_name => l_api_name,

Line 1702: FND_MSG_PUB.Add_Exc_Msg(

1698: l_legal_entity);
1699:
1700: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1701: THEN
1702: FND_MSG_PUB.Add_Exc_Msg(
1703: p_pkg_name => G_PKG_NAME,
1704: p_procedure_name => l_api_name,
1705: p_error_text => l_stmt_num||': Initializing new summary history in CPCS for org '
1706: ||p_org_id|| ', rolling back to ' || to_char(l_prior_end_date,'DD-MON-YYYY HH24:MI:SS')

Line 1784: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1780: CIQT.subinventory_code,
1781: CIQT.inventory_item_id,
1782: CICT.item_cost;
1783:
1784: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1785: THEN
1786: FND_MSG_PUB.Add_Exc_Msg(
1787: p_pkg_name => G_PKG_NAME,
1788: p_procedure_name => l_api_name,

Line 1786: FND_MSG_PUB.Add_Exc_Msg(

1782: CICT.item_cost;
1783:
1784: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1785: THEN
1786: FND_MSG_PUB.Add_Exc_Msg(
1787: p_pkg_name => G_PKG_NAME,
1788: p_procedure_name => l_api_name,
1789: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
1790: ' rows to CPCST for initialization'

Line 1858: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1854: IF (p_simulation = 1) THEN
1855: DELETE cst_per_close_summary_temp;
1856: END IF;
1857:
1858: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1859: THEN
1860: FND_MSG_PUB.Add_Exc_Msg(
1861: p_pkg_name => G_PKG_NAME,
1862: p_procedure_name => l_api_name,

Line 1860: FND_MSG_PUB.Add_Exc_Msg(

1856: END IF;
1857:
1858: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1859: THEN
1860: FND_MSG_PUB.Add_Exc_Msg(
1861: p_pkg_name => G_PKG_NAME,
1862: p_procedure_name => l_api_name,
1863: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
1864: ' rows to CIQT as baseline from CPCST'

Line 1940: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1936: cst_period_close_summary CPCS
1937: WHERE CPCS.organization_id = p_org_id
1938: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1);
1939:
1940: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1941: THEN
1942: FND_MSG_PUB.Add_Exc_Msg(
1943: p_pkg_name => G_PKG_NAME,
1944: p_procedure_name => l_api_name,

Line 1942: FND_MSG_PUB.Add_Exc_Msg(

1938: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1);
1939:
1940: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1941: THEN
1942: FND_MSG_PUB.Add_Exc_Msg(
1943: p_pkg_name => G_PKG_NAME,
1944: p_procedure_name => l_api_name,
1945: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
1946: ' rows to CIQT as baseline from CPCS'

Line 2041: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2037: MMT.subinventory_code),
2038: MMT.subinventory_code),
2039: MMT.inventory_item_id;
2040:
2041: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2042: THEN
2043: FND_MSG_PUB.Add_Exc_Msg(
2044: p_pkg_name => G_PKG_NAME,
2045: p_procedure_name => l_api_name,

Line 2043: FND_MSG_PUB.Add_Exc_Msg(

2039: MMT.inventory_item_id;
2040:
2041: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2042: THEN
2043: FND_MSG_PUB.Add_Exc_Msg(
2044: p_pkg_name => G_PKG_NAME,
2045: p_procedure_name => l_api_name,
2046: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2047: ' rows to CIQT for same MMT MTA primary quantity'

Line 2086: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2082: MMT.transfer_cost_group_id,
2083: MMT.transfer_subinventory,
2084: MMT.inventory_item_id;
2085:
2086: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2087: THEN
2088: FND_MSG_PUB.Add_Exc_Msg(
2089: p_pkg_name => G_PKG_NAME,
2090: p_procedure_name => l_api_name,

Line 2088: FND_MSG_PUB.Add_Exc_Msg(

2084: MMT.inventory_item_id;
2085:
2086: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2087: THEN
2088: FND_MSG_PUB.Add_Exc_Msg(
2089: p_pkg_name => G_PKG_NAME,
2090: p_procedure_name => l_api_name,
2091: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2092: ' rows to CIQT for different MMT MTA primary quantity'

Line 2127: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2123: DECODE(MMT.transaction_action_id,
2124: 24,MMT.cost_group_id,
2125: MMT.transfer_cost_group_id);
2126:
2127: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2128: THEN
2129: FND_MSG_PUB.Add_Exc_Msg(
2130: p_pkg_name => G_PKG_NAME,
2131: p_procedure_name => l_api_name,

Line 2129: FND_MSG_PUB.Add_Exc_Msg(

2125: MMT.transfer_cost_group_id);
2126:
2127: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2128: THEN
2129: FND_MSG_PUB.Add_Exc_Msg(
2130: p_pkg_name => G_PKG_NAME,
2131: p_procedure_name => l_api_name,
2132: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2133: ' rows to CIQT for intransit quantity'

Line 2208: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2204: CIQT.subinventory_code,
2205: CIQT.inventory_item_id,
2206: CICT.item_cost;
2207:
2208: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2209: THEN
2210: FND_MSG_PUB.Add_Exc_Msg(
2211: p_pkg_name => G_PKG_NAME,
2212: p_procedure_name => l_api_name,

Line 2210: FND_MSG_PUB.Add_Exc_Msg(

2206: CICT.item_cost;
2207:
2208: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2209: THEN
2210: FND_MSG_PUB.Add_Exc_Msg(
2211: p_pkg_name => G_PKG_NAME,
2212: p_procedure_name => l_api_name,
2213: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2214: ' rows to CPCST for simulation purposes'

Line 2319: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2315: CIQT.subinventory_code,
2316: CIQT.inventory_item_id,
2317: CICT.item_cost;
2318:
2319: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2320: THEN
2321: FND_MSG_PUB.Add_Exc_Msg(
2322: p_pkg_name => G_PKG_NAME,
2323: p_procedure_name => l_api_name,

Line 2321: FND_MSG_PUB.Add_Exc_Msg(

2317: CICT.item_cost;
2318:
2319: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2320: THEN
2321: FND_MSG_PUB.Add_Exc_Msg(
2322: p_pkg_name => G_PKG_NAME,
2323: p_procedure_name => l_api_name,
2324: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2325: ' rows to CPCS for org/period ' || p_org_id || '/' || p_period_id

Line 2345: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2342: WHEN NO_PREV_SUMMARY_EXISTS THEN
2343: ROLLBACK TO Summarize_Period_PUB;
2344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2345: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2346: THEN
2347: FND_MSG_PUB.Add_Exc_Msg(
2348: p_pkg_name => G_PKG_NAME,
2349: p_procedure_name => l_api_name,

Line 2347: FND_MSG_PUB.Add_Exc_Msg(

2343: ROLLBACK TO Summarize_Period_PUB;
2344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2345: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2346: THEN
2347: FND_MSG_PUB.Add_Exc_Msg(
2348: p_pkg_name => G_PKG_NAME,
2349: p_procedure_name => l_api_name,
2350: p_error_text => l_stmt_num||': Only first unsummarized period can be summarized'
2351: );

Line 2357: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2353:
2354: WHEN OTHERS THEN
2355: ROLLBACK TO Summarize_Period_PUB;
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2357: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2358: THEN
2359: FND_MSG_PUB.Add_Exc_Msg(
2360: p_pkg_name => G_PKG_NAME,
2361: p_procedure_name => l_api_name,

Line 2359: FND_MSG_PUB.Add_Exc_Msg(

2355: ROLLBACK TO Summarize_Period_PUB;
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2357: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2358: THEN
2359: FND_MSG_PUB.Add_Exc_Msg(
2360: p_pkg_name => G_PKG_NAME,
2361: p_procedure_name => l_api_name,
2362: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
2363: );