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.BSC_BIS_DIM_REL_PUB dependencies on FND_MSG_PUB

Line 461: FND_MSG_PUB.Initialize;

457: l_tab VARCHAR2(30);
458: l_Sql VARCHAR2(32000);
459: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
460: BEGIN
461: FND_MSG_PUB.Initialize;
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:
464: IF((p_dim_obj_id IS NOT NULL) AND (p_par_dim_obj_id IS NOT NULL)) THEN
465: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_dim_obj_id)

Line 538: FND_MSG_PUB.Count_And_Get

534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: IF (x_msg_data IS NULL) THEN
538: FND_MSG_PUB.Count_And_Get
539: ( p_encoded => FND_API.G_FALSE
540: , p_count => x_msg_count
541: , p_data => x_msg_data
542: );

Line 596: FND_MSG_PUB.Initialize;

592: l_view_text VARCHAR2(32000);
593:
594: BEGIN
595:
596: FND_MSG_PUB.Initialize;
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: BSC_APPS.Init_Bsc_Apps;
599:
600: IF(BSC_UTILITY.is_View_Exists(p_level_view_name)) THEN

Line 668: FND_MSG_PUB.Initialize;

664: l_new_count NUMBER;
665:
666:
667: BEGIN
668: FND_MSG_PUB.Initialize;
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: l_new_count := x_new_rel_Table.COUNT;
672: l_old_count := x_prev_rel_Table.COUNT;

Line 831: FND_MSG_PUB.Count_And_Get

827:
828: EXCEPTION
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: IF (x_msg_data IS NULL) THEN
831: FND_MSG_PUB.Count_And_Get
832: ( p_encoded => FND_API.G_FALSE
833: , p_count => x_msg_count
834: , p_data => x_msg_data
835: );

Line 924: FND_MSG_PUB.Initialize;

920: l_inner_loop NUMBER;
921: l_found_count NUMBER;
922:
923: BEGIN
924: FND_MSG_PUB.Initialize;
925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926: l_new_rel_Table := x_new_rel_Table;
927: l_prev_rel_Table := x_prev_rel_Table;
928:

Line 1152: FND_MSG_PUB.Count_And_Get

1148:
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: IF (x_msg_data IS NULL) THEN
1152: FND_MSG_PUB.Count_And_Get
1153: ( p_encoded => FND_API.G_FALSE
1154: , p_count => x_msg_count
1155: , p_data => x_msg_data
1156: );

Line 1253: FND_MSG_PUB.Initialize;

1249: WHERE parent_dim_level_id = p_dim_obj_id
1250: AND relation_type = 1;
1251: BEGIN
1252: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');
1253: FND_MSG_PUB.Initialize;
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

Line 1258: FND_MSG_PUB.ADD;

1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261: IF (p_parent_ids IS NOT NULL) THEN
1262: l_parent_ids := p_parent_ids;

Line 1384: FND_MSG_PUB.Count_And_Get

1380: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');
1381: EXCEPTION
1382: WHEN FND_API.G_EXC_ERROR THEN
1383: IF (x_msg_data IS NULL) THEN
1384: FND_MSG_PUB.Count_And_Get
1385: ( p_encoded => FND_API.G_FALSE
1386: , p_count => x_msg_count
1387: , p_data => x_msg_data
1388: );

Line 1394: FND_MSG_PUB.Count_And_Get

1390: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: IF (x_msg_data IS NULL) THEN
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_encoded => FND_API.G_FALSE
1396: , p_count => x_msg_count
1397: , p_data => x_msg_data
1398: );

Line 1552: FND_MSG_PUB.Initialize;

1548: l_Is_PMF_Recur_Type BOOLEAN;
1549:
1550: BEGIN
1551: SAVEPOINT AssUnassBSCRelsPMD;
1552: FND_MSG_PUB.Initialize;
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;
1554: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');
1555: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||p_dim_obj_id);
1556: --DBMS_OUTPUT.PUT_LINE('p_parent_ids '||p_parent_ids);

Line 1569: FND_MSG_PUB.ADD;

1565: --DBMS_OUTPUT.PUT_LINE('p_child_data_source '||p_child_data_source);
1566: IF (p_dim_obj_id IS NULL) THEN
1567: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: SELECT COUNT(*) INTO l_count
1573: FROM BSC_SYS_DIM_LEVELS_B

Line 1579: FND_MSG_PUB.ADD;

