54: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
55: , x_return_status OUT NOCOPY VARCHAR2
56: ) is
57: begin
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: end create_note_pre;
60:
61:
62: /* Verticals Procedure for post processing in case of create note */
109: l_strBuffer VARCHAR2(2000);
110: l_execute_status INTEGER;
111:
112: begin
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: FOR Csr1 in Get_hook_info('A', 'CREATE_NOTE') LOOP
116:
117: /* check execute flag */
207:
208: END LOOP;
209:
210: EXCEPTION WHEN OTHERS THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: end create_note_post;
213:
214:
215: /* Verticals Procedure for pre processing in case of update note */
239: l_strBuffer VARCHAR2(2000);
240: l_execute_status INTEGER;
241:
242: BEGIN
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: FOR Csr1 in Get_hook_info('B', 'UPDATE_NOTE') LOOP
246:
247: /* user execute flag */
309:
310: END LOOP;
311:
312: EXCEPTION WHEN OTHERS THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: end update_note_pre;
315:
316:
317: /* Vertical Procedure for post processing in case of update note */
342: l_strBuffer VARCHAR2(2000);
343: l_execute_status INTEGER;
344:
345: BEGIN
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347:
348: FOR Csr1 in Get_hook_info('A', 'UPDATE_NOTE') LOOP
349:
350: /* user execute flag */
412:
413: END LOOP;
414:
415: EXCEPTION WHEN OTHERS THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417:
418: END;
419:
420: FUNCTION Ok_to_generate_msg