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_JTF_NOTES_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: cslntacb.pls 120.0 2005/05/24 17:15:41 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_NOTES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_NOTES_VL');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
9: g_pk_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
10:

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_NOTES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_NOTES_VL');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
9: g_pk_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
10:
11: g_debug_level NUMBER; -- debug level

Line 27: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

23: r_jtf_note c_jtf_note%ROWTYPE;
24:
25: BEGIN
26: /*** get debug level ***/
27: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
28:
29: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
30: jtm_message_log_pkg.Log_Msg
31: ( p_jtf_note_id

Line 29: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

25: BEGIN
26: /*** get debug level ***/
27: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
28:
29: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
30: jtm_message_log_pkg.Log_Msg
31: ( p_jtf_note_id
32: , g_table_name
33: , 'Entering Replicate_Record'

Line 34: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

30: jtm_message_log_pkg.Log_Msg
31: ( p_jtf_note_id
32: , g_table_name
33: , 'Entering Replicate_Record'
34: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
35: END IF;
36:
37: OPEN c_jtf_note( p_jtf_note_id );
38: FETCH c_jtf_note INTO r_jtf_note;

Line 41: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

37: OPEN c_jtf_note( p_jtf_note_id );
38: FETCH c_jtf_note INTO r_jtf_note;
39: IF c_jtf_note%NOTFOUND THEN
40: /*** could not find jtf_note record -> exit ***/
41: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
42: jtm_message_log_pkg.Log_Msg
43: ( p_jtf_note_id
44: , g_table_name
45: , 'Replicate_Record error: Could not find jtf_note_id ' || p_jtf_note_id

Line 46: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

42: jtm_message_log_pkg.Log_Msg
43: ( p_jtf_note_id
44: , g_table_name
45: , 'Replicate_Record error: Could not find jtf_note_id ' || p_jtf_note_id
46: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
47: END IF;
48:
49: CLOSE c_jtf_note;
50: RETURN FALSE;

Line 54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

50: RETURN FALSE;
51: END IF;
52: CLOSE c_jtf_note;
53:
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
55: jtm_message_log_pkg.Log_Msg
56: ( p_jtf_note_id
57: , g_table_name
58: , 'Replicate_Record returned TRUE'

Line 59: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

55: jtm_message_log_pkg.Log_Msg
56: ( p_jtf_note_id
57: , g_table_name
58: , 'Replicate_Record returned TRUE'
59: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
60: END IF;
61:
62: /** Record matched criteria -> return true ***/
63: RETURN TRUE;

Line 79: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

75: r_jtf_note c_jtf_note%ROWTYPE;
76:
77: BEGIN
78: /*** get debug level ***/
79: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
80:
81: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
82: jtm_message_log_pkg.Log_Msg
83: ( p_jtf_note_id

Line 81: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

77: BEGIN
78: /*** get debug level ***/
79: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
80:
81: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
82: jtm_message_log_pkg.Log_Msg
83: ( p_jtf_note_id
84: , g_table_name
85: , 'Entering Get_User_Id'

Line 86: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

82: jtm_message_log_pkg.Log_Msg
83: ( p_jtf_note_id
84: , g_table_name
85: , 'Entering Get_User_Id'
86: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
87: END IF;
88:
89: OPEN c_jtf_note( p_jtf_note_id );
90: FETCH c_jtf_note INTO r_jtf_note;

Line 93: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

89: OPEN c_jtf_note( p_jtf_note_id );
90: FETCH c_jtf_note INTO r_jtf_note;
91: IF c_jtf_note%NOTFOUND THEN
92: /*** could not find jtf_note record -> exit ***/
93: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
94: jtm_message_log_pkg.Log_Msg
95: ( p_jtf_note_id
96: , g_table_name
97: , 'Get_User_Id error: Could not find jtf_note_id ' || p_jtf_note_id

Line 98: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

94: jtm_message_log_pkg.Log_Msg
95: ( p_jtf_note_id
96: , g_table_name
97: , 'Get_User_Id error: Could not find jtf_note_id ' || p_jtf_note_id
98: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
99: END IF;
100:
101: CLOSE c_jtf_note;
102: RETURN -1;

Line 106: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

102: RETURN -1;
103: END IF;
104: CLOSE c_jtf_note;
105:
106: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
107: jtm_message_log_pkg.Log_Msg
108: ( p_jtf_note_id
109: , g_table_name
110: , 'Get_User_Id returned TRUE'

Line 111: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

107: jtm_message_log_pkg.Log_Msg
108: ( p_jtf_note_id
109: , g_table_name
110: , 'Get_User_Id returned TRUE'
111: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
112: END IF;
113:
114: /** return the entered by id ***/
115: return r_jtf_note.entered_by;

Line 131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

127: r_jtf_rs_resource_extns c_jtf_rs_resource_extns%ROWTYPE;
128:
129: BEGIN
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: ( p_user_id

Line 133: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

129: BEGIN
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: ( p_user_id
136: , g_table_name
137: , 'Entering Get_Resource_Extn_Id'

Line 138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

134: jtm_message_log_pkg.Log_Msg
135: ( p_user_id
136: , g_table_name
137: , 'Entering Get_Resource_Extn_Id'
138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
139: END IF;
140:
141: OPEN c_jtf_rs_resource_extns( p_user_id );
142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;

Line 145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

141: OPEN c_jtf_rs_resource_extns( p_user_id );
142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;
143: IF c_jtf_rs_resource_extns%NOTFOUND THEN
144: /*** could not find jtf_rs_resource_extns record -> exit ***/
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
146: jtm_message_log_pkg.Log_Msg
147: ( p_user_id
148: , g_table_name
149: , 'Get_Resource_Extn_Id error: Could not find p_user_id ' || p_user_id

Line 150: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

146: jtm_message_log_pkg.Log_Msg
147: ( p_user_id
148: , g_table_name
149: , 'Get_Resource_Extn_Id error: Could not find p_user_id ' || p_user_id
150: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
151: END IF;
152:
153: CLOSE c_jtf_rs_resource_extns;
154: RETURN -1;

Line 158: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

154: RETURN -1;
155: END IF;
156: CLOSE c_jtf_rs_resource_extns;
157:
158: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
159: jtm_message_log_pkg.Log_Msg
160: ( p_user_id
161: , g_table_name
162: , 'Get_Resource_Extn_Id returned TRUE'

Line 163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

159: jtm_message_log_pkg.Log_Msg
160: ( p_user_id
161: , g_table_name
162: , 'Get_Resource_Extn_Id returned TRUE'
163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
164: END IF;
165:
166: /** return the entered by id ***/
167: return r_jtf_rs_resource_extns.resource_id;

Line 177: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

173: ,p_resource_id IN NUMBER
174: )
175: IS
176: BEGIN
177: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
178: jtm_message_log_pkg.Log_Msg
179: ( p_jtf_note_id
180: , g_table_name
181: , 'Entering Insert_ACC_Record'

Line 182: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

178: jtm_message_log_pkg.Log_Msg
179: ( p_jtf_note_id
180: , g_table_name
181: , 'Entering Insert_ACC_Record'
182: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
183: END IF;
184:
185: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
186: jtm_message_log_pkg.Log_Msg

Line 185: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

181: , 'Entering Insert_ACC_Record'
182: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
183: END IF;
184:
185: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
186: jtm_message_log_pkg.Log_Msg
187: ( p_jtf_note_id
188: , g_table_name
189: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

186: jtm_message_log_pkg.Log_Msg
187: ( p_jtf_note_id
188: , g_table_name
189: , 'Inserting ACC record for resource_id = ' || p_resource_id
190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
191: END IF;
192:
193: /*** Insert jtf_note ACC record ***/
194: JTM_HOOK_UTIL_PKG.Insert_Acc

Line 194: JTM_HOOK_UTIL_PKG.Insert_Acc

190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
191: END IF;
192:
193: /*** Insert jtf_note ACC record ***/
194: JTM_HOOK_UTIL_PKG.Insert_Acc
195: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
196: ,P_ACC_TABLE_NAME => g_acc_table_name
197: ,P_PK1_NAME => g_pk_name
198: ,P_PK1_NUM_VALUE => p_jtf_note_id

Line 202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

198: ,P_PK1_NUM_VALUE => p_jtf_note_id
199: ,P_RESOURCE_ID => p_resource_id
200: );
201:
202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
203: jtm_message_log_pkg.Log_Msg
204: ( p_jtf_note_id
205: , g_table_name
206: , 'Leaving Insert_ACC_Record'

Line 207: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

203: jtm_message_log_pkg.Log_Msg
204: ( p_jtf_note_id
205: , g_table_name
206: , 'Leaving Insert_ACC_Record'
207: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
208: END IF;
209: END Insert_ACC_Record;
210:
211: /*** Private procedure that re-sends given jtf_note to mobile ***/

Line 219: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

215: ,p_acc_id IN NUMBER
216: )
217: IS
218: BEGIN
219: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
220: jtm_message_log_pkg.Log_Msg
221: ( p_jtf_note_id
222: , g_table_name
223: , 'Entering Update_ACC_Record'

Line 224: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

220: jtm_message_log_pkg.Log_Msg
221: ( p_jtf_note_id
222: , g_table_name
223: , 'Entering Update_ACC_Record'
224: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
225: END IF;
226:
227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
228: jtm_message_log_pkg.Log_Msg

Line 227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

223: , 'Entering Update_ACC_Record'
224: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
225: END IF;
226:
227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
228: jtm_message_log_pkg.Log_Msg
229: ( p_jtf_note_id
230: , g_table_name
231: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id

Line 232: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

228: jtm_message_log_pkg.Log_Msg
229: ( p_jtf_note_id
230: , g_table_name
231: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
232: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
233: END IF;
234:
235: /*** Update jtf_note ACC record ***/
236: JTM_HOOK_UTIL_PKG.Update_Acc

Line 236: JTM_HOOK_UTIL_PKG.Update_Acc

232: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
233: END IF;
234:
235: /*** Update jtf_note ACC record ***/
236: JTM_HOOK_UTIL_PKG.Update_Acc
237: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
238: ,P_ACC_TABLE_NAME => g_acc_table_name
239: ,P_RESOURCE_ID => p_resource_id
240: ,P_ACCESS_ID => p_acc_id

Line 243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

239: ,P_RESOURCE_ID => p_resource_id
240: ,P_ACCESS_ID => p_acc_id
241: );
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( p_jtf_note_id
246: , g_table_name
247: , 'Leaving Update_ACC_Record'

Line 248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

244: jtm_message_log_pkg.Log_Msg
245: ( p_jtf_note_id
246: , g_table_name
247: , 'Leaving Update_ACC_Record'
248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250: END Update_ACC_Record;
251:
252: /*** Private procedure that deletes jtf_note for resource from acc table ***/

Line 259: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

255: ,p_resource_id IN NUMBER
256: )
257: IS
258: BEGIN
259: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
260: jtm_message_log_pkg.Log_Msg
261: ( p_jtf_note_id
262: , g_table_name
263: , 'Entering Delete_ACC_Record'

Line 264: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

260: jtm_message_log_pkg.Log_Msg
261: ( p_jtf_note_id
262: , g_table_name
263: , 'Entering Delete_ACC_Record'
264: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
265: END IF;
266:
267: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
268: jtm_message_log_pkg.Log_Msg

Line 267: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

263: , 'Entering Delete_ACC_Record'
264: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
265: END IF;
266:
267: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
268: jtm_message_log_pkg.Log_Msg
269: ( p_jtf_note_id
270: , g_table_name
271: , 'Deleting ACC record for resource_id = ' || p_resource_id

Line 272: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

268: jtm_message_log_pkg.Log_Msg
269: ( p_jtf_note_id
270: , g_table_name
271: , 'Deleting ACC record for resource_id = ' || p_resource_id
272: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
273: END IF;
274:
275: /*** Delete jtf_note ACC record ***/
276: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 276: JTM_HOOK_UTIL_PKG.Delete_Acc

272: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
273: END IF;
274:
275: /*** Delete jtf_note ACC record ***/
276: JTM_HOOK_UTIL_PKG.Delete_Acc
277: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
278: ,P_ACC_TABLE_NAME => g_acc_table_name
279: ,P_PK1_NAME => g_pk_name
280: ,P_PK1_NUM_VALUE => p_jtf_note_id

Line 284: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

280: ,P_PK1_NUM_VALUE => p_jtf_note_id
281: ,P_RESOURCE_ID => p_resource_id
282: );
283:
284: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
285: jtm_message_log_pkg.Log_Msg
286: ( p_jtf_note_id
287: , g_table_name
288: , 'Leaving Delete_ACC_Record'

Line 289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

285: jtm_message_log_pkg.Log_Msg
286: ( p_jtf_note_id
287: , g_table_name
288: , 'Leaving Delete_ACC_Record'
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
290: END IF;
291: END Delete_ACC_Record;
292:
293: /***

Line 309: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

305: l_resource_extn_id NUMBER;
306: l_success BOOLEAN;
307: BEGIN
308: /*** get debug level ***/
309: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
310:
311: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
312: jtm_message_log_pkg.Log_Msg
313: ( p_jtf_note_id

Line 311: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

307: BEGIN
308: /*** get debug level ***/
309: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
310:
311: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
312: jtm_message_log_pkg.Log_Msg
313: ( p_jtf_note_id
314: , g_table_name
315: , 'Entering Pre_Insert_Child procedure'

Line 316: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

312: jtm_message_log_pkg.Log_Msg
313: ( p_jtf_note_id
314: , g_table_name
315: , 'Entering Pre_Insert_Child procedure'
316: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
317: END IF;
318:
319:
320: /*** no -> does record match criteria? ***/

Line 352: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

348:
349: l_success := TRUE;
350: END IF;
351:
352: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
353: jtm_message_log_pkg.Log_Msg
354: ( p_jtf_note_id
355: , g_table_name
356: , 'Leaving Pre_Insert_Child procedure'

Line 357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

353: jtm_message_log_pkg.Log_Msg
354: ( p_jtf_note_id
355: , g_table_name
356: , 'Leaving Pre_Insert_Child procedure'
357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
358: END IF;
359:
360: RETURN l_success;
361: END Pre_Insert_Child;

Line 385: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

381:
382: l_dummy BOOLEAN;
383: BEGIN
384: /*** get debug level ***/
385: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
386:
387: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
388: jtm_message_log_pkg.Log_Msg
389: ( p_source_obj_id

Line 387: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

383: BEGIN
384: /*** get debug level ***/
385: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
386:
387: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
388: jtm_message_log_pkg.Log_Msg
389: ( p_source_obj_id
390: , g_table_name
391: , 'Entering Pre_Insert_Children procedure'

Line 392: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

388: jtm_message_log_pkg.Log_Msg
389: ( p_source_obj_id
390: , g_table_name
391: , 'Entering Pre_Insert_Children procedure'
392: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
393: END IF;
394:
395: FOR r_jtf_note IN c_jtf_note( p_source_obj_id, p_source_obj_code ) LOOP
396:

Line 404: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

400: ,p_resource_id
401: );
402:
403: IF l_dummy = FALSE THEN
404: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
405: jtm_message_log_pkg.Log_Msg
406: ( p_source_obj_id
407: , g_table_name
408: , 'Pre_Insert_Children: note was not insertable.'

Line 409: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

405: jtm_message_log_pkg.Log_Msg
406: ( p_source_obj_id
407: , g_table_name
408: , 'Pre_Insert_Children: note was not insertable.'
409: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
410: END IF;
411: END IF;
412: END LOOP;
413:

Line 414: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

410: END IF;
411: END IF;
412: END LOOP;
413:
414: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
415: jtm_message_log_pkg.Log_Msg
416: ( p_source_obj_id
417: , g_table_name
418: , 'Leaving Pre_Insert_Children procedure'

Line 419: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

415: jtm_message_log_pkg.Log_Msg
416: ( p_source_obj_id
417: , g_table_name
418: , 'Leaving Pre_Insert_Children procedure'
419: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
420: END IF;
421:
422: RETURN TRUE;
423: END Pre_Insert_Children;

Line 439: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

435: l_resource_extn_id NUMBER;
436: l_success BOOLEAN;
437: BEGIN
438: /*** get debug level ***/
439: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
440:
441: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
442: jtm_message_log_pkg.Log_Msg
443: ( p_jtf_note_id

Line 441: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

437: BEGIN
438: /*** get debug level ***/
439: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
440:
441: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
442: jtm_message_log_pkg.Log_Msg
443: ( p_jtf_note_id
444: , g_table_name
445: , 'Entering Post_Delete_Child'

Line 446: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

442: jtm_message_log_pkg.Log_Msg
443: ( p_jtf_note_id
444: , g_table_name
445: , 'Entering Post_Delete_Child'
446: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
447: END IF;
448:
449: /*** no -> delete jtf_note record from ACC ***/
450: Delete_ACC_Record

Line 475: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

471: ,p_resource_id
472: );
473: END IF;
474:
475: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
476: jtm_message_log_pkg.Log_Msg
477: ( p_jtf_note_id
478: , g_table_name
479: , 'Leaving Post_Delete_Child'

Line 480: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

476: jtm_message_log_pkg.Log_Msg
477: ( p_jtf_note_id
478: , g_table_name
479: , 'Leaving Post_Delete_Child'
480: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
481: END IF;
482: END Post_Delete_Child;
483:
484: /***

Line 503: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

499: r_jtf_note c_jtf_note%ROWTYPE;
500:
501: BEGIN
502: /*** get debug level ***/
503: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
504:
505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
506: jtm_message_log_pkg.Log_Msg
507: ( p_source_obj_id

Line 505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

501: BEGIN
502: /*** get debug level ***/
503: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
504:
505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
506: jtm_message_log_pkg.Log_Msg
507: ( p_source_obj_id
508: , g_table_name
509: , 'Entering Post_Delete_Children procedure'

Line 510: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

506: jtm_message_log_pkg.Log_Msg
507: ( p_source_obj_id
508: , g_table_name
509: , 'Entering Post_Delete_Children procedure'
510: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
511: END IF;
512:
513: FOR r_jtf_note IN c_jtf_note( p_source_obj_id, p_source_obj_code ) LOOP
514:

Line 522: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

518: ,p_resource_id
519: );
520: END LOOP;
521:
522: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
523: jtm_message_log_pkg.Log_Msg
524: ( p_source_obj_id
525: , g_table_name
526: , 'Leaving Post_Delete_Children procedure'

Line 527: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

523: jtm_message_log_pkg.Log_Msg
524: ( p_source_obj_id
525: , g_table_name
526: , 'Leaving Post_Delete_Children procedure'
527: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
528: END IF;
529:
530: END Post_Delete_Children;
531:

Line 598: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

594:
595:
596: BEGIN
597: /*** get debug level ***/
598: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
599:
600: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
601: jtm_message_log_pkg.Log_Msg
602: ( p_jtf_note_id

Line 600: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

596: BEGIN
597: /*** get debug level ***/
598: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
599:
600: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
601: jtm_message_log_pkg.Log_Msg
602: ( p_jtf_note_id
603: , g_table_name
604: , 'Entering POST_INSERT hook'

Line 605: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

601: jtm_message_log_pkg.Log_Msg
602: ( p_jtf_note_id
603: , g_table_name
604: , 'Entering POST_INSERT hook'
605: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
606: END IF;
607:
608: /*Get the object type and id of this note*/
609: OPEN c_object( p_jtf_note_id );

Line 612: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

608: /*Get the object type and id of this note*/
609: OPEN c_object( p_jtf_note_id );
610: FETCH c_object INTO r_object;
611: IF c_object%NOTFOUND THEN
612: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
613: jtm_message_log_pkg.Log_Msg
614: ( p_jtf_note_id
615: , g_table_name
616: , 'Objects for note '||p_jtf_note_id||' not found'

Line 617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

613: jtm_message_log_pkg.Log_Msg
614: ( p_jtf_note_id
615: , g_table_name
616: , 'Objects for note '||p_jtf_note_id||' not found'
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
618: END IF;
619: ELSE
620: l_replicate := FALSE;
621: /*Check if whe have the "parent" object of this note*/

Line 656: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

652: l_replicate := Pre_Insert_Child( p_jtf_note_id, r_debrief.resource_id );
653: END LOOP;
654: ELSE
655: /*Note is of not supported type*/
656: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
657: jtm_message_log_pkg.Log_Msg
658: ( p_jtf_note_id
659: , g_table_name
660: , 'Source_Object_Code '||r_object.SOURCE_OBJECT_CODE||' is not supported'

Line 661: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

657: jtm_message_log_pkg.Log_Msg
658: ( p_jtf_note_id
659: , g_table_name
660: , 'Source_Object_Code '||r_object.SOURCE_OBJECT_CODE||' is not supported'
661: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
662: END IF; --g_debug_level
663: END IF; -- CODE = SR
664:
665: /*** Insert record if applicable ***/

Line 667: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

663: END IF; -- CODE = SR
664:
665: /*** Insert record if applicable ***/
666: IF l_replicate = FALSE THEN
667: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
668: jtm_message_log_pkg.Log_Msg
669: ( p_jtf_note_id
670: , g_table_name
671: , 'Note '||p_jtf_note_id||' did not match the criteria to be replicated'||fnd_global.local_chr(10)||

Line 674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

670: , g_table_name
671: , 'Note '||p_jtf_note_id||' did not match the criteria to be replicated'||fnd_global.local_chr(10)||
672: 'Object id = '||r_object.SOURCE_OBJECT_ID||fnd_global.local_chr(10)||
673: 'Object_code = '||r_object.SOURCE_OBJECT_CODE
674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
675: END IF; -- g_debug_level
676: END IF; -- l_replicate = FALSE
677: END IF; --c_object%NOTFOUND
678: CLOSE c_object;

Line 680: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

676: END IF; -- l_replicate = FALSE
677: END IF; --c_object%NOTFOUND
678: CLOSE c_object;
679:
680: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
681: jtm_message_log_pkg.Log_Msg
682: ( p_jtf_note_id
683: , g_table_name
684: , 'Leaving POST_INSERT hook'

Line 685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

681: jtm_message_log_pkg.Log_Msg
682: ( p_jtf_note_id
683: , g_table_name
684: , 'Leaving POST_INSERT hook'
685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
686: END IF;
687:
688: x_return_status := FND_API.G_RET_STS_SUCCESS;
689: EXCEPTION WHEN OTHERS THEN

Line 691: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

687:
688: x_return_status := FND_API.G_RET_STS_SUCCESS;
689: EXCEPTION WHEN OTHERS THEN
690: /*** hook failed -> log error ***/
691: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
692: jtm_message_log_pkg.Log_Msg
693: ( p_jtf_note_id
694: , g_table_name
695: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm

Line 696: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

692: jtm_message_log_pkg.Log_Msg
693: ( p_jtf_note_id
694: , g_table_name
695: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
696: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
697: END IF;
698: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_NOTES_ACC_PKG','POST_INSERT_JTF_NOTES',sqlerrm);
699: -- x_return_status := FND_API.G_RET_STS_ERROR;
700: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 734: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

730: BEGIN
731: l_jtf_note_id := p_jtf_note_id;
732:
733: /*** get debug level ***/
734: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( l_jtf_note_id

Line 736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

732:
733: /*** get debug level ***/
734: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( l_jtf_note_id
739: , g_table_name
740: , 'Entering POST_UPDATE hook'

Line 741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

737: jtm_message_log_pkg.Log_Msg
738: ( l_jtf_note_id
739: , g_table_name
740: , 'Entering POST_UPDATE hook'
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
742: END IF;
743:
744: /*** Check if jtf_note after update matches criteria ***/
745: l_replicate := Replicate_Record( l_jtf_note_id );

Line 750: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

746:
747: /*** replicate record after update? ***/
748: IF NOT l_replicate THEN
749: /*** yes -> re-send updated jtf_note record to all resources ***/
750: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
751: jtm_message_log_pkg.Log_Msg
752: ( l_jtf_note_id
753: , g_table_name
754: , 'Note was not replicateable after update.'

Line 755: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

751: jtm_message_log_pkg.Log_Msg
752: ( l_jtf_note_id
753: , g_table_name
754: , 'Note was not replicateable after update.'
755: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
756: END IF;
757:
758: ELSE
759: /*** yes -> re-send updated note record to all resources ***/

Line 760: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

756: END IF;
757:
758: ELSE
759: /*** yes -> re-send updated note record to all resources ***/
760: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
761: jtm_message_log_pkg.Log_Msg
762: ( l_jtf_note_id
763: , g_table_name
764: , 'Note being re-sent to mobile users.'

Line 765: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

761: jtm_message_log_pkg.Log_Msg
762: ( l_jtf_note_id
763: , g_table_name
764: , 'Note being re-sent to mobile users.'
765: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
766: END IF;
767:
768: /*** get list of resources to whom the record was replicated ***/
769: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

Line 769: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

765: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
766: END IF;
767:
768: /*** get list of resources to whom the record was replicated ***/
769: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
770: ( P_ACC_TABLE_NAME => g_acc_table_name
771: ,P_PK1_NAME => g_pk_name
772: ,P_PK1_NUM_VALUE => l_jtf_note_id
773: ,L_TAB_RESOURCE_ID => l_tab_resource_id

Line 789: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_tab_resource_id(i) ) THEN

785:
786: FOR i IN l_tab_resource_id.FIRST .. l_tab_resource_id.LAST LOOP
787:
788: /*** is resource a mobile user? ***/
789: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_tab_resource_id(i) ) THEN
790: /*** No -> exit ***/
791: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
792: jtm_message_log_pkg.Log_Msg
793: ( l_tab_resource_id(i)

Line 791: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

787:
788: /*** is resource a mobile user? ***/
789: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_tab_resource_id(i) ) THEN
790: /*** No -> exit ***/
791: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
792: jtm_message_log_pkg.Log_Msg
793: ( l_tab_resource_id(i)
794: , g_table_name
795: , 'POST_UPDATE_DEBRIEF_LINE' || fnd_global.local_chr(10) ||

Line 797: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

793: ( l_tab_resource_id(i)
794: , g_table_name
795: , 'POST_UPDATE_DEBRIEF_LINE' || fnd_global.local_chr(10) ||
796: 'Resource_id ' || l_tab_resource_id(i) || ' is not a mobile user.'
797: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
798: END IF;
799: ELSE
800:
801: Update_ACC_Record

Line 814: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

810: END IF;
811:
812: x_return_status := FND_API.G_RET_STS_SUCCESS;
813:
814: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
815: jtm_message_log_pkg.Log_Msg
816: ( l_jtf_note_id
817: , g_table_name
818: , 'Leaving POST_UPDATE hook'

Line 819: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

815: jtm_message_log_pkg.Log_Msg
816: ( l_jtf_note_id
817: , g_table_name
818: , 'Leaving POST_UPDATE hook'
819: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
820: END IF;
821:
822: EXCEPTION WHEN OTHERS THEN
823: /*** hook failed -> log error ***/

Line 824: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

820: END IF;
821:
822: EXCEPTION WHEN OTHERS THEN
823: /*** hook failed -> log error ***/
824: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
825: jtm_message_log_pkg.Log_Msg
826: ( l_jtf_note_id
827: , g_table_name
828: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

Line 829: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

825: jtm_message_log_pkg.Log_Msg
826: ( l_jtf_note_id
827: , g_table_name
828: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
829: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
830: END IF;
831: fnd_msg_pub.Add_Exc_Msg('CSL_JTF_NOTES_ACC_PKG','POST_UPDATE_JTF_NOTES',sqlerrm);
832: -- x_return_status := FND_API.G_RET_STS_ERROR;
833: x_return_status := FND_API.G_RET_STS_SUCCESS;