900: gme_debug.put_line ( g_pkg_name
901: || '.'
902: || l_api_name
903: || ':'
904: || 'before call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row batch_id='
905: || l_batchstep_activity_rec.batch_id
906: || ' and step_id ='
907: || l_batchstep_activity_rec.batchstep_id
908: );
907: || l_batchstep_activity_rec.batchstep_id
908: );
909: END IF;
910:
911: IF NOT (gme_batch_step_activities_dbl.insert_row (l_batchstep_activity_rec,
912: l_batchstep_activity_out_rec
913: )
914: )
915: THEN
921: gme_debug.put_line ( g_pkg_name
922: || '.'
923: || l_api_name
924: || ':'
925: || 'after call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row activity_id='
926: || l_batchstep_activity_out_rec.batchstep_activity_id
927: );
928: END IF;
929:
1193: THEN
1194: gme_debug.put_line (' Successfully locked the activity');
1195: END IF;
1196:
1197: IF NOT (gme_batch_step_activities_dbl.fetch_row (p_batchstep_activity_rec,
1198: l_batchstep_activity_rec
1199: )
1200: )
1201: THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: END IF;
1719: END IF;
1720:
1721: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec
1722: )
1723: )
1724: THEN
1725: RAISE fnd_api.g_exc_error;
1731: );
1732: END IF;
1733:
1734: /*Fetching the values from the db again to get the latest seq_dep_ind.*/
1735: IF NOT (gme_batch_step_activities_dbl.fetch_row (l_batchstep_activity_rec,
1736: l_batchstep_activity_rec
1737: )
1738: )
1739: THEN