DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PUB dependencies on FND_FILE

Line 110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');

106: END IF;
107:
108: SELECT count(*) INTO l_count1 FROM OKL_TRX_AP_INVOICES_B;
109:
110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');
111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);

Line 111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

107:
108: SELECT count(*) INTO l_count1 FROM OKL_TRX_AP_INVOICES_B;
109:
110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');
111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);

Line 112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);

108: SELECT count(*) INTO l_count1 FROM OKL_TRX_AP_INVOICES_B;
109:
110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');
111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);
116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');

Line 113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);

109:
110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');
111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);
116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');
117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

Line 114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);

110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');
111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);
116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');
117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
118: --dbms_output.put_line('From Consolidated Invoice Date:'||l_from_date);

Line 115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);

111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);
116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');
117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
118: --dbms_output.put_line('From Consolidated Invoice Date:'||l_from_date);
119: --dbms_output.put_line('To Consolidated Invoice Date:'||l_to_date);

Line 116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');

112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);
116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');
117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
118: --dbms_output.put_line('From Consolidated Invoice Date:'||l_from_date);
119: --dbms_output.put_line('To Consolidated Invoice Date:'||l_to_date);
120: auto_disbursement( p_api_version => l_api_vesrions,

Line 117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Consolidated Invoice Date:'||l_from_date);
114: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Consolidated Invoice Date:'||l_to_date);
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number:'||p_contract_number);
116: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages If Any For Each Consolidated Invoice');
117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
118: --dbms_output.put_line('From Consolidated Invoice Date:'||l_from_date);
119: --dbms_output.put_line('To Consolidated Invoice Date:'||l_to_date);
120: auto_disbursement( p_api_version => l_api_vesrions,
121: p_init_msg_list => OKC_API.G_FALSE,

Line 134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));

130: SELECT count(*) INTO l_count2 FROM OKL_TRX_AP_INVOICES_B;
131:
132: l_count := l_count2 - l_count1;
133:
134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));
135: --FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count2));
136:
137:
138: IF lx_msg_count >= 1 THEN

Line 135: --FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count2));

131:
132: l_count := l_count2 - l_count1;
133:
134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));
135: --FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count2));
136:
137:
138: IF lx_msg_count >= 1 THEN
139: FOR i in 1..lx_msg_count LOOP

Line 145: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || lx_msg_data);

141: p_encoded => 'F',
142: p_data => lx_msg_data,
143: p_msg_index_out => l_msg_index_out);
144:
145: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || lx_msg_data);
146: END LOOP;
147: END IF;
148: EXCEPTION
149: WHEN OTHERS THEN

Line 151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

147: END IF;
148: EXCEPTION
149: WHEN OTHERS THEN
150:
151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
152: --dbms_output.put_line('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
153:
154: END;
155: