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.CSL_COUNTER_PROP_VALUES_PKG dependencies on FND_API

Line 97: l_ctr_grp_id := FND_API.G_MISS_NUM;

93: then
94: l_ctr_grp_id := r_counter_group.counter_group_id;
95: l_customer_product_id := r_counter_group.source_object_id;
96: else
97: l_ctr_grp_id := FND_API.G_MISS_NUM;
98: l_customer_product_id := FND_API.G_MISS_NUM;
99: end if;
100: close c_counter_group;
101: */

Line 98: l_customer_product_id := FND_API.G_MISS_NUM;

94: l_ctr_grp_id := r_counter_group.counter_group_id;
95: l_customer_product_id := r_counter_group.source_object_id;
96: else
97: l_ctr_grp_id := FND_API.G_MISS_NUM;
98: l_customer_product_id := FND_API.G_MISS_NUM;
99: end if;
100: close c_counter_group;
101: */
102: -- Determine the group_log_id for the counter_property_value.

Line 128: , p_init_msg_list => FND_API.G_TRUE

124: l_prop_rdg_rec.counter_prop_value_id := p_record.counter_prop_value_id;
125:
126: Cs_Ctr_Capture_Reading_pvt.Capture_Ctr_Property_Reading
127: ( p_api_version_number => 1.0
128: , p_init_msg_list => FND_API.G_TRUE
129: , p_commit => FND_API.G_FALSE
130: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
131: , p_prop_rdg_rec => l_prop_rdg_rec
132: , p_counter_grp_log_id => r_counter_values.counter_grp_log_id

Line 129: , p_commit => FND_API.G_FALSE

125:
126: Cs_Ctr_Capture_Reading_pvt.Capture_Ctr_Property_Reading
127: ( p_api_version_number => 1.0
128: , p_init_msg_list => FND_API.G_TRUE
129: , p_commit => FND_API.G_FALSE
130: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
131: , p_prop_rdg_rec => l_prop_rdg_rec
132: , p_counter_grp_log_id => r_counter_values.counter_grp_log_id
133: , x_return_status => x_return_status

Line 130: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

126: Cs_Ctr_Capture_Reading_pvt.Capture_Ctr_Property_Reading
127: ( p_api_version_number => 1.0
128: , p_init_msg_list => FND_API.G_TRUE
129: , p_commit => FND_API.G_FALSE
130: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
131: , p_prop_rdg_rec => l_prop_rdg_rec
132: , p_counter_grp_log_id => r_counter_values.counter_grp_log_id
133: , x_return_status => x_return_status
134: , x_msg_count => l_msg_count

Line 160: , p_init_msg_list => FND_API.G_TRUE

156: -- All property values have been processed. Call the private API to close
157: -- the counter group log.
158: Cs_Ctr_Capture_Reading_pvt.Post_Capture_Counter_Reading
159: ( p_api_version_number => 1.0
160: , p_init_msg_list => FND_API.G_TRUE
161: , p_commit => FND_API.G_FALSE
162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
163: , p_counter_grp_log_id => r_counter_values.counter_grp_log_id
164: , x_return_status => x_return_status

Line 161: , p_commit => FND_API.G_FALSE

157: -- the counter group log.
158: Cs_Ctr_Capture_Reading_pvt.Post_Capture_Counter_Reading
159: ( p_api_version_number => 1.0
160: , p_init_msg_list => FND_API.G_TRUE
161: , p_commit => FND_API.G_FALSE
162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
163: , p_counter_grp_log_id => r_counter_values.counter_grp_log_id
164: , x_return_status => x_return_status
165: , x_msg_count => l_msg_count

Line 162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

158: Cs_Ctr_Capture_Reading_pvt.Post_Capture_Counter_Reading
159: ( p_api_version_number => 1.0
160: , p_init_msg_list => FND_API.G_TRUE
161: , p_commit => FND_API.G_FALSE
162: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
163: , p_counter_grp_log_id => r_counter_values.counter_grp_log_id
164: , x_return_status => x_return_status
165: , x_msg_count => l_msg_count
166: , x_msg_data => l_msg_data

Line 171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

167: );
168: end if;
169: */
170:
171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
172: /*** exception occurred in API -> return errmsg ***/
173: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
174: (
175: p_api_error => TRUE

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
207: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
208: END IF;
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END APPLY_INSERT;
212:
213: /***
214: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 269: l_ctr_grp_log_id := FND_API.G_MISS_NUM;

265: l_prop_rdg_rec.object_version_number
266: := r_counter_prop_value.object_version_number;
267: else
268: -- Let the API complain with a message.
269: l_ctr_grp_log_id := FND_API.G_MISS_NUM;
270: l_prop_rdg_rec.object_version_number := FND_API.G_MISS_NUM;
271: end if;
272: close c_counter_prop_value;
273:

Line 270: l_prop_rdg_rec.object_version_number := FND_API.G_MISS_NUM;

266: := r_counter_prop_value.object_version_number;
267: else
268: -- Let the API complain with a message.
269: l_ctr_grp_log_id := FND_API.G_MISS_NUM;
270: l_prop_rdg_rec.object_version_number := FND_API.G_MISS_NUM;
271: end if;
272: close c_counter_prop_value;
273:
274: l_prop_rdg_rec.counter_property_id := p_record.counter_property_id;

Line 282: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

278: l_prop_rdg_tbl(1) := l_prop_rdg_rec;
279:
280: Cs_Ctr_Capture_Reading_pub.Update_Counter_Reading
281: ( p_api_version_number => 1.0
282: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
283: , p_init_msg_list => FND_API.G_TRUE
284: , p_commit => FND_API.G_FALSE
285: , p_prop_rdg_tbl => l_prop_rdg_tbl
286: , p_ctr_grp_log_id => l_ctr_grp_log_id

Line 283: , p_init_msg_list => FND_API.G_TRUE

279:
280: Cs_Ctr_Capture_Reading_pub.Update_Counter_Reading
281: ( p_api_version_number => 1.0
282: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
283: , p_init_msg_list => FND_API.G_TRUE
284: , p_commit => FND_API.G_FALSE
285: , p_prop_rdg_tbl => l_prop_rdg_tbl
286: , p_ctr_grp_log_id => l_ctr_grp_log_id
287: , x_return_status => x_return_status

Line 284: , p_commit => FND_API.G_FALSE

280: Cs_Ctr_Capture_Reading_pub.Update_Counter_Reading
281: ( p_api_version_number => 1.0
282: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
283: , p_init_msg_list => FND_API.G_TRUE
284: , p_commit => FND_API.G_FALSE
285: , p_prop_rdg_tbl => l_prop_rdg_tbl
286: , p_ctr_grp_log_id => l_ctr_grp_log_id
287: , x_return_status => x_return_status
288: , x_msg_count => l_msg_count

Line 293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

289: , x_msg_data => l_msg_data
290: );
291: */
292:
293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
294: /*** exception occurred in API -> return errmsg ***/
295: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
296: (
297: p_api_error => TRUE

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END APPLY_UPDATE;
334:
335: /***
336: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 346: x_return_status := FND_API.G_RET_STS_SUCCESS;

342: x_return_status IN OUT NOCOPY VARCHAR2
343: ) IS
344: BEGIN
345: /*** initialize return status and message list ***/
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347: FND_MSG_PUB.INITIALIZE;
348:
349: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
350: jtm_message_log_pkg.Log_Msg

Line 399: x_return_status := FND_API.G_RET_STS_ERROR;

395: , p_token_name1 => 'DML'
396: , p_token_value1 => p_record.dmltype$$
397: );
398:
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: ELSE
401: -- invalid dml type
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413: , p_token_name1 => 'DML'
414: , p_token_value1 => p_record.dmltype$$
415: );
416:
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: END IF;
419:
420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
421: jtm_message_log_pkg.Log_Msg

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
449: END IF;
450:
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: END APPLY_RECORD;
453:
454: /***
455: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item CS_COUNTER_PROP_VALS

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: l_process_status VARCHAR2(1);
469: l_error_msg VARCHAR2(4000);
470: BEGIN
471: g_debug_level := p_debug_level;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
475: jtm_message_log_pkg.Log_Msg
476: ( v_object_id => null

Line 496: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

492: , l_process_status
493: );
494:
495: /*** was record processed successfully? ***/
496: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
497: /*** Yes -> delete record from inqueue ***/
498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here

Line 519: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

515: l_process_status
516: );
517:
518: /*** was delete successful? ***/
519: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
520: /*** no -> rollback ***/
521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
522: jtm_message_log_pkg.Log_Msg
523: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here

Line 532: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

528: ROLLBACK TO save_rec;
529: END IF;
530: END IF;
531:
532: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
533: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
534: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
535: jtm_message_log_pkg.Log_Msg
536: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here

Line 555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

551: , l_process_status
552: );
553:
554: /*** Was defer successful? ***/
555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
556: /*** no -> rollback ***/
557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
558: jtm_message_log_pkg.Log_Msg
559: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here

Line 587: x_return_status := FND_API.G_RET_STS_ERROR;

583: , v_object_name => g_object_name
584: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
585: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
586: END IF;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: END APPLY_CLIENT_CHANGES;
589:
590: END CSL_COUNTER_PROP_VALUES_PKG;