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

162: END IF;
163: END IF;
164:
165:
166: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
167: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
168: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
169: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
170: -- Call action assembler if status is changed

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

163: END IF;
164:
165:
166: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
167: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
168: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
169: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
170: -- Call action assembler if status is changed
171: If p_chrv_rec.old_sts_code is not null AND

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

164:
165:
166: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
167: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
168: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
169: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
170: -- Call action assembler if status is changed
171: If p_chrv_rec.old_sts_code is not null AND
172: p_chrv_rec.new_sts_code is not null AND

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

165:
166: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_sts_code'||p_chrv_rec.old_sts_code);
167: FND_FILE.PUT_LINE( FND_FILE.LOG,'old_ste_code'||p_chrv_rec.old_ste_code);
168: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_sts_code'||p_chrv_rec.new_sts_code);
169: FND_FILE.PUT_LINE( FND_FILE.LOG,'new_ste_code'||p_chrv_rec.new_ste_code);
170: -- Call action assembler if status is changed
171: If p_chrv_rec.old_sts_code is not null AND
172: p_chrv_rec.new_sts_code is not null AND
173: p_chrv_rec.old_ste_code is not null AND

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

3011: BEGIN
3012: ----------------------------------------------------------------------------------------
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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');
3063: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3064: END;
3065:

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

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');
3063: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3064: END;
3065:
3066: PROCEDURE change_status (

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

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');
3063: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,'===============================================================');
3064: END;
3065:
3066: PROCEDURE change_status (
3067: ERRBUF OUT NOCOPY VARCHAR2,

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

3859: BEGIN
3860:
3861: savepoint H_STATUS;
3862: FND_MSG_PUB.initialize;
3863: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);

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

3860:
3861: savepoint H_STATUS;
3862: FND_MSG_PUB.initialize;
3863: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);

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

3861: savepoint H_STATUS;
3862: FND_MSG_PUB.initialize;
3863: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);

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

3862: FND_MSG_PUB.initialize;
3863: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);

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

3863: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3871: --

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

3864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' Start of Status Change Concurrent Program');
3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3871: --
3872: ERRBUF := NULL;

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

3865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'===============================================================');
3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3871: --
3872: ERRBUF := NULL;
3873: RETCODE := 0;

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

3866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Parameters for the Run:');
3867: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Last Run Date: ' || p_last_rundate);
3868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Category: ' || p_category);
3869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number From: ' || p_from_k ||'*'||p_from_m);
3870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Contract Number To: ' || p_to_k ||'*'||p_to_m);
3871: --
3872: ERRBUF := NULL;
3873: RETCODE := 0;
3874:

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

Line 3942: FND_FILE.PUT_LINE(FND_FILE.LOG,'when from-to contract number range with optional category and contract modifier is provided');

3938: c := 0;
3939: l_new_status := null;
3940: l_new_status_m := null;
3941:
3942: FND_FILE.PUT_LINE(FND_FILE.LOG,'when from-to contract number range with optional category and contract modifier is provided');
3943:
3944: FOR r_terminated in c_termn_hdr_all_cntr LOOP
3945:
3946:

Line 3948: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated' || C);

3944: FOR r_terminated in c_termn_hdr_all_cntr LOOP
3945:
3946:
3947: BEGIN
3948: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated' || C);
3949: if (C >= T) then
3950: commit;
3951: c := 0;
3952: end if;

Line 4122: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);

4118: FOR r_expired in c_expired_hdr_all_cntr LOOP
4119:
4120:
4121: BEGIN
4122: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);
4123: if (C >= T) then
4124: commit;
4125: c := 0;
4126: end if;

Line 4246: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active' || C);

4242: -- From Signed to Active
4243: FOR r_active in c_actv_hdr_all_cntr LOOP
4244:
4245: BEGIN
4246: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active' || C);
4247: if (C >= T) then
4248: commit;
4249: c := 0;
4250: end if;

Line 4374: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);

4370:
4371: FOR r_signed in c_sig_hdr_all_cntr LOOP
4372:
4373: BEGIN
4374: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);
4375: if (C >= T) then
4376: commit;
4377: c := 0;
4378: end if;

Line 4500: FND_FILE.PUT_LINE(FND_FILE.LOG,'when only contract from-to range is provided as input');

4496: c := 0;
4497: l_new_status := null;
4498: l_new_status_m := null;
4499:
4500: FND_FILE.PUT_LINE(FND_FILE.LOG,'when only contract from-to range is provided as input');
4501:
4502: FOR r_terminated in c_termn_hdr_only_contract LOOP
4503:
4504:

Line 4506: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated ' || C);

4502: FOR r_terminated in c_termn_hdr_only_contract LOOP
4503:
4504:
4505: BEGIN
4506: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated ' || C);
4507: if (C >= T) then
4508: commit;
4509: c := 0;
4510: end if;

Line 4557: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);

4553: x_msg_count => x_msg_count,
4554: x_msg_data => x_msg_data,
4555: p_chrv_rec => l_chr_rec,
4556: x_chrv_rec => i_chr_rec);
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
4558:
4559: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4560: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4561: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4580: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);

4576: p_estimated_amount => r_terminated.estimated_amount,
4577: P_K_STATUS_CODE => r_terminated.STS_CODE,
4578: p_term_date => r_terminated.date_terminated,
4579: p_term_reason => r_terminated.termination_reason);
4580: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
4581:
4582: --
4583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4584: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4597: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);

4593: p_init_msg_list => p_init_msg_list,
4594: x_return_status => l_return_status
4595: );
4596:
4597: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
4598:
4599: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4601: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 4619: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);

4615: p_k_num => r_terminated.contract_number,
4616: p_k_num_mod => r_terminated.contract_number_modifier,
4617: p_update_minor_version =>'N',
4618: x_return_status => l_return_status);
4619: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);
4620:
4621:
4622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4623: p_error_from_line := 'Y';

Line 4682: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);

4678: FOR r_expired in c_exp_hdr_only_contract LOOP
4679:
4680:
4681: BEGIN
4682: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);
4683: if (C >= T) then
4684: commit;
4685: c := 0;
4686: end if;

Line 4806: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active ' || C);

4802: -- From Signed to Active
4803: FOR r_active in c_actv_hdr_only_contract LOOP
4804:
4805: BEGIN
4806: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active ' || C);
4807: if (C >= T) then
4808: commit;
4809: c := 0;
4810: end if;

Line 4933: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);

4929:
4930: FOR r_signed in c_sig_hdr_only_contract LOOP
4931:
4932: BEGIN
4933: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);
4934: if (C >= T) then
4935: commit;
4936: c := 0;
4937: end if;

Line 5061: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category is provided as input ' || p_category);

5057: c := 0;
5058: l_new_status := null;
5059: l_new_status_m := null;
5060:
5061: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category is provided as input ' || p_category);
5062:
5063: FOR r_terminated in c_termn_hdr_only_category LOOP
5064:
5065:

Line 5067: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated' || C);

5063: FOR r_terminated in c_termn_hdr_only_category LOOP
5064:
5065:
5066: BEGIN
5067: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated' || C);
5068: if (C >= T) then
5069: commit;
5070: c := 0;
5071: end if;

Line 5118: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);

5114: x_msg_count => x_msg_count,
5115: x_msg_data => x_msg_data,
5116: p_chrv_rec => l_chr_rec,
5117: x_chrv_rec => i_chr_rec);
5118: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5119:
5120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5121: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5141: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);

5137: p_estimated_amount => r_terminated.estimated_amount,
5138: P_K_STATUS_CODE => r_terminated.STS_CODE,
5139: p_term_date => r_terminated.date_terminated,
5140: p_term_reason => r_terminated.termination_reason);
5141: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
5142:
5143: --
5144: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5145: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5158: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);

5154: p_init_msg_list => p_init_msg_list,
5155: x_return_status => l_return_status
5156: );
5157:
5158: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5159:
5160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5180: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);

5176: p_k_num => r_terminated.contract_number,
5177: p_k_num_mod => r_terminated.contract_number_modifier,
5178: p_update_minor_version =>'N',
5179: x_return_status => l_return_status);
5180: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);
5181:
5182:
5183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5184: p_error_from_line := 'Y';

Line 5243: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);

5239: FOR r_expired in c_exp_hdr_only_category LOOP
5240:
5241:
5242: BEGIN
5243: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);
5244: if (C >= T) then
5245: commit;
5246: c := 0;
5247: end if;

Line 5367: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active ' || C);

5363: -- From Signed to Active
5364: FOR r_active in c_actv_hdr_only_category LOOP
5365:
5366: BEGIN
5367: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active ' || C);
5368: if (C >= T) then
5369: commit;
5370: c := 0;
5371: end if;

Line 5494: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);

5490:
5491: FOR r_signed in c_sig_hdr_only_category LOOP
5492:
5493: BEGIN
5494: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);
5495: if (C >= T) then
5496: commit;
5497: c := 0;
5498: end if;

Line 5621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent request submitted with last_run_date as '||p_last_rundate);

5617: c := 0;
5618: l_new_status := null;
5619: l_new_status_m := null;
5620:
5621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent request submitted with last_run_date as '||p_last_rundate);
5622:
5623: FOR r_terminated in c_termn_hdr_all LOOP
5624:
5625:

Line 5627: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated' || C);

5623: FOR r_terminated in c_termn_hdr_all LOOP
5624:
5625:
5626: BEGIN
5627: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to terminated' || C);
5628: if (C >= T) then
5629: commit;
5630: c := 0;
5631: end if;

Line 5678: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);

5674: x_msg_count => x_msg_count,
5675: x_msg_data => x_msg_data,
5676: p_chrv_rec => l_chr_rec,
5677: x_chrv_rec => i_chr_rec);
5678: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5679:
5680: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5681: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5682: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5701: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);

5697: p_estimated_amount => r_terminated.estimated_amount,
5698: P_K_STATUS_CODE => r_terminated.STS_CODE,
5699: p_term_date => r_terminated.date_terminated,
5700: p_term_reason => r_terminated.termination_reason);
5701: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
5702:
5703: --
5704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5705: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5718: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);

5714: p_init_msg_list => p_init_msg_list,
5715: x_return_status => l_return_status
5716: );
5717:
5718: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5719:
5720: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 5740: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);

5736: p_k_num => r_terminated.contract_number,
5737: p_k_num_mod => r_terminated.contract_number_modifier,
5738: p_update_minor_version =>'N',
5739: x_return_status => l_return_status);
5740: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);
5741:
5742:
5743: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5744: p_error_from_line := 'Y';

Line 5803: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);

5799: FOR r_expired in c_expired_hdr_all LOOP
5800:
5801:
5802: BEGIN
5803: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active, signed to expired' || C);
5804: if (C >= T) then
5805: commit;
5806: c := 0;
5807: end if;

Line 5927: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active ' || C);

5923: -- From Signed to Active
5924: FOR r_active in c_active_hdr_all LOOP
5925:
5926: BEGIN
5927: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from signed to active ' || C);
5928: if (C >= T) then
5929: commit;
5930: c := 0;
5931: end if;

Line 6054: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);

6050:
6051: FOR r_signed in c_signed_hdr_all LOOP
6052:
6053: BEGIN
6054: FND_FILE.PUT_LINE(FND_FILE.LOG,'C from active to signed ' || C);
6055: if (C >= T) then
6056: commit;
6057: c := 0;
6058: end if;