832: --RAISE;
833: --errbuf := l_where_str1;
834: retcode := 2;
835: WHEN no_data_found THEN
836: FND_MESSAGE.set_name('MST','MST_PQ_INADEQUATE_FILTER' ); --'Inadequate Filter Conditions.');
837: errbuf := FND_MESSAGE.GET;
838: --errbuf := 'No logical conditions';
839: retcode := 2;
840: WHEN OTHERS THEN
833: --errbuf := l_where_str1;
834: retcode := 2;
835: WHEN no_data_found THEN
836: FND_MESSAGE.set_name('MST','MST_PQ_INADEQUATE_FILTER' ); --'Inadequate Filter Conditions.');
837: errbuf := FND_MESSAGE.GET;
838: --errbuf := 'No logical conditions';
839: retcode := 2;
840: WHEN OTHERS THEN
841: IF cur_definition%ISOPEN THEN
958: IF l_executed = 0 THEN
959: RAISE execution_failed;
960: END IF;
961: IF g_select_all IS NULL THEN
962: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
963: g_select_all:= FND_MESSAGE.GET;
964: --g_select_all := 'All';
965: END IF;
966: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
959: RAISE execution_failed;
960: END IF;
961: IF g_select_all IS NULL THEN
962: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
963: g_select_all:= FND_MESSAGE.GET;
964: --g_select_all := 'All';
965: END IF;
966: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
967: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
2396: IF l_executed = 0 THEN
2397: RAISE execution_failed;
2398: END IF;
2399: IF g_select_all IS NULL THEN
2400: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
2401: g_select_all:= FND_MESSAGE.GET;
2402: --g_select_all := 'All';
2403: END IF;
2404: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
2397: RAISE execution_failed;
2398: END IF;
2399: IF g_select_all IS NULL THEN
2400: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
2401: g_select_all:= FND_MESSAGE.GET;
2402: --g_select_all := 'All';
2403: END IF;
2404: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
2405: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
2660: IF l_executed = 0 THEN
2661: RAISE execution_failed;
2662: END IF;
2663: IF g_select_all IS NULL THEN
2664: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
2665: g_select_all:= FND_MESSAGE.GET;
2666: --g_select_all := 'All';
2667: END IF;
2668: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
2661: RAISE execution_failed;
2662: END IF;
2663: IF g_select_all IS NULL THEN
2664: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
2665: g_select_all:= FND_MESSAGE.GET;
2666: --g_select_all := 'All';
2667: END IF;
2668: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
2669: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
3823: IF l_executed = 0 THEN
3824: RAISE execution_failed;
3825: END IF;
3826: IF g_select_all IS NULL THEN
3827: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
3828: g_select_all:= FND_MESSAGE.GET;
3829: --g_select_all := 'All';
3830: END IF;
3831: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
3824: RAISE execution_failed;
3825: END IF;
3826: IF g_select_all IS NULL THEN
3827: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
3828: g_select_all:= FND_MESSAGE.GET;
3829: --g_select_all := 'All';
3830: END IF;
3831: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
3832: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||