[Home] [Help]
490: )
491: IS
492: cursor query_c is
493: select query_name, query_id, query_string
494: from jtf_fm_queries_all
495: where query_id = p_query_id;
496:
497: l_Error_Msg VARCHAR2(240);
498: l_amount INTEGER;
579: DBMS_LOB.CLOSE(l_file_data);
580:
581: JTF_FM_UTL_V.PRINT_MESSAGE('Uploaded Query into FND_LOBS ',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
582:
583: update jtf_fm_queries_all set file_id = x_query_file_id
584: where query_id = p_query_id;
585:
586: COMMIT;
587:
593:
594: exception
595: when others then
596: ROLLBACK TO query_status;
597: l_Error_Msg := 'Could not find Query Details in JTF_FM_QUERIES_ALL table';
598: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
599: RAISE FND_API.G_EXC_ERROR;
600:
601: END INSERT_QUERY;
613: )
614: IS
615: cursor query_c is
616: select query_name, query_id, query_string
617: from jtf_fm_queries_all
618: where query_id = p_query_id;
619:
620: l_Error_Msg VARCHAR2(2000);
621: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_AND_INSERT_QUERY';
637:
638: exception
639: when others then
640: ROLLBACK TO query_status;
641: l_Error_Msg := 'Could not find Query Details in JTF_FM_QUERIES_ALL table';
642: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
643: RAISE FND_API.G_EXC_ERROR;
644:
645: END CHECK_AND_INSERT_QUERY;
3390: END IF; -- EMAIL, PRINTER, FAX
3391:
3392: --Gagan's code ends here
3393:
3394: select file_id into l_query_file_id from jtf_fm_queries_all where query_id = x_query_id;
3395:
3396: IF l_query_file_id IS NOT NULL THEN
3397: JTF_FM_UTL_V.PRINT_MESSAGE('Query has file id :' || l_query_file_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3398: CHECK_AND_INSERT_QUERY(x_query_id, l_query_file_id, x_query_file_id);