APPS.OZF_AUTOPAY_PVT dependencies on OZF_UTILITY_PVT

Line 474: l_claim_settle_rec.USER_STATUS_ID := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

470: CLOSE claim_info_csr;
471:
472: l_claim_settle_rec.claim_id := l_claim_id;
473: l_claim_settle_rec.object_version_number := l_object_version_number;
474: l_claim_settle_rec.USER_STATUS_ID := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
475: P_STATUS_TYPE=> G_CLAIM_STATUS,
476: P_STATUS_CODE=> G_CLOSED_STATUS
477: ));
478:

Line 920: l_org_id OZF_UTILITY_PVT.operating_units_tbl;

916: l_plan_id NUMBER;
917:
918: --Multiorg Changes
919: m NUMBER := 0;
920: l_org_id OZF_UTILITY_PVT.operating_units_tbl;
921:
922: BEGIN
923:
924: SAVEPOINT AutoPay;

Line 1143: OZF_UTILITY_PVT.write_conc_log;

1139: END IF;
1140:
1141: -- log query for debugging
1142: IF OZF_DEBUG_LOW_ON THEN
1143: OZF_UTILITY_PVT.write_conc_log;
1144: END IF;
1145:
1146: l_emp_csr := DBMS_SQL.open_cursor;
1147: FND_DSQL.set_cursor(l_emp_csr);

Line 1353: OZF_UTILITY_PVT.write_conc_log;

1349: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1350: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_amount );
1351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Success. ');
1352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1353: OZF_UTILITY_PVT.write_conc_log;
1354: ELSE
1355: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Autopay flag is not turned on in Trade Profile for customer '||l_cust_name_num);
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');

Line 1378: OZF_UTILITY_PVT.write_conc_log;

1374: EXCEPTION
1375: WHEN FND_API.G_EXC_ERROR THEN
1376: ROLLBACK TO AUTOPAY_CUST;
1377: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1378: OZF_UTILITY_PVT.write_conc_log;
1379: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1380: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

Line 1387: OZF_UTILITY_PVT.write_conc_log;

1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO AUTOPAY_CUST;
1386: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1387: OZF_UTILITY_PVT.write_conc_log;
1388: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1389: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

Line 1402: OZF_UTILITY_PVT.write_conc_log;

1398: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1399: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1400: FND_MSG_PUB.Add;
1401: END IF;
1402: OZF_UTILITY_PVT.write_conc_log;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);

Line 1432: OZF_UTILITY_PVT.Write_Conc_Log;

1428: FND_MSG_PUB.Add;
1429: END IF;
1430:
1431: -- Write all messages to a log
1432: OZF_UTILITY_PVT.Write_Conc_Log;
1433:
1434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
1436: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1443: OZF_UTILITY_PVT.Write_Conc_Log;

1439: EXCEPTION
1440: WHEN FND_API.g_exc_error THEN
1441: ROLLBACK TO AutoPay;
1442:
1443: OZF_UTILITY_PVT.Write_Conc_Log;
1444: ERRBUF := l_msg_data;
1445: RETCODE := 2;
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1453: OZF_UTILITY_PVT.Write_Conc_Log;

1449:
1450: WHEN FND_API.g_exc_unexpected_error THEN
1451: ROLLBACK TO AutoPay;
1452:
1453: OZF_UTILITY_PVT.Write_Conc_Log;
1454: ERRBUF := l_msg_data;
1455: RETCODE := 1; -- show status as warning if claim type/reason is missing, Fix for 5158782
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: ( Warning:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1463: OZF_UTILITY_PVT.Write_Conc_Log;

1459:
1460: WHEN OTHERS THEN
1461: ROLLBACK TO AutoPay;
1462:
1463: OZF_UTILITY_PVT.Write_Conc_Log;
1464: ERRBUF := l_msg_data;
1465: RETCODE := 2;
1466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
1467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));