eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_STATUS_CHANGE_PVT dependencies on FND_MESSAGE

Line 289: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');

285: p_type IN VARCHAR2) IS
286: BEGIN
287: if p_type='S' Then
288: /*
289: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
293: FND_MESSAGE.set_token('STATUS', p_status);

Line 290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);

286: BEGIN
287: if p_type='S' Then
288: /*
289: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
293: FND_MESSAGE.set_token('STATUS', p_status);
294: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);

287: if p_type='S' Then
288: /*
289: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
293: FND_MESSAGE.set_token('STATUS', p_status);
294: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
295: */

Line 292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

288: /*
289: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
293: FND_MESSAGE.set_token('STATUS', p_status);
294: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
295: */
296: NULL;

Line 293: FND_MESSAGE.set_token('STATUS', p_status);

289: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
293: FND_MESSAGE.set_token('STATUS', p_status);
294: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
295: */
296: NULL;
297: elsif p_type='E'Then

Line 294: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

290: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
291: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
292: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
293: FND_MESSAGE.set_token('STATUS', p_status);
294: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
295: */
296: NULL;
297: elsif p_type='E'Then
298: get_fnd_msg_stack(p_msg_data);

Line 299: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');

295: */
296: NULL;
297: elsif p_type='E'Then
298: get_fnd_msg_stack(p_msg_data);
299: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
303: FND_MESSAGE.set_token('STATUS', p_status);

Line 300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);

296: NULL;
297: elsif p_type='E'Then
298: get_fnd_msg_stack(p_msg_data);
299: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
303: FND_MESSAGE.set_token('STATUS', p_status);
304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);

297: elsif p_type='E'Then
298: get_fnd_msg_stack(p_msg_data);
299: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
303: FND_MESSAGE.set_token('STATUS', p_status);
304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
305: elsif p_type='U'Then

Line 302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

298: get_fnd_msg_stack(p_msg_data);
299: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
303: FND_MESSAGE.set_token('STATUS', p_status);
304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
305: elsif p_type='U'Then
306: get_fnd_msg_stack(p_msg_data);

Line 303: FND_MESSAGE.set_token('STATUS', p_status);

299: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
303: FND_MESSAGE.set_token('STATUS', p_status);
304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
305: elsif p_type='U'Then
306: get_fnd_msg_stack(p_msg_data);
307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);

Line 304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

300: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
301: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
302: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
303: FND_MESSAGE.set_token('STATUS', p_status);
304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
305: elsif p_type='U'Then
306: get_fnd_msg_stack(p_msg_data);
307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);

Line 307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);

303: FND_MESSAGE.set_token('STATUS', p_status);
304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
305: elsif p_type='U'Then
306: get_fnd_msg_stack(p_msg_data);
307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');

Line 308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);

304: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
305: elsif p_type='U'Then
306: get_fnd_msg_stack(p_msg_data);
307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);

Line 309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);

305: elsif p_type='U'Then
306: get_fnd_msg_stack(p_msg_data);
307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);

Line 310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

306: get_fnd_msg_stack(p_msg_data);
307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

Line 311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');

307: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
315: FND_MESSAGE.set_token('STATUS', p_status);

Line 312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);

308: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
315: FND_MESSAGE.set_token('STATUS', p_status);
316: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);

309: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
315: FND_MESSAGE.set_token('STATUS', p_status);
316: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
317: end if;

Line 314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

310: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
315: FND_MESSAGE.set_token('STATUS', p_status);
316: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
317: end if;
318: end line_message;

Line 315: FND_MESSAGE.set_token('STATUS', p_status);

311: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
315: FND_MESSAGE.set_token('STATUS', p_status);
316: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
317: end if;
318: end line_message;
319:

Line 316: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

312: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
313: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
314: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
315: FND_MESSAGE.set_token('STATUS', p_status);
316: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
317: end if;
318: end line_message;
319:
320:

Line 2961: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');

2957: p_type IN VARCHAR2) IS
2958: BEGIN
2959: if p_type='S' Then
2960: /*
2961: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2962: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2963: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2964: FND_MESSAGE.set_token('STATUS', p_status);
2965: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 2962: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);

2958: BEGIN
2959: if p_type='S' Then
2960: /*
2961: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2962: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2963: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2964: FND_MESSAGE.set_token('STATUS', p_status);
2965: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2966: */

Line 2963: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

2959: if p_type='S' Then
2960: /*
2961: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2962: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2963: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2964: FND_MESSAGE.set_token('STATUS', p_status);
2965: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2966: */
2967: NULL;

Line 2964: FND_MESSAGE.set_token('STATUS', p_status);

2960: /*
2961: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2962: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2963: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2964: FND_MESSAGE.set_token('STATUS', p_status);
2965: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2966: */
2967: NULL;
2968: elsif p_type='E'Then

Line 2965: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

2961: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2962: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2963: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2964: FND_MESSAGE.set_token('STATUS', p_status);
2965: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2966: */
2967: NULL;
2968: elsif p_type='E'Then
2969: get_fnd_msg_stack(p_msg_data);

Line 2971: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');

2967: NULL;
2968: elsif p_type='E'Then
2969: get_fnd_msg_stack(p_msg_data);
2970: p_hdr_errors := p_hdr_errors +1 ;
2971: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2972: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2973: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2974: FND_MESSAGE.set_token('STATUS', p_status);
2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 2972: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);

2968: elsif p_type='E'Then
2969: get_fnd_msg_stack(p_msg_data);
2970: p_hdr_errors := p_hdr_errors +1 ;
2971: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2972: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2973: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2974: FND_MESSAGE.set_token('STATUS', p_status);
2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2976: elsif p_type='U'Then

Line 2973: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

2969: get_fnd_msg_stack(p_msg_data);
2970: p_hdr_errors := p_hdr_errors +1 ;
2971: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2972: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2973: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2974: FND_MESSAGE.set_token('STATUS', p_status);
2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2976: elsif p_type='U'Then
2977: get_fnd_msg_stack(p_msg_data);

Line 2974: FND_MESSAGE.set_token('STATUS', p_status);

2970: p_hdr_errors := p_hdr_errors +1 ;
2971: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2972: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2973: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2974: FND_MESSAGE.set_token('STATUS', p_status);
2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2976: elsif p_type='U'Then
2977: get_fnd_msg_stack(p_msg_data);
2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);

Line 2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

2971: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2972: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2973: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2974: FND_MESSAGE.set_token('STATUS', p_status);
2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2976: elsif p_type='U'Then
2977: get_fnd_msg_stack(p_msg_data);
2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);

Line 2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);

2974: FND_MESSAGE.set_token('STATUS', p_status);
2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2976: elsif p_type='U'Then
2977: get_fnd_msg_stack(p_msg_data);
2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');

Line 2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);

2975: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2976: elsif p_type='U'Then
2977: get_fnd_msg_stack(p_msg_data);
2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);

Line 2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);

2976: elsif p_type='U'Then
2977: get_fnd_msg_stack(p_msg_data);
2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

Line 2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

2977: get_fnd_msg_stack(p_msg_data);
2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2985: FND_MESSAGE.set_token('STATUS', p_status);

Line 2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');

2978: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2985: FND_MESSAGE.set_token('STATUS', p_status);
2986: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);

2979: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2985: FND_MESSAGE.set_token('STATUS', p_status);
2986: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2987: end if;

Line 2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

2980: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2985: FND_MESSAGE.set_token('STATUS', p_status);
2986: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2987: end if;
2988: end header_message;

Line 2985: FND_MESSAGE.set_token('STATUS', p_status);

2981: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2985: FND_MESSAGE.set_token('STATUS', p_status);
2986: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2987: end if;
2988: end header_message;
2989:

Line 2986: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

2982: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2983: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2984: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2985: FND_MESSAGE.set_token('STATUS', p_status);
2986: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2987: end if;
2988: end header_message;
2989:
2990: PROCEDURE WrapUp IS

Line 2997: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');

2993: ---LOG MESSAGES (SUMMARY)
2994: ----------------------------------------------------------------------------------------
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
2996: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
2997: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');
2998: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2999: IF p_hdr_errors > 0 or p_line_errors > 0 then
3000: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');

Line 2998: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

2994: ----------------------------------------------------------------------------------------
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
2996: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
2997: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');
2998: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2999: IF p_hdr_errors > 0 or p_line_errors > 0 then
3000: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);

Line 3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');

2997: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');
2998: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2999: IF p_hdr_errors > 0 or p_line_errors > 0 then
3000: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');

Line 3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);

2998: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2999: IF p_hdr_errors > 0 or p_line_errors > 0 then
3000: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);

Line 3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

2999: IF p_hdr_errors > 0 or p_line_errors > 0 then
3000: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');

3001: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');

Line 3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);

3002: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);

Line 3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');

3005: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');

Line 3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);

3006: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3014: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);

Line 3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3007: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3014: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3015: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');

3009: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3014: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3015: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3017: ELSE

Line 3014: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);

3010: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3014: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3015: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3017: ELSE
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

Line 3015: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3011: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3013: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3014: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3015: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3017: ELSE
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3019: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');

Line 3019: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');

3015: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3017: ELSE
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3019: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3022: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 3020: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3017: ELSE
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3019: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3022: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3024: END IF;

Line 3022: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');

3018: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3019: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3022: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3024: END IF;
3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');

Line 3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3019: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3021: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3022: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3024: END IF;
3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);

Line 3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');

3022: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3024: END IF;
3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);

Line 3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);

3023: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3024: END IF;
3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

3024: END IF;
3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');

Line 3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');

3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');

Line 3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);

3026: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);

Line 3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

3027: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');

3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);

Line 3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);

3030: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3038: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3031: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3038: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3039:

Line 3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');

3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3038: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3039:
3040: --Comments

Line 3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);

3033: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3038: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3039:
3040: --Comments
3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');

Line 3038: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3034: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3037: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3038: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3039:
3040: --Comments
3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3042: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,' End of Status Change Concurrent Program');

Line 3250: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');

3246:
3247: -- Bug 5086847 --
3248: IF (p_from_m IS NOT NULL) AND (p_from_k IS NULL) THEN
3249:
3250: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3251: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3252:
3253: RETCODE := 2;
3254: return;

Line 3251: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3247: -- Bug 5086847 --
3248: IF (p_from_m IS NOT NULL) AND (p_from_k IS NULL) THEN
3249:
3250: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3251: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3252:
3253: RETCODE := 2;
3254: return;
3255: END IF;

Line 3259: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');

3255: END IF;
3256:
3257: IF (p_to_m IS NOT NULL) AND (p_to_k IS NULL) THEN
3258:
3259: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3260: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3261:
3262: RETCODE := 2;
3263: return;

Line 3260: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

3256:
3257: IF (p_to_m IS NOT NULL) AND (p_to_k IS NULL) THEN
3258:
3259: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3260: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3261:
3262: RETCODE := 2;
3263: return;
3264: END IF;