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_AUTOPAY_PVT dependencies on FND_FILE

Line 588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Number: '||l_claim_num);

584: FETCH csr_claim_num INTO l_claim_num, l_claim_amt,l_cust_billto_acct_site_id;
585: CLOSE csr_claim_num;
586:
587:
588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Number: '||l_claim_num);
589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount: '||l_claim_amt);
590:
591: IF l_cust_billto_acct_site_id IS NOT NULL
592: OR l_cust_billto_acct_site_id<>0 THEN

Line 589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount: '||l_claim_amt);

585: CLOSE csr_claim_num;
586:
587:
588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Number: '||l_claim_num);
589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount: '||l_claim_amt);
590:
591: IF l_cust_billto_acct_site_id IS NOT NULL
592: OR l_cust_billto_acct_site_id<>0 THEN
593:

Line 594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The claim is created for bill_to site: '||l_cust_billto_acct_site_id);

590:
591: IF l_cust_billto_acct_site_id IS NOT NULL
592: OR l_cust_billto_acct_site_id<>0 THEN
593:
594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The claim is created for bill_to site: '||l_cust_billto_acct_site_id);
595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'The claim is created for bill_to site: '|| l_cust_billto_acct_site_id );
596:
597: END IF;
598:

Line 595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'The claim is created for bill_to site: '|| l_cust_billto_acct_site_id );

591: IF l_cust_billto_acct_site_id IS NOT NULL
592: OR l_cust_billto_acct_site_id<>0 THEN
593:
594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The claim is created for bill_to site: '||l_cust_billto_acct_site_id);
595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'The claim is created for bill_to site: '|| l_cust_billto_acct_site_id );
596:
597: END IF;
598:
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Number : '||l_claim_num );

Line 599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Number : '||l_claim_num );

595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'The claim is created for bill_to site: '|| l_cust_billto_acct_site_id );
596:
597: END IF;
598:
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Number : '||l_claim_num );
600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_claim_amt );
601:
602: EXCEPTION
603: WHEN OTHERS THEN

Line 600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_claim_amt );

596:
597: END IF;
598:
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Number : '||l_claim_num );
600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_claim_amt );
601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_ERROR;

Line 973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------ Claims Autopay Execution Report ------------------------------');

969: BEGIN
970:
971: SAVEPOINT AutoPay;
972:
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Claims Autopay Execution Report ------------------------------*');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
976:
977: -- Debug Message

Line 974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

970:
971: SAVEPOINT AutoPay;
972:
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Claims Autopay Execution Report ------------------------------*');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
976:
977: -- Debug Message
978: IF OZF_DEBUG_LOW_ON THEN

Line 975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

971: SAVEPOINT AutoPay;
972:
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------ Claims Autopay Execution Report ------------------------------*');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
976:
977: -- Debug Message
978: IF OZF_DEBUG_LOW_ON THEN
979: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));

1002: FOR m IN l_org_id.FIRST..l_org_id.LAST LOOP
1003: BEGIN
1004: MO_GLOBAL.set_policy_context('S',l_org_id(m));
1005: -- Write OU info to OUT file
1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
1008: -- Write OU info to LOG file
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');

Line 1007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');

1003: BEGIN
1004: MO_GLOBAL.set_policy_context('S',l_org_id(m));
1005: -- Write OU info to OUT file
1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
1008: -- Write OU info to LOG file
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
1011:

Line 1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));

1005: -- Write OU info to OUT file
1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
1008: -- Write OU info to LOG file
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
1011:
1012: IF p_run_mode IS NOT NULL THEN
1013: OPEN csr_meaning('OZF_CLAIM_AUTOPAY_RUNMODE', p_run_mode);

Line 1010: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');

1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
1008: -- Write OU info to LOG file
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
1010: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
1011:
1012: IF p_run_mode IS NOT NULL THEN
1013: OPEN csr_meaning('OZF_CLAIM_AUTOPAY_RUNMODE', p_run_mode);
1014: FETCH csr_meaning INTO l_run_mode;

Line 1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Run Mode', 40, ' ') || ': ' || l_run_mode);

1089: FETCH csr_prod_name INTO l_prod_name;
1090: CLOSE csr_prod_name;
1091: END IF;
1092:
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Run Mode', 40, ' ') || ': ' || l_run_mode);
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);
1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);

Line 1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);

1090: CLOSE csr_prod_name;
1091: END IF;
1092:
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Run Mode', 40, ' ') || ': ' || l_run_mode);
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);
1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);

Line 1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);

1091: END IF;
1092:
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Run Mode', 40, ' ') || ': ' || l_run_mode);
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);
1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);

Line 1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);

1092:
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Run Mode', 40, ' ') || ': ' || l_run_mode);
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);
1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);

Line 1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);

1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Run Mode', 40, ' ') || ': ' || l_run_mode);
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);
1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);

Line 1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);

1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Customer Name', 40, ' ') || ': '|| l_cust_name);
1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);

Line 1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);

1095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Relationship', 40, ' ') || ': ' || l_rlship);
1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);

Line 1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);

1096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Related Customer', 40, ' ') || ': ' || l_rel_cust_name);
1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);

Line 1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);

1097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Buying Group and Members', 40, ' ') || ': ' || l_buy_gp_name);
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);

Line 1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);

1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Include All Member Earnings', 40, ' ') || ': ' || l_members_flag);
1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);

Line 1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);

1099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Pay To', 40, ' ') || ': ' || l_pay_to);
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);
1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);

Line 1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);

1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Fund Name', 40, ' ') || ': ' || l_fund_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);
1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);

1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Type', 40, ' ') || ': ' || l_plan_type_name);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);
1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1109:

Line 1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);

1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Offer Type', 40, ' ') || ': ' || l_offer_type_name);
1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);
1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1109:
1110: /*------------ Autopay starts ---------------*/

Line 1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);

1103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Activity Name', 40, ' ') || ': ' || l_plan_name);
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);
1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1109:
1110: /*------------ Autopay starts ---------------*/
1111:

Line 1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product Category', 40, ' ') || ': ' || l_prod_cat_name);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Product', 40, ' ') || ': ' || l_prod_name);
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('End Date', 40, ' ') || ': ' || p_end_date);
1107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('Group By Offer', 40, ' ') || ': ' || p_group_by_offer);
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1109:
1110: /*------------ Autopay starts ---------------*/
1111:
1112: -- get autopay_flag, reason_code_id

Line 1296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('l_bill_to_site_use_id', 40, ' ') || ': ' || l_bill_to_site_use_id);

1292: FETCH csr_cust_name INTO l_cust_name_num;
1293: CLOSE csr_cust_name;
1294:
1295:
1296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad('l_bill_to_site_use_id', 40, ' ') || ': ' || l_bill_to_site_use_id);
1297:
1298:
1299: -- 1. get trade profile by site_use_id
1300: OPEN g_site_info_csr(l_bill_to_site_use_id);

Line 1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Customer Name : '||l_cust_name_num );

1363: END IF;
1364: l_prev_site_use_id := l_bill_to_site_use_id;
1365:
1366: IF p_customer_id IS NULL THEN
1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Customer Name : '||l_cust_name_num );
1368: END IF;
1369: IF l_offer_pay_method IS NOT NULL THEN
1370: OPEN csr_offer_pay_name(l_offer_pay_method);
1371: FETCH csr_offer_pay_name INTO l_offer_pay_name;

Line 1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Offer Payment Method: '||l_offer_pay_name);

1369: IF l_offer_pay_method IS NOT NULL THEN
1370: OPEN csr_offer_pay_name(l_offer_pay_method);
1371: FETCH csr_offer_pay_name INTO l_offer_pay_name;
1372: CLOSE csr_offer_pay_name;
1373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Offer Payment Method: '||l_offer_pay_name);
1374: END IF;
1375:
1376: IF l_cust_info_invalid THEN
1377: RAISE FND_API.g_exc_unexpected_error;

Line 1411: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Start AUTOPAY for customer '||l_cust_name_num||' ---/');

1407: l_funds_util_flt.end_date := FND_DATE.CANONICAL_TO_DATE(p_end_date);
1408: l_funds_util_flt.group_by_offer := NVL(p_group_by_offer,'N'); --R12
1409: */
1410:
1411: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1412: create_claim_for_cust(p_customer_info => l_customer_info,
1413: p_amount => l_amount,
1414: p_mode => 'N',
1415: p_auto_reason_code_id => l_auto_reason_code_id,

Line 1434: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount = '||l_amount);

1430: IF l_trade_prf_exist THEN
1431: l_trd_prof_tbl(i) := l_customer_info.trade_profile_id;
1432: END IF;
1433:
1434: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount = '||l_amount);
1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');
1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1438: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_amount );

Line 1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');

1431: l_trd_prof_tbl(i) := l_customer_info.trade_profile_id;
1432: END IF;
1433:
1434: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount = '||l_amount);
1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');
1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
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. ');

Line 1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

1432: END IF;
1433:
1434: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount = '||l_amount);
1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');
1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
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, '');

Line 1437: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1433:
1434: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount = '||l_amount);
1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');
1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
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;

Line 1438: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim Amount : '||l_amount );

1434: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim Amount = '||l_amount);
1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');
1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
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

Line 1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Success. ');

1435: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Success.');
1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
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||' ---*/');

Line 1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1436: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
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);

Line 1443: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Start AUTOPAY for customer '||l_cust_name_num||' ---/');

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 ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

