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

Line 787: FND_MSG_PUB.Count_And_Get

783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: x_return_status := FND_API.G_RET_STS_ERROR ;
786: ROLLBACK TO reset_target_counters;
787: FND_MSG_PUB.Count_And_Get
788: ( p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791: WHEN OTHERS THEN

Line 842: x_msg_data := FND_MSG_PUB.GET

838: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
839: l_msg_index := 1;
840: l_msg_count := x_msg_count;
841: WHILE l_msg_count > 0 LOOP
842: x_msg_data := FND_MSG_PUB.GET
843: (l_msg_index,
844: FND_API.G_FALSE
845: );
846: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');

Line 906: FND_MSG_PUB.initialize;

902: l_debug_level := CSI_CTR_GEN_UTILITY_PVT.g_debug_level; -- 8214848 - dsingire
903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
906: FND_MSG_PUB.initialize;
907: END IF;
908: -- Initialize API return status to success
909: x_return_status := FND_API.G_RET_STS_SUCCESS;
910: --

Line 1025: FND_MSG_PUB.Count_And_Get

1021: COMMIT WORK;
1022: END IF;
1023: --
1024: -- Standard call to get message count and IF count is get message info.
1025: FND_MSG_PUB.Count_And_Get
1026: ( p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );
1029: EXCEPTION

Line 1033: FND_MSG_PUB.Count_And_Get

1029: EXCEPTION
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR ;
1032: ROLLBACK TO create_reading_transaction;
1033: FND_MSG_PUB.Count_And_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1040: FND_MSG_PUB.Count_And_Get

1036: );
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: ROLLBACK TO create_reading_transaction;
1040: FND_MSG_PUB.Count_And_Get
1041: ( p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044: WHEN OTHERS THEN

Line 1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1043: );
1044: WHEN OTHERS THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1046: ROLLBACK TO create_reading_transaction;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1048: FND_MSG_PUB.Add_Exc_Msg
1049: ( G_PKG_NAME,
1050: l_api_name
1051: );

Line 1048: FND_MSG_PUB.Add_Exc_Msg

1044: WHEN OTHERS THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1046: ROLLBACK TO create_reading_transaction;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1048: FND_MSG_PUB.Add_Exc_Msg
1049: ( G_PKG_NAME,
1050: l_api_name
1051: );
1052: END IF;

Line 1053: FND_MSG_PUB.Count_And_Get

1049: ( G_PKG_NAME,
1050: l_api_name
1051: );
1052: END IF;
1053: FND_MSG_PUB.Count_And_Get
1054: ( p_count => x_msg_count,
1055: p_data => x_msg_data
1056: );
1057: END Create_Reading_Transaction;

Line 1205: FND_MSG_PUB.initialize;

1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203: -- Initialize message list if p_init_msg_list is set to TRUE.
1204: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1205: FND_MSG_PUB.initialize;
1206: END IF;
1207: -- Initialize API return status to success
1208: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209: --

Line 1392: x_msg_data := FND_MSG_PUB.GET

1388: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');
1389: l_msg_index := 1;
1390: l_msg_count := x_msg_count;
1391: WHILE l_msg_count > 0 LOOP
1392: x_msg_data := FND_MSG_PUB.GET
1393: ( l_msg_index,
1394: FND_API.G_FALSE
1395: );
1396: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1444: x_msg_data := FND_MSG_PUB.GET

1440: END IF; -- 8214848 - dsingire
1441: l_msg_index := 1;
1442: l_msg_count := x_msg_count;
1443: WHILE l_msg_count > 0 LOOP
1444: x_msg_data := FND_MSG_PUB.GET
1445: (l_msg_index,
1446: FND_API.G_FALSE
1447: );
1448: IF (l_debug_level > 0) THEN -- 8214848 - dsingire

Line 2316: x_msg_data := FND_MSG_PUB.GET

2312: END IF; -- 8214848 - dsingire
2313: l_msg_index := 1;
2314: l_msg_count := x_msg_count;
2315: WHILE l_msg_count > 0 LOOP
2316: x_msg_data := FND_MSG_PUB.GET
2317: ( l_msg_index,
2318: FND_API.G_FALSE
2319: );
2320: IF (l_debug_level > 0) THEN -- 8214848 - dsingire

Line 2414: x_msg_data := FND_MSG_PUB.GET

2410: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');
2411: l_msg_index := 1;
2412: l_msg_count := x_msg_count;
2413: WHILE l_msg_count > 0 LOOP
2414: x_msg_data := FND_MSG_PUB.GET
2415: ( l_msg_index,
2416: FND_API.G_FALSE
2417: );
2418: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2588: x_msg_data := FND_MSG_PUB.GET

2584: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');
2585: l_msg_index := 1;
2586: l_msg_count := x_msg_count;
2587: WHILE l_msg_count > 0 LOOP
2588: x_msg_data := FND_MSG_PUB.GET
2589: ( l_msg_index,
2590: FND_API.G_FALSE
2591: );
2592: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2663: x_msg_data := FND_MSG_PUB.GET

