DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on FND_MSG_PUB

Line 673: FND_MSG_PUB.Count_And_Get

669: EXCEPTION
670: WHEN FND_API.G_EXC_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_ERROR ;
672: ROLLBACK TO reset_target_counters;
673: FND_MSG_PUB.Count_And_Get
674: ( p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677: WHEN OTHERS THEN

Line 727: x_msg_data := FND_MSG_PUB.GET

723: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
724: l_msg_index := 1;
725: l_msg_count := x_msg_count;
726: WHILE l_msg_count > 0 LOOP
727: x_msg_data := FND_MSG_PUB.GET
728: (l_msg_index,
729: FND_API.G_FALSE
730: );
731: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');

Line 784: FND_MSG_PUB.initialize;

780: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
781:
782: -- Initialize message list if p_init_msg_list is set to TRUE.
783: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
784: FND_MSG_PUB.initialize;
785: END IF;
786: -- Initialize API return status to success
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788: --

Line 901: FND_MSG_PUB.Count_And_Get

897: COMMIT WORK;
898: END IF;
899: --
900: -- Standard call to get message count and IF count is get message info.
901: FND_MSG_PUB.Count_And_Get
902: ( p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905: EXCEPTION

Line 909: FND_MSG_PUB.Count_And_Get

905: EXCEPTION
906: WHEN FND_API.G_EXC_ERROR THEN
907: x_return_status := FND_API.G_RET_STS_ERROR ;
908: ROLLBACK TO create_reading_transaction;
909: FND_MSG_PUB.Count_And_Get
910: ( p_count => x_msg_count,
911: p_data => x_msg_data
912: );
913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 916: FND_MSG_PUB.Count_And_Get

912: );
913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: ROLLBACK TO create_reading_transaction;
916: FND_MSG_PUB.Count_And_Get
917: ( p_count => x_msg_count,
918: p_data => x_msg_data
919: );
920: WHEN OTHERS THEN

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

919: );
920: WHEN OTHERS THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
922: ROLLBACK TO create_reading_transaction;
923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
924: FND_MSG_PUB.Add_Exc_Msg
925: ( G_PKG_NAME,
926: l_api_name
927: );

Line 924: FND_MSG_PUB.Add_Exc_Msg

920: WHEN OTHERS THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
922: ROLLBACK TO create_reading_transaction;
923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
924: FND_MSG_PUB.Add_Exc_Msg
925: ( G_PKG_NAME,
926: l_api_name
927: );
928: END IF;

Line 929: FND_MSG_PUB.Count_And_Get

925: ( G_PKG_NAME,
926: l_api_name
927: );
928: END IF;
929: FND_MSG_PUB.Count_And_Get
930: ( p_count => x_msg_count,
931: p_data => x_msg_data
932: );
933: END Create_Reading_Transaction;

Line 1042: FND_MSG_PUB.initialize;

1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: -- Initialize message list if p_init_msg_list is set to TRUE.
1041: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044: -- Initialize API return status to success
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: --

Line 1210: x_msg_data := FND_MSG_PUB.GET

1206: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading when disabling WO ');
1207: l_msg_index := 1;
1208: l_msg_count := x_msg_count;
1209: WHILE l_msg_count > 0 LOOP
1210: x_msg_data := FND_MSG_PUB.GET
1211: (l_msg_index,
1212: FND_API.G_FALSE
1213: );
1214: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1957: x_msg_data := FND_MSG_PUB.GET

1953: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
1954: l_msg_index := 1;
1955: l_msg_count := x_msg_count;
1956: WHILE l_msg_count > 0 LOOP
1957: x_msg_data := FND_MSG_PUB.GET
1958: ( l_msg_index,
1959: FND_API.G_FALSE
1960: );
1961: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2050: x_msg_data := FND_MSG_PUB.GET

2046: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');
2047: l_msg_index := 1;
2048: l_msg_count := x_msg_count;
2049: WHILE l_msg_count > 0 LOOP
2050: x_msg_data := FND_MSG_PUB.GET
2051: ( l_msg_index,
2052: FND_API.G_FALSE
2053: );
2054: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2178: x_msg_data := FND_MSG_PUB.GET

2174: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');
2175: l_msg_index := 1;
2176: l_msg_count := x_msg_count;
2177: WHILE l_msg_count > 0 LOOP
2178: x_msg_data := FND_MSG_PUB.GET
2179: ( l_msg_index,
2180: FND_API.G_FALSE
2181: );
2182: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2248: x_msg_data := FND_MSG_PUB.GET

2244: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');
2245: l_msg_index := 1;
2246: l_msg_count := x_msg_count;
2247: WHILE l_msg_count > 0 LOOP
2248: x_msg_data := FND_MSG_PUB.GET
2249: ( l_msg_index,
2250: FND_API.G_FALSE
2251: );
2252: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2404: x_msg_data := FND_MSG_PUB.GET

2400: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
2401: l_msg_index := 1;
2402: l_msg_count := x_msg_count;
2403: WHILE l_msg_count > 0 LOOP
2404: x_msg_data := FND_MSG_PUB.GET
2405: ( l_msg_index,
2406: FND_API.G_FALSE
2407: );
2408: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2449: x_msg_data := FND_MSG_PUB.GET

2445: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Reset_Target_Counters API ');
2446: l_msg_index := 1;
2447: l_msg_count := x_msg_count;
2448: WHILE l_msg_count > 0 LOOP
2449: x_msg_data := FND_MSG_PUB.GET
2450: ( l_msg_index,
2451: FND_API.G_FALSE
2452: );
2453: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2470: FND_MSG_PUB.Count_And_Get

2466: COMMIT WORK;
2467: END IF;
2468: --
2469: -- Standard call to get message count and IF count is get message info.
2470: FND_MSG_PUB.Count_And_Get
2471: ( p_count => x_msg_count,
2472: p_data => x_msg_data
2473: );
2474: EXCEPTION

Line 2477: FND_MSG_PUB.Count_And_Get

2473: );
2474: EXCEPTION
2475: WHEN Skip_Process THEN
2476: x_return_status := FND_API.G_RET_STS_SUCCESS;
2477: FND_MSG_PUB.Count_And_Get
2478: ( p_count => x_msg_count,
2479: p_data => x_msg_data
2480: );
2481: WHEN FND_API.G_EXC_ERROR THEN

Line 2484: FND_MSG_PUB.Count_And_Get

2480: );
2481: WHEN FND_API.G_EXC_ERROR THEN
2482: x_return_status := FND_API.G_RET_STS_ERROR ;
2483: ROLLBACK TO capture_counter_reading_pvt;
2484: FND_MSG_PUB.Count_And_Get
2485: ( p_count => x_msg_count,
2486: p_data => x_msg_data
2487: );
2488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2491: FND_MSG_PUB.Count_And_Get

2487: );
2488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2490: ROLLBACK TO capture_counter_reading_pvt;
2491: FND_MSG_PUB.Count_And_Get
2492: ( p_count => x_msg_count,
2493: p_data => x_msg_data
2494: );
2495: WHEN OTHERS THEN

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

2494: );
2495: WHEN OTHERS THEN
2496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2497: ROLLBACK TO capture_counter_reading_pvt;
2498: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2499: FND_MSG_PUB.Add_Exc_Msg
2500: ( G_PKG_NAME,
2501: l_api_name
2502: );

Line 2499: FND_MSG_PUB.Add_Exc_Msg

2495: WHEN OTHERS THEN
2496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2497: ROLLBACK TO capture_counter_reading_pvt;
2498: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2499: FND_MSG_PUB.Add_Exc_Msg
2500: ( G_PKG_NAME,
2501: l_api_name
2502: );
2503: END IF;

Line 2504: FND_MSG_PUB.Count_And_Get

2500: ( G_PKG_NAME,
2501: l_api_name
2502: );
2503: END IF;
2504: FND_MSG_PUB.Count_And_Get
2505: ( p_count => x_msg_count,
2506: p_data => x_msg_data
2507: );
2508: END Capture_Counter_Reading;

Line 2594: FND_MSG_PUB.initialize;

2590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2591: END IF;
2592: -- Initialize message list if p_init_msg_list is set to TRUE.
2593: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2594: FND_MSG_PUB.initialize;
2595: END IF;
2596: -- Initialize API return status to success
2597: x_return_status := FND_API.G_RET_STS_SUCCESS;
2598:

Line 2821: x_msg_data := FND_MSG_PUB.GET

2817: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
2818: l_msg_index := 1;
2819: l_msg_count := x_msg_count;
2820: WHILE l_msg_count > 0 LOOP
2821: x_msg_data := FND_MSG_PUB.GET
2822: ( l_msg_index,
2823: FND_API.G_FALSE
2824: );
2825: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2851: x_msg_data := FND_MSG_PUB.GET

2847: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
2848: l_msg_index := 1;
2849: l_msg_count := x_msg_count;
2850: WHILE l_msg_count > 0 LOOP
2851: x_msg_data := FND_MSG_PUB.GET
2852: ( l_msg_index,
2853: FND_API.G_FALSE
2854: );
2855: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2894: x_msg_data := FND_MSG_PUB.GET

2890: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
2891: l_msg_index := 1;
2892: l_msg_count := x_msg_count;
2893: WHILE l_msg_count > 0 LOOP
2894: x_msg_data := FND_MSG_PUB.GET
2895: ( l_msg_index,
2896: FND_API.G_FALSE
2897: );
2898: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2970: FND_MSG_PUB.Count_And_Get

2966: COMMIT WORK;
2967: END IF;
2968: --
2969: -- Standard call to get message count and IF count is get message info.
2970: FND_MSG_PUB.Count_And_Get
2971: ( p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: EXCEPTION

Line 2978: FND_MSG_PUB.Count_And_Get

2974: EXCEPTION
2975: WHEN FND_API.G_EXC_ERROR THEN
2976: x_return_status := FND_API.G_RET_STS_ERROR ;
2977: ROLLBACK TO compute_formula_counters;
2978: FND_MSG_PUB.Count_And_Get
2979: ( p_count => x_msg_count,
2980: p_data => x_msg_data
2981: );
2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2985: FND_MSG_PUB.Count_And_Get

2981: );
2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2984: ROLLBACK TO compute_formula_counters;
2985: FND_MSG_PUB.Count_And_Get
2986: ( p_count => x_msg_count,
2987: p_data => x_msg_data
2988: );
2989: WHEN OTHERS THEN

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

2988: );
2989: WHEN OTHERS THEN
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: ROLLBACK TO compute_formula_counters;
2992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2993: FND_MSG_PUB.Add_Exc_Msg
2994: ( G_PKG_NAME,
2995: l_api_name
2996: );

Line 2993: FND_MSG_PUB.Add_Exc_Msg

2989: WHEN OTHERS THEN
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: ROLLBACK TO compute_formula_counters;
2992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2993: FND_MSG_PUB.Add_Exc_Msg
2994: ( G_PKG_NAME,
2995: l_api_name
2996: );
2997: END IF;

Line 2998: FND_MSG_PUB.Count_And_Get

2994: ( G_PKG_NAME,
2995: l_api_name
2996: );
2997: END IF;
2998: FND_MSG_PUB.Count_And_Get
2999: ( p_count => x_msg_count,
3000: p_data => x_msg_data
3001: );
3002: END Compute_Formula_Counters;

Line 3100: FND_MSG_PUB.initialize;

3096: -- Standard Start of API savepoint
3097: SAVEPOINT compute_derive_counters;
3098: -- Initialize message list if p_init_msg_list is set to TRUE.
3099: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3100: FND_MSG_PUB.initialize;
3101: END IF;
3102: x_return_status := FND_API.G_RET_STS_SUCCESS;
3103: --
3104:

Line 3447: x_msg_data := FND_MSG_PUB.GET

3443: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
3444: l_msg_index := 1;
3445: l_msg_count := x_msg_count;
3446: WHILE l_msg_count > 0 LOOP
3447: x_msg_data := FND_MSG_PUB.GET
3448: ( l_msg_index,
3449: FND_API.G_FALSE
3450: );
3451: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3469: FND_MSG_PUB.Count_And_Get

3465: EXCEPTION
3466: WHEN FND_API.G_EXC_ERROR THEN
3467: x_return_status := FND_API.G_RET_STS_ERROR ;
3468: ROLLBACK TO compute_derive_counters;
3469: FND_MSG_PUB.Count_And_Get
3470: ( p_count => x_msg_count,
3471: p_data => x_msg_data
3472: );
3473: WHEN OTHERS THEN

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

3472: );
3473: WHEN OTHERS THEN
3474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3475: ROLLBACK TO compute_derive_counters;
3476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3477: FND_MSG_PUB.Add_Exc_Msg
3478: ( G_PKG_NAME,
3479: l_api_name
3480: );

Line 3477: FND_MSG_PUB.Add_Exc_Msg

3473: WHEN OTHERS THEN
3474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3475: ROLLBACK TO compute_derive_counters;
3476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3477: FND_MSG_PUB.Add_Exc_Msg
3478: ( G_PKG_NAME,
3479: l_api_name
3480: );
3481: END IF;

Line 3482: FND_MSG_PUB.Count_And_Get

3478: ( G_PKG_NAME,
3479: l_api_name
3480: );
3481: END IF;
3482: FND_MSG_PUB.Count_And_Get
3483: ( p_count => x_msg_count,
3484: p_data => x_msg_data
3485: );
3486: IF DBMS_SQL.IS_OPEN(l_cursor_handle) THEN

Line 3588: FND_MSG_PUB.initialize;

3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3585: END IF;
3586: -- Initialize message list if p_init_msg_list is set to TRUE.
3587: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3588: FND_MSG_PUB.initialize;
3589: END IF;
3590: -- Initialize API return status to success
3591: x_return_status := FND_API.G_RET_STS_SUCCESS;
3592: --

Line 4123: x_msg_data := FND_MSG_PUB.GET

4119: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Insert_Meter_Log API ');
4120: l_msg_index := 1;
4121: l_msg_count := x_msg_count;
4122: WHILE l_msg_count > 0 LOOP
4123: x_msg_data := FND_MSG_PUB.GET
4124: ( l_msg_index,
4125: FND_API.G_FALSE
4126: );
4127: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4152: x_msg_data := FND_MSG_PUB.GET

4148: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');
4149: l_msg_index := 1;
4150: l_msg_count := x_msg_count;
4151: WHILE l_msg_count > 0 LOOP
4152: x_msg_data := FND_MSG_PUB.GET
4153: ( l_msg_index,
4154: FND_API.G_FALSE
4155: );
4156: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4255: x_msg_data := FND_MSG_PUB.GET

4251: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
4252: l_msg_index := 1;
4253: l_msg_count := x_msg_count;
4254: WHILE l_msg_count > 0 LOOP
4255: x_msg_data := FND_MSG_PUB.GET
4256: ( l_msg_index,
4257: FND_API.G_FALSE
4258: );
4259: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4277: FND_MSG_PUB.Count_And_Get

