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_BATCHSTEP_RSRC_PVT dependencies on GME_DEBUG

Line 102: IF g_debug <= gme_debug.g_log_procedure THEN

98: stepactivity_not_found EXCEPTION;
99: resource_not_found EXCEPTION;
100: input_param_missing EXCEPTION;
101: BEGIN
102: IF g_debug <= gme_debug.g_log_procedure THEN
103: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
104: || l_api_name);
105: gme_debug.put_line ( g_pkg_name
106: || '.'

Line 103: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

99: resource_not_found EXCEPTION;
100: input_param_missing EXCEPTION;
101: BEGIN
102: IF g_debug <= gme_debug.g_log_procedure THEN
103: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
104: || l_api_name);
105: gme_debug.put_line ( g_pkg_name
106: || '.'
107: || l_api_name

Line 105: gme_debug.put_line ( g_pkg_name

101: BEGIN
102: IF g_debug <= gme_debug.g_log_procedure THEN
103: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
104: || l_api_name);
105: gme_debug.put_line ( g_pkg_name
106: || '.'
107: || l_api_name
108: || ' input org_code =>'
109: || p_org_code);

Line 110: gme_debug.put_line ( g_pkg_name

106: || '.'
107: || l_api_name
108: || ' input org_code =>'
109: || p_org_code);
110: gme_debug.put_line ( g_pkg_name
111: || '.'
112: || l_api_name
113: || ' input batch_no =>'
114: || p_batch_no);

Line 115: gme_debug.put_line ( g_pkg_name

111: || '.'
112: || l_api_name
113: || ' input batch_no =>'
114: || p_batch_no);
115: gme_debug.put_line ( g_pkg_name
116: || '.'
117: || l_api_name
118: || ' input batchstep_no =>'
119: || p_batchstep_no);

Line 120: gme_debug.put_line ( g_pkg_name

116: || '.'
117: || l_api_name
118: || ' input batchstep_no =>'
119: || p_batchstep_no);
120: gme_debug.put_line ( g_pkg_name
121: || '.'
122: || l_api_name
123: || ' input activity =>'
124: || p_activity);

Line 125: gme_debug.put_line ( g_pkg_name

121: || '.'
122: || l_api_name
123: || ' input activity =>'
124: || p_activity);
125: gme_debug.put_line ( g_pkg_name
126: || '.'
127: || l_api_name
128: || ' input resource =>'
129: || p_resource);

Line 130: gme_debug.put_line ( g_pkg_name

126: || '.'
127: || l_api_name
128: || ' input resource =>'
129: || p_resource);
130: gme_debug.put_line ( g_pkg_name
131: || '.'
132: || l_api_name
133: || ' **********************************');
134: END IF;

Line 247: IF g_debug <= gme_debug.g_log_statement THEN

243: ,p_activity);
244: RAISE resource_not_found;
245: END IF;
246:
247: IF g_debug <= gme_debug.g_log_statement THEN
248: gme_debug.put_line ( g_pkg_name
249: || '.'
250: || l_api_name
251: || ' output organization =>'

Line 248: gme_debug.put_line ( g_pkg_name

244: RAISE resource_not_found;
245: END IF;
246:
247: IF g_debug <= gme_debug.g_log_statement THEN
248: gme_debug.put_line ( g_pkg_name
249: || '.'
250: || l_api_name
251: || ' output organization =>'
252: || x_organization_id);

Line 253: gme_debug.put_line ( g_pkg_name

249: || '.'
250: || l_api_name
251: || ' output organization =>'
252: || x_organization_id);
253: gme_debug.put_line ( g_pkg_name
254: || '.'
255: || l_api_name
256: || ' output batch_id =>'
257: || x_batch_id);

Line 258: gme_debug.put_line ( g_pkg_name

254: || '.'
255: || l_api_name
256: || ' output batch_id =>'
257: || x_batch_id);
258: gme_debug.put_line ( g_pkg_name
259: || '.'
260: || l_api_name
261: || ' output batchstep_id =>'
262: || x_batchstep_id);

Line 263: gme_debug.put_line ( g_pkg_name

259: || '.'
260: || l_api_name
261: || ' output batchstep_id =>'
262: || x_batchstep_id);
263: gme_debug.put_line ( g_pkg_name
264: || '.'
265: || l_api_name
266: || ' output activity_id =>'
267: || x_activity_id);

Line 268: gme_debug.put_line ( g_pkg_name

264: || '.'
265: || l_api_name
266: || ' output activity_id =>'
267: || x_activity_id);
268: gme_debug.put_line ( g_pkg_name
269: || '.'
270: || l_api_name
271: || ' output rsrc_id =>'
272: || x_rsrc_id);

Line 273: gme_debug.put_line ( g_pkg_name

269: || '.'
270: || l_api_name
271: || ' output rsrc_id =>'
272: || x_rsrc_id);
273: gme_debug.put_line ( g_pkg_name
274: || '.'
275: || l_api_name
276: || ' output step_status =>'
277: || x_step_status);

Line 278: gme_debug.put_line ( ' Completed private layer '

274: || '.'
275: || l_api_name
276: || ' output step_status =>'
277: || x_step_status);
278: gme_debug.put_line ( ' Completed private layer '
279: || l_api_name
280: || ' at '
281: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
282: END IF;

Line 391: IF g_debug <= gme_debug.g_log_procedure THEN

387: flex_validation_error EXCEPTION;
388: flex_consolidation_error EXCEPTION;
389: rsrc_fetch_error EXCEPTION;
390: BEGIN
391: IF g_debug <= gme_debug.g_log_procedure THEN
392: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
393: || l_api_name);
394: gme_debug.put_line ( g_pkg_name
395: || '.'

Line 392: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

388: flex_consolidation_error EXCEPTION;
389: rsrc_fetch_error EXCEPTION;
390: BEGIN
391: IF g_debug <= gme_debug.g_log_procedure THEN
392: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
393: || l_api_name);
394: gme_debug.put_line ( g_pkg_name
395: || '.'
396: || l_api_name

Line 394: gme_debug.put_line ( g_pkg_name

390: BEGIN
391: IF g_debug <= gme_debug.g_log_procedure THEN
392: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
393: || l_api_name);
394: gme_debug.put_line ( g_pkg_name
395: || '.'
396: || l_api_name
397: || ' action is '
398: || p_action);

Line 407: IF g_debug <= gme_debug.g_log_procedure THEN

403:
404: IF p_action = 'INSERT' THEN
405: /* Validations for Insert processing */
406: --check analysis code
407: IF g_debug <= gme_debug.g_log_procedure THEN
408: gme_debug.put_line ( g_pkg_name
409: || '.'
410: || l_api_name
411: || ' validate cost analysis code '

Line 408: gme_debug.put_line ( g_pkg_name

404: IF p_action = 'INSERT' THEN
405: /* Validations for Insert processing */
406: --check analysis code
407: IF g_debug <= gme_debug.g_log_procedure THEN
408: gme_debug.put_line ( g_pkg_name
409: || '.'
410: || l_api_name
411: || ' validate cost analysis code '
412: || p_batchstep_resource_rec.cost_analysis_code);

Line 439: IF g_debug <= gme_debug.g_log_procedure THEN

435: CLOSE cur_get_analysis_code;
436: END IF;
437:
438: --check cost cmpnt id
439: IF g_debug <= gme_debug.g_log_procedure THEN
440: gme_debug.put_line ( g_pkg_name
441: || '.'
442: || l_api_name
443: || ' validate cost component class'

Line 440: gme_debug.put_line ( g_pkg_name

436: END IF;
437:
438: --check cost cmpnt id
439: IF g_debug <= gme_debug.g_log_procedure THEN
440: gme_debug.put_line ( g_pkg_name
441: || '.'
442: || l_api_name
443: || ' validate cost component class'
444: || p_batchstep_resource_rec.cost_cmpntcls_id);

Line 472: IF g_debug <= gme_debug.g_log_procedure THEN

468: CLOSE cur_get_cost_cmpnt;
469: END IF;
470:
471: -- check scale_type
472: IF g_debug <= gme_debug.g_log_procedure THEN
473: gme_debug.put_line ( g_pkg_name
474: || '.'
475: || l_api_name
476: || ' validate scale type '

Line 473: gme_debug.put_line ( g_pkg_name

469: END IF;
470:
471: -- check scale_type
472: IF g_debug <= gme_debug.g_log_procedure THEN
473: gme_debug.put_line ( g_pkg_name
474: || '.'
475: || l_api_name
476: || ' validate scale type '
477: || p_batchstep_resource_rec.scale_type);

Line 492: IF g_debug <= gme_debug.g_log_procedure THEN

488: RAISE invalid_scale_type;
489: END IF;
490:
491: -- prim rsrc ind
492: IF g_debug <= gme_debug.g_log_procedure THEN
493: gme_debug.put_line ( g_pkg_name
494: || '.'
495: || l_api_name
496: || ' validate primary_resource '

Line 493: gme_debug.put_line ( g_pkg_name

489: END IF;
490:
491: -- prim rsrc ind
492: IF g_debug <= gme_debug.g_log_procedure THEN
493: gme_debug.put_line ( g_pkg_name
494: || '.'
495: || l_api_name
496: || ' validate primary_resource '
497: || p_batchstep_resource_rec.prim_rsrc_ind);

Line 526: IF g_debug <= gme_debug.g_log_procedure THEN

522: l_batchstep_resource_rec.batch_id := l_batch_id;
523: l_batchstep_resource_rec.batchstep_activity_id := l_activity_id;
524: l_batchstep_resource_rec.resource_qty_um := l_step_qty_um;
525:
526: IF g_debug <= gme_debug.g_log_procedure THEN
527: gme_debug.put_line ( g_pkg_name
528: || '.'
529: || l_api_name
530: || ' validate step_status for activity_id '

Line 527: gme_debug.put_line ( g_pkg_name

523: l_batchstep_resource_rec.batchstep_activity_id := l_activity_id;
524: l_batchstep_resource_rec.resource_qty_um := l_step_qty_um;
525:
526: IF g_debug <= gme_debug.g_log_procedure THEN
527: gme_debug.put_line ( g_pkg_name
528: || '.'
529: || l_api_name
530: || ' validate step_status for activity_id '
531: || p_activity_id

Line 556: IF g_debug <= gme_debug.g_log_procedure THEN

552: END IF;
553:
554: x_step_status := l_step_status;
555:
556: IF g_debug <= gme_debug.g_log_procedure THEN
557: gme_debug.put_line ( g_pkg_name
558: || '.'
559: || l_api_name
560: || ' get activity detail for step_status '

Line 557: gme_debug.put_line ( g_pkg_name

553:
554: x_step_status := l_step_status;
555:
556: IF g_debug <= gme_debug.g_log_procedure THEN
557: gme_debug.put_line ( g_pkg_name
558: || '.'
559: || l_api_name
560: || ' get activity detail for step_status '
561: || l_step_status

Line 576: IF g_debug <= gme_debug.g_log_procedure THEN

572:
573: CLOSE cur_get_activity_dtl;
574:
575: -- check activity factor
576: IF g_debug <= gme_debug.g_log_procedure THEN
577: gme_debug.put_line ( g_pkg_name
578: || '.'
579: || l_api_name
580: || ' validate activity factor of '

Line 577: gme_debug.put_line ( g_pkg_name

573: CLOSE cur_get_activity_dtl;
574:
575: -- check activity factor
576: IF g_debug <= gme_debug.g_log_procedure THEN
577: gme_debug.put_line ( g_pkg_name
578: || '.'
579: || l_api_name
580: || ' validate activity factor of '
581: || l_activity_factor);

Line 597: IF g_debug <= gme_debug.g_log_procedure THEN

593: IF p_batchstep_resource_rec.plan_rsrc_count IS NOT NULL THEN
594: l_batchstep_resource_rec.plan_rsrc_count :=
595: TRUNC (p_batchstep_resource_rec.plan_rsrc_count);
596:
597: IF g_debug <= gme_debug.g_log_procedure THEN
598: gme_debug.put_line
599: ( g_pkg_name
600: || '.'
601: || l_api_name

Line 598: gme_debug.put_line

594: l_batchstep_resource_rec.plan_rsrc_count :=
595: TRUNC (p_batchstep_resource_rec.plan_rsrc_count);
596:
597: IF g_debug <= gme_debug.g_log_procedure THEN
598: gme_debug.put_line
599: ( g_pkg_name
600: || '.'
601: || l_api_name
602: || ' integer value needed for plan_rsrc_count '

Line 619: IF g_debug <= gme_debug.g_log_procedure THEN

615: IF p_batchstep_resource_rec.actual_rsrc_count IS NOT NULL THEN
616: l_batchstep_resource_rec.actual_rsrc_count :=
617: TRUNC (p_batchstep_resource_rec.actual_rsrc_count);
618:
619: IF g_debug <= gme_debug.g_log_procedure THEN
620: gme_debug.put_line
621: ( g_pkg_name
622: || '.'
623: || l_api_name

Line 620: gme_debug.put_line

616: l_batchstep_resource_rec.actual_rsrc_count :=
617: TRUNC (p_batchstep_resource_rec.actual_rsrc_count);
618:
619: IF g_debug <= gme_debug.g_log_procedure THEN
620: gme_debug.put_line
621: ( g_pkg_name
622: || '.'
623: || l_api_name
624: || ' integer value needed for actual_rsrc_count '

Line 718: IF g_debug <= gme_debug.g_log_procedure THEN

714: END IF;
715:
716: -- moved date validation out of above if condn as planned dates are defaulted when
717: -- we insert rsrc in WIP step. which is not true for count and usage and other flds
718: IF g_debug <= gme_debug.g_log_procedure THEN
719: gme_debug.put_line ( g_pkg_name
720: || '.'
721: || l_api_name
722: || ' start date validations ');

Line 719: gme_debug.put_line ( g_pkg_name

715:
716: -- moved date validation out of above if condn as planned dates are defaulted when
717: -- we insert rsrc in WIP step. which is not true for count and usage and other flds
718: IF g_debug <= gme_debug.g_log_procedure THEN
719: gme_debug.put_line ( g_pkg_name
720: || '.'
721: || l_api_name
722: || ' start date validations ');
723: END IF;

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

924: RAISE process_qty_error;
925: END IF;
926: END IF;
927:
928: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
929: gme_debug.put_line ('bef ins' || l_batchstep_resource_rec.batch_id);
930: END IF;
931: ELSIF p_action = 'UPDATE' THEN
932: /* ============================ */

Line 929: gme_debug.put_line ('bef ins' || l_batchstep_resource_rec.batch_id);

925: END IF;
926: END IF;
927:
928: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
929: gme_debug.put_line ('bef ins' || l_batchstep_resource_rec.batch_id);
930: END IF;
931: ELSIF p_action = 'UPDATE' THEN
932: /* ============================ */
933: --NULL;

Line 1546: IF g_debug <= gme_debug.g_log_procedure THEN

1542: END IF; -- p_action =
1543:
1544: /* Flexfield Validation */
1545: /* =====================*/
1546: IF g_debug <= gme_debug.g_log_procedure THEN
1547: gme_debug.put_line ( g_pkg_name
1548: || '.'
1549: || l_api_name
1550: || ' start flexfield validation ');

Line 1547: gme_debug.put_line ( g_pkg_name

1543:
1544: /* Flexfield Validation */
1545: /* =====================*/
1546: IF g_debug <= gme_debug.g_log_procedure THEN
1547: gme_debug.put_line ( g_pkg_name
1548: || '.'
1549: || l_api_name
1550: || ' start flexfield validation ');
1551: END IF;

Line 1570: IF g_debug <= gme_debug.g_log_statement THEN

1566: /* Populate the output batchstep resource rec*/
1567: /* ========================================= */
1568: x_batchstep_resource_rec := l_batchstep_resource_rec;
1569:
1570: IF g_debug <= gme_debug.g_log_statement THEN
1571: gme_debug.put_line ( ' Completed '
1572: || l_api_name
1573: || ' at '
1574: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 1571: gme_debug.put_line ( ' Completed '

1567: /* ========================================= */
1568: x_batchstep_resource_rec := l_batchstep_resource_rec;
1569:
1570: IF g_debug <= gme_debug.g_log_statement THEN
1571: gme_debug.put_line ( ' Completed '
1572: || l_api_name
1573: || ' at '
1574: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1575: END IF;

Line 1631: IF g_debug <= gme_debug.g_log_procedure THEN

1627: rsrc_insert_failure EXCEPTION;
1628: rsrc_not_found EXCEPTION;
1629: error_condition EXCEPTION;
1630: BEGIN
1631: IF g_debug <= gme_debug.g_log_procedure THEN
1632: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1633: || l_api_name);
1634: END IF;
1635:

Line 1632: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1628: rsrc_not_found EXCEPTION;
1629: error_condition EXCEPTION;
1630: BEGIN
1631: IF g_debug <= gme_debug.g_log_procedure THEN
1632: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1633: || l_api_name);
1634: END IF;
1635:
1636: /* Initially let us assign the return status to success */

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

1671: ,p_check_prim_rsrc => TRUE
1672: ,x_step_resources_rec => l_batchstep_resource_out_rec
1673: ,x_return_status => l_return_status);
1674:
1675: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1676: gme_debug.put_line ('after insert ' || l_return_status);
1677: END IF;
1678:
1679: IF l_return_status <> 'S' THEN

Line 1676: gme_debug.put_line ('after insert ' || l_return_status);

1672: ,x_step_resources_rec => l_batchstep_resource_out_rec
1673: ,x_return_status => l_return_status);
1674:
1675: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1676: gme_debug.put_line ('after insert ' || l_return_status);
1677: END IF;
1678:
1679: IF l_return_status <> 'S' THEN
1680: RAISE rsrc_insert_failure;

Line 1724: IF g_debug <= gme_debug.g_log_statement THEN

1720: END IF;
1721:
1722: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1723:
1724: IF g_debug <= gme_debug.g_log_statement THEN
1725: gme_debug.put_line ( ' Completed '
1726: || l_api_name
1727: || ' at '
1728: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 1725: gme_debug.put_line ( ' Completed '

1721:
1722: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1723:
1724: IF g_debug <= gme_debug.g_log_statement THEN
1725: gme_debug.put_line ( ' Completed '
1726: || l_api_name
1727: || ' at '
1728: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1729: END IF;

Line 1834: IF g_debug <= gme_debug.g_log_procedure THEN

1830: no_change EXCEPTION;
1831: invalid_step_status EXCEPTION;
1832: error_condition EXCEPTION;
1833: BEGIN
1834: IF g_debug <= gme_debug.g_log_procedure THEN
1835: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1836: || l_api_name);
1837: END IF;
1838:

Line 1835: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1831: invalid_step_status EXCEPTION;
1832: error_condition EXCEPTION;
1833: BEGIN
1834: IF g_debug <= gme_debug.g_log_procedure THEN
1835: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1836: || l_api_name);
1837: END IF;
1838:
1839: /* Initially let us assign the return status to success */

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

1896: ,p_check_prim_rsrc => TRUE
1897: ,x_step_resources_rec => l_batchstep_resource_out_rec
1898: ,x_return_status => l_return_status);
1899:
1900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1901: gme_debug.put_line ('aft upd' || l_return_status);
1902: END IF;
1903:
1904: IF l_return_status <> 'S' THEN

Line 1901: gme_debug.put_line ('aft upd' || l_return_status);

1897: ,x_step_resources_rec => l_batchstep_resource_out_rec
1898: ,x_return_status => l_return_status);
1899:
1900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1901: gme_debug.put_line ('aft upd' || l_return_status);
1902: END IF;
1903:
1904: IF l_return_status <> 'S' THEN
1905: RAISE rsrc_update_failure;

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

1917:
1918: FETCH cur_get_rsrc_dtl
1919: INTO l_capacity_constraint;
1920:
1921: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1922: gme_debug.put_line ('after rsrc dtl fetch ');
1923: END IF;
1924:
1925: IF (cur_get_rsrc_dtl%NOTFOUND) THEN

Line 1922: gme_debug.put_line ('after rsrc dtl fetch ');

1918: FETCH cur_get_rsrc_dtl
1919: INTO l_capacity_constraint;
1920:
1921: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1922: gme_debug.put_line ('after rsrc dtl fetch ');
1923: END IF;
1924:
1925: IF (cur_get_rsrc_dtl%NOTFOUND) THEN
1926: OPEN cur_get_rsrc_hdr (l_resource);

Line 1959: IF g_debug <= gme_debug.g_log_statement THEN

1955: END IF;
1956:
1957: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1958:
1959: IF g_debug <= gme_debug.g_log_statement THEN
1960: gme_debug.put_line ( ' Completed '
1961: || l_api_name
1962: || ' at '
1963: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 1960: gme_debug.put_line ( ' Completed '

1956:
1957: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1958:
1959: IF g_debug <= gme_debug.g_log_statement THEN
1960: gme_debug.put_line ( ' Completed '
1961: || l_api_name
1962: || ' at '
1963: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1964: END IF;

Line 1998: IF g_debug <= gme_debug.g_log_procedure THEN

1994: l_rsrc_trans_count NUMBER;
1995: error_deleting_rsrc EXCEPTION;
1996: error_condition EXCEPTION;
1997: BEGIN
1998: IF g_debug <= gme_debug.g_log_procedure THEN
1999: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2000: || l_api_name);
2001: END IF;
2002:

Line 1999: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1995: error_deleting_rsrc EXCEPTION;
1996: error_condition EXCEPTION;
1997: BEGIN
1998: IF g_debug <= gme_debug.g_log_procedure THEN
1999: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2000: || l_api_name);
2001: END IF;
2002:
2003: /* Initially let us assign the return status to success */

Line 2032: IF g_debug <= gme_debug.g_log_statement THEN

2028: ,p_check_prim_rsrc => TRUE
2029: ,x_step_resources_rec => l_batchstep_resource_rec
2030: ,x_return_status => l_return_status);
2031:
2032: IF g_debug <= gme_debug.g_log_statement THEN
2033: gme_debug.put_line ( 'delete batchsetp resource returns '
2034: || l_return_status);
2035: END IF;
2036:

Line 2033: gme_debug.put_line ( 'delete batchsetp resource returns '

2029: ,x_step_resources_rec => l_batchstep_resource_rec
2030: ,x_return_status => l_return_status);
2031:
2032: IF g_debug <= gme_debug.g_log_statement THEN
2033: gme_debug.put_line ( 'delete batchsetp resource returns '
2034: || l_return_status);
2035: END IF;
2036:
2037: IF l_return_status <> 'S' THEN

Line 2041: IF g_debug <= gme_debug.g_log_statement THEN

2037: IF l_return_status <> 'S' THEN
2038: RAISE error_deleting_rsrc;
2039: END IF;
2040:
2041: IF g_debug <= gme_debug.g_log_statement THEN
2042: gme_debug.put_line ( ' Completed '
2043: || l_api_name
2044: || ' at '
2045: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 2042: gme_debug.put_line ( ' Completed '

2038: RAISE error_deleting_rsrc;
2039: END IF;
2040:
2041: IF g_debug <= gme_debug.g_log_statement THEN
2042: gme_debug.put_line ( ' Completed '
2043: || l_api_name
2044: || ' at '
2045: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2046: END IF;

Line 2074: IF g_debug <= gme_debug.g_log_procedure THEN

2070: ,actual_cmplt_date
2071: FROM gme_batch_step_activities
2072: WHERE batchstep_activity_id = p_batchstep_activity_id;
2073: BEGIN
2074: IF g_debug <= gme_debug.g_log_procedure THEN
2075: gme_debug.put_line ('Entering api ' ||
2076: g_pkg_name || '.' ||
2077: l_api_name);
2078: gme_debug.put_line ('Input step status is ' ||

Line 2075: gme_debug.put_line ('Entering api ' ||

2071: FROM gme_batch_step_activities
2072: WHERE batchstep_activity_id = p_batchstep_activity_id;
2073: BEGIN
2074: IF g_debug <= gme_debug.g_log_procedure THEN
2075: gme_debug.put_line ('Entering api ' ||
2076: g_pkg_name || '.' ||
2077: l_api_name);
2078: gme_debug.put_line ('Input step status is ' ||
2079: p_step_status ||

Line 2078: gme_debug.put_line ('Input step status is ' ||

2074: IF g_debug <= gme_debug.g_log_procedure THEN
2075: gme_debug.put_line ('Entering api ' ||
2076: g_pkg_name || '.' ||
2077: l_api_name);
2078: gme_debug.put_line ('Input step status is ' ||
2079: p_step_status ||
2080: 'Input batchstep activity id is '||
2081: p_batchstep_activity_id);
2082: END IF;

Line 2092: IF (g_debug <= gme_debug.g_log_statement) THEN

2088: ,l_actual_cmplt_date;
2089:
2090: CLOSE cur_get_act_dates;
2091:
2092: IF (g_debug <= gme_debug.g_log_statement) THEN
2093: gme_debug.put_line ( g_pkg_name
2094: || '.'
2095: || l_api_name
2096: || ':'

Line 2093: gme_debug.put_line ( g_pkg_name

2089:
2090: CLOSE cur_get_act_dates;
2091:
2092: IF (g_debug <= gme_debug.g_log_statement) THEN
2093: gme_debug.put_line ( g_pkg_name
2094: || '.'
2095: || l_api_name
2096: || ':'
2097: || 'Input date =>'

Line 2192: IF g_debug <= gme_debug.g_log_procedure THEN

2188: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
2189: l_return_status VARCHAR2 (2);
2190: error_condition EXCEPTION;
2191: BEGIN
2192: IF g_debug <= gme_debug.g_log_procedure THEN
2193: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2194: || l_api_name);
2195: END IF;
2196:

Line 2193: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

2189: l_return_status VARCHAR2 (2);
2190: error_condition EXCEPTION;
2191: BEGIN
2192: IF g_debug <= gme_debug.g_log_procedure THEN
2193: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2194: || l_api_name);
2195: END IF;
2196:
2197: /* Initially let us assign the return status to success */

Line 2557: IF g_debug <= gme_debug.g_log_statement THEN

2553: END IF;
2554:
2555: x_batchstep_resource_rec := l_batchstep_resource_rec;
2556:
2557: IF g_debug <= gme_debug.g_log_statement THEN
2558: gme_debug.put_line ( ' Completed '
2559: || l_api_name
2560: || ' at '
2561: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 2558: gme_debug.put_line ( ' Completed '

2554:
2555: x_batchstep_resource_rec := l_batchstep_resource_rec;
2556:
2557: IF g_debug <= gme_debug.g_log_statement THEN
2558: gme_debug.put_line ( ' Completed '
2559: || l_api_name
2560: || ' at '
2561: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2562: END IF;