2659: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');
2660: l_msg_index := 1;
2661: l_msg_count := x_msg_count;
2662: WHILE l_msg_count > 0 LOOP
2663: x_msg_data := FND_MSG_PUB.GET
2664: ( l_msg_index,
2665: FND_API.G_FALSE
2666: );
2667: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2835: x_msg_data := FND_MSG_PUB.GET

2831: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
2832: l_msg_index := 1;
2833: l_msg_count := x_msg_count;
2834: WHILE l_msg_count > 0 LOOP
2835: x_msg_data := FND_MSG_PUB.GET
2836: ( l_msg_index,
2837: FND_API.G_FALSE
2838: );
2839: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2882: x_msg_data := FND_MSG_PUB.GET

2878: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Reset_Target_Counters API ');
2879: l_msg_index := 1;
2880: l_msg_count := x_msg_count;
2881: WHILE l_msg_count > 0 LOOP
2882: x_msg_data := FND_MSG_PUB.GET
2883: ( l_msg_index,
2884: FND_API.G_FALSE
2885: );
2886: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2903: FND_MSG_PUB.Count_And_Get

2899: COMMIT WORK;
2900: END IF;
2901: --
2902: -- Standard call to get message count and IF count is get message info.
2903: FND_MSG_PUB.Count_And_Get
2904: ( p_count => x_msg_count,
2905: p_data => x_msg_data
2906: );
2907: EXCEPTION

Line 2910: FND_MSG_PUB.Count_And_Get

2906: );
2907: EXCEPTION
2908: WHEN Skip_Process THEN
2909: x_return_status := FND_API.G_RET_STS_SUCCESS;
2910: FND_MSG_PUB.Count_And_Get
2911: ( p_count => x_msg_count,
2912: p_data => x_msg_data
2913: );
2914: WHEN FND_API.G_EXC_ERROR THEN

Line 2917: FND_MSG_PUB.Count_And_Get

2913: );
2914: WHEN FND_API.G_EXC_ERROR THEN
2915: x_return_status := FND_API.G_RET_STS_ERROR ;
2916: ROLLBACK TO capture_counter_reading_pvt;
2917: FND_MSG_PUB.Count_And_Get
2918: ( p_count => x_msg_count,
2919: p_data => x_msg_data
2920: );
2921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2924: FND_MSG_PUB.Count_And_Get

2920: );
2921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2923: ROLLBACK TO capture_counter_reading_pvt;
2924: FND_MSG_PUB.Count_And_Get
2925: ( p_count => x_msg_count,
2926: p_data => x_msg_data
2927: );
2928: WHEN OTHERS THEN

Line 2931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2927: );
2928: WHEN OTHERS THEN
2929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2930: ROLLBACK TO capture_counter_reading_pvt;
2931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2932: FND_MSG_PUB.Add_Exc_Msg
2933: ( G_PKG_NAME,
2934: l_api_name
2935: );

Line 2932: FND_MSG_PUB.Add_Exc_Msg

2928: WHEN OTHERS THEN
2929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2930: ROLLBACK TO capture_counter_reading_pvt;
2931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2932: FND_MSG_PUB.Add_Exc_Msg
2933: ( G_PKG_NAME,
2934: l_api_name
2935: );
2936: END IF;

Line 2937: FND_MSG_PUB.Count_And_Get

2933: ( G_PKG_NAME,
2934: l_api_name
2935: );
2936: END IF;
2937: FND_MSG_PUB.Count_And_Get
2938: ( p_count => x_msg_count,
2939: p_data => x_msg_data
2940: );
2941: END Capture_Counter_Reading;

Line 3036: FND_MSG_PUB.initialize;

3032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3033: END IF;
3034: -- Initialize message list if p_init_msg_list is set to TRUE.
3035: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3036: FND_MSG_PUB.initialize;
3037: END IF;
3038: -- Initialize API return status to success
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;
3040:

Line 3304: x_msg_data := FND_MSG_PUB.GET

3300: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
3301: l_msg_index := 1;
3302: l_msg_count := x_msg_count;
3303: WHILE l_msg_count > 0 LOOP
3304: x_msg_data := FND_MSG_PUB.GET
3305: ( l_msg_index,
3306: FND_API.G_FALSE
3307: );
3308: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3334: x_msg_data := FND_MSG_PUB.GET

3330: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
3331: l_msg_index := 1;
3332: l_msg_count := x_msg_count;
3333: WHILE l_msg_count > 0 LOOP
3334: x_msg_data := FND_MSG_PUB.GET
3335: ( l_msg_index,
3336: FND_API.G_FALSE
3337: );
3338: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3379: x_msg_data := FND_MSG_PUB.GET

3375: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
3376: l_msg_index := 1;
3377: l_msg_count := x_msg_count;
3378: WHILE l_msg_count > 0 LOOP
3379: x_msg_data := FND_MSG_PUB.GET
3380: ( l_msg_index,
3381: FND_API.G_FALSE
3382: );
3383: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3486: FND_MSG_PUB.Count_And_Get

3482: COMMIT WORK;
3483: END IF;
3484: --
3485: -- Standard call to get message count and IF count is get message info.
3486: FND_MSG_PUB.Count_And_Get
3487: ( p_count => x_msg_count,
3488: p_data => x_msg_data
3489: );
3490: EXCEPTION

Line 3494: FND_MSG_PUB.Count_And_Get

3490: EXCEPTION
3491: WHEN FND_API.G_EXC_ERROR THEN
3492: x_return_status := FND_API.G_RET_STS_ERROR ;
3493: ROLLBACK TO compute_formula_counters;
3494: FND_MSG_PUB.Count_And_Get
3495: ( p_count => x_msg_count,
3496: p_data => x_msg_data
3497: );
3498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3501: FND_MSG_PUB.Count_And_Get

3497: );
3498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3500: ROLLBACK TO compute_formula_counters;
3501: FND_MSG_PUB.Count_And_Get
3502: ( p_count => x_msg_count,
3503: p_data => x_msg_data
3504: );
3505: WHEN OTHERS THEN

Line 3508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3504: );
3505: WHEN OTHERS THEN
3506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3507: ROLLBACK TO compute_formula_counters;
3508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3509: FND_MSG_PUB.Add_Exc_Msg
3510: ( G_PKG_NAME,
3511: l_api_name
3512: );

Line 3509: FND_MSG_PUB.Add_Exc_Msg

3505: WHEN OTHERS THEN
3506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3507: ROLLBACK TO compute_formula_counters;
3508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3509: FND_MSG_PUB.Add_Exc_Msg
3510: ( G_PKG_NAME,
3511: l_api_name
3512: );
3513: END IF;

Line 3514: FND_MSG_PUB.Count_And_Get

3510: ( G_PKG_NAME,
3511: l_api_name
3512: );
3513: END IF;
3514: FND_MSG_PUB.Count_And_Get
3515: ( p_count => x_msg_count,
3516: p_data => x_msg_data
3517: );
3518: END Compute_Formula_Counters;

Line 3619: FND_MSG_PUB.initialize;

3615: -- Standard Start of API savepoint
3616: SAVEPOINT compute_derive_counters;
3617: -- Initialize message list if p_init_msg_list is set to TRUE.
3618: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3619: FND_MSG_PUB.initialize;
3620: END IF;
3621: x_return_status := FND_API.G_RET_STS_SUCCESS;
3622: --
3623:

Line 3977: x_msg_data := FND_MSG_PUB.GET

3973: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
3974: l_msg_index := 1;
3975: l_msg_count := x_msg_count;
3976: WHILE l_msg_count > 0 LOOP
3977: x_msg_data := FND_MSG_PUB.GET
3978: ( l_msg_index,
3979: FND_API.G_FALSE
3980: );
3981: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3999: FND_MSG_PUB.Count_And_Get

3995: EXCEPTION
3996: WHEN FND_API.G_EXC_ERROR THEN
3997: x_return_status := FND_API.G_RET_STS_ERROR ;
3998: ROLLBACK TO compute_derive_counters;
3999: FND_MSG_PUB.Count_And_Get
4000: ( p_count => x_msg_count,
4001: p_data => x_msg_data
4002: );
4003: WHEN OTHERS THEN

Line 4006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4002: );
4003: WHEN OTHERS THEN
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005: ROLLBACK TO compute_derive_counters;
4006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4007: FND_MSG_PUB.Add_Exc_Msg
4008: ( G_PKG_NAME,
4009: l_api_name
4010: );

Line 4007: FND_MSG_PUB.Add_Exc_Msg

4003: WHEN OTHERS THEN
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005: ROLLBACK TO compute_derive_counters;
4006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4007: FND_MSG_PUB.Add_Exc_Msg
4008: ( G_PKG_NAME,
4009: l_api_name
4010: );
4011: END IF;

Line 4012: FND_MSG_PUB.Count_And_Get

4008: ( G_PKG_NAME,
4009: l_api_name
4010: );
4011: END IF;
4012: FND_MSG_PUB.Count_And_Get
4013: ( p_count => x_msg_count,
4014: p_data => x_msg_data
4015: );
4016: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

Line 4130: FND_MSG_PUB.initialize;

4126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4127: END IF;
4128: -- Initialize message list if p_init_msg_list is set to TRUE.
4129: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4130: FND_MSG_PUB.initialize;
4131: END IF;
4132: -- Initialize API return status to success
4133: x_return_status := FND_API.G_RET_STS_SUCCESS;
4134: --

Line 4805: x_msg_data := FND_MSG_PUB.GET

4801: END IF; -- 8214848 - dsingire
4802: l_msg_index := 1;
4803: l_msg_count := x_msg_count;
4804: WHILE l_msg_count > 0 LOOP
4805: x_msg_data := FND_MSG_PUB.GET
4806: ( l_msg_index,
4807: FND_API.G_FALSE
4808: );
4809: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4852: x_msg_data := FND_MSG_PUB.GET

4848: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');
4849: l_msg_index := 1;
4850: l_msg_count := x_msg_count;
4851: WHILE l_msg_count > 0 LOOP
4852: x_msg_data := FND_MSG_PUB.GET
4853: ( l_msg_index,
4854: FND_API.G_FALSE
4855: );
4856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4957: x_msg_data := FND_MSG_PUB.GET

