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 303: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');

299: p_type IN VARCHAR2) IS
300: BEGIN
301: if p_type='S' Then
302: /*
303: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
304: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
305: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
306: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
307: FND_MESSAGE.set_token('STATUS', p_status);

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

300: BEGIN
301: if p_type='S' Then
302: /*
303: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
304: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
305: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
306: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
307: FND_MESSAGE.set_token('STATUS', p_status);
308: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

301: if p_type='S' Then
302: /*
303: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
304: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
305: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
306: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
307: FND_MESSAGE.set_token('STATUS', p_status);
308: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
309: */

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

302: /*
303: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
304: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
305: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
306: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
307: FND_MESSAGE.set_token('STATUS', p_status);
308: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
309: */
310: NULL;

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

303: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_SUCCESS');
304: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
305: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
306: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
307: FND_MESSAGE.set_token('STATUS', p_status);
308: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
309: */
310: NULL;
311: elsif p_type='E'Then

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

304: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
305: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
306: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
307: FND_MESSAGE.set_token('STATUS', p_status);
308: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
309: */
310: NULL;
311: elsif p_type='E'Then
312: get_fnd_msg_stack(p_msg_data);

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

309: */
310: NULL;
311: elsif p_type='E'Then
312: get_fnd_msg_stack(p_msg_data);
313: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
314: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
315: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
316: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
317: FND_MESSAGE.set_token('STATUS', p_status);

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

310: NULL;
311: elsif p_type='E'Then
312: get_fnd_msg_stack(p_msg_data);
313: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
314: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
315: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
316: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
317: FND_MESSAGE.set_token('STATUS', p_status);
318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

311: elsif p_type='E'Then
312: get_fnd_msg_stack(p_msg_data);
313: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
314: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
315: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
316: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
317: FND_MESSAGE.set_token('STATUS', p_status);
318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
319: elsif p_type='U'Then

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

312: get_fnd_msg_stack(p_msg_data);
313: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
314: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
315: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
316: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
317: FND_MESSAGE.set_token('STATUS', p_status);
318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
319: elsif p_type='U'Then
320: get_fnd_msg_stack(p_msg_data);

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

313: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
314: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
315: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
316: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
317: FND_MESSAGE.set_token('STATUS', p_status);
318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
319: elsif p_type='U'Then
320: get_fnd_msg_stack(p_msg_data);
321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);

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

314: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
315: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
316: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
317: FND_MESSAGE.set_token('STATUS', p_status);
318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
319: elsif p_type='U'Then
320: get_fnd_msg_stack(p_msg_data);
321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);

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

317: FND_MESSAGE.set_token('STATUS', p_status);
318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
319: elsif p_type='U'Then
320: get_fnd_msg_stack(p_msg_data);
321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');

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

318: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
319: elsif p_type='U'Then
320: get_fnd_msg_stack(p_msg_data);
321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);

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

319: elsif p_type='U'Then
320: get_fnd_msg_stack(p_msg_data);
321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);

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

320: get_fnd_msg_stack(p_msg_data);
321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

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

321: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
329: FND_MESSAGE.set_token('STATUS', p_status);

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

322: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
329: FND_MESSAGE.set_token('STATUS', p_status);
330: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

323: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
329: FND_MESSAGE.set_token('STATUS', p_status);
330: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
331: end if;

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

324: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
329: FND_MESSAGE.set_token('STATUS', p_status);
330: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
331: end if;
332: end line_message;

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

325: FND_MESSAGE.set_name('OKC','OKC_LINE_STS_CHANGE_FAILURE');
326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
329: FND_MESSAGE.set_token('STATUS', p_status);
330: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
331: end if;
332: end line_message;
333:

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

326: FND_MESSAGE.set_token('CONTRACT_NUMBER',p_knum_and_mod);
327: FND_MESSAGE.set_token('LINE_NUMBER',p_line_number);
328: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
329: FND_MESSAGE.set_token('STATUS', p_status);
330: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
331: end if;
332: end line_message;
333:
334:

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

2977: p_type IN VARCHAR2) IS
2978: BEGIN
2979: if p_type='S' Then
2980: /*
2981: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2982: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2983: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2984: FND_MESSAGE.set_token('STATUS', p_status);
2985: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

2978: BEGIN
2979: if p_type='S' Then
2980: /*
2981: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2982: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2983: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2984: FND_MESSAGE.set_token('STATUS', p_status);
2985: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2986: */

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

2979: if p_type='S' Then
2980: /*
2981: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2982: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2983: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2984: FND_MESSAGE.set_token('STATUS', p_status);
2985: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2986: */
2987: NULL;

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

2980: /*
2981: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2982: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2983: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2984: FND_MESSAGE.set_token('STATUS', p_status);
2985: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2986: */
2987: NULL;
2988: elsif p_type='E'Then

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

2981: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_SUCCESS');
2982: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2983: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2984: FND_MESSAGE.set_token('STATUS', p_status);
2985: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2986: */
2987: NULL;
2988: elsif p_type='E'Then
2989: get_fnd_msg_stack(p_msg_data);

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

2987: NULL;
2988: elsif p_type='E'Then
2989: get_fnd_msg_stack(p_msg_data);
2990: p_hdr_errors := p_hdr_errors +1 ;
2991: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2992: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2993: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2994: FND_MESSAGE.set_token('STATUS', p_status);
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

2988: elsif p_type='E'Then
2989: get_fnd_msg_stack(p_msg_data);
2990: p_hdr_errors := p_hdr_errors +1 ;
2991: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2992: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2993: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2994: FND_MESSAGE.set_token('STATUS', p_status);
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2996: elsif p_type='U'Then

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

2989: get_fnd_msg_stack(p_msg_data);
2990: p_hdr_errors := p_hdr_errors +1 ;
2991: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2992: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2993: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2994: FND_MESSAGE.set_token('STATUS', p_status);
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2996: elsif p_type='U'Then
2997: get_fnd_msg_stack(p_msg_data);

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

2990: p_hdr_errors := p_hdr_errors +1 ;
2991: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2992: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2993: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2994: FND_MESSAGE.set_token('STATUS', p_status);
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2996: elsif p_type='U'Then
2997: get_fnd_msg_stack(p_msg_data);
2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);

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

2991: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
2992: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
2993: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
2994: FND_MESSAGE.set_token('STATUS', p_status);
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2996: elsif p_type='U'Then
2997: get_fnd_msg_stack(p_msg_data);
2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);

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

2994: FND_MESSAGE.set_token('STATUS', p_status);
2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2996: elsif p_type='U'Then
2997: get_fnd_msg_stack(p_msg_data);
2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');

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

2995: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
2996: elsif p_type='U'Then
2997: get_fnd_msg_stack(p_msg_data);
2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);

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

2996: elsif p_type='U'Then
2997: get_fnd_msg_stack(p_msg_data);
2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);

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

2997: get_fnd_msg_stack(p_msg_data);
2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
3005: FND_MESSAGE.set_token('STATUS', p_status);

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

2998: FND_MESSAGE.set_name('OKC',G_UNEXPECTED_ERROR);
2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
3005: FND_MESSAGE.set_token('STATUS', p_status);
3006: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

2999: FND_MESSAGE.set_token(G_SQLCODE_TOKEN,SQLCODE);
3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
3005: FND_MESSAGE.set_token('STATUS', p_status);
3006: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3007: end if;

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

3000: FND_MESSAGE.set_token(G_SQLERRM_TOKEN,SQLERRM);
3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
3005: FND_MESSAGE.set_token('STATUS', p_status);
3006: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3007: end if;
3008: end header_message;

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

3001: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
3005: FND_MESSAGE.set_token('STATUS', p_status);
3006: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3007: end if;
3008: end header_message;
3009:

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

3002: FND_MESSAGE.set_name('OKC','OKC_HDR_STS_CHANGE_FAILURE');
3003: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_knum_and_mod);
3004: FND_MESSAGE.set_token('OLD_STATUS', p_old_status);
3005: FND_MESSAGE.set_token('STATUS', p_status);
3006: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3007: end if;
3008: end header_message;
3009:
3010: PROCEDURE WrapUp IS

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

3013: ---LOG MESSAGES (SUMMARY)
3014: ----------------------------------------------------------------------------------------
3015: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
3017: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3019: IF p_hdr_errors > 0 or p_line_errors > 0 then
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3021: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');

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

3014: ----------------------------------------------------------------------------------------
3015: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');
3017: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3019: IF p_hdr_errors > 0 or p_line_errors > 0 then
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3021: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3022: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);

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

3017: FND_MESSAGE.set_name('OKC','OKC_SUMMARY');
3018: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3019: IF p_hdr_errors > 0 or p_line_errors > 0 then
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3021: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3022: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3023: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');

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

3018: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3019: IF p_hdr_errors > 0 or p_line_errors > 0 then
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3021: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3022: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3023: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);

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

3019: IF p_hdr_errors > 0 or p_line_errors > 0 then
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3021: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3022: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3023: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

3021: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3022: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3023: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');

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

3022: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3023: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);

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

3023: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

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

3025: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3033: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');

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

3026: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3033: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3034: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);

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

3027: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3033: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3034: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

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

3029: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_ERRORS');
3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3033: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3034: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3037: ELSE

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

3030: FND_MESSAGE.set_token('HEADER_ERROR', p_hdr_errors);
3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3033: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3034: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3037: ELSE
3038: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

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

3031: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3033: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_ERRORS');
3034: FND_MESSAGE.set_token('LINE_ERRORS', p_line_errors);
3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3037: ELSE
3038: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3039: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');

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

3035: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3036: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3037: ELSE
3038: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3039: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3040: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3042: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

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

3036: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3037: ELSE
3038: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3039: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3040: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3042: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3044: END IF;

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

3038: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3039: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3040: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3042: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3044: END IF;
3045: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');

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

3039: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3040: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3042: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3044: END IF;
3045: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);

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

3042: FND_MESSAGE.set_name('OKC','OKC_NO_ERRORS');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3044: END IF;
3045: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3048: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);

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

3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3044: END IF;
3045: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3048: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

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

3044: END IF;
3045: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3048: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');

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

3045: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');
3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3048: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');

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

3046: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3048: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);

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

3047: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3048: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

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

3049: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3056: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3057: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);

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

3050: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3056: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3057: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3058: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);

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

3051: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3056: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3057: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3058: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3059:

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

3052: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');
3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3056: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3057: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3058: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3059:
3060: --Comments

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

3053: FND_MESSAGE.set_name('OKC','OKC_HDR_NUM_TOTAL');
3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3056: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3057: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3058: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3059:
3060: --Comments
3061: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');

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

3054: FND_MESSAGE.set_token('HEADER_TOTAL', p_hdr_count);
3055: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3056: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');
3057: FND_MESSAGE.set_token('LINE_TOTAL', p_line_count);
3058: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3059:
3060: --Comments
3061: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3062: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,' End of Status Change Concurrent Program');

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

3874:
3875: -- Bug 5086847 --
3876: IF (p_from_m IS NOT NULL) AND (p_from_k IS NULL) THEN
3877:
3878: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3879: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3880:
3881: RETCODE := 2;
3882: return;

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

3875: -- Bug 5086847 --
3876: IF (p_from_m IS NOT NULL) AND (p_from_k IS NULL) THEN
3877:
3878: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3879: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3880:
3881: RETCODE := 2;
3882: return;
3883: END IF;

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

3883: END IF;
3884:
3885: IF (p_to_m IS NOT NULL) AND (p_to_k IS NULL) THEN
3886:
3887: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3888: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3889:
3890: RETCODE := 2;
3891: return;

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

3884:
3885: IF (p_to_m IS NOT NULL) AND (p_to_k IS NULL) THEN
3886:
3887: FND_MESSAGE.set_name('OKC','OKC_ENTER_K_NUMBER');
3888: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,FND_MESSAGE.GET);
3889:
3890: RETCODE := 2;
3891: return;
3892: END IF;