4273: COMMIT WORK;
4274: END IF;
4275: --
4276: -- Standard call to get message count and IF count is get message info.
4277: FND_MSG_PUB.Count_And_Get
4278: ( p_count => x_msg_count,
4279: p_data => x_msg_data
4280: );
4281: EXCEPTION

Line 4285: FND_MSG_PUB.Count_And_Get

4281: EXCEPTION
4282: WHEN FND_API.G_EXC_ERROR THEN
4283: x_return_status := FND_API.G_RET_STS_ERROR ;
4284: ROLLBACK TO compute_target_counters;
4285: FND_MSG_PUB.Count_And_Get
4286: ( p_count => x_msg_count,
4287: p_data => x_msg_data
4288: );
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4292: FND_MSG_PUB.Count_And_Get

4288: );
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4291: ROLLBACK TO compute_target_counters;
4292: FND_MSG_PUB.Count_And_Get
4293: ( p_count => x_msg_count,
4294: p_data => x_msg_data
4295: );
4296: WHEN OTHERS THEN

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

4295: );
4296: WHEN OTHERS THEN
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4298: ROLLBACK TO compute_target_counters;
4299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4300: FND_MSG_PUB.Add_Exc_Msg
4301: ( G_PKG_NAME,
4302: l_api_name
4303: );

Line 4300: FND_MSG_PUB.Add_Exc_Msg

4296: WHEN OTHERS THEN
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4298: ROLLBACK TO compute_target_counters;
4299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4300: FND_MSG_PUB.Add_Exc_Msg
4301: ( G_PKG_NAME,
4302: l_api_name
4303: );
4304: END IF;

Line 4305: FND_MSG_PUB.Count_And_Get

4301: ( G_PKG_NAME,
4302: l_api_name
4303: );
4304: END IF;
4305: FND_MSG_PUB.Count_And_Get
4306: ( p_count => x_msg_count,
4307: p_data => x_msg_data
4308: );
4309: END Compute_Target_Counters;

Line 4417: FND_MSG_PUB.initialize;

4413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4414: END IF;
4415: -- Initialize message list if p_init_msg_list is set to TRUE.
4416: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4417: FND_MSG_PUB.initialize;
4418: END IF;
4419: -- Initialize API return status to success
4420: x_return_status := FND_API.G_RET_STS_SUCCESS;
4421: --

Line 4762: x_msg_data := FND_MSG_PUB.GET

4758: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4759: l_msg_index := 1;
4760: l_msg_count := x_msg_count;
4761: WHILE l_msg_count > 0 LOOP
4762: x_msg_data := FND_MSG_PUB.GET
4763: (l_msg_index,
4764: FND_API.G_FALSE
4765: );
4766: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');

Line 4920: x_msg_data := FND_MSG_PUB.GET

4916: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4917: l_msg_index := 1;
4918: l_msg_count := x_msg_count;
4919: WHILE l_msg_count > 0 LOOP
4920: x_msg_data := FND_MSG_PUB.GET
4921: ( l_msg_index,
4922: FND_API.G_FALSE
4923: );
4924: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');

Line 4963: x_msg_data := FND_MSG_PUB.GET

4959: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
4960: l_msg_index := 1;
4961: l_msg_count := x_msg_count;
4962: WHILE l_msg_count > 0 LOOP
4963: x_msg_data := FND_MSG_PUB.GET
4964: ( l_msg_index,
4965: FND_API.G_FALSE
4966: );
4967: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5034: x_msg_data := FND_MSG_PUB.GET

5030: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5031: l_msg_index := 1;
5032: l_msg_count := x_msg_count;
5033: WHILE l_msg_count > 0 LOOP
5034: x_msg_data := FND_MSG_PUB.GET
5035: ( l_msg_index,
5036: FND_API.G_FALSE
5037: );
5038: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Target_Counters API ');

Line 5074: x_msg_data := FND_MSG_PUB.GET

5070: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5071: l_msg_index := 1;
5072: l_msg_count := x_msg_count;
5073: WHILE l_msg_count > 0 LOOP
5074: x_msg_data := FND_MSG_PUB.GET
5075: ( l_msg_index,
5076: FND_API.G_FALSE
5077: );
5078: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');

Line 5122: x_msg_data := FND_MSG_PUB.GET

5118: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5119: l_msg_index := 1;
5120: l_msg_count := x_msg_count;
5121: WHILE l_msg_count > 0 LOOP
5122: x_msg_data := FND_MSG_PUB.GET
5123: ( l_msg_index,
5124: FND_API.G_FALSE
5125: );
5126: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');

Line 5160: x_msg_data := FND_MSG_PUB.GET

5156: csi_ctr_gen_utility_pvt.put_line('Error from Compute_Formula_Counters API...');
5157: l_msg_index := 1;
5158: l_msg_count := x_msg_count;
5159: WHILE l_msg_count > 0 LOOP
5160: x_msg_data := FND_MSG_PUB.GET
5161: ( l_msg_index,
5162: FND_API.G_FALSE
5163: );
5164: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Formula_Counters API ');

Line 5177: FND_MSG_PUB.Count_And_Get

5173: COMMIT WORK;
5174: END IF;
5175: --
5176: -- Standard call to get message count and IF count is get message info.
5177: FND_MSG_PUB.Count_And_Get
5178: ( p_count => x_msg_count,
5179: p_data => x_msg_data
5180: );
5181: EXCEPTION

Line 5185: FND_MSG_PUB.Count_And_Get

5181: EXCEPTION
5182: WHEN FND_API.G_EXC_ERROR THEN
5183: x_return_status := FND_API.G_RET_STS_ERROR ;
5184: ROLLBACK TO update_counter_reading_pvt;
5185: FND_MSG_PUB.Count_And_Get
5186: ( p_count => x_msg_count,
5187: p_data => x_msg_data
5188: );
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5192: FND_MSG_PUB.Count_And_Get

5188: );
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5191: ROLLBACK TO update_counter_reading_pvt;
5192: FND_MSG_PUB.Count_And_Get
5193: ( p_count => x_msg_count,
5194: p_data => x_msg_data
5195: );
5196: WHEN OTHERS THEN

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

5195: );
5196: WHEN OTHERS THEN
5197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5198: ROLLBACK TO update_counter_reading_pvt;
5199: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5200: FND_MSG_PUB.Add_Exc_Msg
5201: ( G_PKG_NAME,
5202: l_api_name
5203: );

Line 5200: FND_MSG_PUB.Add_Exc_Msg

5196: WHEN OTHERS THEN
5197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5198: ROLLBACK TO update_counter_reading_pvt;
5199: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5200: FND_MSG_PUB.Add_Exc_Msg
5201: ( G_PKG_NAME,
5202: l_api_name
5203: );
5204: END IF;

Line 5205: FND_MSG_PUB.Count_And_Get

5201: ( G_PKG_NAME,
5202: l_api_name
5203: );
5204: END IF;
5205: FND_MSG_PUB.Count_And_Get
5206: ( p_count => x_msg_count,
5207: p_data => x_msg_data
5208: );
5209: END Update_Counter_Reading;

Line 5254: FND_MSG_PUB.initialize;

5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: END IF;
5252: -- Initialize message list if p_init_msg_list is set to TRUE.
5253: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5254: FND_MSG_PUB.initialize;
5255: END IF;
5256: -- Initialize API return status to success
5257: x_return_status := FND_API.G_RET_STS_SUCCESS;
5258: --

Line 5424: FND_MSG_PUB.Count_And_Get

5420: COMMIT WORK;
5421: END IF;
5422: --
5423: -- Standard call to get message count and IF count is get message info.
5424: FND_MSG_PUB.Count_And_Get
5425: ( p_count => x_msg_count,
5426: p_data => x_msg_data
5427: );
5428: EXCEPTION

Line 5432: FND_MSG_PUB.Count_And_Get

5428: EXCEPTION
5429: WHEN FND_API.G_EXC_ERROR THEN
5430: x_return_status := FND_API.G_RET_STS_ERROR ;
5431: ROLLBACK TO capture_ctr_property_reading;
5432: FND_MSG_PUB.Count_And_Get
5433: ( p_count => x_msg_count,
5434: p_data => x_msg_data
5435: );
5436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5439: FND_MSG_PUB.Count_And_Get

5435: );
5436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5438: ROLLBACK TO capture_ctr_property_reading;
5439: FND_MSG_PUB.Count_And_Get
5440: ( p_count => x_msg_count,
5441: p_data => x_msg_data
5442: );
5443: WHEN OTHERS THEN

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

5442: );
5443: WHEN OTHERS THEN
5444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5445: ROLLBACK TO capture_ctr_property_reading;
5446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5447: FND_MSG_PUB.Add_Exc_Msg
5448: ( G_PKG_NAME,
5449: l_api_name
5450: );

Line 5447: FND_MSG_PUB.Add_Exc_Msg

5443: WHEN OTHERS THEN
5444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5445: ROLLBACK TO capture_ctr_property_reading;
5446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5447: FND_MSG_PUB.Add_Exc_Msg
5448: ( G_PKG_NAME,
5449: l_api_name
5450: );
5451: END IF;

Line 5452: FND_MSG_PUB.Count_And_Get

5448: ( G_PKG_NAME,
5449: l_api_name
5450: );
5451: END IF;
5452: FND_MSG_PUB.Count_And_Get
5453: ( p_count => x_msg_count,
5454: p_data => x_msg_data
5455: );
5456: END Capture_Ctr_Property_Reading;

Line 5550: FND_MSG_PUB.initialize;

5546: BEGIN
5547: SAVEPOINT ESTIMATE_START_READINGS;
5548: -- Initialize message list if p_init_msg_list is set to TRUE.
5549: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5550: FND_MSG_PUB.initialize;
5551: END IF;
5552: -- Initialize API return status to SUCCESS
5553: x_return_status := FND_API.G_RET_STS_SUCCESS;
5554: --