4953: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
4954: l_msg_index := 1;
4955: l_msg_count := x_msg_count;
4956: WHILE l_msg_count > 0 LOOP
4957: x_msg_data := FND_MSG_PUB.GET
4958: ( l_msg_index,
4959: FND_API.G_FALSE
4960: );
4961: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4979: FND_MSG_PUB.Count_And_Get

4975: COMMIT WORK;
4976: END IF;
4977: --
4978: -- Standard call to get message count and IF count is get message info.
4979: FND_MSG_PUB.Count_And_Get
4980: ( p_count => x_msg_count,
4981: p_data => x_msg_data
4982: );
4983: EXCEPTION

Line 4987: FND_MSG_PUB.Count_And_Get

4983: EXCEPTION
4984: WHEN FND_API.G_EXC_ERROR THEN
4985: x_return_status := FND_API.G_RET_STS_ERROR ;
4986: ROLLBACK TO compute_target_counters;
4987: FND_MSG_PUB.Count_And_Get
4988: ( p_count => x_msg_count,
4989: p_data => x_msg_data
4990: );
4991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4994: FND_MSG_PUB.Count_And_Get

4990: );
4991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4993: ROLLBACK TO compute_target_counters;
4994: FND_MSG_PUB.Count_And_Get
4995: ( p_count => x_msg_count,
4996: p_data => x_msg_data
4997: );
4998: WHEN OTHERS THEN

Line 5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4997: );
4998: WHEN OTHERS THEN
4999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5000: ROLLBACK TO compute_target_counters;
5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5002: FND_MSG_PUB.Add_Exc_Msg
5003: ( G_PKG_NAME,
5004: l_api_name
5005: );

Line 5002: FND_MSG_PUB.Add_Exc_Msg

4998: WHEN OTHERS THEN
4999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5000: ROLLBACK TO compute_target_counters;
5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5002: FND_MSG_PUB.Add_Exc_Msg
5003: ( G_PKG_NAME,
5004: l_api_name
5005: );
5006: END IF;

Line 5007: FND_MSG_PUB.Count_And_Get

5003: ( G_PKG_NAME,
5004: l_api_name
5005: );
5006: END IF;
5007: FND_MSG_PUB.Count_And_Get
5008: ( p_count => x_msg_count,
5009: p_data => x_msg_data
5010: );
5011: END Compute_Target_Counters;

Line 5137: FND_MSG_PUB.initialize;

5133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5134: END IF;
5135: -- Initialize message list if p_init_msg_list is set to TRUE.
5136: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5137: FND_MSG_PUB.initialize;
5138: END IF;
5139: -- Initialize API return status to success
5140: x_return_status := FND_API.G_RET_STS_SUCCESS;
5141: --

Line 5575: x_msg_data := FND_MSG_PUB.GET

5571: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5572: l_msg_index := 1;
5573: l_msg_count := x_msg_count;
5574: WHILE l_msg_count > 0 LOOP
5575: x_msg_data := FND_MSG_PUB.GET
5576: (l_msg_index,
5577: FND_API.G_FALSE
5578: );
5579: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');

Line 5751: x_msg_data := FND_MSG_PUB.GET

5747: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5748: l_msg_index := 1;
5749: l_msg_count := x_msg_count;
5750: WHILE l_msg_count > 0 LOOP
5751: x_msg_data := FND_MSG_PUB.GET
5752: ( l_msg_index,
5753: FND_API.G_FALSE
5754: );
5755: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');

Line 5796: x_msg_data := FND_MSG_PUB.GET

5792: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
5793: l_msg_index := 1;
5794: l_msg_count := x_msg_count;
5795: WHILE l_msg_count > 0 LOOP
5796: x_msg_data := FND_MSG_PUB.GET
5797: ( l_msg_index,
5798: FND_API.G_FALSE
5799: );
5800: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5869: x_msg_data := FND_MSG_PUB.GET

5865: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5866: l_msg_index := 1;
5867: l_msg_count := x_msg_count;
5868: WHILE l_msg_count > 0 LOOP
5869: x_msg_data := FND_MSG_PUB.GET
5870: ( l_msg_index,
5871: FND_API.G_FALSE
5872: );
5873: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');

Line 5911: x_msg_data := FND_MSG_PUB.GET

5907: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5908: l_msg_index := 1;
5909: l_msg_count := x_msg_count;
5910: WHILE l_msg_count > 0 LOOP
5911: x_msg_data := FND_MSG_PUB.GET
5912: ( l_msg_index,
5913: FND_API.G_FALSE
5914: );
5915: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');

Line 5961: x_msg_data := FND_MSG_PUB.GET

5957: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5958: l_msg_index := 1;
5959: l_msg_count := x_msg_count;
5960: WHILE l_msg_count > 0 LOOP
5961: x_msg_data := FND_MSG_PUB.GET
5962: ( l_msg_index,
5963: FND_API.G_FALSE
5964: );
5965: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');

Line 6001: x_msg_data := FND_MSG_PUB.GET

