DBA Data[Home] [Help]

APPS.INV_UPDATE_ONHAND_STATUS dependencies on FND_CONCURRENT

Line 69: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');

65:
66: --FETCH c_org_id bulk collect INTO orgid_list LIMIT l_bulk_limit;
67: IF (orgid_list.Count = 0) THEN
68: print_debug('No organization selected for given range. Please choose valid range');
69: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');
70:
71: x_retcode := 2;
72: x_errbuf := 'Error';
73: RETURN ;

Line 85: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');

81: IF c_org_id%ISOPEN THEN
82: CLOSE c_org_id;
83: END IF;
84:
85: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');
86:
87: x_retcode := 2;
88: x_errbuf := 'Error';
89:

Line 109: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');

105: WHEN OTHERS THEN
106: print_debug('Error updating the material statues');
107: print_debug('Error :'||substr(sqlerrm, 1, 200));
108:
109: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');
110:
111: x_retcode := 2;
112: x_errbuf := 'Error';
113: RETURN ;

Line 192: l_ret := fnd_concurrent.set_completion_status('NORMAL', 'Success');

188: END IF;
189:
190: END LOOP;
191:
192: l_ret := fnd_concurrent.set_completion_status('NORMAL', 'Success');
193:
194: x_retcode := 0;
195: x_errbuf := 'Success';
196:

Line 205: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');

201: IF c_moqd%ISOPEN THEN
202: CLOSE c_moqd;
203: END IF;
204:
205: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');
206:
207: x_retcode := 2;
208: x_errbuf := 'Error';
209: