DBA Data[Home] [Help]

APPS.GME_BATCH_STEPS_DBL dependencies on GME_COMMON_PVT

Line 156: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp

152: ,x_batch_step.max_step_capacity
153: --, x_batch_step.MAX_STEP_CAPACITY_UOM
154: , x_batch_step.plan_charges
155: ,x_batch_step.actual_charges, x_batch_step.text_code
156: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
157: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
158: ,gme_common_pvt.g_login_id
159: ,x_batch_step.attribute_category, x_batch_step.attribute1
160: ,x_batch_step.attribute2, x_batch_step.attribute3

Line 157: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident

153: --, x_batch_step.MAX_STEP_CAPACITY_UOM
154: , x_batch_step.plan_charges
155: ,x_batch_step.actual_charges, x_batch_step.text_code
156: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
157: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
158: ,gme_common_pvt.g_login_id
159: ,x_batch_step.attribute_category, x_batch_step.attribute1
160: ,x_batch_step.attribute2, x_batch_step.attribute3
161: ,x_batch_step.attribute4, x_batch_step.attribute5

Line 158: ,gme_common_pvt.g_login_id

154: , x_batch_step.plan_charges
155: ,x_batch_step.actual_charges, x_batch_step.text_code
156: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
157: ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
158: ,gme_common_pvt.g_login_id
159: ,x_batch_step.attribute_category, x_batch_step.attribute1
160: ,x_batch_step.attribute2, x_batch_step.attribute3
161: ,x_batch_step.attribute4, x_batch_step.attribute5
162: ,x_batch_step.attribute6, x_batch_step.attribute7

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

198: END IF;
199: EXCEPTION
200: WHEN OTHERS THEN
201: x_batch_step.batchstep_id := NULL;
202: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
203: ,SQLERRM);
204: --Bug2804440
205: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
206: RETURN FALSE;

Line 441: gme_common_pvt.log_message ('GME_NO_KEYS'

437: FROM gme_batch_steps
438: WHERE batch_id = p_batch_step.batch_id
439: AND batchstep_no = p_batch_step.batchstep_no;
440: ELSE
441: gme_common_pvt.log_message ('GME_NO_KEYS'
442: ,'TABLE_NAME'
443: ,g_table_name);
444: RETURN FALSE;
445: END IF;

Line 454: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

450:
451: RETURN TRUE;
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN
454: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
455: ,'TABLE_NAME'
456: ,g_table_name);
457: RETURN FALSE;
458: WHEN OTHERS THEN

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

455: ,'TABLE_NAME'
456: ,g_table_name);
457: RETURN FALSE;
458: WHEN OTHERS THEN
459: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
460: ,SQLERRM);
461: --bug2804440
462: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
463: RETURN FALSE;

Line 530: gme_common_pvt.log_message ('GME_NO_KEYS'

526: DELETE FROM gme_batch_steps
527: WHERE batch_id = p_batch_step.batch_id
528: AND batchstep_no = p_batch_step.batchstep_no;
529: ELSE
530: gme_common_pvt.log_message ('GME_NO_KEYS'
531: ,'TABLE_NAME'
532: ,g_table_name);
533: RETURN FALSE;
534: END IF;

Line 540: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

536: IF SQL%FOUND THEN
537: RETURN TRUE;
538: ELSE
539: IF l_dummy = 0 THEN
540: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
541: ,'TABLE_NAME'
542: ,g_table_name);
543: ELSE
544: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 544: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

540: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
541: ,'TABLE_NAME'
542: ,g_table_name);
543: ELSE
544: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
545: ,'TABLE_NAME'
546: ,g_table_name);
547: END IF;
548:

Line 553: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

549: RETURN FALSE;
550: END IF;
551: EXCEPTION
552: WHEN locked_by_other_user THEN
553: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
554: ,'TABLE_NAME'
555: ,g_table_name
556: ,'RECORD'
557: ,'Batchstep'

Line 571: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

567: || ' Error is '
568: || SQLERRM);
569: END IF;
570:
571: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
572: --bug2804440
573: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
574: RETURN FALSE;
575: END delete_row;

Line 652: ,last_update_date = gme_common_pvt.g_timestamp

648: --,MAX_STEP_CAPACITY_UOM=p_batch_step.max_step_capacity_uom
649: , plan_charges = p_batch_step.plan_charges
650: ,actual_charges = p_batch_step.actual_charges
651: ,text_code = p_batch_step.text_code
652: ,last_update_date = gme_common_pvt.g_timestamp
653: ,last_updated_by = gme_common_pvt.g_user_ident
654: ,last_update_login = gme_common_pvt.g_login_id
655: ,attribute_category = p_batch_step.attribute_category
656: ,attribute1 = p_batch_step.attribute1

Line 653: ,last_updated_by = gme_common_pvt.g_user_ident

649: , plan_charges = p_batch_step.plan_charges
650: ,actual_charges = p_batch_step.actual_charges
651: ,text_code = p_batch_step.text_code
652: ,last_update_date = gme_common_pvt.g_timestamp
653: ,last_updated_by = gme_common_pvt.g_user_ident
654: ,last_update_login = gme_common_pvt.g_login_id
655: ,attribute_category = p_batch_step.attribute_category
656: ,attribute1 = p_batch_step.attribute1
657: ,attribute2 = p_batch_step.attribute2

Line 654: ,last_update_login = gme_common_pvt.g_login_id

650: ,actual_charges = p_batch_step.actual_charges
651: ,text_code = p_batch_step.text_code
652: ,last_update_date = gme_common_pvt.g_timestamp
653: ,last_updated_by = gme_common_pvt.g_user_ident
654: ,last_update_login = gme_common_pvt.g_login_id
655: ,attribute_category = p_batch_step.attribute_category
656: ,attribute1 = p_batch_step.attribute1
657: ,attribute2 = p_batch_step.attribute2
658: ,attribute3 = p_batch_step.attribute3

Line 733: ,last_update_date = gme_common_pvt.g_timestamp

729: --,MAX_STEP_CAPACITY_UOM=p_batch_step.max_step_capacity_uom
730: , plan_charges = p_batch_step.plan_charges
731: ,actual_charges = p_batch_step.actual_charges
732: ,text_code = p_batch_step.text_code
733: ,last_update_date = gme_common_pvt.g_timestamp
734: ,last_updated_by = gme_common_pvt.g_user_ident
735: ,last_update_login = gme_common_pvt.g_login_id
736: ,attribute_category = p_batch_step.attribute_category
737: ,attribute1 = p_batch_step.attribute1

Line 734: ,last_updated_by = gme_common_pvt.g_user_ident

730: , plan_charges = p_batch_step.plan_charges
731: ,actual_charges = p_batch_step.actual_charges
732: ,text_code = p_batch_step.text_code
733: ,last_update_date = gme_common_pvt.g_timestamp
734: ,last_updated_by = gme_common_pvt.g_user_ident
735: ,last_update_login = gme_common_pvt.g_login_id
736: ,attribute_category = p_batch_step.attribute_category
737: ,attribute1 = p_batch_step.attribute1
738: ,attribute2 = p_batch_step.attribute2

Line 735: ,last_update_login = gme_common_pvt.g_login_id

731: ,actual_charges = p_batch_step.actual_charges
732: ,text_code = p_batch_step.text_code
733: ,last_update_date = gme_common_pvt.g_timestamp
734: ,last_updated_by = gme_common_pvt.g_user_ident
735: ,last_update_login = gme_common_pvt.g_login_id
736: ,attribute_category = p_batch_step.attribute_category
737: ,attribute1 = p_batch_step.attribute1
738: ,attribute2 = p_batch_step.attribute2
739: ,attribute3 = p_batch_step.attribute3

Line 782: gme_common_pvt.log_message ('GME_NO_KEYS'

778: ,volume_ref_um = p_batch_step.volume_ref_um
779: WHERE batch_id = p_batch_step.batch_id
780: AND batchstep_no = p_batch_step.batchstep_no;
781: ELSE
782: gme_common_pvt.log_message ('GME_NO_KEYS'
783: ,'TABLE_NAME'
784: ,g_table_name);
785: RETURN FALSE;
786: END IF;

Line 796: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

792: END IF;
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: IF l_dummy = 0 THEN
796: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
797: ,'TABLE_NAME'
798: ,g_table_name);
799: ELSE
800: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 800: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

796: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
797: ,'TABLE_NAME'
798: ,g_table_name);
799: ELSE
800: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
801: ,'TABLE_NAME'
802: ,g_table_name);
803: END IF;
804:

Line 807: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

803: END IF;
804:
805: RETURN FALSE;
806: WHEN locked_by_other_user THEN
807: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
808: ,'TABLE_NAME'
809: ,g_table_name
810: ,'RECORD'
811: ,'Batchstep'

Line 825: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

821: || ' Error is '
822: || SQLERRM);
823: END IF;
824:
825: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
826: --Bug2804440
827: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
828: RETURN FALSE;
829: END update_row;

Line 853: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

849:
850: RETURN TRUE;
851: EXCEPTION
852: WHEN app_exception.record_lock_exception THEN
853: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
854: ,'TABLE_NAME'
855: ,g_table_name
856: ,'RECORD'
857: ,'Batchstep'