eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_UTILITY_PVT dependencies on OZF_UTILITY_PVT

Line 79: OZF_Utility_PVT.debug_message(l_full_name||': start');

75: -- Standard Start of API savepoint
76: SAVEPOINT Check_Claim_ACC;
77:
78: IF OZF_DEBUG_HIGH_ON THEN
79: OZF_Utility_PVT.debug_message(l_full_name||': start');
80: END IF;
81:
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 126: OZF_Utility_PVT.debug_message('user_id='||p_user_id||' update_access is '||l_access);

122: END IF;
123: END IF;
124:
125: IF OZF_DEBUG_HIGH_ON THEN
126: OZF_Utility_PVT.debug_message('user_id='||p_user_id||' update_access is '||l_access);
127: OZF_Utility_PVT.debug_message('claim access is '||x_access);
128: END IF;
129:
130: --

Line 127: OZF_Utility_PVT.debug_message('claim access is '||x_access);

123: END IF;
124:
125: IF OZF_DEBUG_HIGH_ON THEN
126: OZF_Utility_PVT.debug_message('user_id='||p_user_id||' update_access is '||l_access);
127: OZF_Utility_PVT.debug_message('claim access is '||x_access);
128: END IF;
129:
130: --
131: -- End of API body

Line 140: OZF_Utility_PVT.debug_message(l_full_name||': end');

136: COMMIT WORK;
137: END IF;
138:
139: IF OZF_DEBUG_HIGH_ON THEN
140: OZF_Utility_PVT.debug_message(l_full_name||': end');
141: END IF;
142:
143: -- Standard call to get message count and if count is 1, get message info.
144: FND_MSG_PUB.Count_And_Get

Line 322: OZF_Utility_PVT.debug_message(l_full_name||': start');

318: BEGIN
319: SAVEPOINT CREATE_LOG;
320:
321: IF OZF_DEBUG_HIGH_ON THEN
322: OZF_Utility_PVT.debug_message(l_full_name||': start');
323: END IF;
324:
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Rule Based Settlement Report --------------------------------_*');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date & Time: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 859: OZF_Utility_PVT.write_conc_log('------------------------------ Claims Rule Based Settlement Log ------------------------------');

855:
856: SAVEPOINT RuleBased;
857:
858:
859: OZF_Utility_PVT.write_conc_log('*------------------------------ Claims Rule Based Settlement Log ------------------------------*');
860: OZF_Utility_PVT.write_conc_log('Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
861: OZF_Utility_PVT.write_conc_log('*-------------------------------------------------------------------------------------------------*');
862:
863: IF OZF_DEBUG_HIGH_ON THEN

Line 860: OZF_Utility_PVT.write_conc_log('Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

856: SAVEPOINT RuleBased;
857:
858:
859: OZF_Utility_PVT.write_conc_log('*------------------------------ Claims Rule Based Settlement Log ------------------------------*');
860: OZF_Utility_PVT.write_conc_log('Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
861: OZF_Utility_PVT.write_conc_log('*-------------------------------------------------------------------------------------------------*');
862:
863: IF OZF_DEBUG_HIGH_ON THEN
864: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 861: OZF_Utility_PVT.write_conc_log('-------------------------------------------------------------------------------------------------');

857:
858:
859: OZF_Utility_PVT.write_conc_log('*------------------------------ Claims Rule Based Settlement Log ------------------------------*');
860: OZF_Utility_PVT.write_conc_log('Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
861: OZF_Utility_PVT.write_conc_log('*-------------------------------------------------------------------------------------------------*');
862:
863: IF OZF_DEBUG_HIGH_ON THEN
864: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
865: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

Line 872: OZF_Utility_PVT.write_conc_log('Start Rule Based Settlement');

868:
869:
870:
871: IF OZF_DEBUG_HIGH_ON THEN
872: OZF_Utility_PVT.write_conc_log('Start Rule Based Settlement');
873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');
874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);

Line 873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');

869:
870:
871: IF OZF_DEBUG_HIGH_ON THEN
872: OZF_Utility_PVT.write_conc_log('Start Rule Based Settlement');
873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');
874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);
877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);

Line 874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);

870:
871: IF OZF_DEBUG_HIGH_ON THEN
872: OZF_Utility_PVT.write_conc_log('Start Rule Based Settlement');
873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');
874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);
877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);
878: OZF_Utility_PVT.write_conc_log('--- End Parameter List -----');

Line 875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);

871: IF OZF_DEBUG_HIGH_ON THEN
872: OZF_Utility_PVT.write_conc_log('Start Rule Based Settlement');
873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');
874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);
877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);
878: OZF_Utility_PVT.write_conc_log('--- End Parameter List -----');
879:

Line 876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);

872: OZF_Utility_PVT.write_conc_log('Start Rule Based Settlement');
873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');
874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);
877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);
878: OZF_Utility_PVT.write_conc_log('--- End Parameter List -----');
879:
880:

Line 877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);

873: OZF_Utility_PVT.write_conc_log('--- Start Parameter List ---');
874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);
877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);
878: OZF_Utility_PVT.write_conc_log('--- End Parameter List -----');
879:
880:
881: END IF;

Line 878: OZF_Utility_PVT.write_conc_log('--- End Parameter List -----');

874: OZF_Utility_PVT.write_conc_log('l_org_id: ' || l_org_id);
875: OZF_Utility_PVT.write_conc_log('p_start_date: ' || p_start_date);
876: OZF_Utility_PVT.write_conc_log('p_end_date: ' || p_end_date);
877: OZF_Utility_PVT.write_conc_log('p_pay_to_customer: ' || p_pay_to_customer);
878: OZF_Utility_PVT.write_conc_log('--- End Parameter List -----');
879:
880:
881: END IF;
882:

Line 889: OZF_Utility_PVT.write_conc_log('Processing Claims for Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id));

885: FETCH chk_rule_based_csr INTO l_enable_rule_based,l_cust_name_match_type,l_cre_threshold_type,l_cre_threshold_val;
886: CLOSE chk_rule_based_csr;
887:
888: IF OZF_DEBUG_HIGH_ON THEN
889: OZF_Utility_PVT.write_conc_log('Processing Claims for Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id));
890: OZF_Utility_PVT.write_conc_log('Rule Based Settlement : '|| l_enable_rule_based);
891: OZF_Utility_PVT.write_conc_log('Customer Name Matching Type : ' || l_cust_name_match_type);
892: OZF_Utility_PVT.write_conc_log('Cr Threshold Type : ' || l_cre_threshold_type);
893: OZF_Utility_PVT.write_conc_log('Cr Threshold Value : ' || l_cre_threshold_val);

Line 890: OZF_Utility_PVT.write_conc_log('Rule Based Settlement : '|| l_enable_rule_based);

886: CLOSE chk_rule_based_csr;
887:
888: IF OZF_DEBUG_HIGH_ON THEN
889: OZF_Utility_PVT.write_conc_log('Processing Claims for Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id));
890: OZF_Utility_PVT.write_conc_log('Rule Based Settlement : '|| l_enable_rule_based);
891: OZF_Utility_PVT.write_conc_log('Customer Name Matching Type : ' || l_cust_name_match_type);
892: OZF_Utility_PVT.write_conc_log('Cr Threshold Type : ' || l_cre_threshold_type);
893: OZF_Utility_PVT.write_conc_log('Cr Threshold Value : ' || l_cre_threshold_val);
894: END IF;

Line 891: OZF_Utility_PVT.write_conc_log('Customer Name Matching Type : ' || l_cust_name_match_type);

887:
888: IF OZF_DEBUG_HIGH_ON THEN
889: OZF_Utility_PVT.write_conc_log('Processing Claims for Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id));
890: OZF_Utility_PVT.write_conc_log('Rule Based Settlement : '|| l_enable_rule_based);
891: OZF_Utility_PVT.write_conc_log('Customer Name Matching Type : ' || l_cust_name_match_type);
892: OZF_Utility_PVT.write_conc_log('Cr Threshold Type : ' || l_cre_threshold_type);
893: OZF_Utility_PVT.write_conc_log('Cr Threshold Value : ' || l_cre_threshold_val);
894: END IF;
895:

Line 892: OZF_Utility_PVT.write_conc_log('Cr Threshold Type : ' || l_cre_threshold_type);

888: IF OZF_DEBUG_HIGH_ON THEN
889: OZF_Utility_PVT.write_conc_log('Processing Claims for Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id));
890: OZF_Utility_PVT.write_conc_log('Rule Based Settlement : '|| l_enable_rule_based);
891: OZF_Utility_PVT.write_conc_log('Customer Name Matching Type : ' || l_cust_name_match_type);
892: OZF_Utility_PVT.write_conc_log('Cr Threshold Type : ' || l_cre_threshold_type);
893: OZF_Utility_PVT.write_conc_log('Cr Threshold Value : ' || l_cre_threshold_val);
894: END IF;
895:
896:

Line 893: OZF_Utility_PVT.write_conc_log('Cr Threshold Value : ' || l_cre_threshold_val);

889: OZF_Utility_PVT.write_conc_log('Processing Claims for Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id));
890: OZF_Utility_PVT.write_conc_log('Rule Based Settlement : '|| l_enable_rule_based);
891: OZF_Utility_PVT.write_conc_log('Customer Name Matching Type : ' || l_cust_name_match_type);
892: OZF_Utility_PVT.write_conc_log('Cr Threshold Type : ' || l_cre_threshold_type);
893: OZF_Utility_PVT.write_conc_log('Cr Threshold Value : ' || l_cre_threshold_val);
894: END IF;
895:
896:
897: IF(l_enable_rule_based = 'F') THEN

Line 899: OZF_Utility_PVT.write_conc_log('Rule Based Flag is disabled in System Parameter page for Operating unit :' ||MO_GLOBAL.get_ou_name(l_org_id));

895:
896:
897: IF(l_enable_rule_based = 'F') THEN
898:
899: OZF_Utility_PVT.write_conc_log('Rule Based Flag is disabled in System Parameter page for Operating unit :' ||MO_GLOBAL.get_ou_name(l_org_id));
900: OZF_Utility_PVT.write_conc_log('Please Enable the Rule Based Settlement checkbox to process the deductions');
901:
902: ELSE
903:

Line 900: OZF_Utility_PVT.write_conc_log('Please Enable the Rule Based Settlement checkbox to process the deductions');

896:
897: IF(l_enable_rule_based = 'F') THEN
898:
899: OZF_Utility_PVT.write_conc_log('Rule Based Flag is disabled in System Parameter page for Operating unit :' ||MO_GLOBAL.get_ou_name(l_org_id));
900: OZF_Utility_PVT.write_conc_log('Please Enable the Rule Based Settlement checkbox to process the deductions');
901:
902: ELSE
903:
904: OZF_Utility_PVT.write_conc_log('Proceed with Rule Based Engine');

Line 904: OZF_Utility_PVT.write_conc_log('Proceed with Rule Based Engine');

900: OZF_Utility_PVT.write_conc_log('Please Enable the Rule Based Settlement checkbox to process the deductions');
901:
902: ELSE
903:
904: OZF_Utility_PVT.write_conc_log('Proceed with Rule Based Engine');
905:
906:
907: IF p_start_date IS NOT NULL THEN
908: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS');

Line 927: OZF_Utility_PVT.write_conc_log('Operating Unit: ' || l_org_id);

923: END IF ;
924:
925:
926: IF OZF_DEBUG_HIGH_ON THEN
927: OZF_Utility_PVT.write_conc_log('Operating Unit: ' || l_org_id);
928: OZF_Utility_PVT.write_conc_log('Start Date: ' || l_start_date);
929: OZF_Utility_PVT.write_conc_log('End Date: ' || l_end_date);
930: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_cust_account_number);
931: END IF;

Line 928: OZF_Utility_PVT.write_conc_log('Start Date: ' || l_start_date);

924:
925:
926: IF OZF_DEBUG_HIGH_ON THEN
927: OZF_Utility_PVT.write_conc_log('Operating Unit: ' || l_org_id);
928: OZF_Utility_PVT.write_conc_log('Start Date: ' || l_start_date);
929: OZF_Utility_PVT.write_conc_log('End Date: ' || l_end_date);
930: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_cust_account_number);
931: END IF;
932:

Line 929: OZF_Utility_PVT.write_conc_log('End Date: ' || l_end_date);

925:
926: IF OZF_DEBUG_HIGH_ON THEN
927: OZF_Utility_PVT.write_conc_log('Operating Unit: ' || l_org_id);
928: OZF_Utility_PVT.write_conc_log('Start Date: ' || l_start_date);
929: OZF_Utility_PVT.write_conc_log('End Date: ' || l_end_date);
930: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_cust_account_number);
931: END IF;
932:
933: OPEN open_ded_csr (l_cust_account_number,l_start_date,l_end_date);

Line 930: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_cust_account_number);

926: IF OZF_DEBUG_HIGH_ON THEN
927: OZF_Utility_PVT.write_conc_log('Operating Unit: ' || l_org_id);
928: OZF_Utility_PVT.write_conc_log('Start Date: ' || l_start_date);
929: OZF_Utility_PVT.write_conc_log('End Date: ' || l_end_date);
930: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_cust_account_number);
931: END IF;
932:
933: OPEN open_ded_csr (l_cust_account_number,l_start_date,l_end_date);
934: LOOP

Line 953: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');

949:
950:
951:
952: IF OZF_DEBUG_HIGH_ON THEN
953: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);
955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));