5997: csi_ctr_gen_utility_pvt.put_line('Error from Compute_Formula_Counters API...');
5998: l_msg_index := 1;
5999: l_msg_count := x_msg_count;
6000: WHILE l_msg_count > 0 LOOP
6001: x_msg_data := FND_MSG_PUB.GET
6002: ( l_msg_index,
6003: FND_API.G_FALSE
6004: );
6005: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Formula_Counters API ');

Line 6018: FND_MSG_PUB.Count_And_Get

6014: COMMIT WORK;
6015: END IF;
6016: --
6017: -- Standard call to get message count and IF count is get message info.
6018: FND_MSG_PUB.Count_And_Get
6019: ( p_count => x_msg_count,
6020: p_data => x_msg_data
6021: );
6022: EXCEPTION

Line 6026: FND_MSG_PUB.Count_And_Get

6022: EXCEPTION
6023: WHEN FND_API.G_EXC_ERROR THEN
6024: x_return_status := FND_API.G_RET_STS_ERROR ;
6025: ROLLBACK TO update_counter_reading_pvt;
6026: FND_MSG_PUB.Count_And_Get
6027: ( p_count => x_msg_count,
6028: p_data => x_msg_data
6029: );
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6033: FND_MSG_PUB.Count_And_Get

6029: );
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6032: ROLLBACK TO update_counter_reading_pvt;
6033: FND_MSG_PUB.Count_And_Get
6034: ( p_count => x_msg_count,
6035: p_data => x_msg_data
6036: );
6037: WHEN OTHERS THEN

Line 6040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6036: );
6037: WHEN OTHERS THEN
6038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6039: ROLLBACK TO update_counter_reading_pvt;
6040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6041: FND_MSG_PUB.Add_Exc_Msg
6042: ( G_PKG_NAME,
6043: l_api_name
6044: );

Line 6041: FND_MSG_PUB.Add_Exc_Msg

6037: WHEN OTHERS THEN
6038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6039: ROLLBACK TO update_counter_reading_pvt;
6040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6041: FND_MSG_PUB.Add_Exc_Msg
6042: ( G_PKG_NAME,
6043: l_api_name
6044: );
6045: END IF;

Line 6046: FND_MSG_PUB.Count_And_Get

6042: ( G_PKG_NAME,
6043: l_api_name
6044: );
6045: END IF;
6046: FND_MSG_PUB.Count_And_Get
6047: ( p_count => x_msg_count,
6048: p_data => x_msg_data
6049: );
6050: END Update_Counter_Reading;

Line 6098: FND_MSG_PUB.initialize;

6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END IF;
6096: -- Initialize message list if p_init_msg_list is set to TRUE.
6097: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6098: FND_MSG_PUB.initialize;
6099: END IF;
6100: -- Initialize API return status to success
6101: x_return_status := FND_API.G_RET_STS_SUCCESS;
6102: --

Line 6278: FND_MSG_PUB.Count_And_Get

6274: COMMIT WORK;
6275: END IF;
6276: --
6277: -- Standard call to get message count and IF count is get message info.
6278: FND_MSG_PUB.Count_And_Get
6279: ( p_count => x_msg_count,
6280: p_data => x_msg_data
6281: );
6282: EXCEPTION

Line 6286: FND_MSG_PUB.Count_And_Get

6282: EXCEPTION
6283: WHEN FND_API.G_EXC_ERROR THEN
6284: x_return_status := FND_API.G_RET_STS_ERROR ;
6285: ROLLBACK TO capture_ctr_property_reading;
6286: FND_MSG_PUB.Count_And_Get
6287: ( p_count => x_msg_count,
6288: p_data => x_msg_data
6289: );
6290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6293: FND_MSG_PUB.Count_And_Get

6289: );
6290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6292: ROLLBACK TO capture_ctr_property_reading;
6293: FND_MSG_PUB.Count_And_Get
6294: ( p_count => x_msg_count,
6295: p_data => x_msg_data
6296: );
6297: WHEN OTHERS THEN

Line 6300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6296: );
6297: WHEN OTHERS THEN
6298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6299: ROLLBACK TO capture_ctr_property_reading;
6300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6301: FND_MSG_PUB.Add_Exc_Msg
6302: ( G_PKG_NAME,
6303: l_api_name
6304: );

Line 6301: FND_MSG_PUB.Add_Exc_Msg

6297: WHEN OTHERS THEN
6298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6299: ROLLBACK TO capture_ctr_property_reading;
6300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6301: FND_MSG_PUB.Add_Exc_Msg
6302: ( G_PKG_NAME,
6303: l_api_name
6304: );
6305: END IF;

Line 6306: FND_MSG_PUB.Count_And_Get

6302: ( G_PKG_NAME,
6303: l_api_name
6304: );
6305: END IF;
6306: FND_MSG_PUB.Count_And_Get
6307: ( p_count => x_msg_count,
6308: p_data => x_msg_data
6309: );
6310: END Capture_Ctr_Property_Reading;

Line 6405: FND_MSG_PUB.initialize;

