DBA Data[Home] [Help]

APPS.GME_BATCHSTEP_ACT_PVT dependencies on GME_DEBUG

Line 58: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

54: AND batch_id = v_batch_id
55: AND activity = v_activity;
56: BEGIN
57: IF (NVL (g_debug, 0) IN
58: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
59: )
60: THEN
61: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
62: || 'Entering'

Line 61: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

57: IF (NVL (g_debug, 0) IN
58: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
59: )
60: THEN
61: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
62: || 'Entering'
63: );
64: END IF;
65:

Line 139: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

135: CLOSE cur_get_activity_id;
136: END IF;
137:
138: IF (NVL (g_debug, 0) IN
139: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
140: )
141: THEN
142: gme_debug.put_line ( g_pkg_name
143: || '.'

Line 142: gme_debug.put_line ( g_pkg_name

138: IF (NVL (g_debug, 0) IN
139: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
140: )
141: THEN
142: gme_debug.put_line ( g_pkg_name
143: || '.'
144: || l_api_name
145: || ':'
146: || 'Exiting with '

Line 160: gme_debug.put_line ( g_pkg_name

156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157:
158: IF (NVL (g_debug, 0) > 0)
159: THEN
160: gme_debug.put_line ( g_pkg_name
161: || '.'
162: || l_api_name
163: || ':'
164: || 'UNEXPECTED:'

Line 175: gme_debug.put_line ( g_pkg_name

171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172:
173: IF (NVL (g_debug, 0) > 0)
174: THEN
175: gme_debug.put_line ( g_pkg_name
176: || '.'
177: || l_api_name
178: || ':'
179: || 'OTHERS:'

Line 238: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

234: FROM gme_batch_header b, gme_batch_steps s
235: WHERE b.batch_id = s.batch_id AND batchstep_id = v_step_id;
236: BEGIN
237: IF (NVL (g_debug, 0) IN
238: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
239: )
240: THEN
241: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
242: || 'Entering'

Line 241: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

237: IF (NVL (g_debug, 0) IN
238: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
239: )
240: THEN
241: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
242: || 'Entering'
243: );
244: END IF;
245:

Line 614: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

610:
611: x_batchstep_activity_rec := l_batchstep_activity_rec;
612:
613: IF (NVL (g_debug, 0) IN
614: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
615: )
616: THEN
617: gme_debug.put_line ( g_pkg_name
618: || '.'

Line 617: gme_debug.put_line ( g_pkg_name

613: IF (NVL (g_debug, 0) IN
614: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
615: )
616: THEN
617: gme_debug.put_line ( g_pkg_name
618: || '.'
619: || l_api_name
620: || ':'
621: || 'Exiting with '

Line 635: gme_debug.put_line ( g_pkg_name

631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632:
633: IF (NVL (g_debug, 0) > 0)
634: THEN
635: gme_debug.put_line ( g_pkg_name
636: || '.'
637: || l_api_name
638: || ':'
639: || 'UNEXPECTED:'

Line 650: gme_debug.put_line ( g_pkg_name

646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647:
648: IF (NVL (g_debug, 0) > 0)
649: THEN
650: gme_debug.put_line ( g_pkg_name
651: || '.'
652: || l_api_name
653: || ':'
654: || 'OTHERS:'

Line 709: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

705: FROM gme_batch_steps
706: WHERE batchstep_id = v_step_id;
707: BEGIN
708: IF (NVL (g_debug, 0) IN
709: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
710: )
711: THEN
712: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
713: || 'Entering'

Line 712: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

708: IF (NVL (g_debug, 0) IN
709: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
710: )
711: THEN
712: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
713: || 'Entering'
714: );
715: END IF;
716:

Line 761: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

757: x_step_status => l_step_status,
758: x_return_status => x_return_status
759: );
760:
761: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
762: THEN
763: gme_debug.put_line ( g_pkg_name
764: || '.'
765: || l_api_name

Line 763: gme_debug.put_line ( g_pkg_name

759: );
760:
761: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
762: THEN
763: gme_debug.put_line ( g_pkg_name
764: || '.'
765: || l_api_name
766: || ':'
767: || 'after the call to procedure validate_param '

Line 790: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

786: x_step_status => l_step_status,
787: x_return_status => x_return_status
788: );
789:
790: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
791: THEN
792: gme_debug.put_line ( g_pkg_name
793: || '.'
794: || l_api_name

Line 792: gme_debug.put_line ( g_pkg_name

788: );
789:
790: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
791: THEN
792: gme_debug.put_line ( g_pkg_name
793: || '.'
794: || l_api_name
795: || ':'
796: || 'after the call to procedure validate_activity_param '

Line 891: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

887: );
888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
892: THEN
893: gme_debug.put_line ( g_pkg_name
894: || '.'
895: || l_api_name

Line 893: gme_debug.put_line ( g_pkg_name

889: END IF;
890:
891: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
892: THEN
893: gme_debug.put_line ( g_pkg_name
894: || '.'
895: || l_api_name
896: || ':'
897: || 'before call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row batch_id='

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

908: THEN
909: RAISE fnd_api.g_exc_error;
910: END IF;
911:
912: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
913: THEN
914: gme_debug.put_line ( g_pkg_name
915: || '.'
916: || l_api_name

Line 914: gme_debug.put_line ( g_pkg_name

910: END IF;
911:
912: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
913: THEN
914: gme_debug.put_line ( g_pkg_name
915: || '.'
916: || l_api_name
917: || ':'
918: || 'after call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row activity_id='

Line 952: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

948:
949: x_batchstep_activity_rec := l_batchstep_activity_out_rec;
950:
951: IF (NVL (g_debug, 0) IN
952: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
953: )
954: THEN
955: gme_debug.put_line ( g_pkg_name
956: || '.'

Line 955: gme_debug.put_line ( g_pkg_name

951: IF (NVL (g_debug, 0) IN
952: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
953: )
954: THEN
955: gme_debug.put_line ( g_pkg_name
956: || '.'
957: || l_api_name
958: || ':'
959: || 'Exiting with '

Line 975: gme_debug.put_line ( g_pkg_name

971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972:
973: IF (NVL (g_debug, 0) > 0)
974: THEN
975: gme_debug.put_line ( g_pkg_name
976: || '.'
977: || l_api_name
978: || ':'
979: || 'UNEXPECTED:'

Line 991: gme_debug.put_line ( g_pkg_name

987: x_return_status := fnd_api.g_ret_sts_unexp_error;
988:
989: IF (NVL (g_debug, 0) > 0)
990: THEN
991: gme_debug.put_line ( g_pkg_name
992: || '.'
993: || l_api_name
994: || ':'
995: || 'OTHERS:'

Line 1096: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

1092:
1093: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;
1094: BEGIN
1095: IF (NVL (g_debug, 0) IN
1096: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1097: )
1098: THEN
1099: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1100: || 'Entering'

Line 1099: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1095: IF (NVL (g_debug, 0) IN
1096: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1097: )
1098: THEN
1099: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1100: || 'Entering'
1101: );
1102: END IF;
1103:

Line 1149: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

1145: x_step_status => l_step_status,
1146: x_return_status => x_return_status
1147: );
1148:
1149: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1150: THEN
1151: gme_debug.put_line ( g_pkg_name
1152: || '.'
1153: || l_api_name

Line 1151: gme_debug.put_line ( g_pkg_name

1147: );
1148:
1149: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1150: THEN
1151: gme_debug.put_line ( g_pkg_name
1152: || '.'
1153: || l_api_name
1154: || ':'
1155: || 'after the call to procedure validate_param '

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

1181: OPEN cur_lock_actv (l_activity_id);
1182: FETCH cur_lock_actv INTO l_last_update_date;
1183: CLOSE cur_lock_actv;
1184:
1185: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1186: THEN
1187: gme_debug.put_line (' Successfully locked the activity');
1188: END IF;
1189:

Line 1187: gme_debug.put_line (' Successfully locked the activity');

1183: CLOSE cur_lock_actv;
1184:
1185: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1186: THEN
1187: gme_debug.put_line (' Successfully locked the activity');
1188: END IF;
1189:
1190: IF NOT (gme_batch_step_activities_dbl.fetch_row (p_batchstep_activity_rec,
1191: l_batchstep_activity_rec

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

1558: x_step_activities => x_batchstep_activity_rec,
1559: x_return_status => x_return_status
1560: );
1561:
1562: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1563: THEN
1564: gme_debug.put_line ( 'gme_validate_flex_fld_pvt.validate_flex_step_activities '
1565: || x_return_status
1566: );

Line 1564: gme_debug.put_line ( 'gme_validate_flex_fld_pvt.validate_flex_step_activities '

1560: );
1561:
1562: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1563: THEN
1564: gme_debug.put_line ( 'gme_validate_flex_fld_pvt.validate_flex_step_activities '
1565: || x_return_status
1566: );
1567: END IF;
1568:

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

1645: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
1646: RAISE fnd_api.g_exc_error;
1647: END IF;
1648:
1649: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1650: THEN
1651: gme_debug.put_line ('before update of activity');
1652: END IF;
1653:

Line 1651: gme_debug.put_line ('before update of activity');

1647: END IF;
1648:
1649: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1650: THEN
1651: gme_debug.put_line ('before update of activity');
1652: END IF;
1653:
1654: IF l_update_resources
1655: THEN

Line 1668: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

1664: x_rsc_row_count => l_rsrc_trans_count,
1665: x_return_status => x_return_status
1666: );
1667:
1668: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1669: THEN
1670: gme_debug.put_line ( g_pkg_name
1671: || '.'
1672: || l_api_name

Line 1670: gme_debug.put_line ( g_pkg_name

1666: );
1667:
1668: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1669: THEN
1670: gme_debug.put_line ( g_pkg_name
1671: || '.'
1672: || l_api_name
1673: || ':'
1674: || 'after call to GME_TRANS_ENGINE_UTIL.load_rsrc_trans return status is '

Line 1694: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

1690: p_batchstep_activities_rec => l_batchstep_activity_rec,
1691: x_return_status => x_return_status
1692: );
1693:
1694: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1695: THEN
1696: gme_debug.put_line ( g_pkg_name
1697: || '.'
1698: || l_api_name

Line 1696: gme_debug.put_line ( g_pkg_name

1692: );
1693:
1694: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1695: THEN
1696: gme_debug.put_line ( g_pkg_name
1697: || '.'
1698: || l_api_name
1699: || ':'
1700: || 'after call to GME_UPDATE_STEP_QTY_PVT.update_resources return status is '

Line 1739: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

1735:
1736: x_batchstep_activity_rec := l_batchstep_activity_rec;
1737:
1738: IF (NVL (g_debug, 0) IN
1739: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1740: )
1741: THEN
1742: gme_debug.put_line ( g_pkg_name
1743: || '.'

Line 1742: gme_debug.put_line ( g_pkg_name

1738: IF (NVL (g_debug, 0) IN
1739: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1740: )
1741: THEN
1742: gme_debug.put_line ( g_pkg_name
1743: || '.'
1744: || l_api_name
1745: || ':'
1746: || 'Exiting with '

Line 1771: gme_debug.put_line ( g_pkg_name

1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768:
1769: IF (NVL (g_debug, 0) > 0)
1770: THEN
1771: gme_debug.put_line ( g_pkg_name
1772: || '.'
1773: || l_api_name
1774: || ':'
1775: || 'UNEXPECTED:'

Line 1786: gme_debug.put_line ( g_pkg_name

1782: x_return_status := fnd_api.g_ret_sts_unexp_error;
1783:
1784: IF (NVL (g_debug, 0) > 0)
1785: THEN
1786: gme_debug.put_line ( g_pkg_name
1787: || '.'
1788: || l_api_name
1789: || ':'
1790: || 'OTHERS:'

Line 1869: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

1865: WHERE batchstep_activity_id = v_activity_id
1866: FOR UPDATE OF last_update_date NOWAIT;
1867: BEGIN
1868: IF (NVL (g_debug, 0) IN
1869: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1870: )
1871: THEN
1872: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1873: || 'Entering'

Line 1872: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1868: IF (NVL (g_debug, 0) IN
1869: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1870: )
1871: THEN
1872: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1873: || 'Entering'
1874: );
1875: END IF;
1876:

Line 1902: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

1898: x_step_status => l_step_status,
1899: x_return_status => x_return_status
1900: );
1901:
1902: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1903: THEN
1904: gme_debug.put_line ( g_pkg_name
1905: || '.'
1906: || l_api_name

Line 1904: gme_debug.put_line ( g_pkg_name

1900: );
1901:
1902: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1903: THEN
1904: gme_debug.put_line ( g_pkg_name
1905: || '.'
1906: || l_api_name
1907: || ':'
1908: || 'after the call to procedure validate_param '

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

1955: OPEN cur_lock_actv (l_activity_id);
1956: FETCH cur_lock_actv INTO l_last_update_date;
1957: CLOSE cur_lock_actv;
1958:
1959: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1960: THEN
1961: gme_debug.put_line (' Successfully locked the activity');
1962: END IF;
1963:

Line 1961: gme_debug.put_line (' Successfully locked the activity');

1957: CLOSE cur_lock_actv;
1958:
1959: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1960: THEN
1961: gme_debug.put_line (' Successfully locked the activity');
1962: END IF;
1963:
1964: IF l_batch_status <> 1
1965: THEN

Line 1994: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)

1990: x_rsc_row_count => l_rsrc_trans_count,
1991: x_return_status => x_return_status
1992: );
1993:
1994: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1995: THEN
1996: gme_debug.put_line ( g_pkg_name
1997: || '.'
1998: || l_api_name

Line 1996: gme_debug.put_line ( g_pkg_name

1992: );
1993:
1994: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
1995: THEN
1996: gme_debug.put_line ( g_pkg_name
1997: || '.'
1998: || l_api_name
1999: || ':'
2000: || 'after call to GME_TRANS_ENGINE_UTIL.load_rsrc_trans return status is '

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

2014: gme_delete_batch_step_pvt.delete_activity (p_batch_step_activities_rec => l_batchstep_activity_rec,
2015: x_return_status => x_return_status
2016: );
2017:
2018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
2019: THEN
2020: gme_debug.put_line ( 'after call to gme_delete_batch_step_pvt.delete_activity return status is '
2021: || x_return_status
2022: );

Line 2020: gme_debug.put_line ( 'after call to gme_delete_batch_step_pvt.delete_activity return status is '

2016: );
2017:
2018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
2019: THEN
2020: gme_debug.put_line ( 'after call to gme_delete_batch_step_pvt.delete_activity return status is '
2021: || x_return_status
2022: );
2023: END IF;
2024:

Line 2034: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032:
2033: IF (NVL (g_debug, 0) IN
2034: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
2035: )
2036: THEN
2037: gme_debug.put_line ( g_pkg_name
2038: || '.'

Line 2037: gme_debug.put_line ( g_pkg_name

2033: IF (NVL (g_debug, 0) IN
2034: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
2035: )
2036: THEN
2037: gme_debug.put_line ( g_pkg_name
2038: || '.'
2039: || l_api_name
2040: || ':'
2041: || 'Exiting with '

Line 2066: gme_debug.put_line ( g_pkg_name

2062: x_return_status := fnd_api.g_ret_sts_unexp_error;
2063:
2064: IF (NVL (g_debug, 0) > 0)
2065: THEN
2066: gme_debug.put_line ( g_pkg_name
2067: || '.'
2068: || l_api_name
2069: || ':'
2070: || 'UNEXPECTED:'

Line 2081: gme_debug.put_line ( g_pkg_name

2077: x_return_status := fnd_api.g_ret_sts_unexp_error;
2078:
2079: IF (NVL (g_debug, 0) > 0)
2080: THEN
2081: gme_debug.put_line ( g_pkg_name
2082: || '.'
2083: || l_api_name
2084: || ':'
2085: || 'OTHERS:'