APPS.CSL_CSF_DEBRIEF_LINE_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: csldbacb.pls 120.0 2005/05/25 11:04:53 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSF_DEBRIEF_LINES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_LINES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
10: g_pre_replicate BOOLEAN;

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSF_DEBRIEF_LINES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSF_DEBRIEF_LINES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
10: g_pre_replicate BOOLEAN;
11:

Line 38: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

34: r_debrief_line c_debrief_line%ROWTYPE;
35:
36: BEGIN
37: /*** get debug level ***/
38: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
39:
40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
41: jtm_message_log_pkg.Log_Msg
42: ( p_debrief_line_id

Line 40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

36: BEGIN
37: /*** get debug level ***/
38: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
39:
40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
41: jtm_message_log_pkg.Log_Msg
42: ( p_debrief_line_id
43: , g_table_name
44: , 'Entering Get_Debrief_Header_Id'

Line 45: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

41: jtm_message_log_pkg.Log_Msg
42: ( p_debrief_line_id
43: , g_table_name
44: , 'Entering Get_Debrief_Header_Id'
45: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
46: END IF;
47:
48: OPEN c_debrief_line( p_debrief_line_id );
49: FETCH c_debrief_line INTO r_debrief_line;

Line 52: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

48: OPEN c_debrief_line( p_debrief_line_id );
49: FETCH c_debrief_line INTO r_debrief_line;
50: IF c_debrief_line%NOTFOUND THEN
51: /*** could not find debrief_line record -> exit ***/
52: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
53: jtm_message_log_pkg.Log_Msg
54: ( p_debrief_line_id
55: , g_table_name
56: , 'Get_Debrief_Header_Id error: Could not find debrief_line_id ' ||

Line 58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

54: ( p_debrief_line_id
55: , g_table_name
56: , 'Get_Debrief_Header_Id error: Could not find debrief_line_id ' ||
57: p_debrief_line_id
58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
59: END IF;
60:
61: CLOSE c_debrief_line;
62: RETURN -1;

Line 66: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

62: RETURN -1;
63: END IF;
64: CLOSE c_debrief_line;
65:
66: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
67: jtm_message_log_pkg.Log_Msg
68: ( p_debrief_line_id
69: , g_table_name
70: , 'Get_Debrief_Header_Id returned TRUE'

Line 71: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

67: jtm_message_log_pkg.Log_Msg
68: ( p_debrief_line_id
69: , g_table_name
70: , 'Get_Debrief_Header_Id returned TRUE'
71: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
72: END IF;
73:
74: /** return the debrief header id ***/
75: return r_debrief_line.debrief_header_id;

Line 92: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

88: r_debrief_line c_debrief_line%ROWTYPE;
89:
90: BEGIN
91: /*** get debug level ***/
92: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
93:
94: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
95: jtm_message_log_pkg.Log_Msg
96: ( p_debrief_line_id

Line 94: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

90: BEGIN
91: /*** get debug level ***/
92: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
93:
94: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
95: jtm_message_log_pkg.Log_Msg
96: ( p_debrief_line_id
97: , g_table_name
98: , 'Entering Replicate_Record'

Line 99: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

95: jtm_message_log_pkg.Log_Msg
96: ( p_debrief_line_id
97: , g_table_name
98: , 'Entering Replicate_Record'
99: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
100: END IF;
101:
102: OPEN c_debrief_line( p_debrief_line_id );
103: FETCH c_debrief_line INTO r_debrief_line;

Line 106: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

102: OPEN c_debrief_line( p_debrief_line_id );
103: FETCH c_debrief_line INTO r_debrief_line;
104: IF c_debrief_line%NOTFOUND THEN
105: /*** could not find debrief_line record -> exit ***/
106: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
107: jtm_message_log_pkg.Log_Msg
108: ( p_debrief_line_id
109: , g_table_name
110: , 'Replicate_Record error: Could not find debrief_line_id ' || p_debrief_line_id

Line 111: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

107: jtm_message_log_pkg.Log_Msg
108: ( p_debrief_line_id
109: , g_table_name
110: , 'Replicate_Record error: Could not find debrief_line_id ' || p_debrief_line_id
111: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
112: END IF;
113:
114: CLOSE c_debrief_line;
115: RETURN FALSE;

Line 119: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

115: RETURN FALSE;
116: END IF;
117: CLOSE c_debrief_line;
118:
119: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
120: jtm_message_log_pkg.Log_Msg
121: ( p_debrief_line_id
122: , g_table_name
123: , 'Replicate_Record returned TRUE'

Line 124: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

120: jtm_message_log_pkg.Log_Msg
121: ( p_debrief_line_id
122: , g_table_name
123: , 'Replicate_Record returned TRUE'
124: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
125: END IF;
126:
127: /** Record matched criteria -> return true ***/
128: RETURN TRUE;

Line 139: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

135: ,p_resource_id IN NUMBER
136: )
137: IS
138: BEGIN
139: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
140: jtm_message_log_pkg.Log_Msg
141: ( p_debrief_line_id
142: , g_table_name
143: , 'Entering Insert_ACC_Record'

Line 144: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

140: jtm_message_log_pkg.Log_Msg
141: ( p_debrief_line_id
142: , g_table_name
143: , 'Entering Insert_ACC_Record'
144: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
145: END IF;
146:
147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
148: jtm_message_log_pkg.Log_Msg

Line 147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

143: , 'Entering Insert_ACC_Record'
144: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
145: END IF;
146:
147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
148: jtm_message_log_pkg.Log_Msg
149: ( p_debrief_line_id
150: , g_table_name
151: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 152: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

148: jtm_message_log_pkg.Log_Msg
149: ( p_debrief_line_id
150: , g_table_name
151: , 'Inserting ACC record for resource_id = ' || p_resource_id
152: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
153: END IF;
154:
155: /*** Insert debrief_line ACC record ***/
156: JTM_HOOK_UTIL_PKG.Insert_Acc

Line 156: JTM_HOOK_UTIL_PKG.Insert_Acc

152: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
153: END IF;
154:
155: /*** Insert debrief_line ACC record ***/
156: JTM_HOOK_UTIL_PKG.Insert_Acc
157: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
158: ,P_ACC_TABLE_NAME => g_acc_table_name
159: ,P_PK1_NAME => g_pk1_name
160: ,P_PK1_NUM_VALUE => p_debrief_line_id

Line 164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

160: ,P_PK1_NUM_VALUE => p_debrief_line_id
161: ,P_RESOURCE_ID => p_resource_id
162: );
163:
164: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
165: jtm_message_log_pkg.Log_Msg
166: ( p_debrief_line_id
167: , g_table_name
168: , 'Leaving Insert_ACC_Record'

Line 169: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

165: jtm_message_log_pkg.Log_Msg
166: ( p_debrief_line_id
167: , g_table_name
168: , 'Leaving Insert_ACC_Record'
169: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
170: END IF;
171: END Insert_ACC_Record;
172:
173: /*** Private procedure that re-sends given debrief_line to mobile ***/

Line 181: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

177: ,p_acc_id IN NUMBER
178: )
179: IS
180: BEGIN
181: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
182: jtm_message_log_pkg.Log_Msg
183: ( p_debrief_line_id
184: , g_table_name
185: , 'Entering Update_ACC_Record'

Line 186: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

182: jtm_message_log_pkg.Log_Msg
183: ( p_debrief_line_id
184: , g_table_name
185: , 'Entering Update_ACC_Record'
186: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
187: END IF;
188:
189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
190: jtm_message_log_pkg.Log_Msg

Line 189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

185: , 'Entering Update_ACC_Record'
186: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
187: END IF;
188:
189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
190: jtm_message_log_pkg.Log_Msg
191: ( p_debrief_line_id
192: , g_table_name
193: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id

Line 194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

190: jtm_message_log_pkg.Log_Msg
191: ( p_debrief_line_id
192: , g_table_name
193: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
195: END IF;
196:
197: /*** Update debrief_line ACC record ***/
198: JTM_HOOK_UTIL_PKG.Update_Acc

Line 198: JTM_HOOK_UTIL_PKG.Update_Acc

194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
195: END IF;
196:
197: /*** Update debrief_line ACC record ***/
198: JTM_HOOK_UTIL_PKG.Update_Acc
199: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
200: ,P_ACC_TABLE_NAME => g_acc_table_name
201: ,P_RESOURCE_ID => p_resource_id
202: ,P_ACCESS_ID => p_acc_id

Line 205: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

201: ,P_RESOURCE_ID => p_resource_id
202: ,P_ACCESS_ID => p_acc_id
203: );
204:
205: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
206: jtm_message_log_pkg.Log_Msg
207: ( p_debrief_line_id
208: , g_table_name
209: , 'Leaving Update_ACC_Record'

Line 210: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

206: jtm_message_log_pkg.Log_Msg
207: ( p_debrief_line_id
208: , g_table_name
209: , 'Leaving Update_ACC_Record'
210: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
211: END IF;
212: END Update_ACC_Record;
213:
214: /*** Private procedure that deletes debrief_line for resource from acc table ***/

Line 221: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

217: ,p_resource_id IN NUMBER
218: )
219: IS
220: BEGIN
221: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
222: jtm_message_log_pkg.Log_Msg
223: ( p_debrief_line_id
224: , g_table_name
225: , 'Entering Delete_ACC_Record'

Line 226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

222: jtm_message_log_pkg.Log_Msg
223: ( p_debrief_line_id
224: , g_table_name
225: , 'Entering Delete_ACC_Record'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
227: END IF;
228:
229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
230: jtm_message_log_pkg.Log_Msg

Line 229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

225: , 'Entering Delete_ACC_Record'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
227: END IF;
228:
229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
230: jtm_message_log_pkg.Log_Msg
231: ( p_debrief_line_id
232: , g_table_name
233: , 'Deleting ACC record for resource_id = ' || p_resource_id

Line 234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

230: jtm_message_log_pkg.Log_Msg
231: ( p_debrief_line_id
232: , g_table_name
233: , 'Deleting ACC record for resource_id = ' || p_resource_id
234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
235: END IF;
236:
237: /*** Delete debrief_line ACC record ***/
238: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 238: JTM_HOOK_UTIL_PKG.Delete_Acc

234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
235: END IF;
236:
237: /*** Delete debrief_line ACC record ***/
238: JTM_HOOK_UTIL_PKG.Delete_Acc
239: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
240: ,P_ACC_TABLE_NAME => g_acc_table_name
241: ,P_PK1_NAME => g_pk1_name
242: ,P_PK1_NUM_VALUE => p_debrief_line_id

Line 246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

242: ,P_PK1_NUM_VALUE => p_debrief_line_id
243: ,P_RESOURCE_ID => p_resource_id
244: );
245:
246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
247: jtm_message_log_pkg.Log_Msg
248: ( p_debrief_line_id
249: , g_table_name
250: , 'Leaving Delete_ACC_Record'

Line 251: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

247: jtm_message_log_pkg.Log_Msg
248: ( p_debrief_line_id
249: , g_table_name
250: , 'Leaving Delete_ACC_Record'
251: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
252: END IF;
253: END Delete_ACC_Record;
254:
255: /***

Line 279: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

275: l_acc_id NUMBER;
276: l_success BOOLEAN;
277: BEGIN
278: /*** get debug level ***/
279: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
280:
281: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
282: jtm_message_log_pkg.Log_Msg
283: ( p_debrief_line_id

Line 281: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

277: BEGIN
278: /*** get debug level ***/
279: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
280:
281: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
282: jtm_message_log_pkg.Log_Msg
283: ( p_debrief_line_id
284: , g_table_name
285: , 'Entering Pre_Insert_Child procedure'

Line 286: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

282: jtm_message_log_pkg.Log_Msg
283: ( p_debrief_line_id
284: , g_table_name
285: , 'Entering Pre_Insert_Child procedure'
286: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
287: END IF;
288:
289: /*** does record match criteria? ***/
290: IF Replicate_Record( p_debrief_line_id ) THEN

Line 324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

320:
321: l_success := TRUE;
322: END IF;
323:
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_debrief_line_id
327: , g_table_name
328: , 'Leaving Pre_Insert_Child procedure'

Line 329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

325: jtm_message_log_pkg.Log_Msg
326: ( p_debrief_line_id
327: , g_table_name
328: , 'Leaving Pre_Insert_Child procedure'
329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
330: END IF;
331:
332: RETURN l_success;
333: END Pre_Insert_Child;

Line 353: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

349:
350: l_dummy BOOLEAN;
351: BEGIN
352: /*** get debug level ***/
353: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
354:
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( p_task_assignment_id

Line 355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

351: BEGIN
352: /*** get debug level ***/
353: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
354:
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( p_task_assignment_id
358: , g_table_name
359: , 'Entering Pre_Insert_Children procedure'

Line 360: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

356: jtm_message_log_pkg.Log_Msg
357: ( p_task_assignment_id
358: , g_table_name
359: , 'Entering Pre_Insert_Children procedure'
360: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
361: END IF;
362:
363: FOR r_debrief_line IN c_debrief_line( p_task_assignment_id ) LOOP
364:

Line 372: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

368: ,p_resource_id
369: );
370:
371: IF l_dummy = FALSE THEN
372: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
373: jtm_message_log_pkg.Log_Msg
374: ( p_task_assignment_id
375: , g_table_name
376: , 'Pre_Insert_Children: debrief line was not insertable.'

Line 377: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

373: jtm_message_log_pkg.Log_Msg
374: ( p_task_assignment_id
375: , g_table_name
376: , 'Pre_Insert_Children: debrief line was not insertable.'
377: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
378: END IF;
379: END IF;
380: END LOOP;
381:

Line 382: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

378: END IF;
379: END IF;
380: END LOOP;
381:
382: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
383: jtm_message_log_pkg.Log_Msg
384: ( p_task_assignment_id
385: , g_table_name
386: , 'Leaving Pre_Insert_Children procedure'

Line 387: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

383: jtm_message_log_pkg.Log_Msg
384: ( p_task_assignment_id
385: , g_table_name
386: , 'Leaving Pre_Insert_Children procedure'
387: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
388: END IF;
389:
390: END Pre_Insert_Children;
391:

Line 414: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

410: l_acc_id NUMBER;
411: l_success BOOLEAN;
412: BEGIN
413: /*** get debug level ***/
414: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( p_debrief_line_id

Line 416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

412: BEGIN
413: /*** get debug level ***/
414: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( p_debrief_line_id
419: , g_table_name
420: , 'Entering Post_Delete_Child'

Line 421: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

417: jtm_message_log_pkg.Log_Msg
418: ( p_debrief_line_id
419: , g_table_name
420: , 'Entering Post_Delete_Child'
421: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
422: END IF;
423:
424: /*** no -> delete debrief_line record from ACC ***/
425: Delete_ACC_Record

Line 453: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

449: ( l_debrief_header_id
450: ,p_resource_id
451: );
452:
453: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
454: jtm_message_log_pkg.Log_Msg
455: ( p_debrief_line_id
456: , g_table_name
457: , 'Leaving Post_Delete_Child'

Line 458: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

454: jtm_message_log_pkg.Log_Msg
455: ( p_debrief_line_id
456: , g_table_name
457: , 'Leaving Post_Delete_Child'
458: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
459: END IF;
460: END Post_Delete_Child;
461:
462: /***

Line 479: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

475: r_debrief_line c_debrief_line%ROWTYPE;
476:
477: BEGIN
478: /*** get debug level ***/
479: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
480:
481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
482: jtm_message_log_pkg.Log_Msg
483: ( p_task_assignment_id

Line 481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

477: BEGIN
478: /*** get debug level ***/
479: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
480:
481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
482: jtm_message_log_pkg.Log_Msg
483: ( p_task_assignment_id
484: , g_table_name
485: , 'Entering Post_Delete_Children procedure'

Line 486: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

482: jtm_message_log_pkg.Log_Msg
483: ( p_task_assignment_id
484: , g_table_name
485: , 'Entering Post_Delete_Children procedure'
486: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
487: END IF;
488:
489: FOR r_debrief_line IN c_debrief_line( p_task_assignment_id ) LOOP
490:

Line 498: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

494: ,p_resource_id
495: );
496: END LOOP;
497:
498: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
499: jtm_message_log_pkg.Log_Msg
500: ( p_task_assignment_id
501: , g_table_name
502: , 'Leaving Post_Delete_Children procedure'

Line 503: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

499: jtm_message_log_pkg.Log_Msg
500: ( p_task_assignment_id
501: , g_table_name
502: , 'Leaving Post_Delete_Children procedure'
503: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
504: END IF;
505:
506: END Post_Delete_Children;
507:

Line 525: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

521: AND dbh.debrief_header_id = dbl.debrief_header_id
522: AND dbl.debrief_line_id = b_debrief_line_id;
523: r_resource c_resource%ROWTYPE;
524: BEGIN
525: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
526: jtm_message_log_pkg.Log_Msg
527: ( p_debrief_line_id
528: , g_table_name
529: , 'Entering Get_Resource_Id function'

Line 530: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

526: jtm_message_log_pkg.Log_Msg
527: ( p_debrief_line_id
528: , g_table_name
529: , 'Entering Get_Resource_Id function'
530: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
531: END IF;
532:
533: OPEN c_resource( p_debrief_line_id );
534: FETCH c_resource INTO r_resource;

Line 537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

533: OPEN c_resource( p_debrief_line_id );
534: FETCH c_resource INTO r_resource;
535: CLOSE c_resource;
536:
537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
538: jtm_message_log_pkg.Log_Msg
539: ( p_debrief_line_id
540: , g_table_name
541: , 'Leaving Get_Resource_Id function'

Line 542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

538: jtm_message_log_pkg.Log_Msg
539: ( p_debrief_line_id
540: , g_table_name
541: , 'Leaving Get_Resource_Id function'
542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
543: END IF;
544: RETURN r_resource.resource_id;
545: END Get_Resource_Id;
546:

Line 572: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: RETURN;
570: END IF;
571: /*** get debug level ***/
572: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
573:
574: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
575: jtm_message_log_pkg.Log_Msg
576: ( l_debrief_line_id

Line 574: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

570: END IF;
571: /*** get debug level ***/
572: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
573:
574: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
575: jtm_message_log_pkg.Log_Msg
576: ( l_debrief_line_id
577: , g_table_name
578: , 'Entering POST_INSERT hook'

Line 579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

575: jtm_message_log_pkg.Log_Msg
576: ( l_debrief_line_id
577: , g_table_name
578: , 'Entering POST_INSERT hook'
579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
580: END IF;
581:
582: /*** get debrief record details from public API ***/
583: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

Line 587: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN

583: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
584: l_resource_id := Get_Resource_Id( l_debrief_line_id );
585:
586: /*** is resource a mobile user? ***/
587: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
588: /*** No -> exit ***/
589: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
590: jtm_message_log_pkg.Log_Msg
591: ( l_debrief_line_id

Line 589: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

585:
586: /*** is resource a mobile user? ***/
587: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
588: /*** No -> exit ***/
589: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
590: jtm_message_log_pkg.Log_Msg
591: ( l_debrief_line_id
592: , g_table_name
593: , 'POST_INSERT_DEBRIEF_LINE' || fnd_global.local_chr(10) ||

Line 595: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

591: ( l_debrief_line_id
592: , g_table_name
593: , 'POST_INSERT_DEBRIEF_LINE' || fnd_global.local_chr(10) ||
594: 'Resource_id ' || l_resource_id || ' is not a mobile user.'
595: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
596: END IF;
597: ELSE
598:
599: /*** Insert record if applicable ***/

Line 606: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

602: ,l_resource_id
603: );
604: END IF;
605:
606: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
607: jtm_message_log_pkg.Log_Msg
608: ( l_debrief_line_id
609: , g_table_name
610: , 'Leaving POST_INSERT hook'

Line 611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

607: jtm_message_log_pkg.Log_Msg
608: ( l_debrief_line_id
609: , g_table_name
610: , 'Leaving POST_INSERT hook'
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
612: END IF;
613:
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: RETURN;

Line 619: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

615: RETURN;
616:
617: EXCEPTION WHEN OTHERS THEN
618: /*** hook failed -> log error ***/
619: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
620: jtm_message_log_pkg.Log_Msg
621: ( l_debrief_line_id
622: , g_table_name
623: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm

Line 624: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

620: jtm_message_log_pkg.Log_Msg
621: ( l_debrief_line_id
622: , g_table_name
623: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
624: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
625: END IF;
626: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_INSERT_DEBRIEF_LINE',sqlerrm);
627: -- x_return_status := FND_API.G_RET_STS_ERROR;
628: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 646: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643: RETURN;
644: END IF;
645: /*** get debug level ***/
646: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
647:
648: /*** default value of pre replication ***/
649: g_pre_replicate := FALSE;
650:

Line 651: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

647:
648: /*** default value of pre replication ***/
649: g_pre_replicate := FALSE;
650:
651: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
652: jtm_message_log_pkg.Log_Msg
653: ( l_debrief_line_id
654: , g_table_name
655: , 'Entering PRE_UPDATE hook'

Line 656: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

652: jtm_message_log_pkg.Log_Msg
653: ( l_debrief_line_id
654: , g_table_name
655: , 'Entering PRE_UPDATE hook'
656: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
657: END IF;
658:
659: /*** get debrief_line record details from public API ***/
660: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

Line 664: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN

660: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
661: l_resource_id := Get_Resource_Id( l_debrief_line_id );
662:
663: /*** Check if debrief_line before update matches criteria ***/
664: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
665: g_pre_replicate := Replicate_Record( l_debrief_line_id );
666: END IF;
667:
668: IF g_pre_replicate THEN

Line 669: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

665: g_pre_replicate := Replicate_Record( l_debrief_line_id );
666: END IF;
667:
668: IF g_pre_replicate THEN
669: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
670: jtm_message_log_pkg.Log_Msg
671: ( l_debrief_line_id
672: , g_table_name
673: , 'Debrief line was replicated before update.'

Line 674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

670: jtm_message_log_pkg.Log_Msg
671: ( l_debrief_line_id
672: , g_table_name
673: , 'Debrief line was replicated before update.'
674: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
675: END IF;
676:
677: /*** retrieve old system item data from debrief line ***/
678: OPEN c_update_cache_rec( l_debrief_line_id );

Line 682: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

678: OPEN c_update_cache_rec( l_debrief_line_id );
679: FETCH c_update_cache_rec INTO g_pre_update_rec;
680: CLOSE c_update_cache_rec;
681:
682: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
683: jtm_message_log_pkg.Log_Msg
684: ( l_debrief_line_id
685: , g_table_name
686: , 'Debrief line was not replicated before update'

Line 687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

683: jtm_message_log_pkg.Log_Msg
684: ( l_debrief_line_id
685: , g_table_name
686: , 'Debrief line was not replicated before update'
687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
688: END IF;
689:
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:

Line 692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

688: END IF;
689:
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
693: jtm_message_log_pkg.Log_Msg
694: ( l_debrief_line_id
695: , g_table_name
696: , 'Leaving PRE_UPDATE hook'

Line 697: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

693: jtm_message_log_pkg.Log_Msg
694: ( l_debrief_line_id
695: , g_table_name
696: , 'Leaving PRE_UPDATE hook'
697: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
698: END IF;
699:
700: EXCEPTION WHEN OTHERS THEN
701: /*** hook failed -> log error ***/

Line 702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

698: END IF;
699:
700: EXCEPTION WHEN OTHERS THEN
701: /*** hook failed -> log error ***/
702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
703: jtm_message_log_pkg.Log_Msg
704: ( l_debrief_line_id
705: , g_table_name
706: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

Line 707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

703: jtm_message_log_pkg.Log_Msg
704: ( l_debrief_line_id
705: , g_table_name
706: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
708: END IF;
709: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_UPDATE_DEBRIEF_LINE',sqlerrm);
710: -- x_return_status := FND_API.G_RET_STS_ERROR;
711: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 737: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734: RETURN;
735: END IF;
736: /*** get debug level ***/
737: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
738:
739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
740: jtm_message_log_pkg.Log_Msg
741: ( l_debrief_line_id

Line 739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

735: END IF;
736: /*** get debug level ***/
737: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
738:
739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
740: jtm_message_log_pkg.Log_Msg
741: ( l_debrief_line_id
742: , g_table_name
743: , 'Entering POST_UPDATE hook'

Line 744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

740: jtm_message_log_pkg.Log_Msg
741: ( l_debrief_line_id
742: , g_table_name
743: , 'Entering POST_UPDATE hook'
744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
745: END IF;
746:
747: /*** get debrief_line record details from public API ***/
748: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

Line 753: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN

749: l_resource_id := Get_Resource_Id( l_debrief_line_id );
750:
751: /*** Check if debrief_line after update matches criteria ***/
752: l_replicate := FALSE;
753: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
754: l_replicate := Replicate_Record( l_debrief_line_id );
755: END IF;
756:
757: IF l_replicate THEN

Line 758: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

754: l_replicate := Replicate_Record( l_debrief_line_id );
755: END IF;
756:
757: IF l_replicate THEN
758: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
759: jtm_message_log_pkg.Log_Msg
760: ( l_debrief_line_id
761: , g_table_name
762: , 'Debrief line should be replicated after update.'

Line 763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

759: jtm_message_log_pkg.Log_Msg
760: ( l_debrief_line_id
761: , g_table_name
762: , 'Debrief line should be replicated after update.'
763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
764: END IF;
765: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
766: jtm_message_log_pkg.Log_Msg
767: ( l_debrief_line_id

Line 765: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

761: , g_table_name
762: , 'Debrief line should be replicated after update.'
763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
764: END IF;
765: ELSIF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
766: jtm_message_log_pkg.Log_Msg
767: ( l_debrief_line_id
768: , g_table_name
769: , 'Debrief line should not be replicated after update'

Line 770: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

766: jtm_message_log_pkg.Log_Msg
767: ( l_debrief_line_id
768: , g_table_name
769: , 'Debrief line should not be replicated after update'
770: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
771: END IF;
772:
773: /*** Check results from pre update ***/
774: IF g_pre_replicate THEN

Line 784: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

780: Post_Delete_Child
781: ( l_debrief_line_id
782: , l_resource_id );
783:
784: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
785: jtm_message_log_pkg.Log_Msg
786: ( l_debrief_line_id
787: , g_table_name
788: , 'Debrief line was deleted during post update.'

Line 789: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

785: jtm_message_log_pkg.Log_Msg
786: ( l_debrief_line_id
787: , g_table_name
788: , 'Debrief line was deleted during post update.'
789: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
790: END IF;
791:
792: ELSE
793:

Line 795: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

791:
792: ELSE
793:
794: /*** yes -> re-send updated debrief record to resource ***/
795: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
796: jtm_message_log_pkg.Log_Msg
797: ( l_debrief_line_id
798: , g_table_name
799: , 'Debrief line being re-sent to mobile user.'

Line 800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

796: jtm_message_log_pkg.Log_Msg
797: ( l_debrief_line_id
798: , g_table_name
799: , 'Debrief line being re-sent to mobile user.'
800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
801: END IF;
802:
803: l_access_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
804: ( p_acc_table_name => g_acc_table_name

Line 803: l_access_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id

799: , 'Debrief line being re-sent to mobile user.'
800: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
801: END IF;
802:
803: l_access_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
804: ( p_acc_table_name => g_acc_table_name
805: ,p_resource_id => l_resource_id
806: ,P_PK1_NAME => g_pk1_name
807: ,P_PK1_NUM_VALUE => l_debrief_line_id

Line 823: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

819: FETCH c_update_cache_rec INTO l_post_update_rec;
820: IF (g_pre_update_rec.inventory_item_id <> l_post_update_rec.inventory_item_id
821: OR g_pre_update_rec.organization_id <> l_post_update_rec.organization_id) THEN
822: -- yes -> remove old item and insert new item
823: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
824: jtm_message_log_pkg.Log_Msg
825: ( l_debrief_line_id
826: , g_table_name
827: , 'System item changed -> deleting old item and inserting new item.'

Line 828: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

824: jtm_message_log_pkg.Log_Msg
825: ( l_debrief_line_id
826: , g_table_name
827: , 'System item changed -> deleting old item and inserting new item.'
828: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
829: END IF;
830:
831: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child (
832: p_inventory_item_id => g_pre_update_rec.inventory_item_id

Line 848: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

844: END IF;
845:
846: ELSIF l_replicate THEN
847: /*** record was not replicated before update -> replicate now ***/
848: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
849: jtm_message_log_pkg.Log_Msg
850: ( l_debrief_line_id
851: , g_table_name
852: , 'Debrief line was inserted during post update.'

Line 853: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

849: jtm_message_log_pkg.Log_Msg
850: ( l_debrief_line_id
851: , g_table_name
852: , 'Debrief line was inserted during post update.'
853: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
854: END IF;
855:
856: /*** Insert record if applicable ***/
857: l_dummy := Pre_Insert_Child

Line 863: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

859: ,l_resource_id
860: );
861: END IF;
862:
863: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
864: jtm_message_log_pkg.Log_Msg
865: ( l_debrief_line_id
866: , g_table_name
867: , 'Leaving POST_UPDATE hook'

Line 868: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

864: jtm_message_log_pkg.Log_Msg
865: ( l_debrief_line_id
866: , g_table_name
867: , 'Leaving POST_UPDATE hook'
868: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
869: END IF;
870:
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:

Line 875: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:
873: EXCEPTION WHEN OTHERS THEN
874: /*** hook failed -> log error ***/
875: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
876: jtm_message_log_pkg.Log_Msg
877: ( l_debrief_line_id
878: , g_table_name
879: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm

Line 880: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

876: jtm_message_log_pkg.Log_Msg
877: ( l_debrief_line_id
878: , g_table_name
879: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
880: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
881: END IF;
882: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','POST_UPDATE_DEBRIEF_LINE',sqlerrm);
883: -- x_return_status := FND_API.G_RET_STS_ERROR;
884: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 899: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

895:
896: BEGIN
897:
898: /*** get debug level ***/
899: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
900:
901: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
902: jtm_message_log_pkg.Log_Msg
903: ( v_object_id => l_debrief_line_id

Line 901: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

897:
898: /*** get debug level ***/
899: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
900:
901: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
902: jtm_message_log_pkg.Log_Msg
903: ( v_object_id => l_debrief_line_id
904: , v_object_name => g_table_name
905: , v_message => 'Entering PRE_DELETE hook'

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

902: jtm_message_log_pkg.Log_Msg
903: ( v_object_id => l_debrief_line_id
904: , v_object_name => g_table_name
905: , v_message => 'Entering PRE_DELETE hook'
906: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
907: END IF;
908:
909: /*** Get debrief line record details from public API and then get the resource id ***/
910: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

Line 919: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

915: , l_resource_id );
916:
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918:
919: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
920: jtm_message_log_pkg.Log_Msg
921: ( v_object_id => l_debrief_line_id
922: , v_object_name => g_table_name
923: , v_message => 'Leaving PRE_DELETE hook'

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

920: jtm_message_log_pkg.Log_Msg
921: ( v_object_id => l_debrief_line_id
922: , v_object_name => g_table_name
923: , v_message => 'Leaving PRE_DELETE hook'
924: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
925: END IF;
926:
927: EXCEPTION WHEN OTHERS THEN
928:

Line 930: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

926:
927: EXCEPTION WHEN OTHERS THEN
928:
929: /*** hook failed -> log error ***/
930: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
931: jtm_message_log_pkg.Log_Msg
932: ( v_object_id => l_debrief_line_id
933: , v_object_name => g_table_name
934: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm

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

931: jtm_message_log_pkg.Log_Msg
932: ( v_object_id => l_debrief_line_id
933: , v_object_name => g_table_name
934: , v_message => 'Caught exception in PRE_DELETE hook:' || fnd_global.local_chr(10) || sqlerrm
935: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
936: END IF;
937:
938: fnd_msg_pub.Add_Exc_Msg('CSL_CSF_DEBRIEF_LINE_ACC_PKG','PRE_DELETE_DEBRIEF_LINE',sqlerrm);
939: