DBA Data[Home] [Help]

APPS.CSI_TIME_BASED_CTR_ENGINE_PKG dependencies on FND_API

Line 45: ,p_commit => fnd_api.g_false

41: --
42: /* -- bug 15972103
43: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
44: ( p_api_version => 1.0
45: ,p_commit => fnd_api.g_false
46: ,p_init_msg_list => fnd_api.g_true
47: ,p_validation_level => fnd_api.g_valid_level_full
48: ,p_txn_rec => l_txn_rec
49: ,x_return_status => x_return_status

Line 46: ,p_init_msg_list => fnd_api.g_true

42: /* -- bug 15972103
43: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
44: ( p_api_version => 1.0
45: ,p_commit => fnd_api.g_false
46: ,p_init_msg_list => fnd_api.g_true
47: ,p_validation_level => fnd_api.g_valid_level_full
48: ,p_txn_rec => l_txn_rec
49: ,x_return_status => x_return_status
50: ,x_msg_count => x_msg_count

Line 47: ,p_validation_level => fnd_api.g_valid_level_full

43: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
44: ( p_api_version => 1.0
45: ,p_commit => fnd_api.g_false
46: ,p_init_msg_list => fnd_api.g_true
47: ,p_validation_level => fnd_api.g_valid_level_full
48: ,p_txn_rec => l_txn_rec
49: ,x_return_status => x_return_status
50: ,x_msg_count => x_msg_count
51: ,x_msg_data => x_msg_data

Line 53: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

49: ,x_return_status => x_return_status
50: ,x_msg_count => x_msg_count
51: ,x_msg_data => x_msg_data
52: );*/
53: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
54: fnd_file.put_line(fnd_file.log,'Error from Create_Reading_Transaction...');
55: l_msg_index := 1;
56: FND_MSG_PUB.Count_And_Get
57: (p_count => x_msg_count,

Line 64: FND_API.G_FALSE );

60: l_msg_count := x_msg_count;
61: WHILE l_msg_count > 0 LOOP
62: x_msg_data := FND_MSG_PUB.GET
63: ( l_msg_index,
64: FND_API.G_FALSE );
65: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
66: l_msg_index := l_msg_index + 1;
67: l_msg_count := l_msg_count - 1;
68: END LOOP;

Line 69: RAISE FND_API.G_EXC_ERROR;

65: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
66: l_msg_index := l_msg_index + 1;
67: l_msg_count := l_msg_count - 1;
68: END LOOP;
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71: fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');
72: select CSI_COUNTER_READINGS_S.nextval
73: into l_ctr_rdg_rec.counter_value_id from dual;

Line 137: ,p_commit => fnd_api.g_false

