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 1546: FND_MSG_PUB.Initialize;

1542:
1543: -- Check for message level threshold
1544: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1545:
1546: FND_MSG_PUB.Initialize;
1547:
1548: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1549: THEN
1550: FND_MSG_PUB.Add_Exc_Msg(

Line 1548: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

1544: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');
1545:
1546: FND_MSG_PUB.Initialize;
1547:
1548: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1549: THEN
1550: FND_MSG_PUB.Add_Exc_Msg(
1551: p_pkg_name => G_PKG_NAME,
1552: p_procedure_name => l_api_name,

Line 1550: FND_MSG_PUB.Add_Exc_Msg(

1546: FND_MSG_PUB.Initialize;
1547:
1548: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
1549: THEN
1550: FND_MSG_PUB.Add_Exc_Msg(
1551: p_pkg_name => G_PKG_NAME,
1552: p_procedure_name => l_api_name,
1553: p_error_text => SUBSTR(
1554: l_stmt_num||':'||

Line 1596: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1592: p_to_date,
1593: l_legal_entity);
1594: END IF;
1595:
1596: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1597: THEN
1598: FND_MSG_PUB.Add_Exc_Msg(
1599: p_pkg_name => G_PKG_NAME,
1600: p_procedure_name => l_api_name,

Line 1598: FND_MSG_PUB.Add_Exc_Msg(

1594: END IF;
1595:
1596: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1597: THEN
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 start date of ' || to_char(l_period_start_date,'DD-MON-YYYY HH24:MI:SS')
1602: );

Line 1603: 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 start date of ' || to_char(l_period_start_date,'DD-MON-YYYY HH24:MI:SS')
1602: );
1603: FND_MSG_PUB.Add_Exc_Msg(
1604: p_pkg_name => G_PKG_NAME,
1605: p_procedure_name => l_api_name,
1606: p_error_text => l_stmt_num||': Using to date of ' || to_char(l_to_date,'DD-MON-YYYY HH24:MI:SS')
1607: );

Line 1626: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1622: IF l_err_num = 0 THEN
1623: l_err_msg := 'Invalid return value from hook: ' || l_zero_val_hook;
1624: END IF;
1625:
1626: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg(
1629: p_pkg_name => G_PKG_NAME,
1630: p_procedure_name => l_api_name,

Line 1628: FND_MSG_PUB.Add_Exc_Msg(

1624: END IF;
1625:
1626: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg(
1629: p_pkg_name => G_PKG_NAME,
1630: p_procedure_name => l_api_name,
1631: p_error_text => l_stmt_num||': Error in CST_Common_hooks.get_prd_cls_zeroval_option: ' || l_err_msg || '(' || l_err_code || ')'
1632: );

Line 1639: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1635: RAISE ZERO_VAL_SUMMARY_OPTION_ERROR;
1636:
1637: END IF;
1638:
1639: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1640: THEN
1641: FND_MSG_PUB.Add_Exc_Msg(
1642: p_pkg_name => G_PKG_NAME,
1643: p_procedure_name => l_api_name,

Line 1641: FND_MSG_PUB.Add_Exc_Msg(

1637: END IF;
1638:
1639: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1640: THEN
1641: FND_MSG_PUB.Add_Exc_Msg(
1642: p_pkg_name => G_PKG_NAME,
1643: p_procedure_name => l_api_name,
1644: p_error_text => l_stmt_num||': Period Close Summarization option for zero value items is: ' || l_zero_val_hook
1645: );

Line 1674: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1670: AND acct_period_id = p_period_id);
1671:
1672: IF (l_resummarize > 0) THEN
1673:
1674: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1675: THEN
1676: FND_MSG_PUB.Add_Exc_Msg(
1677: p_pkg_name => G_PKG_NAME,
1678: p_procedure_name => l_api_name,

Line 1676: FND_MSG_PUB.Add_Exc_Msg(

1672: IF (l_resummarize > 0) THEN
1673:
1674: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1675: THEN
1676: FND_MSG_PUB.Add_Exc_Msg(
1677: p_pkg_name => G_PKG_NAME,
1678: p_procedure_name => l_api_name,
1679: p_error_text => l_stmt_num||': Resummarizing: data exists in CPCS for org/period '
1680: ||p_org_id || '/' || p_period_id

Line 1743: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1739: l_prior_end_date := INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(
1740: l_le_prior_end_date,
1741: l_legal_entity);
1742:
1743: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1744: THEN
1745: FND_MSG_PUB.Add_Exc_Msg(
1746: p_pkg_name => G_PKG_NAME,
1747: p_procedure_name => l_api_name,

Line 1745: FND_MSG_PUB.Add_Exc_Msg(

1741: l_legal_entity);
1742:
1743: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1744: THEN
1745: FND_MSG_PUB.Add_Exc_Msg(
1746: p_pkg_name => G_PKG_NAME,
1747: p_procedure_name => l_api_name,
1748: p_error_text => l_stmt_num||': Initializing new summary history in CPCS for org '
1749: ||p_org_id|| ', rolling back to ' || to_char(l_prior_end_date,'DD-MON-YYYY HH24:MI:SS')

Line 1832: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1828: SUM(NVL(CIQT.rollback_qty,0)) <> 0 OR
1829: l_zero_val_hook = 0;
1830:
1831:
1832: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg(
1835: p_pkg_name => G_PKG_NAME,
1836: p_procedure_name => l_api_name,

Line 1834: FND_MSG_PUB.Add_Exc_Msg(

1830:
1831:
1832: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg(
1835: p_pkg_name => G_PKG_NAME,
1836: p_procedure_name => l_api_name,
1837: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
1838: ' rows to CPCST for initialization'

Line 1906: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

1902: IF (p_simulation = 1) THEN
1903: DELETE cst_per_close_summary_temp;
1904: END IF;
1905:
1906: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1907: THEN
1908: FND_MSG_PUB.Add_Exc_Msg(
1909: p_pkg_name => G_PKG_NAME,
1910: p_procedure_name => l_api_name,

Line 1908: FND_MSG_PUB.Add_Exc_Msg(

1904: END IF;
1905:
1906: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1907: THEN
1908: FND_MSG_PUB.Add_Exc_Msg(
1909: p_pkg_name => G_PKG_NAME,
1910: p_procedure_name => l_api_name,
1911: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
1912: ' rows to CIQT as baseline from CPCST'

Line 2062: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2058: accounted_onhand_value <> 0 OR
2059: accounted_intransit_value <> 0 OR
2060: l_zero_val_hook = 0);
2061:
2062: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2063: THEN
2064: FND_MSG_PUB.Add_Exc_Msg(
2065: p_pkg_name => G_PKG_NAME,
2066: p_procedure_name => l_api_name,

Line 2064: FND_MSG_PUB.Add_Exc_Msg(

2060: l_zero_val_hook = 0);
2061:
2062: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2063: THEN
2064: FND_MSG_PUB.Add_Exc_Msg(
2065: p_pkg_name => G_PKG_NAME,
2066: p_procedure_name => l_api_name,
2067: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2068: ' rows to CIQT as baseline from CPCS'

Line 2166: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2162: /* Bug 14036099 */
2163: HAVING (SUM(base_transaction_value) <> 0
2164: OR l_zero_val_hook = 0);
2165:
2166: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2167: THEN
2168: FND_MSG_PUB.Add_Exc_Msg(
2169: p_pkg_name => G_PKG_NAME,
2170: p_procedure_name => l_api_name,

Line 2168: FND_MSG_PUB.Add_Exc_Msg(

2164: OR l_zero_val_hook = 0);
2165:
2166: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2167: THEN
2168: FND_MSG_PUB.Add_Exc_Msg(
2169: p_pkg_name => G_PKG_NAME,
2170: p_procedure_name => l_api_name,
2171: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2172: ' rows to CIQT for same MMT MTA primary quantity'

Line 2214: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2210: /* Bug 14036099 */
2211: HAVING (SUM(base_transaction_value) <> 0
2212: OR l_zero_val_hook = 0);
2213:
2214: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg(
2217: p_pkg_name => G_PKG_NAME,
2218: p_procedure_name => l_api_name,

Line 2216: FND_MSG_PUB.Add_Exc_Msg(

2212: OR l_zero_val_hook = 0);
2213:
2214: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg(
2217: p_pkg_name => G_PKG_NAME,
2218: p_procedure_name => l_api_name,
2219: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2220: ' rows to CIQT for different MMT MTA primary quantity'

Line 2264: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2260: /* Bug 14036099 */
2261: HAVING (SUM(MTA.base_transaction_value) <> 0
2262: OR l_zero_val_hook = 0);
2263:
2264: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2265: THEN
2266: FND_MSG_PUB.Add_Exc_Msg(
2267: p_pkg_name => G_PKG_NAME,
2268: p_procedure_name => l_api_name,

Line 2266: FND_MSG_PUB.Add_Exc_Msg(

2262: OR l_zero_val_hook = 0);
2263:
2264: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2265: THEN
2266: FND_MSG_PUB.Add_Exc_Msg(
2267: p_pkg_name => G_PKG_NAME,
2268: p_procedure_name => l_api_name,
2269: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2270: ' rows to CIQT for intransit quantity'

Line 2353: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2349: OR SUM(NVL(CIQT.rollback_qty,0))*NVL(CICT.item_cost,0) <> 0
2350: OR SUM(NVL(CIQT.rollback_qty,0)) <> 0
2351: OR l_zero_val_hook = 0;
2352:
2353: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2354: THEN
2355: FND_MSG_PUB.Add_Exc_Msg(
2356: p_pkg_name => G_PKG_NAME,
2357: p_procedure_name => l_api_name,

Line 2355: FND_MSG_PUB.Add_Exc_Msg(

2351: OR l_zero_val_hook = 0;
2352:
2353: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2354: THEN
2355: FND_MSG_PUB.Add_Exc_Msg(
2356: p_pkg_name => G_PKG_NAME,
2357: p_procedure_name => l_api_name,
2358: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2359: ' rows to CPCST for simulation purposes'

Line 2485: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

2481: 12,NVL(CIQT.accounted_value,0),
2482: 0)) <> 0
2483: OR l_zero_val_hook = 0;
2484:
2485: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2486: THEN
2487: FND_MSG_PUB.Add_Exc_Msg(
2488: p_pkg_name => G_PKG_NAME,
2489: p_procedure_name => l_api_name,

Line 2487: FND_MSG_PUB.Add_Exc_Msg(

2483: OR l_zero_val_hook = 0;
2484:
2485: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
2486: THEN
2487: FND_MSG_PUB.Add_Exc_Msg(
2488: p_pkg_name => G_PKG_NAME,
2489: p_procedure_name => l_api_name,
2490: p_error_text => l_stmt_num||': Inserted '||SQL%ROWCOUNT||
2491: ' rows to CPCS for org/period ' || p_org_id || '/' || p_period_id

Line 2516: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2512:
2513: WHEN NO_PREV_SUMMARY_EXISTS THEN
2514: ROLLBACK TO Summarize_Period_PUB;
2515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2516: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2517: THEN
2518: FND_MSG_PUB.Add_Exc_Msg(
2519: p_pkg_name => G_PKG_NAME,
2520: p_procedure_name => l_api_name,

Line 2518: FND_MSG_PUB.Add_Exc_Msg(

2514: ROLLBACK TO Summarize_Period_PUB;
2515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2516: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2517: THEN
2518: FND_MSG_PUB.Add_Exc_Msg(
2519: p_pkg_name => G_PKG_NAME,
2520: p_procedure_name => l_api_name,
2521: p_error_text => l_stmt_num||': Only first unsummarized period can be summarized'
2522: );

Line 2528: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2524:
2525: WHEN OTHERS THEN
2526: ROLLBACK TO Summarize_Period_PUB;
2527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2528: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2529: THEN
2530: FND_MSG_PUB.Add_Exc_Msg(
2531: p_pkg_name => G_PKG_NAME,
2532: p_procedure_name => l_api_name,

Line 2530: FND_MSG_PUB.Add_Exc_Msg(

2526: ROLLBACK TO Summarize_Period_PUB;
2527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2528: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2529: THEN
2530: FND_MSG_PUB.Add_Exc_Msg(
2531: p_pkg_name => G_PKG_NAME,
2532: p_procedure_name => l_api_name,
2533: p_error_text => l_stmt_num||SUBSTR(SQLERRM,1,235)
2534: );