Line 954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);

950:
951:
952: IF OZF_DEBUG_HIGH_ON THEN
953: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);
955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));

Line 955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');

951:
952: IF OZF_DEBUG_HIGH_ON THEN
953: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);
955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));

Line 956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));

952: IF OZF_DEBUG_HIGH_ON THEN
953: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);
955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));

Line 957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));

953: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);
955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));

Line 958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));

954: OZF_Utility_PVT.write_conc_log('START : Fetching Claim ' || i);
955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));

Line 959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));

955: OZF_Utility_PVT.write_conc_log('-------------------------------------------------');
956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));

Line 960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));

956: OZF_Utility_PVT.write_conc_log('Claim ID: ' || l_claimidTbl(i));
957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));

Line 961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));

957: OZF_Utility_PVT.write_conc_log('Claim Number: ' || l_claimTbl(i));
958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));

Line 962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));

958: OZF_Utility_PVT.write_conc_log('Claim Amount: ' || l_amountTbl(i));
959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));

Line 963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));

959: OZF_Utility_PVT.write_conc_log('Claim Acctd Amount: ' || l_acctdamountTbl(i));
960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));

Line 964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));

960: OZF_Utility_PVT.write_conc_log('Customer Reference: ' || l_custrefdTbl(i));
961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));
968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));

Line 965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));

961: OZF_Utility_PVT.write_conc_log('Customer Reference Norm: ' || l_custrefnormTbl(i));
962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));
968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));
969: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_offerIdTbl(i));

Line 966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));

962: OZF_Utility_PVT.write_conc_log('Customer Account: ' || l_custaccountTbl(i));
963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));
968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));
969: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_offerIdTbl(i));
970: END IF;

Line 967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));

963: OZF_Utility_PVT.write_conc_log('Customer Bill To: ' || l_custbilltositeTbl(i));
964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));
968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));
969: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_offerIdTbl(i));
970: END IF;
971:

Line 968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));

964: OZF_Utility_PVT.write_conc_log('Claim Obj Version#: ' || l_claimobjverTbl(i));
965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));
968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));
969: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_offerIdTbl(i));
970: END IF;
971:
972: -- For 100% Credit Match

Line 969: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_offerIdTbl(i));

965: OZF_Utility_PVT.write_conc_log('Claim Currency Code: ' || l_curcodeTbl(i));
966: OZF_Utility_PVT.write_conc_log('Claim PAD#: ' || l_padTbl(i));
967: OZF_Utility_PVT.write_conc_log('Claim PAD NORM#: ' || l_padnormTbl(i));
968: OZF_Utility_PVT.write_conc_log('Claim Site Used Id: ' || l_siteUseIdTbl(i));
969: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_offerIdTbl(i));
970: END IF;
971:
972: -- For 100% Credit Match
973: IF(l_cust_name_match_type = 'EXCLUDE_REL_CUST') THEN

Line 977: OZF_Utility_PVT.write_conc_log('100% Credit Match - Exclude Related Customer ');

973: IF(l_cust_name_match_type = 'EXCLUDE_REL_CUST') THEN
974: OPEN csr_exact_cm_exc_cust(l_custaccountTbl(i),l_curcodeTbl(i),l_siteUseIdTbl(i),l_amountTbl(i),l_custrefnormTbl(i));
975: FETCH csr_exact_cm_exc_cust INTO l_trx_id,l_trx_number,l_crditmemo_amount;
976: IF OZF_DEBUG_HIGH_ON THEN
977: OZF_Utility_PVT.write_conc_log('100% Credit Match - Exclude Related Customer ');
978: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
979: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
980: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
981: END IF;

Line 978: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);

974: OPEN csr_exact_cm_exc_cust(l_custaccountTbl(i),l_curcodeTbl(i),l_siteUseIdTbl(i),l_amountTbl(i),l_custrefnormTbl(i));
975: FETCH csr_exact_cm_exc_cust INTO l_trx_id,l_trx_number,l_crditmemo_amount;
976: IF OZF_DEBUG_HIGH_ON THEN
977: OZF_Utility_PVT.write_conc_log('100% Credit Match - Exclude Related Customer ');
978: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
979: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
980: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
981: END IF;
982: CLOSE csr_exact_cm_exc_cust;

Line 979: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);

975: FETCH csr_exact_cm_exc_cust INTO l_trx_id,l_trx_number,l_crditmemo_amount;
976: IF OZF_DEBUG_HIGH_ON THEN
977: OZF_Utility_PVT.write_conc_log('100% Credit Match - Exclude Related Customer ');
978: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
979: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
980: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
981: END IF;
982: CLOSE csr_exact_cm_exc_cust;
983: ELSIF(l_cust_name_match_type = 'INCLUDE_REL_CUST') THEN

Line 980: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);

976: IF OZF_DEBUG_HIGH_ON THEN
977: OZF_Utility_PVT.write_conc_log('100% Credit Match - Exclude Related Customer ');
978: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
979: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
980: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
981: END IF;
982: CLOSE csr_exact_cm_exc_cust;
983: ELSIF(l_cust_name_match_type = 'INCLUDE_REL_CUST') THEN
984: OPEN csr_exact_cm_rel_cust(l_custaccountTbl(i),l_claimidTbl(i),l_curcodeTbl(i),l_amountTbl(i),l_custrefnormTbl(i));

Line 987: OZF_Utility_PVT.write_conc_log('100% Credit Match - Include Related Customer');

983: ELSIF(l_cust_name_match_type = 'INCLUDE_REL_CUST') THEN
984: OPEN csr_exact_cm_rel_cust(l_custaccountTbl(i),l_claimidTbl(i),l_curcodeTbl(i),l_amountTbl(i),l_custrefnormTbl(i));
985: FETCH csr_exact_cm_rel_cust INTO l_trx_id,l_trx_number,l_crditmemo_amount;
986: IF OZF_DEBUG_HIGH_ON THEN
987: OZF_Utility_PVT.write_conc_log('100% Credit Match - Include Related Customer');
988: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
989: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
990: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
991: END IF;

Line 988: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);

984: OPEN csr_exact_cm_rel_cust(l_custaccountTbl(i),l_claimidTbl(i),l_curcodeTbl(i),l_amountTbl(i),l_custrefnormTbl(i));
985: FETCH csr_exact_cm_rel_cust INTO l_trx_id,l_trx_number,l_crditmemo_amount;
986: IF OZF_DEBUG_HIGH_ON THEN
987: OZF_Utility_PVT.write_conc_log('100% Credit Match - Include Related Customer');
988: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
989: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
990: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
991: END IF;
992: CLOSE csr_exact_cm_rel_cust;

Line 989: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);

985: FETCH csr_exact_cm_rel_cust INTO l_trx_id,l_trx_number,l_crditmemo_amount;
986: IF OZF_DEBUG_HIGH_ON THEN
987: OZF_Utility_PVT.write_conc_log('100% Credit Match - Include Related Customer');
988: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
989: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
990: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
991: END IF;
992: CLOSE csr_exact_cm_rel_cust;
993: END IF;

Line 990: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);

986: IF OZF_DEBUG_HIGH_ON THEN
987: OZF_Utility_PVT.write_conc_log('100% Credit Match - Include Related Customer');
988: OZF_Utility_PVT.write_conc_log('l_trx_id: ' ||l_trx_id);
989: OZF_Utility_PVT.write_conc_log('l_trx_number: ' || l_trx_number);
990: OZF_Utility_PVT.write_conc_log('l_crditmemo_amount: ' || l_crditmemo_amount);
991: END IF;
992: CLOSE csr_exact_cm_rel_cust;
993: END IF;
994:

Line 1004: ozf_utility_pvt.get_default_user_status(

1000: l_claim_rec.payment_reference_id := l_trx_id;
1001: l_claim_rec.object_version_number := l_claimobjverTbl(i);
1002: l_claim_rec.status_code := 'CLOSED';
1003: l_claim_rec.user_status_id := to_number(
1004: ozf_utility_pvt.get_default_user_status(
1005: p_status_type => 'OZF_CLAIM_STATUS',
1006: p_status_code => l_claim_rec.status_code));
1007: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
1008: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

Line 1024: OZF_Utility_PVT.write_conc_log('Return Status for 100%: ' || l_return_status);

1020: ,p_event => 'UPDATE'
1021: ,p_mode => 'AUTO'
1022: ,x_object_version_number => l_object_version_number
1023: );
1024: OZF_Utility_PVT.write_conc_log('Return Status for 100%: ' || l_return_status);
1025:
1026: IF l_return_status = fnd_api.g_ret_sts_success THEN
1027: l_cm_match_found := 'T';
1028: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1061: OZF_Utility_PVT.write_conc_log('Possible Match - Exclude Related Customer');

1057:
1058:
1059: IF(l_cust_name_match_type = 'EXCLUDE_REL_CUST') THEN
1060: IF OZF_DEBUG_HIGH_ON THEN
1061: OZF_Utility_PVT.write_conc_log('Possible Match - Exclude Related Customer');
1062: END IF;
1063:
1064: OPEN csr_poss_cm_exc_cust(l_custaccountTbl(i),l_curcodeTbl(i),l_siteUseIdTbl(i),l_lower_thres_amount,l_upper_thres_amount,l_custrefnormTbl(i));
1065: LOOP

Line 1079: OZF_Utility_PVT.write_conc_log('Possible Match - l_trx_id :' || l_trx_id);

1075: l_possiblematchTbl(l_possible_count).currency_code := l_curcodeTbl(i);
1076: l_possiblematchTbl(l_possible_count).customer_trx_id := l_trx_id;
1077:
1078: IF OZF_DEBUG_HIGH_ON THEN
1079: OZF_Utility_PVT.write_conc_log('Possible Match - l_trx_id :' || l_trx_id);
1080: END IF;
1081:
1082: IF(l_trx_id IS NOT NULL) THEN
1083: l_cm_match_found := 'T';

Line 1092: OZF_Utility_PVT.write_conc_log('Possible Match - Include Related Customer');

1088: CLOSE csr_poss_cm_exc_cust;
1089:
1090: ELSIF(l_cust_name_match_type = 'INCLUDE_REL_CUST') THEN
1091: IF OZF_DEBUG_HIGH_ON THEN
1092: OZF_Utility_PVT.write_conc_log('Possible Match - Include Related Customer');
1093: END IF;
1094:
1095:
1096: OPEN csr_poss_cm_rel_cust(l_custaccountTbl(i),l_claimidTbl(i),l_curcodeTbl(i),l_lower_thres_amount,l_upper_thres_amount,l_custrefnormTbl(i));

Line 1110: OZF_Utility_PVT.write_conc_log('Possible Match - l_trx_id :' || l_trx_id);

1106: l_possiblematchTbl(l_possible_count).currency_code := l_curcodeTbl(i);
1107: l_possiblematchTbl(l_possible_count).customer_trx_id := l_trx_id;
1108:
1109: IF OZF_DEBUG_HIGH_ON THEN
1110: OZF_Utility_PVT.write_conc_log('Possible Match - l_trx_id :' || l_trx_id);
1111: END IF;
1112:
1113: IF(l_trx_id IS NOT NULL) THEN
1114: l_cm_match_found := 'T';

Line 1124: OZF_Utility_PVT.write_conc_log('l_possiblematchTbl.count :' || l_possiblematchTbl.count);

1120:
1121: END IF;
1122: -- If possible match found then go to next deduction
1123: IF OZF_DEBUG_HIGH_ON THEN
1124: OZF_Utility_PVT.write_conc_log('l_possiblematchTbl.count :' || l_possiblematchTbl.count);
1125: OZF_Utility_PVT.write_conc_log('l_cm_match_found :' || l_cm_match_found);
1126: END IF;
1127:
1128: IF (l_possiblematchTbl.count > 0 AND l_cm_match_found = 'T' )THEN

Line 1125: OZF_Utility_PVT.write_conc_log('l_cm_match_found :' || l_cm_match_found);

1121: END IF;
1122: -- If possible match found then go to next deduction
1123: IF OZF_DEBUG_HIGH_ON THEN
1124: OZF_Utility_PVT.write_conc_log('l_possiblematchTbl.count :' || l_possiblematchTbl.count);
1125: OZF_Utility_PVT.write_conc_log('l_cm_match_found :' || l_cm_match_found);
1126: END IF;
1127:
1128: IF (l_possiblematchTbl.count > 0 AND l_cm_match_found = 'T' )THEN
1129: GOTO END_OF_DEDUCTION;

Line 1141: OZF_Utility_PVT.write_conc_log('Offer Found: ' || l_offer_code);

1137: l_list_header_id := l_offerIdTbl(i);
1138: l_offer_code := l_padnormTbl(i);
1139:
1140: IF OZF_DEBUG_HIGH_ON THEN
1141: OZF_Utility_PVT.write_conc_log('Offer Found: ' || l_offer_code);
1142: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_list_header_id);
1143: END IF;
1144:
1145:

Line 1142: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_list_header_id);

1138: l_offer_code := l_padnormTbl(i);
1139:
1140: IF OZF_DEBUG_HIGH_ON THEN
1141: OZF_Utility_PVT.write_conc_log('Offer Found: ' || l_offer_code);
1142: OZF_Utility_PVT.write_conc_log('Offer ID: ' || l_list_header_id);
1143: END IF;
1144:
1145:
1146: IF l_list_header_id IS NULL THEN

Line 1148: OZF_Utility_PVT.write_conc_log('Invalid PAD Number ' || l_padnormTbl(i));