6401: BEGIN
6402: SAVEPOINT ESTIMATE_START_READINGS;
6403: -- Initialize message list if p_init_msg_list is set to TRUE.
6404: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6405: FND_MSG_PUB.initialize;
6406: END IF;
6407: -- Initialize API return status to SUCCESS
6408: x_return_status := FND_API.G_RET_STS_SUCCESS;
6409: --

Line 6489: FND_MSG_PUB.Count_And_Get

6485: COMMIT WORK;
6486: END IF;
6487: --
6488: -- Standard call to get message count and IF count is get message info.
6489: FND_MSG_PUB.Count_And_Get
6490: ( p_count => x_msg_count,
6491: p_data => x_msg_data
6492: );
6493:

Line 6498: FND_MSG_PUB.Count_And_Get

6494: EXCEPTION
6495: WHEN FND_API.G_EXC_ERROR THEN
6496: ROLLBACK TO ESTIMATE_START_READINGS;
6497: x_return_status := FND_API.G_RET_STS_ERROR ;
6498: FND_MSG_PUB.Count_And_Get
6499: (p_count => x_msg_count,
6500: p_data => x_msg_data
6501: );
6502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6505: FND_MSG_PUB.Count_And_Get

6501: );
6502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6503: ROLLBACK TO ESTIMATE_START_READINGS;
6504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6505: FND_MSG_PUB.Count_And_Get
6506: (
6507: p_count => x_msg_count,
6508: p_data => x_msg_data
6509: );

Line 6513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6509: );
6510: WHEN OTHERS THEN
6511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6512: ROLLBACK TO ESTIMATE_START_READINGS;
6513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6514: FND_MSG_PUB.Add_Exc_Msg
6515: ( G_PKG_NAME,
6516: l_api_name
6517: );

Line 6514: FND_MSG_PUB.Add_Exc_Msg

6510: WHEN OTHERS THEN
6511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6512: ROLLBACK TO ESTIMATE_START_READINGS;
6513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6514: FND_MSG_PUB.Add_Exc_Msg
6515: ( G_PKG_NAME,
6516: l_api_name
6517: );
6518: END IF;

Line 6519: FND_MSG_PUB.Count_And_Get

6515: ( G_PKG_NAME,
6516: l_api_name
6517: );
6518: END IF;
6519: FND_MSG_PUB.Count_And_Get
6520: ( p_count => x_msg_count,
6521: p_data => x_msg_data
6522: );
6523: END ESTIMATE_START_READINGS;

Line 6613: FND_MSG_PUB.initialize;

6609: BEGIN
6610: SAVEPOINT EST_PERIOD_START_READINGS;
6611: -- Initialize message list if p_init_msg_list is set to TRUE.
6612: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6613: FND_MSG_PUB.initialize;
6614: END IF;
6615: -- Initialize API return status to SUCCESS
6616: x_return_status := FND_API.G_RET_STS_SUCCESS;
6617: --

Line 6707: x_msg_data := FND_MSG_PUB.GET

6703: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Start_Readings API ');
6704: l_msg_index := 1;
6705: l_msg_count := x_msg_count;
6706: WHILE l_msg_count > 0 LOOP
6707: x_msg_data := FND_MSG_PUB.GET
6708: ( l_msg_index,
6709: FND_API.G_FALSE
6710: );
6711: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6766: FND_MSG_PUB.Count_And_Get

6762: x_calc_start_reading := round(l_calculation_start_rdg);
6763: END IF; --l_calculation_start_rdg null
6764: --
6765: -- Standard call to get message count and IF count is get message info.
6766: FND_MSG_PUB.Count_And_Get
6767: ( p_count => x_msg_count,
6768: p_data => x_msg_data
6769: );
6770:

Line 6775: FND_MSG_PUB.Count_And_Get

6771: EXCEPTION
6772: WHEN FND_API.G_EXC_ERROR THEN
6773: ROLLBACK TO EST_PERIOD_START_READINGS;
6774: x_return_status := FND_API.G_RET_STS_ERROR ;
6775: FND_MSG_PUB.Count_And_Get
6776: (p_count => x_msg_count,
6777: p_data => x_msg_data
6778: );
6779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6782: FND_MSG_PUB.Count_And_Get

6778: );
6779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6780: ROLLBACK TO EST_PERIOD_START_READINGS;
6781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6782: FND_MSG_PUB.Count_And_Get
6783: (
6784: p_count => x_msg_count,
6785: p_data => x_msg_data
6786: );

Line 6790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6786: );
6787: WHEN OTHERS THEN
6788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6789: ROLLBACK TO EST_PERIOD_START_READINGS;
6790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6791: FND_MSG_PUB.Add_Exc_Msg
6792: ( G_PKG_NAME,
6793: l_api_name
6794: );

Line 6791: FND_MSG_PUB.Add_Exc_Msg

6787: WHEN OTHERS THEN
6788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6789: ROLLBACK TO EST_PERIOD_START_READINGS;
6790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6791: FND_MSG_PUB.Add_Exc_Msg
6792: ( G_PKG_NAME,
6793: l_api_name
6794: );
6795: END IF;

Line 6796: FND_MSG_PUB.Count_And_Get

