54: x_msg_data => errbuf,
55: p_contract_number => p_contract_number,
56: p_asset_number => p_asset_number);
57:
58: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Property Tax Reconciliation');
59: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
60: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||SYSDATE);
61: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
62: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Messages For Each Record:');
55: p_contract_number => p_contract_number,
56: p_asset_number => p_asset_number);
57:
58: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Property Tax Reconciliation');
59: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
60: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||SYSDATE);
61: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
62: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Messages For Each Record:');
63:
56: p_asset_number => p_asset_number);
57:
58: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Property Tax Reconciliation');
59: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
60: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||SYSDATE);
61: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
62: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Messages For Each Record:');
63:
64: BEGIN
57:
58: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Property Tax Reconciliation');
59: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
60: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||SYSDATE);
61: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
62: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Messages For Each Record:');
63:
64: BEGIN
65: IF lx_msg_count > 0 THEN
58: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Property Tax Reconciliation');
59: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
60: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Program Run Date:'||SYSDATE);
61: FND_FILE.PUT_LINE (FND_FILE.LOG, '***********************************************');
62: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Detailed Error Messages For Each Record:');
63:
64: BEGIN
65: IF lx_msg_count > 0 THEN
66: FOR i IN 1..lx_msg_count LOOP
67: fnd_msg_pub.get (p_msg_index => i,
68: p_encoded => 'F',
69: p_data => lx_msg_data,
70: p_msg_index_out => l_msg_index_out);
71: FND_FILE.PUT_LINE (FND_FILE.LOG,TO_CHAR(i) || ': ' || lx_msg_data);
72: END LOOP;
73: END IF;
74: EXCEPTION
75: WHEN OTHERS THEN
72: END LOOP;
73: END IF;
74: EXCEPTION
75: WHEN OTHERS THEN
76: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
77: END;
78:
79: END create_adjust_invoice_conc;
80: