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.GME_BATCH_STEP_CHARGE_DBL dependencies on GME_COMMON_PVT

Line 61: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp

57: ,x_batch_step_charges.charge_quantity
58: ,x_batch_step_charges.activity_sequence_number
59: ,x_batch_step_charges.plan_start_date
60: ,x_batch_step_charges.plan_cmplt_date
61: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
62: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
63: ,gme_common_pvt.g_login_id);
64:
65: IF SQL%FOUND THEN

Line 62: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident

58: ,x_batch_step_charges.activity_sequence_number
59: ,x_batch_step_charges.plan_start_date
60: ,x_batch_step_charges.plan_cmplt_date
61: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
62: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
63: ,gme_common_pvt.g_login_id);
64:
65: IF SQL%FOUND THEN
66: RETURN TRUE;

Line 63: ,gme_common_pvt.g_login_id);

59: ,x_batch_step_charges.plan_start_date
60: ,x_batch_step_charges.plan_cmplt_date
61: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
62: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
63: ,gme_common_pvt.g_login_id);
64:
65: IF SQL%FOUND THEN
66: RETURN TRUE;
67: ELSE

Line 72: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

68: RETURN FALSE;
69: END IF;
70: EXCEPTION
71: WHEN OTHERS THEN
72: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
73: ,SQLERRM);
74: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
75: RETURN FALSE;
76: END insert_row;

Line 175: gme_common_pvt.log_message ('GME_NO_KEYS'

171: FROM gme_batch_step_charges
172: WHERE batch_id = p_batch_step_charges_in.batch_id
173: AND batchstep_id = p_batch_step_charges_in.batchstep_id;
174: ELSE
175: gme_common_pvt.log_message ('GME_NO_KEYS'
176: ,'TABLE_NAME'
177: ,g_table_name);
178: RETURN FALSE;
179: END IF;

Line 184: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

180:
181: RETURN TRUE;
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
185: ,'TABLE_NAME'
186: ,g_table_name);
187: RETURN FALSE;
188: WHEN OTHERS THEN

Line 189: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

185: ,'TABLE_NAME'
186: ,g_table_name);
187: RETURN FALSE;
188: WHEN OTHERS THEN
189: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
190: ,SQLERRM);
191: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
192: RETURN FALSE;
193: END fetch_row;

Line 270: ,last_update_date = gme_common_pvt.g_timestamp

266: ,charge_number = p_batch_step_charges_in.charge_number
267: ,charge_quantity = p_batch_step_charges_in.charge_quantity
268: ,plan_start_date = p_batch_step_charges_in.plan_start_date
269: ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
270: ,last_update_date = gme_common_pvt.g_timestamp
271: ,last_updated_by = gme_common_pvt.g_user_ident
272: ,last_update_login = gme_common_pvt.g_login_id
273: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
274: AND last_update_date = p_batch_step_charges_in.last_update_date;

Line 271: ,last_updated_by = gme_common_pvt.g_user_ident

267: ,charge_quantity = p_batch_step_charges_in.charge_quantity
268: ,plan_start_date = p_batch_step_charges_in.plan_start_date
269: ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
270: ,last_update_date = gme_common_pvt.g_timestamp
271: ,last_updated_by = gme_common_pvt.g_user_ident
272: ,last_update_login = gme_common_pvt.g_login_id
273: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
274: AND last_update_date = p_batch_step_charges_in.last_update_date;
275: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL

Line 272: ,last_update_login = gme_common_pvt.g_login_id

268: ,plan_start_date = p_batch_step_charges_in.plan_start_date
269: ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
270: ,last_update_date = gme_common_pvt.g_timestamp
271: ,last_updated_by = gme_common_pvt.g_user_ident
272: ,last_update_login = gme_common_pvt.g_login_id
273: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
274: AND last_update_date = p_batch_step_charges_in.last_update_date;
275: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
276: AND p_batch_step_charges_in.batchstep_id IS NOT NULL THEN

Line 301: ,last_update_date = gme_common_pvt.g_timestamp

