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.

[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on FND_PROFILE

Line 7: g_debug Number := Nvl(Fnd_Profile.Value('INV_DEBUG_TRACE'),0);

3:
4: g_dummy_sn_tbl inv_reservation_global.serial_number_tbl_type;
5:
6: -- CodeReview.SU.03 Define a global variable for l_Debug
7: g_debug Number := Nvl(Fnd_Profile.Value('INV_DEBUG_TRACE'),0);
8:
9:
10: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MAINTAIN_RESERVATION_PUB';
11: g_version_printed BOOLEAN := FALSE;

Line 104: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

100: l_debug NUMBER;
101: c_api_name CONSTANT VARCHAR2(30) := 'Check_Reqd_Param';
102: BEGIN
103: IF (g_debug IS NULL) THEN
104: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
105: END IF;
106:
107: l_debug := g_debug;
108:

Line 135: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

131: l_debug NUMBER;
132: c_api_name CONSTANT VARCHAR2(30) := 'Check_Reqd_Param';
133: BEGIN
134: IF (g_debug IS NULL) THEN
135: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
136: END IF;
137:
138: l_debug := g_debug;
139:

Line 169: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

165: l_debug NUMBER;
166: c_api_name CONSTANT VARCHAR2(30) := 'CHECK_REQD_PARAM';
167: BEGIN
168: IF (g_debug IS NULL) THEN
169: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
170: END IF;
171:
172: l_debug := g_debug;
173:

Line 234: -- l_debug number := nvl(fnd_profile.value('inv_debug_trace'), 0);

230: c_action_supply constant number := 0;
231: c_action_demand constant number := 1;
232: c_cancel_order_no constant number := inv_reservation_global.g_cancel_order_no ;
233:
234: -- l_debug number := nvl(fnd_profile.value('inv_debug_trace'), 0);
235: l_fnd_log_message varchar2(2000);
236: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
237: l_query_input inv_reservation_global.mtl_reservation_rec_type;
238: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type ;

Line 1433: --l_debug number := nvl(fnd_profile.value('inv_debug_trace'), 0);

1429: c_api_name constant varchar2(30) := 'create_res';
1430: c_module_name constant varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1431: c_debug_enabled constant number := 1 ;
1432:
1433: --l_debug number := nvl(fnd_profile.value('inv_debug_trace'), 0);
1434: l_fnd_log_message varchar2(2000);
1435: l_msg_index_out number;
1436:
1437: l_rsv inv_reservation_global.mtl_reservation_rec_type;

Line 1708: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1704: C_api_name CONSTANT VARCHAR2(30) := 'QUERY_RES';
1705: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1706: C_Debug_Enabled Constant Number := 1 ;
1707:
1708: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1709: l_Fnd_Log_Message VARCHAR2(2000);
1710: l_Msg_Index_Out Number;
1711:
1712: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1974: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1970: C_api_name CONSTANT VARCHAR2(30) := 'EXISTS_RESERVATION';
1971: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
1972: C_Debug_Enabled Constant Number := 1 ;
1973:
1974: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1975: l_Fnd_Log_Message VARCHAR2(2000);
1976: l_Msg_Index_Out Number;
1977:
1978: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

Line 2082: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2078: C_api_name CONSTANT VARCHAR2(30) := 'GET_REQ_LINE_RES';
2079: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2080: C_Debug_Enabled Constant Number := 1 ;
2081:
2082: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2083: l_Fnd_Log_Message VARCHAR2(2000);
2084: l_Msg_Index_Out Number;
2085:
2086: l_msg_count NUMBER;

Line 2194: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2190: C_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RES';
2191: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2192: C_Debug_Enabled Constant Number := 1 ;
2193:
2194: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2195: l_Fnd_Log_Message VARCHAR2(2000);
2196: l_Msg_Index_Out Number;
2197:
2198: l_rsv inv_reservation_global.mtl_reservation_rec_type;

Line 2449: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2445: C_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_RES';
2446: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2447: C_Debug_Enabled Constant Number := 1 ;
2448:
2449: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2450: l_Fnd_Log_Message VARCHAR2(2000);
2451: l_Msg_Index_Out Number;
2452:
2453: l_rsv inv_reservation_global.mtl_reservation_rec_type;

Line 2756: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2752: C_api_name CONSTANT VARCHAR2(30) := 'DELETE_RES';
2753: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2754: C_Debug_Enabled Constant Number := 1 ;
2755:
2756: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2757: l_Fnd_Log_Message VARCHAR2(2000);
2758: l_Msg_Index_Out Number;
2759:
2760: l_rsv inv_reservation_global.mtl_reservation_rec_type;

Line 2995: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2991: C_api_name CONSTANT VARCHAR2(30) := 'UOM_CONVERSION';
2992: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation_pub.maintain_reservation';
2993: C_Debug_Enabled Constant Number := 1 ;
2994:
2995: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2996: l_fnd_log_message VARCHAR2(2000);
2997: l_Msg_Index_Out Number;
2998:
2999: l_item_id NUMBER ;

Line 3575: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3571: C_api_name CONSTANT VARCHAR2(30) := 'Maintain_Reservation';
3572: C_Module_Name Constant Varchar2(2000) := 'inv.plsql.inv_maintain_reservation.Maintain_Reservation';
3573: C_Debug_Enabled Constant Number := 1 ;
3574:
3575: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3576: l_Fnd_Log_Message VARCHAR2(2000);
3577:
3578: l_return_status VARCHAR2(1);
3579: l_reservation_quantity NUMBER;