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 110: IF g_debug <= gme_debug.g_log_procedure THEN

106: stepactivity_not_found EXCEPTION;
107: resource_not_found EXCEPTION;
108: input_param_missing EXCEPTION;
109: BEGIN
110: IF g_debug <= gme_debug.g_log_procedure THEN
111: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
112: || l_api_name);
113: gme_debug.put_line ( g_pkg_name
114: || '.'

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

107: resource_not_found EXCEPTION;
108: input_param_missing EXCEPTION;
109: BEGIN
110: IF g_debug <= gme_debug.g_log_procedure THEN
111: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
112: || l_api_name);
113: gme_debug.put_line ( g_pkg_name
114: || '.'
115: || l_api_name

Line 113: gme_debug.put_line ( g_pkg_name

109: BEGIN
110: IF g_debug <= gme_debug.g_log_procedure THEN
111: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
112: || l_api_name);
113: gme_debug.put_line ( g_pkg_name
114: || '.'
115: || l_api_name
116: || ' input org_code =>'
117: || p_org_code);

Line 118: gme_debug.put_line ( g_pkg_name

114: || '.'
115: || l_api_name
116: || ' input org_code =>'
117: || p_org_code);
118: gme_debug.put_line ( g_pkg_name
119: || '.'
120: || l_api_name
121: || ' input batch_no =>'
122: || p_batch_no);

Line 123: gme_debug.put_line ( g_pkg_name

119: || '.'
120: || l_api_name
121: || ' input batch_no =>'
122: || p_batch_no);
123: gme_debug.put_line ( g_pkg_name
124: || '.'
125: || l_api_name
126: || ' input batchstep_no =>'
127: || p_batchstep_no);

Line 128: gme_debug.put_line ( g_pkg_name

124: || '.'
125: || l_api_name
126: || ' input batchstep_no =>'
127: || p_batchstep_no);
128: gme_debug.put_line ( g_pkg_name
129: || '.'
130: || l_api_name
131: || ' input activity =>'
132: || p_activity);

Line 133: gme_debug.put_line ( g_pkg_name

129: || '.'
130: || l_api_name
131: || ' input activity =>'
132: || p_activity);
133: gme_debug.put_line ( g_pkg_name
134: || '.'
135: || l_api_name
136: || ' input resource =>'
137: || p_resource);

Line 138: gme_debug.put_line ( g_pkg_name

134: || '.'
135: || l_api_name
136: || ' input resource =>'
137: || p_resource);
138: gme_debug.put_line ( g_pkg_name
139: || '.'
140: || l_api_name
141: || ' **********************************');
142: END IF;

Line 255: IF g_debug <= gme_debug.g_log_statement THEN

251: ,p_activity);
252: RAISE resource_not_found;
253: END IF;
254:
255: IF g_debug <= gme_debug.g_log_statement THEN
256: gme_debug.put_line ( g_pkg_name
257: || '.'
258: || l_api_name
259: || ' output organization =>'

Line 256: gme_debug.put_line ( g_pkg_name

252: RAISE resource_not_found;
253: END IF;
254:
255: IF g_debug <= gme_debug.g_log_statement THEN
256: gme_debug.put_line ( g_pkg_name
257: || '.'
258: || l_api_name
259: || ' output organization =>'
260: || x_organization_id);

Line 261: gme_debug.put_line ( g_pkg_name

257: || '.'
258: || l_api_name
259: || ' output organization =>'
260: || x_organization_id);
261: gme_debug.put_line ( g_pkg_name
262: || '.'
263: || l_api_name
264: || ' output batch_id =>'
265: || x_batch_id);

Line 266: gme_debug.put_line ( g_pkg_name

262: || '.'
263: || l_api_name
264: || ' output batch_id =>'
265: || x_batch_id);
266: gme_debug.put_line ( g_pkg_name
267: || '.'
268: || l_api_name
269: || ' output batchstep_id =>'
270: || x_batchstep_id);

Line 271: gme_debug.put_line ( g_pkg_name

267: || '.'
268: || l_api_name
269: || ' output batchstep_id =>'
270: || x_batchstep_id);
271: gme_debug.put_line ( g_pkg_name
272: || '.'
273: || l_api_name
274: || ' output activity_id =>'
275: || x_activity_id);

Line 276: gme_debug.put_line ( g_pkg_name

272: || '.'
273: || l_api_name
274: || ' output activity_id =>'
275: || x_activity_id);
276: gme_debug.put_line ( g_pkg_name
277: || '.'
278: || l_api_name
279: || ' output rsrc_id =>'
280: || x_rsrc_id);

Line 281: gme_debug.put_line ( g_pkg_name

277: || '.'
278: || l_api_name
279: || ' output rsrc_id =>'
280: || x_rsrc_id);
281: gme_debug.put_line ( g_pkg_name
282: || '.'
283: || l_api_name
284: || ' output step_status =>'
285: || x_step_status);

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

282: || '.'
283: || l_api_name
284: || ' output step_status =>'
285: || x_step_status);
286: gme_debug.put_line ( ' Completed private layer '
287: || l_api_name
288: || ' at '
289: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
290: END IF;

Line 403: IF g_debug <= gme_debug.g_log_procedure THEN

399: flex_validation_error EXCEPTION;
400: flex_consolidation_error EXCEPTION;
401: rsrc_fetch_error EXCEPTION;
402: BEGIN
403: IF g_debug <= gme_debug.g_log_procedure THEN
404: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
405: || l_api_name);
406: gme_debug.put_line ( g_pkg_name
407: || '.'

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

400: flex_consolidation_error EXCEPTION;
401: rsrc_fetch_error EXCEPTION;
402: BEGIN
403: IF g_debug <= gme_debug.g_log_procedure THEN
404: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
405: || l_api_name);
406: gme_debug.put_line ( g_pkg_name
407: || '.'
408: || l_api_name

Line 406: gme_debug.put_line ( g_pkg_name

402: BEGIN
403: IF g_debug <= gme_debug.g_log_procedure THEN
404: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
405: || l_api_name);
406: gme_debug.put_line ( g_pkg_name
407: || '.'
408: || l_api_name
409: || ' action is '
410: || p_action);

Line 428: IF g_debug <= gme_debug.g_log_procedure THEN

424:
425: IF p_action = 'INSERT' THEN
426: /* Validations for Insert processing */
427: --check analysis code
428: IF g_debug <= gme_debug.g_log_procedure THEN
429: gme_debug.put_line ( g_pkg_name
430: || '.'
431: || l_api_name
432: || ' validate cost analysis code '

Line 429: gme_debug.put_line ( g_pkg_name

425: IF p_action = 'INSERT' THEN
426: /* Validations for Insert processing */
427: --check analysis code
428: IF g_debug <= gme_debug.g_log_procedure THEN
429: gme_debug.put_line ( g_pkg_name
430: || '.'
431: || l_api_name
432: || ' validate cost analysis code '
433: || p_batchstep_resource_rec.cost_analysis_code);

Line 460: IF g_debug <= gme_debug.g_log_procedure THEN

456: CLOSE cur_get_analysis_code;
457: END IF;
458:
459: --check cost cmpnt id
460: IF g_debug <= gme_debug.g_log_procedure THEN
461: gme_debug.put_line ( g_pkg_name
462: || '.'
463: || l_api_name
464: || ' validate cost component class'

Line 461: gme_debug.put_line ( g_pkg_name

457: END IF;
458:
459: --check cost cmpnt id
460: IF g_debug <= gme_debug.g_log_procedure THEN
461: gme_debug.put_line ( g_pkg_name
462: || '.'
463: || l_api_name
464: || ' validate cost component class'
465: || p_batchstep_resource_rec.cost_cmpntcls_id);

Line 493: IF g_debug <= gme_debug.g_log_procedure THEN

489: CLOSE cur_get_cost_cmpnt;
490: END IF;
491:
492: -- check scale_type
493: IF g_debug <= gme_debug.g_log_procedure THEN
494: gme_debug.put_line ( g_pkg_name
495: || '.'
496: || l_api_name
497: || ' validate scale type '

Line 494: gme_debug.put_line ( g_pkg_name

490: END IF;
491:
492: -- check scale_type
493: IF g_debug <= gme_debug.g_log_procedure THEN
494: gme_debug.put_line ( g_pkg_name
495: || '.'
496: || l_api_name
497: || ' validate scale type '
498: || p_batchstep_resource_rec.scale_type);

Line 513: IF g_debug <= gme_debug.g_log_procedure THEN

509: RAISE invalid_scale_type;
510: END IF;
511:
512: -- prim rsrc ind
513: IF g_debug <= gme_debug.g_log_procedure THEN
514: gme_debug.put_line ( g_pkg_name
515: || '.'
516: || l_api_name
517: || ' validate primary_resource '

Line 514: gme_debug.put_line ( g_pkg_name

510: END IF;
511:
512: -- prim rsrc ind
513: IF g_debug <= gme_debug.g_log_procedure THEN
514: gme_debug.put_line ( g_pkg_name
515: || '.'
516: || l_api_name
517: || ' validate primary_resource '
518: || p_batchstep_resource_rec.prim_rsrc_ind);

Line 551: IF g_debug <= gme_debug.g_log_procedure THEN

547: l_batchstep_resource_rec.batch_id := l_batch_id;
548: l_batchstep_resource_rec.batchstep_activity_id := l_activity_id;
549: l_batchstep_resource_rec.resource_qty_um := l_step_qty_um;
550:
551: IF g_debug <= gme_debug.g_log_procedure THEN
552: gme_debug.put_line ( g_pkg_name
553: || '.'
554: || l_api_name
555: || ' validate step_status for activity_id '

Line 552: gme_debug.put_line ( g_pkg_name

548: l_batchstep_resource_rec.batchstep_activity_id := l_activity_id;
549: l_batchstep_resource_rec.resource_qty_um := l_step_qty_um;
550:
551: IF g_debug <= gme_debug.g_log_procedure THEN
552: gme_debug.put_line ( g_pkg_name
553: || '.'
554: || l_api_name
555: || ' validate step_status for activity_id '
556: || p_activity_id

Line 581: IF g_debug <= gme_debug.g_log_procedure THEN

577: END IF;
578:
579: x_step_status := l_step_status;
580:
581: IF g_debug <= gme_debug.g_log_procedure THEN
582: gme_debug.put_line ( g_pkg_name
583: || '.'
584: || l_api_name
585: || ' get activity detail for step_status '

Line 582: gme_debug.put_line ( g_pkg_name

578:
579: x_step_status := l_step_status;
580:
581: IF g_debug <= gme_debug.g_log_procedure THEN
582: gme_debug.put_line ( g_pkg_name
583: || '.'
584: || l_api_name
585: || ' get activity detail for step_status '
586: || l_step_status

Line 601: IF g_debug <= gme_debug.g_log_procedure THEN

597:
598: CLOSE cur_get_activity_dtl;
599:
600: -- check activity factor
601: IF g_debug <= gme_debug.g_log_procedure THEN
602: gme_debug.put_line ( g_pkg_name
603: || '.'
604: || l_api_name
605: || ' validate activity factor of '

Line 602: gme_debug.put_line ( g_pkg_name

598: CLOSE cur_get_activity_dtl;
599:
600: -- check activity factor
601: IF g_debug <= gme_debug.g_log_procedure THEN
602: gme_debug.put_line ( g_pkg_name
603: || '.'
604: || l_api_name
605: || ' validate activity factor of '
606: || l_activity_factor);

Line 622: IF g_debug <= gme_debug.g_log_procedure THEN

618: IF p_batchstep_resource_rec.plan_rsrc_count IS NOT NULL THEN
619: l_batchstep_resource_rec.plan_rsrc_count :=
620: TRUNC (p_batchstep_resource_rec.plan_rsrc_count);
621:
622: IF g_debug <= gme_debug.g_log_procedure THEN
623: gme_debug.put_line
624: ( g_pkg_name
625: || '.'
626: || l_api_name

Line 623: gme_debug.put_line

619: l_batchstep_resource_rec.plan_rsrc_count :=
620: TRUNC (p_batchstep_resource_rec.plan_rsrc_count);
621:
622: IF g_debug <= gme_debug.g_log_procedure THEN
623: gme_debug.put_line
624: ( g_pkg_name
625: || '.'
626: || l_api_name
627: || ' integer value needed for plan_rsrc_count '

Line 644: IF g_debug <= gme_debug.g_log_procedure THEN

640: IF p_batchstep_resource_rec.actual_rsrc_count IS NOT NULL THEN
641: l_batchstep_resource_rec.actual_rsrc_count :=
642: TRUNC (p_batchstep_resource_rec.actual_rsrc_count);
643:
644: IF g_debug <= gme_debug.g_log_procedure THEN
645: gme_debug.put_line
646: ( g_pkg_name
647: || '.'
648: || l_api_name

Line 645: gme_debug.put_line

641: l_batchstep_resource_rec.actual_rsrc_count :=
642: TRUNC (p_batchstep_resource_rec.actual_rsrc_count);
643:
644: IF g_debug <= gme_debug.g_log_procedure THEN
645: gme_debug.put_line
646: ( g_pkg_name
647: || '.'
648: || l_api_name
649: || ' integer value needed for actual_rsrc_count '

Line 743: IF g_debug <= gme_debug.g_log_procedure THEN

739: END IF;
740:
741: -- moved date validation out of above if condn as planned dates are defaulted when
742: -- we insert rsrc in WIP step. which is not true for count and usage and other flds
743: IF g_debug <= gme_debug.g_log_procedure THEN
744: gme_debug.put_line ( g_pkg_name
745: || '.'
746: || l_api_name
747: || ' start date validations ');

Line 744: gme_debug.put_line ( g_pkg_name

740:
741: -- moved date validation out of above if condn as planned dates are defaulted when
742: -- we insert rsrc in WIP step. which is not true for count and usage and other flds
743: IF g_debug <= gme_debug.g_log_procedure THEN
744: gme_debug.put_line ( g_pkg_name
745: || '.'
746: || l_api_name
747: || ' start date validations ');
748: END IF;

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

949: RAISE process_qty_error;
950: END IF;
951: END IF;
952:
953: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
954: gme_debug.put_line ('bef ins' || l_batchstep_resource_rec.batch_id);
955: END IF;
956: ELSIF p_action = 'UPDATE' THEN
957: /* ============================ */

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

950: END IF;
951: END IF;
952:
953: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
954: gme_debug.put_line ('bef ins' || l_batchstep_resource_rec.batch_id);
955: END IF;
956: ELSIF p_action = 'UPDATE' THEN
957: /* ============================ */
958: --NULL;

Line 1571: IF g_debug <= gme_debug.g_log_procedure THEN

1567: END IF; -- p_action =
1568:
1569: /* Flexfield Validation */
1570: /* =====================*/
1571: IF g_debug <= gme_debug.g_log_procedure THEN
1572: gme_debug.put_line ( g_pkg_name
1573: || '.'
1574: || l_api_name
1575: || ' start flexfield validation ');

Line 1572: gme_debug.put_line ( g_pkg_name

1568:
1569: /* Flexfield Validation */
1570: /* =====================*/
1571: IF g_debug <= gme_debug.g_log_procedure THEN
1572: gme_debug.put_line ( g_pkg_name
1573: || '.'
1574: || l_api_name
1575: || ' start flexfield validation ');
1576: END IF;

Line 1595: IF g_debug <= gme_debug.g_log_statement THEN

1591: /* Populate the output batchstep resource rec*/
1592: /* ========================================= */
1593: x_batchstep_resource_rec := l_batchstep_resource_rec;
1594:
1595: IF g_debug <= gme_debug.g_log_statement THEN
1596: gme_debug.put_line ( ' Completed '
1597: || l_api_name
1598: || ' at '
1599: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 1596: gme_debug.put_line ( ' Completed '

1592: /* ========================================= */
1593: x_batchstep_resource_rec := l_batchstep_resource_rec;
1594:
1595: IF g_debug <= gme_debug.g_log_statement THEN
1596: gme_debug.put_line ( ' Completed '
1597: || l_api_name
1598: || ' at '
1599: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1600: END IF;

Line 1656: IF g_debug <= gme_debug.g_log_procedure THEN

1652: rsrc_insert_failure EXCEPTION;
1653: rsrc_not_found EXCEPTION;
1654: error_condition EXCEPTION;
1655: BEGIN
1656: IF g_debug <= gme_debug.g_log_procedure THEN
1657: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1658: || l_api_name);
1659: END IF;
1660:

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

1653: rsrc_not_found EXCEPTION;
1654: error_condition EXCEPTION;
1655: BEGIN
1656: IF g_debug <= gme_debug.g_log_procedure THEN
1657: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1658: || l_api_name);
1659: END IF;
1660:
1661: /* Initially let us assign the return status to success */

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

1696: ,p_check_prim_rsrc => TRUE
1697: ,x_step_resources_rec => l_batchstep_resource_out_rec
1698: ,x_return_status => l_return_status);
1699:
1700: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1701: gme_debug.put_line ('after insert ' || l_return_status);
1702: END IF;
1703:
1704: IF l_return_status <> 'S' THEN

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

1697: ,x_step_resources_rec => l_batchstep_resource_out_rec
1698: ,x_return_status => l_return_status);
1699:
1700: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1701: gme_debug.put_line ('after insert ' || l_return_status);
1702: END IF;
1703:
1704: IF l_return_status <> 'S' THEN
1705: RAISE rsrc_insert_failure;

Line 1749: IF g_debug <= gme_debug.g_log_statement THEN

1745: END IF;
1746:
1747: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1748:
1749: IF g_debug <= gme_debug.g_log_statement THEN
1750: gme_debug.put_line ( ' Completed '
1751: || l_api_name
1752: || ' at '
1753: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 1750: gme_debug.put_line ( ' Completed '

1746:
1747: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1748:
1749: IF g_debug <= gme_debug.g_log_statement THEN
1750: gme_debug.put_line ( ' Completed '
1751: || l_api_name
1752: || ' at '
1753: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1754: END IF;

Line 1865: IF g_debug <= gme_debug.g_log_procedure THEN

1861: no_change EXCEPTION;
1862: invalid_step_status EXCEPTION;
1863: error_condition EXCEPTION;
1864: BEGIN
1865: IF g_debug <= gme_debug.g_log_procedure THEN
1866: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1867: || l_api_name);
1868: END IF;
1869:

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

1862: invalid_step_status EXCEPTION;
1863: error_condition EXCEPTION;
1864: BEGIN
1865: IF g_debug <= gme_debug.g_log_procedure THEN
1866: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1867: || l_api_name);
1868: END IF;
1869:
1870: /* Initially let us assign the return status to success */

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

1927: ,p_check_prim_rsrc => TRUE
1928: ,x_step_resources_rec => l_batchstep_resource_out_rec
1929: ,x_return_status => l_return_status);
1930:
1931: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1932: gme_debug.put_line ('aft upd' || l_return_status);
1933: END IF;
1934:
1935: IF l_return_status <> 'S' THEN

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

1928: ,x_step_resources_rec => l_batchstep_resource_out_rec
1929: ,x_return_status => l_return_status);
1930:
1931: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1932: gme_debug.put_line ('aft upd' || l_return_status);
1933: END IF;
1934:
1935: IF l_return_status <> 'S' THEN
1936: RAISE rsrc_update_failure;

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

1948:
1949: FETCH cur_get_rsrc_dtl
1950: INTO l_capacity_constraint;
1951:
1952: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1953: gme_debug.put_line ('after rsrc dtl fetch ');
1954: END IF;
1955:
1956: IF (cur_get_rsrc_dtl%NOTFOUND) THEN

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

1949: FETCH cur_get_rsrc_dtl
1950: INTO l_capacity_constraint;
1951:
1952: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1953: gme_debug.put_line ('after rsrc dtl fetch ');
1954: END IF;
1955:
1956: IF (cur_get_rsrc_dtl%NOTFOUND) THEN
1957: OPEN cur_get_rsrc_hdr (l_resource);

Line 1994: IF g_debug <= gme_debug.g_log_statement THEN

1990: END IF;
1991:
1992: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1993:
1994: IF g_debug <= gme_debug.g_log_statement THEN
1995: gme_debug.put_line ( ' Completed '
1996: || l_api_name
1997: || ' at '
1998: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 1995: gme_debug.put_line ( ' Completed '

1991:
1992: x_batchstep_resource_rec := l_batchstep_resource_out_rec;
1993:
1994: IF g_debug <= gme_debug.g_log_statement THEN
1995: gme_debug.put_line ( ' Completed '
1996: || l_api_name
1997: || ' at '
1998: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1999: END IF;

Line 2033: IF g_debug <= gme_debug.g_log_procedure THEN

2029: l_rsrc_trans_count NUMBER;
2030: error_deleting_rsrc EXCEPTION;
2031: error_condition EXCEPTION;
2032: BEGIN
2033: IF g_debug <= gme_debug.g_log_procedure THEN
2034: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2035: || l_api_name);
2036: END IF;
2037:

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

2030: error_deleting_rsrc EXCEPTION;
2031: error_condition EXCEPTION;
2032: BEGIN
2033: IF g_debug <= gme_debug.g_log_procedure THEN
2034: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2035: || l_api_name);
2036: END IF;
2037:
2038: /* Initially let us assign the return status to success */

Line 2067: IF g_debug <= gme_debug.g_log_statement THEN

2063: ,p_check_prim_rsrc => TRUE
2064: ,x_step_resources_rec => l_batchstep_resource_rec
2065: ,x_return_status => l_return_status);
2066:
2067: IF g_debug <= gme_debug.g_log_statement THEN
2068: gme_debug.put_line ( 'delete batchsetp resource returns '
2069: || l_return_status);
2070: END IF;
2071:

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

2064: ,x_step_resources_rec => l_batchstep_resource_rec
2065: ,x_return_status => l_return_status);
2066:
2067: IF g_debug <= gme_debug.g_log_statement THEN
2068: gme_debug.put_line ( 'delete batchsetp resource returns '
2069: || l_return_status);
2070: END IF;
2071:
2072: IF l_return_status <> 'S' THEN

Line 2076: IF g_debug <= gme_debug.g_log_statement THEN

2072: IF l_return_status <> 'S' THEN
2073: RAISE error_deleting_rsrc;
2074: END IF;
2075:
2076: IF g_debug <= gme_debug.g_log_statement THEN
2077: gme_debug.put_line ( ' Completed '
2078: || l_api_name
2079: || ' at '
2080: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 2077: gme_debug.put_line ( ' Completed '

2073: RAISE error_deleting_rsrc;
2074: END IF;
2075:
2076: IF g_debug <= gme_debug.g_log_statement THEN
2077: gme_debug.put_line ( ' Completed '
2078: || l_api_name
2079: || ' at '
2080: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2081: END IF;

Line 2109: IF g_debug <= gme_debug.g_log_procedure THEN

2105: ,actual_cmplt_date
2106: FROM gme_batch_step_activities
2107: WHERE batchstep_activity_id = p_batchstep_activity_id;
2108: BEGIN
2109: IF g_debug <= gme_debug.g_log_procedure THEN
2110: gme_debug.put_line ('Entering api ' ||
2111: g_pkg_name || '.' ||
2112: l_api_name);
2113: gme_debug.put_line (' Input step status is ' ||

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

2106: FROM gme_batch_step_activities
2107: WHERE batchstep_activity_id = p_batchstep_activity_id;
2108: BEGIN
2109: IF g_debug <= gme_debug.g_log_procedure THEN
2110: gme_debug.put_line ('Entering api ' ||
2111: g_pkg_name || '.' ||
2112: l_api_name);
2113: gme_debug.put_line (' Input step status is ' ||
2114: p_step_status ||

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

2109: IF g_debug <= gme_debug.g_log_procedure THEN
2110: gme_debug.put_line ('Entering api ' ||
2111: g_pkg_name || '.' ||
2112: l_api_name);
2113: gme_debug.put_line (' Input step status is ' ||
2114: p_step_status ||
2115: ' Input batchstep activity id is '||
2116: p_batchstep_activity_id);
2117: END IF;

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

2123: ,l_actual_cmplt_date;
2124:
2125: CLOSE cur_get_act_dates;
2126:
2127: IF (g_debug <= gme_debug.g_log_statement) THEN
2128: gme_debug.put_line ( g_pkg_name
2129: || '.'
2130: || l_api_name
2131: || ':'

Line 2128: gme_debug.put_line ( g_pkg_name

2124:
2125: CLOSE cur_get_act_dates;
2126:
2127: IF (g_debug <= gme_debug.g_log_statement) THEN
2128: gme_debug.put_line ( g_pkg_name
2129: || '.'
2130: || l_api_name
2131: || ':'
2132: || 'Input date =>'

Line 2227: IF g_debug <= gme_debug.g_log_procedure THEN

2223: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
2224: l_return_status VARCHAR2 (2);
2225: error_condition EXCEPTION;
2226: BEGIN
2227: IF g_debug <= gme_debug.g_log_procedure THEN
2228: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2229: || l_api_name);
2230: END IF;
2231:

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

2224: l_return_status VARCHAR2 (2);
2225: error_condition EXCEPTION;
2226: BEGIN
2227: IF g_debug <= gme_debug.g_log_procedure THEN
2228: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2229: || l_api_name);
2230: END IF;
2231:
2232: /* Initially let us assign the return status to success */

Line 2592: IF g_debug <= gme_debug.g_log_statement THEN

2588: END IF;
2589:
2590: x_batchstep_resource_rec := l_batchstep_resource_rec;
2591:
2592: IF g_debug <= gme_debug.g_log_statement THEN
2593: gme_debug.put_line ( ' Completed '
2594: || l_api_name
2595: || ' at '
2596: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );

Line 2593: gme_debug.put_line ( ' Completed '

2589:
2590: x_batchstep_resource_rec := l_batchstep_resource_rec;
2591:
2592: IF g_debug <= gme_debug.g_log_statement THEN
2593: gme_debug.put_line ( ' Completed '
2594: || l_api_name
2595: || ' at '
2596: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2597: END IF;