DBA Data[Home] [Help]

APPS.GME_BATCH_STEP_CHARGE_DBL dependencies on GME_DEBUG

Line 408: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

404: locked_by_other_user EXCEPTION;
405: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
406: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_ROW';
407: BEGIN
408: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
409: gme_debug.put_line ( g_pkg_name
410: || '.'
411: || l_api_name
412: || 'dbl,batch,step ids are '

Line 409: gme_debug.put_line ( g_pkg_name

405: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
406: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_ROW';
407: BEGIN
408: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
409: gme_debug.put_line ( g_pkg_name
410: || '.'
411: || l_api_name
412: || 'dbl,batch,step ids are '
413: || p_batch_step_charges_in.batch_id

Line 418: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

414: || p_batch_step_charges_in.batchstep_id);
415: END IF;
416:
417: IF p_batch_step_charges_in.batchstep_id IS NOT NULL THEN
418: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
419: gme_debug.put_line ( g_pkg_name
420: || '.'
421: || l_api_name
422: || 'dbl,batchstep id is '

Line 419: gme_debug.put_line ( g_pkg_name

415: END IF;
416:
417: IF p_batch_step_charges_in.batchstep_id IS NOT NULL THEN
418: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
419: gme_debug.put_line ( g_pkg_name
420: || '.'
421: || l_api_name
422: || 'dbl,batchstep id is '
423: || p_batch_step_charges_in.batchstep_id);

Line 443: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

439: DELETE FROM gme_batch_step_charges
440: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id;
441: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
442: AND p_batch_step_charges_in.batchstep_id IS NOT NULL THEN
443: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
444: gme_debug.put_line ( g_pkg_name
445: || '.'
446: || l_api_name
447: || 'in delete dbl,batch,step id is'

Line 444: gme_debug.put_line ( g_pkg_name

440: WHERE batchstep_id = p_batch_step_charges_in.batchstep_id;
441: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
442: AND p_batch_step_charges_in.batchstep_id IS NOT NULL THEN
443: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
444: gme_debug.put_line ( g_pkg_name
445: || '.'
446: || l_api_name
447: || 'in delete dbl,batch,step id is'
448: || p_batch_step_charges_in.batch_id

Line 471: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

467: WHERE batch_id = p_batch_step_charges_in.batch_id
468: AND batchstep_id = p_batch_step_charges_in.batchstep_id;
469: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
470: AND p_batch_step_charges_in.batchstep_id IS NULL THEN
471: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
472: gme_debug.put_line ( g_pkg_name
473: || '.'
474: || l_api_name
475: || 'in delete dbl,batch_id is'

Line 472: gme_debug.put_line ( g_pkg_name

468: AND batchstep_id = p_batch_step_charges_in.batchstep_id;
469: ELSIF p_batch_step_charges_in.batch_id IS NOT NULL
470: AND p_batch_step_charges_in.batchstep_id IS NULL THEN
471: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
472: gme_debug.put_line ( g_pkg_name
473: || '.'
474: || l_api_name
475: || 'in delete dbl,batch_id is'
476: || p_batch_step_charges_in.batch_id);