1575: IF (l_count = 0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;
1582:
1583: -- Restrict Period Dim Object from relationship.

Line 1820: FND_MSG_PUB.ADD;

1816: IF (l_bsc_dim_obj_rec.bsc_parent_level_source <> l_bsc_dim_obj_rec.Bsc_Source) THEN
1817: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1818: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1819: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1823: END IF;
1824: --DBMS_OUTPUT.PUT_LINE('l_bsc_dim_obj_rec.bsc_level_id <'||l_bsc_dim_obj_rec.bsc_level_id);

Line 1850: FND_MSG_PUB.ADD;

1846: IF ((l_bsc_dim_obj_rec.bsc_relation_type = 2) AND
1847: (l_bsc_dim_obj_rec.Bsc_Level_Id = l_bsc_dim_obj_rec.bsc_parent_level_id)) THEN
1848: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1849: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1850: FND_MSG_PUB.ADD;
1851: RAISE FND_API.G_EXC_ERROR;
1852: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1853: END IF;
1854: SELECT COUNT(*) INTO l_count

Line 1881: FND_MSG_PUB.ADD;

1877: WHERE dim_level_id = l_bsc_dim_obj_rec.bsc_parent_level_id
1878: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
1879: IF (l_count <> 0) THEN
1880: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
1881: FND_MSG_PUB.ADD;
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884: END IF;
1885: --DBMS_OUTPUT.PUT_LINE('reached I 6');

Line 1916: FND_MSG_PUB.ADD;

1912: END IF;
1913: -- END Granluar Locking
1914: ELSE
1915: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: END IF;
1919: END LOOP;
1920: --DBMS_OUTPUT.PUT_LINE('reached I 9');

Line 1967: FND_MSG_PUB.ADD;

1963: IF(l_bsc_dim_obj_rec.bsc_parent_level_source <> l_bsc_dim_obj_rec.Bsc_Source) THEN
1964: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1965: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1966: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1967: FND_MSG_PUB.ADD;
1968: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
1969: RAISE FND_API.G_EXC_ERROR;
1970:
1971: END IF;

Line 1999: FND_MSG_PUB.ADD;

1995: IF ((l_bsc_dim_obj_rec.bsc_relation_type = 2) AND
1996: (l_bsc_dim_obj_rec.Bsc_Level_Id = l_bsc_dim_obj_rec.bsc_parent_level_id)) THEN
1997: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1998: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1999: FND_MSG_PUB.ADD;
2000: RAISE FND_API.G_EXC_ERROR;
2001: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
2002: END IF;
2003:

Line 2042: FND_MSG_PUB.ADD;

2038: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Parent_Level_Id
2039: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
2040: IF (l_count <> 0) THEN
2041: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
2042: FND_MSG_PUB.ADD;
2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: END IF;
2046:

Line 2087: FND_MSG_PUB.ADD;

2083: END IF;
2084:
2085: IF (NOT ((l_db_child_rel_type = 2) AND (l_bsc_dim_obj_rec.bsc_relation_type = 2)) AND l_Is_PMF_Recur_Type = FALSE)THEN
2086: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
2087: FND_MSG_PUB.ADD;
2088: RAISE FND_API.G_EXC_ERROR;
2089: END IF;
2090: END IF;
2091: END LOOP;

Line 2297: FND_MSG_PUB.ADD;

2293: WHERE A.Dim_Level_Id = l_One_N_Table(i).p_dim_obj_id
2294: AND A.Relation_Type = 1;
2295: IF (l_Count > MAX_PARENTS_RELS_1_N) THEN
2296: FND_MESSAGE.SET_NAME('BSC','BSC_MAX_DIM_OBJ_RELS');
2297: FND_MSG_PUB.ADD;
2298: RAISE FND_API.G_EXC_ERROR;
2299: END IF;
2300: END IF;
2301: END LOOP;

Line 2477: FND_MSG_PUB.Count_And_Get

2473: CLOSE c_db_child_type;
2474: END IF;
2475: ROLLBACK TO AssUnassBSCRelsPMD;
2476: IF (x_msg_data IS NULL) THEN
2477: FND_MSG_PUB.Count_And_Get
2478: ( p_encoded => FND_API.G_FALSE
2479: , p_count => x_msg_count
2480: , p_data => x_msg_data
2481: );

Line 2491: FND_MSG_PUB.Count_And_Get

2487: END IF;
2488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2489: ROLLBACK TO AssUnassBSCRelsPMD;
2490: IF (x_msg_data IS NULL) THEN
2491: FND_MSG_PUB.Count_And_Get
2492: ( p_encoded => FND_API.G_FALSE
2493: , p_count => x_msg_count
2494: , p_data => x_msg_data
2495: );

Line 2571: FND_MSG_PUB.Initialize;

2567: WHERE parent_dim_level_id = p_dim_obj_id
2568: AND relation_type = 1;
2569: BEGIN
2570: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');
2571: FND_MSG_PUB.Initialize;
2572: x_return_status := FND_API.G_RET_STS_SUCCESS;
2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

Line 2576: FND_MSG_PUB.ADD;

2572: x_return_status := FND_API.G_RET_STS_SUCCESS;
2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2576: FND_MSG_PUB.ADD;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END IF;
2579: FOR cd IN c_parent_ids LOOP
2580: l_dim_obj_ids := p_parent_ids;

Line 2691: FND_MSG_PUB.Count_And_Get

2687: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');
2688: EXCEPTION
2689: WHEN FND_API.G_EXC_ERROR THEN
2690: IF (x_msg_data IS NULL) THEN
2691: FND_MSG_PUB.Count_And_Get
2692: ( p_encoded => FND_API.G_FALSE
2693: , p_count => x_msg_count
2694: , p_data => x_msg_data
2695: );

Line 2701: FND_MSG_PUB.Count_And_Get

2697: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2700: IF (x_msg_data IS NULL) THEN
2701: FND_MSG_PUB.Count_And_Get
2702: ( p_encoded => FND_API.G_FALSE
2703: , p_count => x_msg_count
2704: , p_data => x_msg_data
2705: );

Line 2967: FND_MSG_PUB.Initialize;

2963: AND B.Dim_Level_Id = A.Parent_Dim_Level_Id
2964: AND A.Relation_Type = 1;
2965: BEGIN
2966: SAVEPOINT CreateBSC1toNTabsPMD;
2967: FND_MSG_PUB.Initialize;
2968: x_return_status := FND_API.G_RET_STS_SUCCESS;
2969: BSC_APPS.Init_Bsc_Apps;
2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN

Line 2974: FND_MSG_PUB.ADD;

2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: END IF;
2977: IF (p_dim_obj_id IS NOT NULL) THEN
2978: -- Bug #3236356

Line 2987: FND_MSG_PUB.ADD;

2983: IF (l_count = 0) THEN
2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;
2990: END IF;
2991: --DBMS_OUTPUT.PUT_LINE('2 ');

Line 3243: FND_MSG_PUB.Count_And_Get

3239: RETURN FALSE;
3240: WHEN FND_API.G_EXC_ERROR THEN
3241: ROLLBACK TO CreateBSC1toNTabsPMD;
3242: IF (x_msg_data IS NULL) THEN
3243: FND_MSG_PUB.Count_And_Get
3244: ( p_encoded => FND_API.G_FALSE
3245: , p_count => x_msg_count
3246: , p_data => x_msg_data
3247: );

Line 3255: FND_MSG_PUB.Count_And_Get

3251: RETURN FALSE;
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: ROLLBACK TO CreateBSC1toNTabsPMD;
3254: IF (x_msg_data IS NULL) THEN
3255: FND_MSG_PUB.Count_And_Get
3256: ( p_encoded => FND_API.G_FALSE
3257: , p_count => x_msg_count
3258: , p_data => x_msg_data
3259: );

Line 3315: FND_MSG_PUB.Initialize;

3311: l_master_table VARCHAR2(30);
3312: l_input_table VARCHAR2(30);
3313: BEGIN
3314: SAVEPOINT CreateBSCMtoNTabsPMD;
3315: FND_MSG_PUB.Initialize;
3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 3321: FND_MSG_PUB.ADD;

3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3321: FND_MSG_PUB.ADD;
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;
3324: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');
3325: IF (p_dim_obj_id IS NOT NULL) THEN

Line 3336: FND_MSG_PUB.ADD;

3332: IF (l_count = 0) THEN
3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
3336: FND_MSG_PUB.ADD;
3337: RAISE FND_API.G_EXC_ERROR;
3338: END IF;
3339: END IF;
3340: SELECT COUNT(*) INTO l_count

Line 3478: FND_MSG_PUB.Count_And_Get

3474: WHEN FND_API.G_EXC_ERROR THEN
3475: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3476: ROLLBACK TO CreateBSCMtoNTabsPMD;
3477: IF (x_msg_data IS NULL) THEN
3478: FND_MSG_PUB.Count_And_Get
3479: ( p_encoded => FND_API.G_FALSE
3480: , p_count => x_msg_count
3481: , p_data => x_msg_data
3482: );

Line 3490: FND_MSG_PUB.Count_And_Get

3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3487: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3488: ROLLBACK TO CreateBSCMtoNTabsPMD;
3489: IF (x_msg_data IS NULL) THEN
3490: FND_MSG_PUB.Count_And_Get
3491: ( p_encoded => FND_API.G_FALSE
3492: , p_count => x_msg_count
3493: , p_data => x_msg_data
3494: );

Line 3539: FND_MSG_PUB.Initialize;

3535: l_c_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3536: l_p_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3537: BEGIN
3538: SAVEPOINT DropBSCMtoNTabsPMD;
3539: FND_MSG_PUB.Initialize;
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 3545: FND_MSG_PUB.ADD;

3541: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:
3549: SELECT abbreviation INTO l_p_abbre

Line 3600: FND_MSG_PUB.Count_And_Get

3596: EXCEPTION
3597: WHEN FND_API.G_EXC_ERROR THEN
3598: ROLLBACK TO DropBSCMtoNTabsPMD;
3599: IF (x_msg_data IS NULL) THEN
3600: FND_MSG_PUB.Count_And_Get
3601: ( p_encoded => FND_API.G_FALSE
3602: , p_count => x_msg_count
3603: , p_data => x_msg_data
3604: );

Line 3611: FND_MSG_PUB.Count_And_Get

3607: x_return_status := FND_API.G_RET_STS_ERROR;
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO DropBSCMtoNTabsPMD;
3610: IF (x_msg_data IS NULL) THEN
3611: FND_MSG_PUB.Count_And_Get
3612: ( p_encoded => FND_API.G_FALSE
3613: , p_count => x_msg_count
3614: , p_data => x_msg_data
3615: );

Line 3727: FND_MSG_PUB.Initialize;

3723:
3724: BEGIN
3725: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');
3726:
3727: FND_MSG_PUB.Initialize;
3728: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
3729: RETURN NULL;
3730: END IF;
3731:

Line 3990: FND_MSG_PUB.ADD;

3986: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_kpi_names, 801, 200));
3987: IF ((l_strut_flag) AND (l_kpi_names IS NOT NULL)) THEN
3988: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3989: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
3990: FND_MSG_PUB.ADD;
3991: RAISE FND_API.G_EXC_ERROR;
3992: END IF;
3993: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');
3994: RETURN NULL;

