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.CSL_MTL_MAT_TRANS_ACC_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

2: /* $Header: cslmtacb.pls 120.0 2005/05/24 18:31:07 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_MAT_TRANS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_MAT_TRANS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_MATERIAL_TRANSACTIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level

Line 31: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

27: r_mtl_mat_transactions c_mtl_mat_transactions%ROWTYPE;
28:
29: BEGIN
30: /*** get debug level ***/
31: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
32:
33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
34: jtm_message_log_pkg.Log_Msg
35: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

29: BEGIN
30: /*** get debug level ***/
31: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
32:
33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
34: jtm_message_log_pkg.Log_Msg
35: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
36: , v_object_name => g_table_name
37: , v_message => 'Entering Insert_MTL_Mat_Transaction'

Line 38: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

34: jtm_message_log_pkg.Log_Msg
35: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
36: , v_object_name => g_table_name
37: , v_message => 'Entering Insert_MTL_Mat_Transaction'
38: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
39: END IF;
40:
41: /*** Retreive record assigned by Hook ***/
42: OPEN c_mtl_mat_transactions( p_subinventory_code, p_organization_id);

Line 46: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

42: OPEN c_mtl_mat_transactions( p_subinventory_code, p_organization_id);
43: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
44: IF c_mtl_mat_transactions%NOTFOUND THEN
45: /*** could not find assignment record -> exit ***/
46: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
47: jtm_message_log_pkg.Log_Msg
48: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
49: , v_object_name => g_table_name
50: , v_message => 'Insert_MTL_Mat_Transaction => no transactions for sub inventory :' ||

Line 53: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

49: , v_object_name => g_table_name
50: , v_message => 'Insert_MTL_Mat_Transaction => no transactions for sub inventory :' ||
51: p_subinventory_code ||', organization '||p_organization_id||
52: ' for resource id ' || p_resource_id|| ' found'
53: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
54: END IF;
55:
56: CLOSE c_mtl_mat_transactions;
57: -- RETURN FALSE;

Line 59: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

55:
56: CLOSE c_mtl_mat_transactions;
57: -- RETURN FALSE;
58: ELSE
59: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
60: jtm_message_log_pkg.Log_Msg
61: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
62: , v_object_name => g_table_name
63: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||

Line 65: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

61: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
62: , v_object_name => g_table_name
63: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||
64: ' for resource id ' || p_resource_id
65: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
66: END IF;
67:
68: /*** Loop over all available records and put them in the acc table ***/
69: WHILE c_mtl_mat_transactions%FOUND LOOP

Line 71: JTM_HOOK_UTIL_PKG.Insert_Acc