Line 5628: FND_MSG_PUB.Count_And_Get

5624: COMMIT WORK;
5625: END IF;
5626: --
5627: -- Standard call to get message count and IF count is get message info.
5628: FND_MSG_PUB.Count_And_Get
5629: ( p_count => x_msg_count,
5630: p_data => x_msg_data
5631: );
5632:

Line 5637: FND_MSG_PUB.Count_And_Get

5633: EXCEPTION
5634: WHEN FND_API.G_EXC_ERROR THEN
5635: ROLLBACK TO ESTIMATE_START_READINGS;
5636: x_return_status := FND_API.G_RET_STS_ERROR ;
5637: FND_MSG_PUB.Count_And_Get
5638: (p_count => x_msg_count,
5639: p_data => x_msg_data
5640: );
5641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5644: FND_MSG_PUB.Count_And_Get

5640: );
5641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5642: ROLLBACK TO ESTIMATE_START_READINGS;
5643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5644: FND_MSG_PUB.Count_And_Get
5645: (
5646: p_count => x_msg_count,
5647: p_data => x_msg_data
5648: );

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

5648: );
5649: WHEN OTHERS THEN
5650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5651: ROLLBACK TO ESTIMATE_START_READINGS;
5652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5653: FND_MSG_PUB.Add_Exc_Msg
5654: ( G_PKG_NAME,
5655: l_api_name
5656: );

Line 5653: FND_MSG_PUB.Add_Exc_Msg

5649: WHEN OTHERS THEN
5650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5651: ROLLBACK TO ESTIMATE_START_READINGS;
5652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5653: FND_MSG_PUB.Add_Exc_Msg
5654: ( G_PKG_NAME,
5655: l_api_name
5656: );
5657: END IF;

Line 5658: FND_MSG_PUB.Count_And_Get

5654: ( G_PKG_NAME,
5655: l_api_name
5656: );
5657: END IF;
5658: FND_MSG_PUB.Count_And_Get
5659: ( p_count => x_msg_count,
5660: p_data => x_msg_data
5661: );
5662: END ESTIMATE_START_READINGS;

Line 5751: FND_MSG_PUB.initialize;

5747: BEGIN
5748: SAVEPOINT EST_PERIOD_START_READINGS;
5749: -- Initialize message list if p_init_msg_list is set to TRUE.
5750: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5751: FND_MSG_PUB.initialize;
5752: END IF;
5753: -- Initialize API return status to SUCCESS
5754: x_return_status := FND_API.G_RET_STS_SUCCESS;
5755: --

Line 5837: x_msg_data := FND_MSG_PUB.GET

5833: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Start_Readings API ');
5834: l_msg_index := 1;
5835: l_msg_count := x_msg_count;
5836: WHILE l_msg_count > 0 LOOP
5837: x_msg_data := FND_MSG_PUB.GET
5838: ( l_msg_index,
5839: FND_API.G_FALSE
5840: );
5841: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5896: FND_MSG_PUB.Count_And_Get

5892: x_calc_start_reading := round(l_calculation_start_rdg);
5893: END IF; --l_calculation_start_rdg null
5894: --
5895: -- Standard call to get message count and IF count is get message info.
5896: FND_MSG_PUB.Count_And_Get
5897: ( p_count => x_msg_count,
5898: p_data => x_msg_data
5899: );
5900:

Line 5905: FND_MSG_PUB.Count_And_Get

5901: EXCEPTION
5902: WHEN FND_API.G_EXC_ERROR THEN
5903: ROLLBACK TO EST_PERIOD_START_READINGS;
5904: x_return_status := FND_API.G_RET_STS_ERROR ;
5905: FND_MSG_PUB.Count_And_Get
5906: (p_count => x_msg_count,
5907: p_data => x_msg_data
5908: );
5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5912: FND_MSG_PUB.Count_And_Get

5908: );
5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5910: ROLLBACK TO EST_PERIOD_START_READINGS;
5911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5912: FND_MSG_PUB.Count_And_Get
5913: (
5914: p_count => x_msg_count,
5915: p_data => x_msg_data
5916: );

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

5916: );
5917: WHEN OTHERS THEN
5918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5919: ROLLBACK TO EST_PERIOD_START_READINGS;
5920: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5921: FND_MSG_PUB.Add_Exc_Msg
5922: ( G_PKG_NAME,
5923: l_api_name
5924: );

Line 5921: FND_MSG_PUB.Add_Exc_Msg

5917: WHEN OTHERS THEN
5918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5919: ROLLBACK TO EST_PERIOD_START_READINGS;
5920: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5921: FND_MSG_PUB.Add_Exc_Msg
5922: ( G_PKG_NAME,
5923: l_api_name
5924: );
5925: END IF;

Line 5926: FND_MSG_PUB.Count_And_Get

5922: ( G_PKG_NAME,
5923: l_api_name
5924: );
5925: END IF;
5926: FND_MSG_PUB.Count_And_Get
5927: ( p_count => x_msg_count,
5928: p_data => x_msg_data
5929: );
5930: END EST_PERIOD_START_READINGS;

Line 6032: FND_MSG_PUB.initialize;

6028: BEGIN
6029: SAVEPOINT ESTIMATE_USAGE;
6030: -- Initialize message list if p_init_msg_list is set to TRUE.
6031: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6032: FND_MSG_PUB.initialize;
6033: END IF;
6034: -- Initialize API return status to SUCCESS
6035: x_return_status := FND_API.G_RET_STS_SUCCESS;
6036: --

Line 6062: x_msg_data := FND_MSG_PUB.GET

6058: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6059: l_msg_index := 1;
6060: l_msg_count := x_msg_count;
6061: WHILE l_msg_count > 0 LOOP
6062: x_msg_data := FND_MSG_PUB.GET
6063: ( l_msg_index,
6064: FND_API.G_FALSE
6065: );
6066: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Start_Readings API ');

Line 6095: x_msg_data := FND_MSG_PUB.GET

6091: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6092: l_msg_index := 1;
6093: l_msg_count := x_msg_count;
6094: WHILE l_msg_count > 0 LOOP
6095: x_msg_data := FND_MSG_PUB.GET
6096: ( l_msg_index,
6097: FND_API.G_FALSE
6098: );
6099: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Est_Period_Start_Readings API ');

Line 6342: FND_MSG_PUB.Count_And_Get

6338: COMMIT WORK;
6339: END IF;
6340: --
6341: -- Standard call to get message count and IF count is get message info.
6342: FND_MSG_PUB.Count_And_Get
6343: ( p_count => x_msg_count,
6344: p_data => x_msg_data
6345: );
6346:

Line 6351: FND_MSG_PUB.Count_And_Get

6347: EXCEPTION
6348: WHEN FND_API.G_EXC_ERROR THEN
6349: ROLLBACK TO ESTIMATE_USAGE;
6350: x_return_status := FND_API.G_RET_STS_ERROR ;
6351: FND_MSG_PUB.Count_And_Get
6352: (p_count => x_msg_count,
6353: p_data => x_msg_data
6354: );
6355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6358: FND_MSG_PUB.Count_And_Get

6354: );
6355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6356: ROLLBACK TO ESTIMATE_USAGE;
6357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6358: FND_MSG_PUB.Count_And_Get
6359: (
6360: p_count => x_msg_count,
6361: p_data => x_msg_data
6362: );

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

6362: );
6363: WHEN OTHERS THEN
6364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6365: ROLLBACK TO ESTIMATE_USAGE;
6366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6367: FND_MSG_PUB.Add_Exc_Msg
6368: ( G_PKG_NAME,
6369: l_api_name
6370: );

Line 6367: FND_MSG_PUB.Add_Exc_Msg

6363: WHEN OTHERS THEN
6364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6365: ROLLBACK TO ESTIMATE_USAGE;
6366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6367: FND_MSG_PUB.Add_Exc_Msg
6368: ( G_PKG_NAME,
6369: l_api_name
6370: );
6371: END IF;

Line 6372: FND_MSG_PUB.Count_And_Get

6368: ( G_PKG_NAME,
6369: l_api_name
6370: );
6371: END IF;
6372: FND_MSG_PUB.Count_And_Get
6373: ( p_count => x_msg_count,
6374: p_data => x_msg_data
6375: );
6376: END ESTIMATE_USAGE;

Line 6455: FND_MSG_PUB.initialize;

6451: BEGIN
6452: SAVEPOINT ESTIMATE_COUNTER_READING;
6453: -- Initialize message list if p_init_msg_list is set to TRUE.
6454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6455: FND_MSG_PUB.initialize;
6456: END IF;
6457: -- Initialize API return status to SUCCESS
6458: x_return_status := FND_API.G_RET_STS_SUCCESS;
6459: --

Line 6568: x_msg_data := FND_MSG_PUB.GET

6564: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_fixed_values API ');
6565: l_msg_index := 1;
6566: l_msg_count := x_msg_count;
6567: WHILE l_msg_count > 0 LOOP
6568: x_msg_data := FND_MSG_PUB.GET
6569: ( l_msg_index,
6570: FND_API.G_FALSE
6571: );
6572: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6609: x_msg_data := FND_MSG_PUB.GET

6605: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Usage API ');
6606: l_msg_index := 1;
6607: l_msg_count := x_msg_count;
6608: WHILE l_msg_count > 0 LOOP
6609: x_msg_data := FND_MSG_PUB.GET
6610: ( l_msg_index,
6611: FND_API.G_FALSE
6612: );
6613: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6661: x_msg_data := FND_MSG_PUB.GET

6657: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Estimate_Usage API ');
6658: l_msg_index := 1;
6659: l_msg_count := x_msg_count;
6660: WHILE l_msg_count > 0 LOOP
6661: x_msg_data := FND_MSG_PUB.GET
6662: ( l_msg_index,
6663: FND_API.G_FALSE
6664: );
6665: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6725: FND_MSG_PUB.Count_And_Get