6792: ( G_PKG_NAME,
6793: l_api_name
6794: );
6795: END IF;
6796: FND_MSG_PUB.Count_And_Get
6797: ( p_count => x_msg_count,
6798: p_data => x_msg_data
6799: );
6800: END EST_PERIOD_START_READINGS;

Line 6903: FND_MSG_PUB.initialize;

6899: BEGIN
6900: SAVEPOINT ESTIMATE_USAGE;
6901: -- Initialize message list if p_init_msg_list is set to TRUE.
6902: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6903: FND_MSG_PUB.initialize;
6904: END IF;
6905: -- Initialize API return status to SUCCESS
6906: x_return_status := FND_API.G_RET_STS_SUCCESS;
6907: --

Line 6941: x_msg_data := FND_MSG_PUB.GET

6937: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6938: l_msg_index := 1;
6939: l_msg_count := x_msg_count;
6940: WHILE l_msg_count > 0 LOOP
6941: x_msg_data := FND_MSG_PUB.GET
6942: ( l_msg_index,
6943: FND_API.G_FALSE
6944: );
6945: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Start_Readings API ');

Line 6976: x_msg_data := FND_MSG_PUB.GET

6972: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6973: l_msg_index := 1;
6974: l_msg_count := x_msg_count;
6975: WHILE l_msg_count > 0 LOOP
6976: x_msg_data := FND_MSG_PUB.GET
6977: ( l_msg_index,
6978: FND_API.G_FALSE
6979: );
6980: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Est_Period_Start_Readings API ');

Line 7223: FND_MSG_PUB.Count_And_Get

7219: COMMIT WORK;
7220: END IF;
7221: --
7222: -- Standard call to get message count and IF count is get message info.
7223: FND_MSG_PUB.Count_And_Get
7224: ( p_count => x_msg_count,
7225: p_data => x_msg_data
7226: );
7227:

Line 7232: FND_MSG_PUB.Count_And_Get

7228: EXCEPTION
7229: WHEN FND_API.G_EXC_ERROR THEN
7230: ROLLBACK TO ESTIMATE_USAGE;
7231: x_return_status := FND_API.G_RET_STS_ERROR ;
7232: FND_MSG_PUB.Count_And_Get
7233: (p_count => x_msg_count,
7234: p_data => x_msg_data
7235: );
7236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7239: FND_MSG_PUB.Count_And_Get

7235: );
7236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7237: ROLLBACK TO ESTIMATE_USAGE;
7238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7239: FND_MSG_PUB.Count_And_Get
7240: (
7241: p_count => x_msg_count,
7242: p_data => x_msg_data
7243: );

Line 7247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7243: );
7244: WHEN OTHERS THEN
7245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7246: ROLLBACK TO ESTIMATE_USAGE;
7247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7248: FND_MSG_PUB.Add_Exc_Msg
7249: ( G_PKG_NAME,
7250: l_api_name
7251: );

Line 7248: FND_MSG_PUB.Add_Exc_Msg

7244: WHEN OTHERS THEN
7245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7246: ROLLBACK TO ESTIMATE_USAGE;
7247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7248: FND_MSG_PUB.Add_Exc_Msg
7249: ( G_PKG_NAME,
7250: l_api_name
7251: );
7252: END IF;

Line 7253: FND_MSG_PUB.Count_And_Get

7249: ( G_PKG_NAME,
7250: l_api_name
7251: );
7252: END IF;
7253: FND_MSG_PUB.Count_And_Get
7254: ( p_count => x_msg_count,
7255: p_data => x_msg_data
7256: );
7257: END ESTIMATE_USAGE;

Line 7340: FND_MSG_PUB.initialize;

7336: BEGIN
7337: SAVEPOINT ESTIMATE_COUNTER_READING;
7338: -- Initialize message list if p_init_msg_list is set to TRUE.
7339: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7340: FND_MSG_PUB.initialize;
7341: END IF;
7342: -- Initialize API return status to SUCCESS
7343: x_return_status := FND_API.G_RET_STS_SUCCESS;
7344: --

Line 7461: x_msg_data := FND_MSG_PUB.GET

7457: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_fixed_values API ');
7458: l_msg_index := 1;
7459: l_msg_count := x_msg_count;
7460: WHILE l_msg_count > 0 LOOP
7461: x_msg_data := FND_MSG_PUB.GET
7462: ( l_msg_index,
7463: FND_API.G_FALSE
7464: );
7465: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7504: x_msg_data := FND_MSG_PUB.GET

7500: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Usage API ');
7501: l_msg_index := 1;
7502: l_msg_count := x_msg_count;
7503: WHILE l_msg_count > 0 LOOP
7504: x_msg_data := FND_MSG_PUB.GET
7505: ( l_msg_index,
7506: FND_API.G_FALSE
7507: );
7508: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7556: x_msg_data := FND_MSG_PUB.GET

7552: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Usage API ');
7553: l_msg_index := 1;
7554: l_msg_count := x_msg_count;
7555: WHILE l_msg_count > 0 LOOP
7556: x_msg_data := FND_MSG_PUB.GET
7557: ( l_msg_index,
7558: FND_API.G_FALSE
7559: );
7560: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7620: FND_MSG_PUB.Count_And_Get