67:
68: /*** Loop over all available records and put them in the acc table ***/
69: WHILE c_mtl_mat_transactions%FOUND LOOP
70: /*** Call common package to insert record into ACC table ***/
71: JTM_HOOK_UTIL_PKG.Insert_Acc
72: ( p_publication_item_names => g_publication_item_name
73: ,p_acc_table_name => g_acc_table_name
74: ,p_resource_id => p_resource_id
75: ,p_pk1_name => g_pk1_name

Line 98: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

94: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
95: END LOOP;
96: END IF;
97:
98: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
99: jtm_message_log_pkg.Log_Msg
100: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
101: , v_object_name => g_table_name
102: , v_message => 'Leaving Insert_MTL_Mat_Transaction'

Line 103: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

99: jtm_message_log_pkg.Log_Msg
100: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
101: , v_object_name => g_table_name
102: , v_message => 'Leaving Insert_MTL_Mat_Transaction'
103: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
104: END IF;
105:
106: END Insert_MTL_Mat_Transaction;
107:

Line 131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

127:
128: BEGIN
129:
130: /*** get debug level ***/
131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
132:
133: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
134: jtm_message_log_pkg.Log_Msg
135: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 133: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

129:
130: /*** get debug level ***/
131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
132:
133: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
134: jtm_message_log_pkg.Log_Msg
135: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
136: , v_object_name => g_table_name
137: , v_message => 'Entering Update_CSP_Sec_Inventory'

Line 138: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

134: jtm_message_log_pkg.Log_Msg
135: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
136: , v_object_name => g_table_name
137: , v_message => 'Entering Update_CSP_Sec_Inventory'
138: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
139: END IF;
140:
141: /*** Retreive record assigned by Hook ***/
142: OPEN c_mtl_mat_transactions( p_subinventory_code, p_organization_id);

Line 146: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

142: OPEN c_mtl_mat_transactions( p_subinventory_code, p_organization_id);
143: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
144: IF c_mtl_mat_transactions%NOTFOUND THEN
145: /*** could not find assignment record -> exit ***/
146: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
147: jtm_message_log_pkg.Log_Msg
148: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
149: , v_object_name => g_table_name
150: , v_message => 'Update_MTL_Mat_Transaction could not find records for :' || p_subinventory_code || ','

Line 152: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

148: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
149: , v_object_name => g_table_name
150: , v_message => 'Update_MTL_Mat_Transaction could not find records for :' || p_subinventory_code || ','
151: || p_organization_id || ' for resource id ' || p_resource_id
152: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
153: END IF;
154:
155: CLOSE c_mtl_mat_transactions;
156: ELSE

Line 157: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

153: END IF;
154:
155: CLOSE c_mtl_mat_transactions;
156: ELSE
157: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
158: jtm_message_log_pkg.Log_Msg
159: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
160: , v_object_name => g_table_name
161: , v_message => 'Update ACC record :' || p_subinventory_code || ' , ' || p_organization_id

Line 163: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

159: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
160: , v_object_name => g_table_name
161: , v_message => 'Update ACC record :' || p_subinventory_code || ' , ' || p_organization_id
162: || ' for resource id ' || p_resource_id
163: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
164: END IF;
165:
166: /*** Loop over all available records and put them in the acc table ***/
167: WHILE c_mtl_mat_transactions%FOUND LOOP

Line 169: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id

165:
166: /*** Loop over all available records and put them in the acc table ***/
167: WHILE c_mtl_mat_transactions%FOUND LOOP
168: /*** Call common package to insert record into ACC table ***/
169: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
170: ( P_ACC_TABLE_NAME => g_acc_table_name
171: ,P_PK1_NAME => g_pk1_name
172: ,P_PK1_NUM_VALUE => r_mtl_mat_transactions.TRANSACTION_ID
173: ,P_RESOURCE_ID => p_resource_id);

Line 178: JTM_HOOK_UTIL_PKG.Insert_Acc

174:
175:
176: IF l_acc_id = -1 THEN
177: /*** Record is not yet in ACC tables. Insert has to be done ***/
178: JTM_HOOK_UTIL_PKG.Insert_Acc
179: ( p_publication_item_names => g_publication_item_name
180: ,p_acc_table_name => g_acc_table_name
181: ,p_resource_id => p_resource_id
182: ,p_pk1_name => g_pk1_name

Line 187: JTM_HOOK_UTIL_PKG.Update_Acc

183: ,p_pk1_num_value => r_mtl_mat_transactions.TRANSACTION_ID
184: );
185: ELSE
186: /*** Record is already in ACC. Only an update is required for re-sending ***/
187: JTM_HOOK_UTIL_PKG.Update_Acc
188: ( p_publication_item_names => g_publication_item_name
189: ,p_acc_table_name => g_acc_table_name
190: ,p_resource_id => p_resource_id
191: ,p_access_id => l_acc_id

Line 215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

211: /*** Succesfull looped through recordset ***/
212:
213: END IF;
214:
215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
216: jtm_message_log_pkg.Log_Msg
217: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
218: , v_object_name => g_table_name
219: , v_message => 'Leaving Update_MTL_Mat_Transaction'

Line 220: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

216: jtm_message_log_pkg.Log_Msg
217: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
218: , v_object_name => g_table_name
219: , v_message => 'Leaving Update_MTL_Mat_Transaction'
220: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
221: END IF;
222:
223:
224:

Line 248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

244:
245: BEGIN
246:
247: /*** get debug level ***/
248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
249:
250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
251: jtm_message_log_pkg.Log_Msg
252: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id

Line 250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

246:
247: /*** get debug level ***/
248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
249:
250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
251: jtm_message_log_pkg.Log_Msg
252: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
253: , v_object_name => g_table_name
254: , v_message => 'Entering Delete_MTL_Mat_Transaction'

Line 255: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

251: jtm_message_log_pkg.Log_Msg
252: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
253: , v_object_name => g_table_name
254: , v_message => 'Entering Delete_MTL_Mat_Transaction'
255: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
256: END IF;
257:
258: /*** Retreive record assigned by Hook ***/
259: OPEN c_mtl_mat_transactions( p_subinventory_code, p_organization_id);

Line 263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

259: OPEN c_mtl_mat_transactions( p_subinventory_code, p_organization_id);
260: FETCH c_mtl_mat_transactions INTO r_mtl_mat_transactions;
261: IF c_mtl_mat_transactions%NOTFOUND THEN
262: /*** could not find assignment record -> exit ***/
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
264: jtm_message_log_pkg.Log_Msg
265: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
266: , v_object_name => g_table_name
267: , v_message => 'Delete_MTL_Mat_Transaction could not find records for :' || p_subinventory_code ||

Line 269: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

265: ( v_object_id => p_subinventory_code || ' , ' || p_organization_id
266: , v_object_name => g_table_name
267: , v_message => 'Delete_MTL_Mat_Transaction could not find records for :' || p_subinventory_code ||
268: ' , ' || p_organization_id || ' for resource id ' || p_resource_id
269: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
270: END IF;
271:
272: CLOSE c_mtl_mat_transactions;
273: -- RETURN FALSE;

Line 275: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

271:
272: CLOSE c_mtl_mat_transactions;
273: -- RETURN FALSE;
274: ELSE
275: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
276: jtm_message_log_pkg.Log_Msg
277: ( v_object_id => p_organization_id
278: , v_object_name => g_table_name
279: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||

Line 281: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

277: ( v_object_id => p_organization_id
278: , v_object_name => g_table_name
279: , v_message => 'Inserting ACC record :' || p_subinventory_code || ' , ' || p_organization_id ||
280: ' for resource id ' || p_resource_id
281: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
282: END IF;
283:
284: /*** Loop over all available records and put them in the acc table ***/
285: WHILE c_mtl_mat_transactions%FOUND LOOP

Line 287: JTM_HOOK_UTIL_PKG.Delete_Acc

283:
284: /*** Loop over all available records and put them in the acc table ***/
285: WHILE c_mtl_mat_transactions%FOUND LOOP
286: /*** Call common package to insert record into ACC table ***/
287: JTM_HOOK_UTIL_PKG.Delete_Acc
288: ( p_publication_item_names => g_publication_item_name
289: ,p_acc_table_name => g_acc_table_name
290: ,p_resource_id => p_resource_id
291: ,p_pk1_name => g_pk1_name

Line 323: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

319: , x_return_status OUT NOCOPY VARCHAR2 )
320: IS
321: BEGIN
322: /*** get debug level ***/
323: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_resource_id
327: , g_table_name

Line 324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

320: IS
321: BEGIN
322: /*** get debug level ***/
323: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_resource_id
327: , g_table_name
328: , 'Entering DELETE_ALL_ACC_RECORDS'

Line 329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

325: jtm_message_log_pkg.Log_Msg
326: ( p_resource_id
327: , g_table_name
328: , 'Entering DELETE_ALL_ACC_RECORDS'
329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
330: );
331: END IF;
332:
333: DELETE JTM_MTL_MAT_TRANS_ACC

Line 338: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

334: WHERE RESOURCE_ID = p_resource_id;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
339: jtm_message_log_pkg.Log_Msg
340: ( p_resource_id
341: , g_table_name
342: , 'Leaving DELETE_ALL_ACC_RECORDS'

Line 343: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

339: jtm_message_log_pkg.Log_Msg
340: ( p_resource_id
341: , g_table_name
342: , 'Leaving DELETE_ALL_ACC_RECORDS'
343: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
344: );
345: END IF;
346: EXCEPTION WHEN OTHERS THEN
347: /*** hook failed -> log error ***/

Line 350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

346: EXCEPTION WHEN OTHERS THEN
347: /*** hook failed -> log error ***/
348: -- x_return_status := FND_API.G_RET_STS_ERROR;
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => 1
353: , v_object_name => g_table_name
354: , v_message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm

Line 355: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => 1
353: , v_object_name => g_table_name
354: , v_message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
355: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
356: END IF;
357: fnd_msg_pub.Add_Exc_Msg('CSL_MTL_MAT_TRANS_ACC_PKG','PROCESS_ACC',sqlerrm);
358: END DELETE_ALL_ACC_RECORDS;
359: