DBA Data[Home] [Help]

APPS.OZF_THRESHOLD_PVT dependencies on FND_FILE

Line 1037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Budget Threshold ........ ');

1033:
1034: OPEN c_trans_seq;
1035: FETCH c_trans_seq INTO l_trans_id;
1036: CLOSE c_trans_seq;
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Budget Threshold ........ ');
1038: FOR rule IN c_threshold_rules_cur
1039: LOOP
1040: BEGIN
1041: FOR budget IN c_threshold_funds(rule.threshold_rule_id)

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Budget Threshold ........ ');

1293: ozf_utility_pvt.write_conc_log(l_msg_data);
1294: OZF_UTILITY_PVT.debug_message( 'End of Budget Threshold ........ ');
1295: OZF_UTILITY_PVT.debug_message( 'Start of Quota Threshold ........ ');
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Budget Threshold ........ ');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Quota Threshold ........ ');
1299: OZF_QUOTA_THRESHOLD_PVT.validate_quota_threshold(
1300: x_errbuf => l_errbuf,
1301: x_retcode => l_retcode);

Line 1298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Quota Threshold ........ ');

1294: OZF_UTILITY_PVT.debug_message( 'End of Budget Threshold ........ ');
1295: OZF_UTILITY_PVT.debug_message( 'Start of Quota Threshold ........ ');
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Budget Threshold ........ ');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Quota Threshold ........ ');
1299: OZF_QUOTA_THRESHOLD_PVT.validate_quota_threshold(
1300: x_errbuf => l_errbuf,
1301: x_retcode => l_retcode);
1302: IF l_retcode <> 0 THEN

Line 1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN Quota Threshold ........ l_errbuf :' || l_errbuf);

1301: x_retcode => l_retcode);
1302: IF l_retcode <> 0 THEN
1303: x_errbuf := l_errbuf;
1304: x_retcode := l_retcode;
1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN Quota Threshold ........ l_errbuf :' || l_errbuf);
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: COMMIT;
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Quota Threshold ........ ');

Line 1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Quota Threshold ........ ');

1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN Quota Threshold ........ l_errbuf :' || l_errbuf);
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: COMMIT;
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Quota Threshold ........ ');
1310: OZF_UTILITY_PVT.debug_message( 'End of Quota Threshold ........ ');
1311: EXCEPTION
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN

Line 1315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);

1311: EXCEPTION
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);
1316: x_retcode := 1;
1317: x_errbuf := l_msg_data;
1318: ozf_utility_pvt.write_conc_log(x_errbuf);
1319:

Line 1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);

1318: ozf_utility_pvt.write_conc_log(x_errbuf);
1319:
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);
1323: x_retcode := 1;
1324: x_errbuf := l_msg_data;
1325: ozf_utility_pvt.write_conc_log(x_errbuf);
1326:

Line 1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);

1325: ozf_utility_pvt.write_conc_log(x_errbuf);
1326:
1327: WHEN OTHERS THEN
1328: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);
1330: x_retcode := 1;
1331: x_errbuf := l_msg_data;
1332: ozf_utility_pvt.write_conc_log(x_errbuf);
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);

Line 1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);

1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);
1330: x_retcode := 1;
1331: x_errbuf := l_msg_data;
1332: ozf_utility_pvt.write_conc_log(x_errbuf);
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);
1334: END validate_threshold;
1335:
1336: END Ozf_Threshold_Pvt;
1337: