DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on OZF_UTILITY_PVT

Line 366: OZF_Utility_PVT.debug_message('create_claim_for_cust START');

362:
363: BEGIN
364:
365: IF OZF_DEBUG_HIGH_ON THEN
366: OZF_Utility_PVT.debug_message('create_claim_for_cust START');
367: END IF;
368:
369: -- Initialize API return status to sucess
370: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

515: CLOSE claim_info_csr;
516:
517: l_claim_settle_rec.claim_id := l_claim_id;
518: l_claim_settle_rec.object_version_number := l_object_version_number;
519: l_claim_settle_rec.USER_STATUS_ID := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
520: P_STATUS_TYPE=> G_CLAIM_STATUS,
521: P_STATUS_CODE=> G_CLOSED_STATUS
522: ));
523:

Line 965: l_org_id OZF_UTILITY_PVT.operating_units_tbl;

961: l_plan_id NUMBER;
962:
963: --Multiorg Changes
964: m NUMBER := 0;
965: l_org_id OZF_UTILITY_PVT.operating_units_tbl;
966:
967: l_currency_rec OZF_CLAIM_ACCRUAL_PVT.currency_rec_type;
968:
969: BEGIN

Line 1197: OZF_UTILITY_PVT.write_conc_log;

1193: END IF;
1194:
1195: -- log query for debugging
1196: IF OZF_DEBUG_LOW_ON THEN
1197: OZF_UTILITY_PVT.write_conc_log;
1198: END IF;
1199:
1200: l_emp_csr := DBMS_SQL.open_cursor;
1201: FND_DSQL.set_cursor(l_emp_csr);

Line 1441: OZF_UTILITY_PVT.write_conc_log;

1437: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1438: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_amount );
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Success. ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1441: OZF_UTILITY_PVT.write_conc_log;
1442: ELSE
1443: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1444: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Autopay flag is not turned on in Trade Profile for customer '||l_cust_name_num);
1445: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');

Line 1466: OZF_UTILITY_PVT.write_conc_log;

1462: EXCEPTION
1463: WHEN FND_API.G_EXC_ERROR THEN
1464: ROLLBACK TO AUTOPAY_CUST;
1465: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1466: OZF_UTILITY_PVT.write_conc_log;
1467: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1468: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1469: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

Line 1475: OZF_UTILITY_PVT.write_conc_log;

1471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: ROLLBACK TO AUTOPAY_CUST;
1474: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1475: OZF_UTILITY_PVT.write_conc_log;
1476: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1477: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

Line 1490: OZF_UTILITY_PVT.write_conc_log;

1486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1487: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1488: FND_MSG_PUB.Add;
1489: END IF;
1490: OZF_UTILITY_PVT.write_conc_log;
1491: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1492: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);

Line 1520: OZF_UTILITY_PVT.Write_Conc_Log;

1516: FND_MSG_PUB.Add;
1517: END IF;
1518:
1519: -- Write all messages to a log
1520: OZF_UTILITY_PVT.Write_Conc_Log;
1521:
1522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
1524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1531: OZF_UTILITY_PVT.Write_Conc_Log;

1527: EXCEPTION
1528: WHEN FND_API.g_exc_error THEN
1529: ROLLBACK TO AutoPay;
1530:
1531: OZF_UTILITY_PVT.Write_Conc_Log;
1532: ERRBUF := l_msg_data;
1533: RETCODE := 2;
1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');
1535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1541: OZF_UTILITY_PVT.Write_Conc_Log;

1537:
1538: WHEN FND_API.g_exc_unexpected_error THEN
1539: ROLLBACK TO AutoPay;
1540:
1541: OZF_UTILITY_PVT.Write_Conc_Log;
1542: ERRBUF := l_msg_data;
1543: RETCODE := 1; -- show status as warning if claim type/reason is missing, Fix for 5158782
1544: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: ( Warning:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');
1545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1551: OZF_UTILITY_PVT.Write_Conc_Log;

1547:
1548: WHEN OTHERS THEN
1549: ROLLBACK TO AutoPay;
1550:
1551: OZF_UTILITY_PVT.Write_Conc_Log;
1552: ERRBUF := l_msg_data;
1553: RETCODE := 2;
1554: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
1555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));