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.BIS_BUCKET_PVT dependencies on BIS_UTILITIES_PVT

Line 930: BIS_UTILITIES_PVT.Add_Error_Message (

926:
927: IF (l_short_count > 0) THEN
928:
929: l_error_tbl := x_error_tbl ;
930: BIS_UTILITIES_PVT.Add_Error_Message (
931: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
932: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
933: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
934: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1195: BIS_UTILITIES_PVT.Add_Error_Message (

1191: ROLLBACK TO SAVEPOINT SP_CREATE_BUCKET;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1193:
1194: l_error_tbl := x_error_tbl;
1195: BIS_UTILITIES_PVT.Add_Error_Message (
1196: p_error_msg_id => SQLCODE
1197: ,p_error_description => SQLERRM
1198: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
1199: ,p_error_table => l_error_tbl

Line 1253: BIS_UTILITIES_PVT.Add_Error_Message (

1249: FROM BIS_BUCKET
1250: WHERE BUCKET_ID = p_bis_bucket_rec.bucket_id;
1251: ELSE
1252: l_error_tbl := x_error_tbl ;
1253: BIS_UTILITIES_PVT.Add_Error_Message (
1254: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
1255: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1256: ,p_error_proc_name => G_PKG_NAME||'.UPDATE_BIS_BUCKET'
1257: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1423: BIS_UTILITIES_PVT.Add_Error_Message (

1419: EXCEPTION
1420: WHEN NO_DATA_FOUND THEN
1421: ROLLBACK TO SAVEPOINT SP_UPDATE_BUCKET;
1422: l_error_tbl := x_error_tbl;
1423: BIS_UTILITIES_PVT.Add_Error_Message (
1424: p_error_msg_name => 'BIS_INVALID_BUCKET_ID_NAME'
1425: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1426: ,p_error_proc_name => G_PKG_NAME||'.UPDATE_BIS_BUCKET'
1427: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1441: BIS_UTILITIES_PVT.Add_Error_Message (

1437: WHEN others THEN
1438: ROLLBACK TO SAVEPOINT SP_UPDATE_BUCKET;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1440: l_error_tbl := x_error_tbl;
1441: BIS_UTILITIES_PVT.Add_Error_Message (
1442: p_error_msg_id => SQLCODE
1443: ,p_error_description => SQLERRM
1444: ,p_error_proc_name => G_PKG_NAME||'.UPDATE_BIS_BUCKET'
1445: ,p_error_table => l_error_tbl

Line 1502: BIS_UTILITIES_PVT.Add_Error_Message (

1498: WHERE BUCKET_ID = p_bucket_id;
1499:
1500: IF (l_dcount = 0) THEN
1501: l_error_tbl := x_error_tbl ;
1502: BIS_UTILITIES_PVT.Add_Error_Message (
1503: p_error_msg_name => 'BIS_INVALID_BUCKET_ID'
1504: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1505: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1506: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1530: BIS_UTILITIES_PVT.Add_Error_Message (

1526:
1527: END IF;
1528: ELSE
1529: l_error_tbl := x_error_tbl ;
1530: BIS_UTILITIES_PVT.Add_Error_Message (
1531: p_error_msg_name => 'BIS_INVALID_BUCKET_ID_NAME'
1532: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1533: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1534: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1548: BIS_UTILITIES_PVT.Add_Error_Message (

1544: EXCEPTION
1545: WHEN NO_DATA_FOUND THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR ;
1547: l_error_tbl := x_error_tbl ;
1548: BIS_UTILITIES_PVT.Add_Error_Message (
1549: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
1550: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1551: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1552: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1566: BIS_UTILITIES_PVT.Add_Error_Message (

1562: ROLLBACK;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1564:
1565: l_error_tbl := x_error_tbl;
1566: BIS_UTILITIES_PVT.Add_Error_Message (
1567: p_error_msg_id => SQLCODE
1568: ,p_error_description => SQLERRM
1569: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BIS_BUCKET'
1570: ,p_error_table => l_error_tbl

Line 1651: BIS_UTILITIES_PVT.Add_Error_Message (

1647: WHERE SHORT_NAME = p_short_name;
1648:
1649: IF ((l_ret_name = FND_API.G_TRUE) OR (l_dcount = 0)) THEN
1650: l_error_tbl := x_error_tbl ;
1651: BIS_UTILITIES_PVT.Add_Error_Message (
1652: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
1653: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1654: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1655: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1728: BIS_UTILITIES_PVT.Add_Error_Message (

1724: END IF;
1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1726:
1727: l_error_tbl := x_error_tbl;
1728: BIS_UTILITIES_PVT.Add_Error_Message (
1729: p_error_msg_id => SQLCODE
1730: ,p_error_description => SQLERRM
1731: ,p_error_proc_name => G_PKG_NAME||'.RETRIEVE_BIS_BUCKET'
1732: ,p_error_table => l_error_tbl

Line 1833: BIS_UTILITIES_PVT.Add_Error_Message(

1829: WHEN OTHERS THEN
1830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1831:
1832: l_error_tbl := x_error_tbl;
1833: BIS_UTILITIES_PVT.Add_Error_Message(
1834: p_error_msg_id => SQLCODE
1835: ,p_error_description => SQLERRM
1836: ,p_error_proc_name => G_PKG_NAME||'.Translate_bucket'
1837: ,p_error_table => l_error_tbl

Line 2401: BIS_UTILITIES_PVT.Add_Error_Message (

2397: l_bis_bucket_rec := p_bis_bucket_rec;
2398:
2399: IF NOT (IS_VALID_APPLICATION_ID(p_application_id => l_bis_bucket_rec.application_id)) THEN
2400: l_error_tbl := x_error_tbl;
2401: BIS_UTILITIES_PVT.Add_Error_Message (
2402: p_error_msg_name => 'BIS_INVALID_APPLICATION_ID'
2403: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2404: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET_APPLICATION_ID'
2405: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2618: BIS_UTILITIES_PVT.Add_Error_Message (

2614:
2615: EXCEPTION
2616: WHEN OTHERS THEN
2617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2618: BIS_UTILITIES_PVT.Add_Error_Message (
2619: p_error_msg_id => SQLCODE
2620: ,p_error_description => SQLERRM
2621: ,p_error_proc_name => G_PKG_NAME||'.Populate_Loc_Bucket_Range_Tbl'
2622: ,p_error_table => l_error_tbl

Line 2670: BIS_UTILITIES_PVT.Add_Error_Message (

2666:
2667: EXCEPTION
2668: WHEN FND_API.G_EXC_ERROR THEN -- overlapping occurs
2669: x_return_status := FND_API.G_RET_STS_ERROR;
2670: BIS_UTILITIES_PVT.Add_Error_Message (
2671: p_error_msg_name => 'BIS_BUCKET_SET_OVERLAPPING'
2672: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2673: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Overlapping'
2674: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2681: BIS_UTILITIES_PVT.Add_Error_Message (

2677: );
2678: RAISE FND_API.G_EXC_ERROR;
2679: WHEN OTHERS THEN
2680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2681: BIS_UTILITIES_PVT.Add_Error_Message (
2682: p_error_msg_id => SQLCODE
2683: ,p_error_description => SQLERRM
2684: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Overlapping'
2685: ,p_error_table => l_error_tbl

Line 2732: BIS_UTILITIES_PVT.Add_Error_Message (

2728:
2729: EXCEPTION
2730: WHEN FND_API.G_EXC_ERROR THEN -- discontinuous occurs
2731: x_return_status := FND_API.G_RET_STS_ERROR;
2732: BIS_UTILITIES_PVT.Add_Error_Message (
2733: p_error_msg_name => 'BIS_BUCKET_SET_DISCONTINUOUS'
2734: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2735: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Discontinuous'
2736: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2743: BIS_UTILITIES_PVT.Add_Error_Message (

2739: );
2740: RAISE FND_API.G_EXC_ERROR;
2741: WHEN OTHERS THEN
2742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2743: BIS_UTILITIES_PVT.Add_Error_Message (
2744: p_error_msg_id => SQLCODE
2745: ,p_error_description => SQLERRM
2746: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Discontinuous'
2747: ,p_error_table => l_error_tbl

Line 2786: BIS_UTILITIES_PVT.Add_Error_Message (

2782:
2783: EXCEPTION
2784: WHEN FND_API.G_EXC_ERROR THEN -- FROM > TO
2785: x_return_status := FND_API.G_RET_STS_ERROR;
2786: BIS_UTILITIES_PVT.Add_Error_Message (
2787: p_error_msg_name => l_error_message
2788: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2789: ,p_error_proc_name => G_PKG_NAME||'.Validate_From_To'
2790: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2797: BIS_UTILITIES_PVT.Add_Error_Message (

2793: );
2794: RAISE FND_API.G_EXC_ERROR;
2795: WHEN OTHERS THEN
2796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2797: BIS_UTILITIES_PVT.Add_Error_Message (
2798: p_error_msg_id => SQLCODE
2799: ,p_error_description => SQLERRM
2800: ,p_error_proc_name => G_PKG_NAME||'.Validate_From_To'
2801: ,p_error_table => l_error_tbl

Line 2973: BIS_UTILITIES_PVT.Add_Error_Message (

2969: l_bis_bucket_rec := p_bis_bucket_rec;
2970:
2971: IF NOT (IS_BUCKET_TYPE_EXISTS(p_bucket_type=> l_bis_bucket_rec.type)) THEN
2972: l_error_tbl := x_error_tbl;
2973: BIS_UTILITIES_PVT.Add_Error_Message (
2974: p_error_msg_name => 'BIS_INVALID_BUCKET_TYPE'
2975: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2976: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET_TYPE'
2977: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2986: BIS_UTILITIES_PVT.Add_Error_Message (

2982: END IF;
2983:
2984: IF NOT ( CHECK_RANGE_NAME(p_bis_bucket_rec => l_bis_bucket_rec) ) THEN
2985: l_error_tbl := x_error_tbl;
2986: BIS_UTILITIES_PVT.Add_Error_Message (
2987: p_error_msg_name => 'BIS_DUPLICATE_RANGE_NAME'
2988: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2989: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
2990: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2999: BIS_UTILITIES_PVT.Add_Error_Message (

2995: END IF;
2996:
2997: IF NOT ( CHECK_RANGE_VAL_HIGH(p_bis_bucket_rec => l_bis_bucket_rec) ) THEN
2998: l_error_tbl := x_error_tbl;
2999: BIS_UTILITIES_PVT.Add_Error_Message (
3000: p_error_msg_name => 'BIS_DUPLICATE_VAL_HIGH'
3001: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3002: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
3003: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3012: BIS_UTILITIES_PVT.Add_Error_Message (

3008: END IF;
3009:
3010: IF NOT ( CHECK_RANGE_VAL_LOW(p_bis_bucket_rec => l_bis_bucket_rec) ) THEN
3011: l_error_tbl := x_error_tbl;
3012: BIS_UTILITIES_PVT.Add_Error_Message (
3013: p_error_msg_name => 'BIS_DUPLICATE_VAL_LOW'
3014: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3015: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
3016: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR