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_FILE

Line 77: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

73: PROCEDURE get_fnd_msg_stack(p_msg_data IN VARCHAR2) IS
74: BEGIN
75: -- IF FND_MSG_PUB.Count_Msg > 1 Then
76: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
77: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
78: END LOOP;
79: -- ELSE
80: --FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get);
81: -- FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);

Line 80: --FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get);

76: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
77: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
78: END LOOP;
79: -- ELSE
80: --FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get);
81: -- FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);
82: -- END IF;
83: FND_MSG_PUB.initialize;
84:

Line 81: -- FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);

77: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
78: END LOOP;
79: -- ELSE
80: --FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get);
81: -- FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);
82: -- END IF;
83: FND_MSG_PUB.initialize;
84:
85: END get_fnd_msg_stack;

Line 152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);

148: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
149: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
150: WHERE ID = p_chrv_rec.id;
151:
152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
153: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
154: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
155: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
156: -- Call action assembler if status is changed

Line 153: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);

149: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
150: WHERE ID = p_chrv_rec.id;
151:
152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
153: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
154: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
155: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
156: -- Call action assembler if status is changed
157: If p_chrv_rec.old_sts_code is not null AND

Line 154: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);

150: WHERE ID = p_chrv_rec.id;
151:
152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
153: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
154: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
155: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
156: -- Call action assembler if status is changed
157: If p_chrv_rec.old_sts_code is not null AND
158: p_chrv_rec.new_sts_code is not null AND

Line 155: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);

151:
152: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
153: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
154: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
155: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
156: -- Call action assembler if status is changed
157: If p_chrv_rec.old_sts_code is not null AND
158: p_chrv_rec.new_sts_code is not null AND
159: p_chrv_rec.old_ste_code is not null AND

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 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 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 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 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 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 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 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 2995: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');

2991: BEGIN
2992: ----------------------------------------------------------------------------------------
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

Line 2996: FND_FILE.PUT_LINE( FND_FILE.LOG,' ');

2992: ----------------------------------------------------------------------------------------
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,'--------------------------------------');

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 3000: 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);
3003: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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 3004: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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);
3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

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 3008: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

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);
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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 3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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);
3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');

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 3016: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');

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');
3020: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);

Line 3018: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

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');
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');

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 3021: 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;
3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

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 3025: FND_FILE.PUT_LINE( FND_FILE.LOG,'--------------------------------------');

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);
3028: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET);
3029: FND_MESSAGE.set_name('OKC','OKC_LINE_NUM_TOTAL');

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 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 3032: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'--------------------------------------');

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

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 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 3041: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');

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');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3044: END;
3045:

Line 3042: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,' End of Status Change Concurrent Program');

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');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3044: END;
3045:
3046: PROCEDURE change_status (

Line 3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');

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');
3043: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3044: END;
3045:
3046: PROCEDURE change_status (
3047: ERRBUF OUT NOCOPY VARCHAR2,

Line 3235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');

3231: BEGIN
3232:
3233: savepoint H_STATUS;
3234: FND_MSG_PUB.initialize;
3235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);

Line 3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');

3232:
3233: savepoint H_STATUS;
3234: FND_MSG_PUB.initialize;
3235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);

Line 3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');

3233: savepoint H_STATUS;
3234: FND_MSG_PUB.initialize;
3235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);

Line 3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');

3234: FND_MSG_PUB.initialize;
3235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);

Line 3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);

3235: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3243: --

Line 3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);

3236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3243: --
3244: ERRBUF := NULL;

Line 3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);

3237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3243: --
3244: ERRBUF := NULL;
3245: RETCODE := 0;

Line 3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);

3238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3243: --
3244: ERRBUF := NULL;
3245: RETCODE := 0;
3246:

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 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;