1144:
1145:
1146: IF l_list_header_id IS NULL THEN
1147: IF OZF_DEBUG_HIGH_ON THEN
1148: OZF_Utility_PVT.write_conc_log('Invalid PAD Number ' || l_padnormTbl(i));
1149: END IF;
1150:
1151: ELSE
1152:

Line 1187: OZF_Utility_PVT.write_conc_log('Claim Line Deleted');

1183: END IF;
1184: END IF; -- End of delete claim line
1185:
1186: IF OZF_DEBUG_HIGH_ON THEN
1187: OZF_Utility_PVT.write_conc_log('Claim Line Deleted');
1188: END IF;
1189:
1190: l_claim_line_rec.claim_id := l_claimidTbl(i);
1191: l_claim_line_rec.activity_type := 'OFFR';

Line 1218: OZF_Utility_PVT.write_conc_log('Claim Line Created');

1214: RAISE FND_API.g_exc_unexpected_error;
1215: END IF;
1216:
1217: IF OZF_DEBUG_HIGH_ON THEN
1218: OZF_Utility_PVT.write_conc_log('Claim Line Created');
1219: OZF_Utility_PVT.write_conc_log('New Claim Line Created' || l_claim_line_id);
1220: END IF;
1221:
1222: -- Associate Accruals to Claim Line

Line 1219: OZF_Utility_PVT.write_conc_log('New Claim Line Created' || l_claim_line_id);

1215: END IF;
1216:
1217: IF OZF_DEBUG_HIGH_ON THEN
1218: OZF_Utility_PVT.write_conc_log('Claim Line Created');
1219: OZF_Utility_PVT.write_conc_log('New Claim Line Created' || l_claim_line_id);
1220: END IF;
1221:
1222: -- Associate Accruals to Claim Line
1223: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim_Line(

Line 1234: OZF_Utility_PVT.write_conc_log('Return Status for Asso_Accruals_To_Claim_Line: ' || l_return_status);

1230: ,x_msg_data => l_msg_data
1231: ,p_claim_line_id => l_claim_line_id
1232: );
1233:
1234: OZF_Utility_PVT.write_conc_log('Return Status for Asso_Accruals_To_Claim_Line: ' || l_return_status);
1235:
1236: IF l_return_status = FND_API.g_ret_sts_error THEN
1237: RAISE FND_API.g_exc_error;
1238: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1261: ozf_utility_pvt.get_default_user_status(

1257: l_claim_rec.payment_method := 'CREDIT_MEMO';
1258: l_claim_rec.object_version_number := l_claimobjverTbl(i);
1259: l_claim_rec.status_code := 'CLOSED';
1260: l_claim_rec.user_status_id := to_number(
1261: ozf_utility_pvt.get_default_user_status(
1262: p_status_type => 'OZF_CLAIM_STATUS',
1263: p_status_code => l_claim_rec.status_code));
1264: l_claim_rec.request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
1265: l_claim_rec.program_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

Line 1304: OZF_Utility_PVT.write_conc_log('Expected errors:l_msg_count' || l_msg_count);

1300:
1301: EXCEPTION
1302: WHEN FND_API.g_exc_error THEN
1303: ROLLBACK TO Update_Claim_From_Association;
1304: OZF_Utility_PVT.write_conc_log('Expected errors:l_msg_count' || l_msg_count);
1305: IF OZF_DEBUG_HIGH_ON THEN
1306: OZF_UTILITY_PVT.write_conc_log;
1307: ELSE
1308: FOR I IN 1..l_msg_count LOOP

Line 1306: OZF_UTILITY_PVT.write_conc_log;

1302: WHEN FND_API.g_exc_error THEN
1303: ROLLBACK TO Update_Claim_From_Association;
1304: OZF_Utility_PVT.write_conc_log('Expected errors:l_msg_count' || l_msg_count);
1305: IF OZF_DEBUG_HIGH_ON THEN
1306: OZF_UTILITY_PVT.write_conc_log;
1307: ELSE
1308: FOR I IN 1..l_msg_count LOOP
1309: IF I = l_msg_count THEN
1310: OZF_Utility_PVT.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));

Line 1310: OZF_Utility_PVT.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));

1306: OZF_UTILITY_PVT.write_conc_log;
1307: ELSE
1308: FOR I IN 1..l_msg_count LOOP
1309: IF I = l_msg_count THEN
1310: OZF_Utility_PVT.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));
1311: END IF;
1312: END LOOP;
1313: END IF;
1314:

Line 1317: OZF_Utility_PVT.write_conc_log('Unexpected errors:l_msg_count' || l_msg_count);

