138: || SQLERRM);
139: END IF;
140:
141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
143: END fetch_all_resources;
144:
145: /*===========================================================================================
146: Procedure
205: || SQLERRM);
206: END IF;
207:
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
210: END create_resource_trans;
211:
212: /*===========================================================================================
213: Procedure
268: || SQLERRM);
269: END IF;
270:
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
273: END delete_resource_trans;
274:
275: /*===========================================================================================
276: Procedure
334: || SQLERRM);
335: END IF;
336:
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
339: END update_resource_trans;
340:
341: /*===========================================================================================
342: Procedure
733: || SQLERRM);
734: END IF;
735:
736: x_return_status := fnd_api.g_ret_sts_unexp_error;
737: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
738: END consolidate_batch_resources;
739:
740: /*===========================================================================================
741: Procedure
841: || ' Error is '
842: || SQLERRM);
843: END IF;
844:
845: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
846: --End Bug2804440
847: END build_resource_tran;
848:
849: /*===========================================================================================
974: || SQLERRM);
975: END IF;
976:
977: x_return_status := fnd_api.g_ret_sts_unexp_error;
978: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
979: END fetch_active_resources;
980:
981: /*===========================================================================================
982: Procedure
1372: || SQLERRM);
1373: END IF;
1374:
1375: x_return_status := fnd_api.g_ret_sts_unexp_error;
1376: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1377: ,'resource_dtl_process');
1378: END resource_dtl_process;
1379:
1380: /*===========================================================================================
1542: || SQLERRM);
1543: END IF;
1544:
1545: x_return_status := fnd_api.g_ret_sts_unexp_error;
1546: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1547: ,'VALIDATE_RESOURCE');
1548: END validate_resource;
1549:
1550: /*===========================================================================================
1653: fnd_message.set_name ('GME', 'GME_ONE_PRIM_RSRC');
1654: --Rishi 3446787/3020345
1655: fnd_message.set_token ('ACTIVITY', l_activity);
1656: fnd_message.set_token ('STEPNO', l_batchstep_no);
1657: fnd_msg_pub.ADD;
1658: RAISE fnd_api.g_exc_error;
1659: ELSIF (l_count = 0) AND NVL (p_step_resources_rec.prim_rsrc_ind, 0) = 0 THEN
1660: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1661: fnd_message.set_token ('ACTIVITY', l_activity);
1660: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1661: fnd_message.set_token ('ACTIVITY', l_activity);
1662: fnd_message.set_token ('STEPNO', l_batchstep_no);
1663: --Rishi 3446787/3020345 end
1664: fnd_msg_pub.ADD;
1665: RAISE fnd_api.g_exc_error;
1666: END IF;
1667:
1668: IF g_debug <= gme_debug.g_log_procedure THEN
1681: || SQLERRM);
1682: END IF;
1683:
1684: x_return_status := fnd_api.g_ret_sts_unexp_error;
1685: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1686: ,'CHECK_PRIMARY_RESOURCE');
1687: END check_primary_resource;
1688:
1689: /*===========================================================================================
1754: IF (l_count > 1) THEN
1755: fnd_message.set_name ('GME', 'GME_ONE_PRIM_RSRC');
1756: fnd_message.set_token ('ACTIVITY', activities.activity);
1757: fnd_message.set_token ('STEPNO', batchsteps.batchstep_no);
1758: fnd_msg_pub.ADD;
1759: RAISE fnd_api.g_exc_error;
1760: ELSIF (l_count = 0) THEN
1761: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1762: fnd_message.set_token ('ACTIVITY', activities.activity);
1760: ELSIF (l_count = 0) THEN
1761: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1762: fnd_message.set_token ('ACTIVITY', activities.activity);
1763: fnd_message.set_token ('STEPNO', batchsteps.batchstep_no);
1764: fnd_msg_pub.ADD;
1765: RAISE fnd_api.g_exc_error;
1766: END IF;
1767: END LOOP;
1768: END LOOP;
1770: WHEN fnd_api.g_exc_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;
1774: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1775: ,'CHECK_PRIMARY_RESOURCE');
1776: END check_primary_resource;
1777:
1778: /*===========================================================================================
1875: || SQLERRM);
1876: END IF;
1877:
1878: x_return_status := fnd_api.g_ret_sts_unexp_error;
1879: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1880: ,'GET_RESOURCE_USAGE');
1881: END get_resource_usage;
1882:
1883: /*===========================================================================================
2450: WHEN stepactivity_not_found OR resource_not_found OR rtxn_for_updinv_not_allowed THEN
2451: x_return_status := fnd_api.g_ret_sts_error;
2452: WHEN invalid_reason_code THEN
2453: fnd_message.set_name ('GMA', 'SY_REASONCODE');
2454: fnd_msg_pub.ADD;
2455: x_return_status := fnd_api.g_ret_sts_error;
2456: WHEN OTHERS THEN
2457: IF g_debug <= gme_debug.g_log_unexpected THEN
2458: gme_debug.put_line ( 'When others exception in '
2463: || SQLERRM);
2464: END IF;
2465:
2466: x_return_status := fnd_api.g_ret_sts_unexp_error;
2467: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2468: END validate_rsrc_txn_param;
2469:
2470: /*===========================================================================================
2471: Procedure
2758: || SQLERRM);
2759: END IF;
2760:
2761: x_return_status := fnd_api.g_ret_sts_unexp_error;
2762: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2763: END update_actual_resource_usage;
2764:
2765: /*===========================================================================================
2766: Procedure
3008: || SQLERRM);
3009: END IF;
3010:
3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3013: END insert_incr_actual_rsrc_txn;
3014:
3015: /*==== =======================================================================================
3016: Procedure
3307: || SQLERRM);
3308: END IF;
3309:
3310: x_return_status := fnd_api.g_ret_sts_unexp_error;
3311: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3312: END insert_timed_actual_rsrc_txn;
3313:
3314: /*==== =======================================================================================
3315: Procedure
3507: || SQLERRM);
3508: END IF;
3509:
3510: x_return_status := fnd_api.g_ret_sts_unexp_error;
3511: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3512: END start_cmplt_actual_rsrc_txn;
3513:
3514: /*==== =======================================================================================
3515: Procedure
3911: || SQLERRM);
3912: END IF;
3913:
3914: x_return_status := fnd_api.g_ret_sts_unexp_error;
3915: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3916: END end_cmplt_actual_rsrc_txn;
3917: END gme_resource_engine_pvt;