133: );
134: -- Added for FP Tracking bug 7390758 (base bug 7374316)
135: CSI_COUNTER_PVT.update_ctr_val_max_seq_no(
136: p_api_version => 1.0
137: ,p_commit => fnd_api.g_false
138: ,p_init_msg_list => fnd_api.g_true
139: ,p_validation_level => fnd_api.g_valid_level_full
140: ,p_counter_id => l_ctr_rdg_rec.counter_id
141: ,px_ctr_val_max_seq_no => l_ctr_rdg_rec.counter_value_id

Line 138: ,p_init_msg_list => fnd_api.g_true

134: -- Added for FP Tracking bug 7390758 (base bug 7374316)
135: CSI_COUNTER_PVT.update_ctr_val_max_seq_no(
136: p_api_version => 1.0
137: ,p_commit => fnd_api.g_false
138: ,p_init_msg_list => fnd_api.g_true
139: ,p_validation_level => fnd_api.g_valid_level_full
140: ,p_counter_id => l_ctr_rdg_rec.counter_id
141: ,px_ctr_val_max_seq_no => l_ctr_rdg_rec.counter_value_id
142: ,x_return_status => x_return_status

Line 139: ,p_validation_level => fnd_api.g_valid_level_full

135: CSI_COUNTER_PVT.update_ctr_val_max_seq_no(
136: p_api_version => 1.0
137: ,p_commit => fnd_api.g_false
138: ,p_init_msg_list => fnd_api.g_true
139: ,p_validation_level => fnd_api.g_valid_level_full
140: ,p_counter_id => l_ctr_rdg_rec.counter_id
141: ,px_ctr_val_max_seq_no => l_ctr_rdg_rec.counter_value_id
142: ,x_return_status => x_return_status
143: ,x_msg_count => x_msg_count

Line 147: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

143: ,x_msg_count => x_msg_count
144: ,x_msg_data => x_msg_data
145: );
146:
147: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
148: l_msg_index := 1;
149: l_msg_count := x_msg_count;
150: WHILE l_msg_count > 0 LOOP
151: x_msg_data := FND_MSG_PUB.GET

Line 153: FND_API.G_FALSE

149: l_msg_count := x_msg_count;
150: WHILE l_msg_count > 0 LOOP
151: x_msg_data := FND_MSG_PUB.GET
152: (l_msg_index,
153: FND_API.G_FALSE
154: );
155: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
156: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
157: l_msg_index := l_msg_index + 1;

Line 160: RAISE FND_API.G_EXC_ERROR;

156: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
157: l_msg_index := l_msg_index + 1;
158: l_msg_count := l_msg_count - 1;
159: END LOOP;
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162: -- End add for FP Tracking bug 7390758 (base bug 7374316)
163: --
164: fnd_file.put_line(fnd_file.log, 'Calling OKC Assembler Event...');

Line 172: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

168: x_msg_count => x_msg_count,
169: x_msg_data => x_msg_data,
170: p_counter_id => l_ctr_rdg_rec.counter_id
171: );
172: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
173: fnd_file.put_line(fnd_file.log,'ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
174: l_msg_index := 1;
175: l_msg_count := x_msg_count;
176: WHILE l_msg_count > 0 LOOP

Line 179: FND_API.G_FALSE

175: l_msg_count := x_msg_count;
176: WHILE l_msg_count > 0 LOOP
177: x_msg_data := FND_MSG_PUB.GET
178: ( l_msg_index,
179: FND_API.G_FALSE
180: );
181: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
182: l_msg_index := l_msg_index + 1;
183: l_msg_count := l_msg_count - 1;

Line 185: RAISE FND_API.G_EXC_ERROR;

181: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
182: l_msg_index := l_msg_index + 1;
183: l_msg_count := l_msg_count - 1;
184: END LOOP;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184: END LOOP;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: Rollback To Increment_Reading;
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;

Line 189: x_return_status := FND_API.G_RET_STS_ERROR;

185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: Rollback To Increment_Reading;
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: Rollback To Increment_Reading;

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: Rollback To Increment_Reading;
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: Rollback To Increment_Reading;
194: fnd_file.put_line(fnd_file.log,'Into when others error in Increment_Reading...');
195: fnd_file.put_line(fnd_file.log,sqlerrm);
196: END Increment_Reading;

Line 295: RAISE FND_API.G_EXC_ERROR;

291: --
292: IF l_day_uom_code IS NULL THEN
293: fnd_file.put_line(fnd_file.log,'DAY_UNIT_OF_MEASURE Profile Not Set..');
294: errbuf := 'DAY_UNIT_OF_MEASURE Profile Not Set';
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: --
298: --Bug 15972103
299: l_txn_rec := l_temp_txn_rec;

Line 306: ,p_commit => fnd_api.g_false

302: l_txn_rec.source_header_ref_id := 0;
303:
304: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
305: ( p_api_version => 1.0
306: ,p_commit => fnd_api.g_false
307: ,p_init_msg_list => fnd_api.g_true
308: ,p_validation_level => fnd_api.g_valid_level_full
309: ,p_txn_rec => l_txn_rec
310: ,x_return_status => x_return_status

Line 307: ,p_init_msg_list => fnd_api.g_true

303:
304: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
305: ( p_api_version => 1.0
306: ,p_commit => fnd_api.g_false
307: ,p_init_msg_list => fnd_api.g_true
308: ,p_validation_level => fnd_api.g_valid_level_full
309: ,p_txn_rec => l_txn_rec
310: ,x_return_status => x_return_status
311: ,x_msg_count => x_msg_count

Line 308: ,p_validation_level => fnd_api.g_valid_level_full

304: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
305: ( p_api_version => 1.0
306: ,p_commit => fnd_api.g_false
307: ,p_init_msg_list => fnd_api.g_true
308: ,p_validation_level => fnd_api.g_valid_level_full
309: ,p_txn_rec => l_txn_rec
310: ,x_return_status => x_return_status
311: ,x_msg_count => x_msg_count
312: ,x_msg_data => x_msg_data

Line 406: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

402: x_return_status => x_return_status,
403: x_msg_data => x_msg_data,
404: x_msg_count => x_msg_count
405: );
406: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- Moving the END IF to the end of formulae counter update block

Line 407: RAISE FND_API.G_EXC_ERROR;

403: x_msg_data => x_msg_data,
404: x_msg_count => x_msg_count
405: );
406: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- Moving the END IF to the end of formulae counter update block
411: -- END IF;

Line 430: ,p_commit => fnd_api.g_false

426: l_txn_rec.source_header_ref_id := 0;
427:
428: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
429: ( p_api_version => 1.0
430: ,p_commit => fnd_api.g_false
431: ,p_init_msg_list => fnd_api.g_true
432: ,p_validation_level => fnd_api.g_valid_level_full
433: ,p_txn_rec => l_txn_rec
434: ,x_return_status => x_return_status

Line 431: ,p_init_msg_list => fnd_api.g_true

427:
428: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
429: ( p_api_version => 1.0
430: ,p_commit => fnd_api.g_false
431: ,p_init_msg_list => fnd_api.g_true
432: ,p_validation_level => fnd_api.g_valid_level_full
433: ,p_txn_rec => l_txn_rec
434: ,x_return_status => x_return_status
435: ,x_msg_count => x_msg_count

Line 432: ,p_validation_level => fnd_api.g_valid_level_full

428: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
429: ( p_api_version => 1.0
430: ,p_commit => fnd_api.g_false
431: ,p_init_msg_list => fnd_api.g_true
432: ,p_validation_level => fnd_api.g_valid_level_full
433: ,p_txn_rec => l_txn_rec
434: ,x_return_status => x_return_status
435: ,x_msg_count => x_msg_count
436: ,x_msg_data => x_msg_data

Line 438: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

434: ,x_return_status => x_return_status
435: ,x_msg_count => x_msg_count
436: ,x_msg_data => x_msg_data
437: );*/
438: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
439: fnd_file.put_line(fnd_file.log,'Error from Create_Reading_Transaction...');
440: l_msg_index := 1;
441: FND_MSG_PUB.Count_And_Get
442: (p_count => x_msg_count,

Line 449: FND_API.G_FALSE );

445: l_msg_count := x_msg_count;
446: WHILE l_msg_count > 0 LOOP
447: x_msg_data := FND_MSG_PUB.GET
448: ( l_msg_index,
449: FND_API.G_FALSE );
450: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
451: l_msg_index := l_msg_index + 1;
452: l_msg_count := l_msg_count - 1;
453: END LOOP;

Line 454: RAISE FND_API.G_EXC_ERROR;

450: fnd_file.put_line(fnd_file.log,'MESSAGE DATA = '||x_msg_data);
451: l_msg_index := l_msg_index + 1;
452: l_msg_count := l_msg_count - 1;
453: END LOOP;
454: RAISE FND_API.G_EXC_ERROR;
455: END IF;
456: -- End of bug 9386676
457:
458: l_formula_ctr_rec.counter_id := time_ctr_array(i).counter_id;

Line 474: ,p_commit => FND_API.G_FALSE

470:
471: CSI_COUNTER_READINGS_PVT.Compute_Formula_Counters
472: (
473: p_api_version => 1.0
474: ,p_commit => FND_API.G_FALSE
475: ,p_init_msg_list => FND_API.G_TRUE
476: ,p_validation_level => fnd_api.g_valid_level_full
477: ,p_txn_rec => l_txn_rec
478: ,p_ctr_rdg_rec => l_formula_ctr_rec

Line 475: ,p_init_msg_list => FND_API.G_TRUE

471: CSI_COUNTER_READINGS_PVT.Compute_Formula_Counters
472: (
473: p_api_version => 1.0
474: ,p_commit => FND_API.G_FALSE
475: ,p_init_msg_list => FND_API.G_TRUE
476: ,p_validation_level => fnd_api.g_valid_level_full
477: ,p_txn_rec => l_txn_rec
478: ,p_ctr_rdg_rec => l_formula_ctr_rec
479: ,x_return_status => x_return_status

Line 476: ,p_validation_level => fnd_api.g_valid_level_full

472: (
473: p_api_version => 1.0
474: ,p_commit => FND_API.G_FALSE
475: ,p_init_msg_list => FND_API.G_TRUE
476: ,p_validation_level => fnd_api.g_valid_level_full
477: ,p_txn_rec => l_txn_rec
478: ,p_ctr_rdg_rec => l_formula_ctr_rec
479: ,x_return_status => x_return_status
480: ,x_msg_count => x_msg_count

Line 483: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

479: ,x_return_status => x_return_status
480: ,x_msg_count => x_msg_count
481: ,x_msg_data => x_msg_data
482: );
483: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
484: fnd_file.put_line(fnd_file.log, 'Error from Compute_Formula_Counters API');
485: l_msg_index := 1;
486: l_msg_count := x_msg_count;
487: WHILE l_msg_count > 0 LOOP

Line 490: FND_API.G_FALSE

486: l_msg_count := x_msg_count;
487: WHILE l_msg_count > 0 LOOP
488: x_msg_data := FND_MSG_PUB.GET
489: ( l_msg_index,
490: FND_API.G_FALSE
491: );
492: fnd_file.put_line(fnd_file.log, 'MESSAGE DATA = '||x_msg_data);
493: l_msg_index := l_msg_index + 1;
494: l_msg_count := l_msg_count - 1;

Line 496: RAISE FND_API.G_EXC_ERROR;

492: fnd_file.put_line(fnd_file.log, 'MESSAGE DATA = '||x_msg_data);
493: l_msg_index := l_msg_index + 1;
494: l_msg_count := l_msg_count - 1;
495: END LOOP;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: END IF; -- IS_FORMULA_COUNTER_EXISTS(time_ctr_array(i).counter_id)
499: -- End Bug 9283089
500:

Line 522: WHEN FND_API.G_EXC_ERROR THEN

518: errbuf := '';
519: retcode := 0;
520: --
521: EXCEPTION
522: WHEN FND_API.G_EXC_ERROR THEN
523: retcode := 2;
524: fnd_file.put_line(fnd_file.log,'Program Aborting....');
525: WHEN OTHERS THEN
526: fnd_file.put_line(fnd_file.log, 'Into when others in Capture_Readings..');