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'
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:
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: || '.'
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 '
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:'
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:'
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'
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:
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: || '.'
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 '
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:'
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:'
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'
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:
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
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 '
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
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 '
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
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='
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
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='
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: || '.'
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 '
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:'
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:'
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'
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:
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
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 '
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:
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
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: );
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:
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:
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
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
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 '
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
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 '
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: || '.'
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 '
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:'
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:'
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'
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:
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
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 '
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:
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
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
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 '
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: );
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:
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: || '.'
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 '
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:'
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:'