1313: END IF;
1314:
1315: WHEN FND_API.g_exc_unexpected_error THEN
1316: ROLLBACK TO Update_Claim_From_Association;
1317: OZF_Utility_PVT.write_conc_log('Unexpected errors:l_msg_count' || l_msg_count);
1318: IF OZF_DEBUG_HIGH_ON THEN
1319: OZF_UTILITY_PVT.write_conc_log;
1320: ELSE
1321: FOR I IN 1..l_msg_count LOOP

Line 1319: OZF_UTILITY_PVT.write_conc_log;

1315: WHEN FND_API.g_exc_unexpected_error THEN
1316: ROLLBACK TO Update_Claim_From_Association;
1317: OZF_Utility_PVT.write_conc_log('Unexpected errors:l_msg_count' || l_msg_count);
1318: IF OZF_DEBUG_HIGH_ON THEN
1319: OZF_UTILITY_PVT.write_conc_log;
1320: ELSE
1321: FOR I IN 1..l_msg_count LOOP
1322: IF I = l_msg_count THEN
1323: OZF_Utility_PVT.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));

Line 1323: OZF_Utility_PVT.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));

1319: OZF_UTILITY_PVT.write_conc_log;
1320: ELSE
1321: FOR I IN 1..l_msg_count LOOP
1322: IF I = l_msg_count THEN
1323: OZF_Utility_PVT.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));
1324: END IF;
1325: END LOOP;
1326: END IF;
1327:

Line 1331: OZF_Utility_PVT.write_conc_log('Fail For Deduction OTHERS : ' || l_claimTbl(i) || ' - Error Message: ' || SQLERRM);

1327:
1328: WHEN OTHERS THEN
1329: ROLLBACK TO Update_Claim_From_Association;
1330: IF OZF_DEBUG_HIGH_ON THEN
1331: OZF_Utility_PVT.write_conc_log('Fail For Deduction OTHERS : ' || l_claimTbl(i) || ' - Error Message: ' || SQLERRM);
1332: END IF;
1333:
1334: FND_MSG_PUB.count_and_get(
1335: p_encoded => FND_API.g_false

Line 1349: OZF_Utility_PVT.write_conc_log('Credit Count' || l_exactmatchTbl.count);

1345: EXIT WHEN open_ded_csr%NOTFOUND;
1346: END LOOP;
1347: -- Need to Call the Log procedure
1348: IF OZF_DEBUG_HIGH_ON THEN
1349: OZF_Utility_PVT.write_conc_log('Credit Count' || l_exactmatchTbl.count);
1350: OZF_Utility_PVT.write_conc_log('Credit Possible Count' || l_possiblematchTbl.count);
1351: OZF_Utility_PVT.write_conc_log('Accrual Count' || l_accrualmatchTbl.count);
1352: END IF;
1353:

Line 1350: OZF_Utility_PVT.write_conc_log('Credit Possible Count' || l_possiblematchTbl.count);

1346: END LOOP;
1347: -- Need to Call the Log procedure
1348: IF OZF_DEBUG_HIGH_ON THEN
1349: OZF_Utility_PVT.write_conc_log('Credit Count' || l_exactmatchTbl.count);
1350: OZF_Utility_PVT.write_conc_log('Credit Possible Count' || l_possiblematchTbl.count);
1351: OZF_Utility_PVT.write_conc_log('Accrual Count' || l_accrualmatchTbl.count);
1352: END IF;
1353:
1354: -- For logging

Line 1351: OZF_Utility_PVT.write_conc_log('Accrual Count' || l_accrualmatchTbl.count);

1347: -- Need to Call the Log procedure
1348: IF OZF_DEBUG_HIGH_ON THEN
1349: OZF_Utility_PVT.write_conc_log('Credit Count' || l_exactmatchTbl.count);
1350: OZF_Utility_PVT.write_conc_log('Credit Possible Count' || l_possiblematchTbl.count);
1351: OZF_Utility_PVT.write_conc_log('Accrual Count' || l_accrualmatchTbl.count);
1352: END IF;
1353:
1354: -- For logging
1355: Create_Log(

Line 1383: OZF_UTILITY_PVT.write_conc_log;

1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO RuleBased;
1382: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1383: OZF_UTILITY_PVT.write_conc_log;
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

Line 1392: OZF_UTILITY_PVT.write_conc_log;

1388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: ROLLBACK TO RuleBased;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1392: OZF_UTILITY_PVT.write_conc_log;
1393: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1394: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

Line 1407: OZF_UTILITY_PVT.write_conc_log;

1403: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1404: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1405: FND_MSG_PUB.Add;
1406: END IF;
1407: OZF_UTILITY_PVT.write_conc_log;
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Rule Based Engine Failed. ');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);