297: ,charge_number = p_batch_step_charges_in.charge_number
298: ,charge_quantity = p_batch_step_charges_in.charge_quantity
299: ,plan_start_date = p_batch_step_charges_in.plan_start_date
300: ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
301: ,last_update_date = gme_common_pvt.g_timestamp
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_login = gme_common_pvt.g_login_id
304: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
305: AND batch_id = p_batch_step_charges_in.batch_id

Line 302: ,last_updated_by = gme_common_pvt.g_user_ident

298: ,charge_quantity = p_batch_step_charges_in.charge_quantity
299: ,plan_start_date = p_batch_step_charges_in.plan_start_date
300: ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
301: ,last_update_date = gme_common_pvt.g_timestamp
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_login = gme_common_pvt.g_login_id
304: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
305: AND batch_id = p_batch_step_charges_in.batch_id
306: AND last_update_date = p_batch_step_charges_in.last_update_date;

Line 303: ,last_update_login = gme_common_pvt.g_login_id

299: ,plan_start_date = p_batch_step_charges_in.plan_start_date
300: ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
301: ,last_update_date = gme_common_pvt.g_timestamp
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_login = gme_common_pvt.g_login_id
304: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
305: AND batch_id = p_batch_step_charges_in.batch_id
306: AND last_update_date = p_batch_step_charges_in.last_update_date;
307: ELSE

Line 308: gme_common_pvt.log_message ('GME_NO_KEYS'

304: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
305: AND batch_id = p_batch_step_charges_in.batch_id
306: AND last_update_date = p_batch_step_charges_in.last_update_date;
307: ELSE
308: gme_common_pvt.log_message ('GME_NO_KEYS'
309: ,'TABLE_NAME'
310: ,g_table_name);
311: RETURN FALSE;
312: END IF;

Line 322: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

318: END IF;
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: IF (l_both_ids_rec = 0 AND l_step_id_rec = 0) THEN
322: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
323: ,'TABLE_NAME'
324: ,g_table_name);
325: ELSE
326: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 326: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

322: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
323: ,'TABLE_NAME'
324: ,g_table_name);
325: ELSE
326: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
327: ,'TABLE_NAME'
328: ,g_table_name);
329: END IF;
330:

Line 333: gme_common_pvt.log_message

329: END IF;
330:
331: RETURN FALSE;
332: WHEN locked_by_other_user THEN
333: gme_common_pvt.log_message
334: ('GME_RECORD_LOCKED'
335: ,'TABLE_NAME'
336: ,g_table_name
337: ,'RECORD'

Line 343: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

339: ,'KEY'
340: ,TO_CHAR (p_batch_step_charges_in.batchstep_id) );
341: RETURN FALSE;
342: WHEN OTHERS THEN
343: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
344: ,SQLERRM);
345: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
346: RETURN FALSE;
347: END update_row;

Line 495: gme_common_pvt.log_message ('GME_NO_KEYS'

491:
492: DELETE FROM gme_batch_step_charges
493: WHERE batch_id = p_batch_step_charges_in.batch_id;
494: ELSE
495: gme_common_pvt.log_message ('GME_NO_KEYS'
496: ,'TABLE_NAME'
497: ,g_table_name);
498: RETURN FALSE;
499: END IF;

Line 507: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

503: ELSE
504: IF (l_both_ids_rec = 0)
505: AND (l_step_id_rec = 0)
506: AND (l_batch_id_rec = 0) THEN
507: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
508: ,'TABLE_NAME'
509: ,g_table_name);
510: ELSE
511: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 511: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

507: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
508: ,'TABLE_NAME'
509: ,g_table_name);
510: ELSE
511: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
512: ,'TABLE_NAME'
513: ,g_table_name);
514: END IF;
515:

Line 520: gme_common_pvt.log_message

516: RETURN FALSE;
517: END IF;
518: EXCEPTION
519: WHEN locked_by_other_user THEN
520: gme_common_pvt.log_message
521: ('GME_RECORD_LOCKED'
522: ,'TABLE_NAME'
523: ,g_table_name
524: ,'RECORD'

Line 530: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

526: ,'KEY'
527: ,TO_CHAR (p_batch_step_charges_in.batchstep_id) );
528: RETURN FALSE;
529: WHEN OTHERS THEN
530: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
531: ,SQLERRM);
532: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
533: RETURN FALSE;
534: END delete_row;