6721: COMMIT WORK;
6722: END IF;
6723: --
6724: -- Standard call to get message count and IF count is get message info.
6725: FND_MSG_PUB.Count_And_Get
6726: ( p_count => x_msg_count,
6727: p_data => x_msg_data
6728: );
6729:

Line 6734: FND_MSG_PUB.Count_And_Get

6730: EXCEPTION
6731: WHEN FND_API.G_EXC_ERROR THEN
6732: ROLLBACK TO ESTIMATE_COUNTER_READING;
6733: x_return_status := FND_API.G_RET_STS_ERROR ;
6734: FND_MSG_PUB.Count_And_Get
6735: (p_count => x_msg_count,
6736: p_data => x_msg_data
6737: );
6738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6741: FND_MSG_PUB.Count_And_Get

6737: );
6738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6739: ROLLBACK TO ESTIMATE_COUNTER_READING;
6740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6741: FND_MSG_PUB.Count_And_Get
6742: (
6743: p_count => x_msg_count,
6744: p_data => x_msg_data
6745: );

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

6745: );
6746: WHEN OTHERS THEN
6747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6748: ROLLBACK TO ESTIMATE_COUNTER_READING;
6749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6750: FND_MSG_PUB.Add_Exc_Msg
6751: ( G_PKG_NAME,
6752: l_api_name
6753: );

Line 6750: FND_MSG_PUB.Add_Exc_Msg

6746: WHEN OTHERS THEN
6747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6748: ROLLBACK TO ESTIMATE_COUNTER_READING;
6749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6750: FND_MSG_PUB.Add_Exc_Msg
6751: ( G_PKG_NAME,
6752: l_api_name
6753: );
6754: END IF;

Line 6755: FND_MSG_PUB.Count_And_Get

6751: ( G_PKG_NAME,
6752: l_api_name
6753: );
6754: END IF;
6755: FND_MSG_PUB.Count_And_Get
6756: ( p_count => x_msg_count,
6757: p_data => x_msg_data
6758: );
6759: END ESTIMATE_COUNTER_READING;

Line 6819: FND_MSG_PUB.initialize;

6815: BEGIN
6816: SAVEPOINT ESTIMATE_FIXED_VALUES;
6817: -- Initialize message list if p_init_msg_list is set to TRUE.
6818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6819: FND_MSG_PUB.initialize;
6820: END IF;
6821: -- Initialize API return status to SUCCESS
6822: x_return_status := FND_API.G_RET_STS_SUCCESS;
6823: --

Line 6859: x_msg_data := FND_MSG_PUB.GET

6855: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Est_Period_Start_Readings API ');
6856: l_msg_index := 1;
6857: l_msg_count := x_msg_count;
6858: WHILE l_msg_count > 0 LOOP
6859: x_msg_data := FND_MSG_PUB.GET
6860: ( l_msg_index,
6861: FND_API.G_FALSE
6862: );
6863: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6903: FND_MSG_PUB.Count_And_Get

6899: COMMIT WORK;
6900: END IF;
6901: --
6902: -- Standard call to get message count and IF count is get message info.
6903: FND_MSG_PUB.Count_And_Get
6904: ( p_count => x_msg_count,
6905: p_data => x_msg_data
6906: );
6907:

Line 6912: FND_MSG_PUB.Count_And_Get

6908: EXCEPTION
6909: WHEN FND_API.G_EXC_ERROR THEN
6910: ROLLBACK TO ESTIMATE_FIXED_VALUES;
6911: x_return_status := FND_API.G_RET_STS_ERROR ;
6912: FND_MSG_PUB.Count_And_Get
6913: (p_count => x_msg_count,
6914: p_data => x_msg_data
6915: );
6916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6919: FND_MSG_PUB.Count_And_Get

6915: );
6916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6917: ROLLBACK TO ESTIMATE_FIXED_VALUES;
6918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6919: FND_MSG_PUB.Count_And_Get
6920: (
6921: p_count => x_msg_count,
6922: p_data => x_msg_data
6923: );

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

6923: );
6924: WHEN OTHERS THEN
6925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6926: ROLLBACK TO ESTIMATE_FIXED_VALUES;
6927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6928: FND_MSG_PUB.Add_Exc_Msg
6929: ( G_PKG_NAME,
6930: l_api_name
6931: );

Line 6928: FND_MSG_PUB.Add_Exc_Msg

6924: WHEN OTHERS THEN
6925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6926: ROLLBACK TO ESTIMATE_FIXED_VALUES;
6927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6928: FND_MSG_PUB.Add_Exc_Msg
6929: ( G_PKG_NAME,
6930: l_api_name
6931: );
6932: END IF;

Line 6933: FND_MSG_PUB.Count_And_Get

6929: ( G_PKG_NAME,
6930: l_api_name
6931: );
6932: END IF;
6933: FND_MSG_PUB.Count_And_Get
6934: ( p_count => x_msg_count,
6935: p_data => x_msg_data
6936: );
6937: END ESTIMATE_FIXED_VALUES;