Line 3998: FND_MSG_PUB.Count_And_Get

3994: RETURN NULL;
3995: EXCEPTION
3996: WHEN FND_API.G_EXC_ERROR THEN
3997: IF (l_Msg_Data IS NULL) THEN
3998: FND_MSG_PUB.Count_And_Get
3999: ( p_encoded => FND_API.G_FALSE
4000: , p_count => l_msg_count
4001: , p_data => l_Msg_Data
4002: );

Line 4008: FND_MSG_PUB.Count_And_Get

4004: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels');
4005: RETURN l_Msg_Data;
4006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4007: IF (l_Msg_Data IS NULL) THEN
4008: FND_MSG_PUB.Count_And_Get
4009: ( p_encoded => FND_API.G_FALSE
4010: , p_count => l_msg_count
4011: , p_data => l_Msg_Data
4012: );

Line 4120: FND_MSG_PUB.ADD;

4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;
4122: RAISE FND_API.G_EXC_ERROR;
4123: END IF;
4124: END LOOP;

Line 4135: FND_MSG_PUB.Count_And_Get

4131: RETURN NULL;
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: IF (l_Msg_Data IS NULL) THEN
4135: FND_MSG_PUB.Count_And_Get
4136: ( p_encoded => FND_API.G_FALSE
4137: , p_count => l_msg_count
4138: , p_data => l_Msg_Data
4139: );

Line 4253: FND_MSG_PUB.Count_And_Get

4249: RETURN FND_API.G_RET_STS_SUCCESS;
4250: EXCEPTION
4251: WHEN FND_API.G_EXC_ERROR THEN
4252: IF (x_msg_data IS NULL) THEN
4253: FND_MSG_PUB.Count_And_Get
4254: ( p_encoded => FND_API.G_FALSE
4255: , p_count => x_msg_count
4256: , p_data => x_msg_data
4257: );

Line 4266: FND_MSG_PUB.Count_And_Get

4262: ROLLBACK TO sp_before_rel_view;
4263: RETURN x_msg_data;
4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4265: IF (x_msg_data IS NULL) THEN
4266: FND_MSG_PUB.Count_And_Get
4267: ( p_encoded => FND_API.G_FALSE
4268: , p_count => x_msg_count
4269: , p_data => x_msg_data
4270: );