7616: COMMIT WORK;
7617: END IF;
7618: --
7619: -- Standard call to get message count and IF count is get message info.
7620: FND_MSG_PUB.Count_And_Get
7621: ( p_count => x_msg_count,
7622: p_data => x_msg_data
7623: );
7624:

Line 7629: FND_MSG_PUB.Count_And_Get

7625: EXCEPTION
7626: WHEN FND_API.G_EXC_ERROR THEN
7627: ROLLBACK TO ESTIMATE_COUNTER_READING;
7628: x_return_status := FND_API.G_RET_STS_ERROR ;
7629: FND_MSG_PUB.Count_And_Get
7630: (p_count => x_msg_count,
7631: p_data => x_msg_data
7632: );
7633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7636: FND_MSG_PUB.Count_And_Get

7632: );
7633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7634: ROLLBACK TO ESTIMATE_COUNTER_READING;
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7636: FND_MSG_PUB.Count_And_Get
7637: (
7638: p_count => x_msg_count,
7639: p_data => x_msg_data
7640: );

Line 7644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7640: );
7641: WHEN OTHERS THEN
7642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7643: ROLLBACK TO ESTIMATE_COUNTER_READING;
7644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7645: FND_MSG_PUB.Add_Exc_Msg
7646: ( G_PKG_NAME,
7647: l_api_name
7648: );

Line 7645: FND_MSG_PUB.Add_Exc_Msg

7641: WHEN OTHERS THEN
7642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7643: ROLLBACK TO ESTIMATE_COUNTER_READING;
7644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7645: FND_MSG_PUB.Add_Exc_Msg
7646: ( G_PKG_NAME,
7647: l_api_name
7648: );
7649: END IF;

Line 7650: FND_MSG_PUB.Count_And_Get

7646: ( G_PKG_NAME,
7647: l_api_name
7648: );
7649: END IF;
7650: FND_MSG_PUB.Count_And_Get
7651: ( p_count => x_msg_count,
7652: p_data => x_msg_data
7653: );
7654: END ESTIMATE_COUNTER_READING;

Line 7715: FND_MSG_PUB.initialize;

7711: BEGIN
7712: SAVEPOINT ESTIMATE_FIXED_VALUES;
7713: -- Initialize message list if p_init_msg_list is set to TRUE.
7714: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7715: FND_MSG_PUB.initialize;
7716: END IF;
7717: -- Initialize API return status to SUCCESS
7718: x_return_status := FND_API.G_RET_STS_SUCCESS;
7719: --

Line 7763: x_msg_data := FND_MSG_PUB.GET

7759: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Est_Period_Start_Readings API ');
7760: l_msg_index := 1;
7761: l_msg_count := x_msg_count;
7762: WHILE l_msg_count > 0 LOOP
7763: x_msg_data := FND_MSG_PUB.GET
7764: ( l_msg_index,
7765: FND_API.G_FALSE
7766: );
7767: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7807: FND_MSG_PUB.Count_And_Get

7803: COMMIT WORK;
7804: END IF;
7805: --
7806: -- Standard call to get message count and IF count is get message info.
7807: FND_MSG_PUB.Count_And_Get
7808: ( p_count => x_msg_count,
7809: p_data => x_msg_data
7810: );
7811:

Line 7816: FND_MSG_PUB.Count_And_Get

7812: EXCEPTION
7813: WHEN FND_API.G_EXC_ERROR THEN
7814: ROLLBACK TO ESTIMATE_FIXED_VALUES;
7815: x_return_status := FND_API.G_RET_STS_ERROR ;
7816: FND_MSG_PUB.Count_And_Get
7817: (p_count => x_msg_count,
7818: p_data => x_msg_data
7819: );
7820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7823: FND_MSG_PUB.Count_And_Get

7819: );
7820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7821: ROLLBACK TO ESTIMATE_FIXED_VALUES;
7822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7823: FND_MSG_PUB.Count_And_Get
7824: (
7825: p_count => x_msg_count,
7826: p_data => x_msg_data
7827: );

Line 7831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7827: );
7828: WHEN OTHERS THEN
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7830: ROLLBACK TO ESTIMATE_FIXED_VALUES;
7831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7832: FND_MSG_PUB.Add_Exc_Msg
7833: ( G_PKG_NAME,
7834: l_api_name
7835: );

Line 7832: FND_MSG_PUB.Add_Exc_Msg

7828: WHEN OTHERS THEN
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7830: ROLLBACK TO ESTIMATE_FIXED_VALUES;
7831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7832: FND_MSG_PUB.Add_Exc_Msg
7833: ( G_PKG_NAME,
7834: l_api_name
7835: );
7836: END IF;

Line 7837: FND_MSG_PUB.Count_And_Get

7833: ( G_PKG_NAME,
7834: l_api_name
7835: );
7836: END IF;
7837: FND_MSG_PUB.Count_And_Get
7838: ( p_count => x_msg_count,
7839: p_data => x_msg_data
7840: );
7841: END ESTIMATE_FIXED_VALUES;