Line 1444: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Autopay flag is not turned on in Trade Profile for customer '||l_cust_name_num);

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 ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');

Line 1445: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

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 ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1446: FND_FILE.PUT_LINE(FND_FILE.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 ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1450: END IF; -- end of if autopay flag is turning on

Line 1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

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 ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1450: END IF; -- end of if autopay flag is turning on
1451: ELSE

Line 1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');

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 ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1450: END IF; -- end of if autopay flag is turning on
1451: ELSE
1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');

Line 1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1445: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1446: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1450: END IF; -- end of if autopay flag is turning on
1451: ELSE
1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);

Line 1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Start AUTOPAY for customer '||l_cust_name_num||' ---/');

1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Autopay flag is not turned on in Trade Profile for this customer. ');
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1450: END IF; -- end of if autopay flag is turning on
1451: ELSE
1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);
1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

Line 1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);

1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1450: END IF; -- end of if autopay flag is turning on
1451: ELSE
1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);
1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');

Line 1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

1450: END IF; -- end of if autopay flag is turning on
1451: ELSE
1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);
1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');
1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1451: ELSE
1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);
1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');
1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1459: END IF; -- end of if l_trade_prf_exist

Line 1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

1452: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start AUTOPAY for customer '||l_cust_name_num||' ---*/');
1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);
1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');
1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1459: END IF; -- end of if l_trade_prf_exist
1460: END IF; -- end of if l_cust_account_id is not null

Line 1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');

1453: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Trade Profile is not existing for customer '||l_cust_name_num);
1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');
1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1459: END IF; -- end of if l_trade_prf_exist
1460: END IF; -- end of if l_cust_account_id is not null
1461:

Line 1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1454: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Trade Profile is not existing for this customer.');
1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1459: END IF; -- end of if l_trade_prf_exist
1460: END IF; -- end of if l_cust_account_id is not null
1461:
1462: EXCEPTION

Line 1465: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

1461:
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. ');

Line 1467: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

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));
1471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1468: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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));
1471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1469: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

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));
1471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: ROLLBACK TO AUTOPAY_CUST;

Line 1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

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));
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.');

Line 1471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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));
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;

Line 1474: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

1470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
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. ');

Line 1476: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

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));
1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1477: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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));
1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1481:

Line 1478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

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));
1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1481:
1482: WHEN OTHERS THEN

Line 1479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

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));
1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1481:
1482: WHEN OTHERS THEN
1483: ROLLBACK TO AUTOPAY_CUST;

Line 1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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));
1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1481:
1482: WHEN OTHERS THEN
1483: ROLLBACK TO AUTOPAY_CUST;
1484: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

Line 1484: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

1480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1481:
1482: WHEN OTHERS THEN
1483: ROLLBACK TO AUTOPAY_CUST;
1484: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1485: IF OZF_DEBUG_LOW_ON THEN
1486: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1487: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1488: FND_MSG_PUB.Add;

Line 1491: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End ---/');

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);
1495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1492: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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);
1495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1496: END;

Line 1493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');

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);
1495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1496: END;
1497:

Line 1494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE||SQLERRM);

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);
1495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1496: END;
1497:
1498: ELSE

Line 1495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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);
1495: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1496: END;
1497:
1498: ELSE
1499: EXIT;

Line 1522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

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'));
1525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1526:

Line 1523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );

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'));
1525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1526:
1527: EXCEPTION

Line 1524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

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'));
1525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1526:
1527: EXCEPTION
1528: WHEN FND_API.g_exc_error THEN

Line 1525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

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'));
1525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1526:
1527: EXCEPTION
1528: WHEN FND_API.g_exc_error THEN
1529: ROLLBACK TO AutoPay;

Line 1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');

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'));
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1537:
1538: WHEN FND_API.g_exc_unexpected_error THEN

Line 1535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

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'));
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1537:
1538: WHEN FND_API.g_exc_unexpected_error THEN
1539: ROLLBACK TO AutoPay;

Line 1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

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'));
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1537:
1538: WHEN FND_API.g_exc_unexpected_error THEN
1539: ROLLBACK TO AutoPay;
1540:

Line 1544: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: ( Warning:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');

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'));
1546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1547:
1548: WHEN OTHERS THEN

Line 1545: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

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'));
1546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1547:
1548: WHEN OTHERS THEN
1549: ROLLBACK TO AutoPay;

Line 1546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

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'));
1546: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1547:
1548: WHEN OTHERS THEN
1549: ROLLBACK TO AutoPay;
1550:

Line 1554: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');

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'));
1556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1557:
1558: END;

Line 1555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

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'));
1556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1557:
1558: END;
1559: END LOOP;

Line 1556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

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'));
1556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1557:
1558: END;
1559: END LOOP;
1560: END IF;