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.AR_IREC_PAYMENTS dependencies on FND_LOG

Line 766: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

762:
763: EXCEPTION
764: WHEN OTHERS THEN
765: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
766: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
767: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
768: ||':ERROR =>'|| SQLERRM);
769: end if;
770: END;

Line 767: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info

763: EXCEPTION
764: WHEN OTHERS THEN
765: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
766: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
767: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
768: ||':ERROR =>'|| SQLERRM);
769: end if;
770: END;
771:

Line 799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
801: ||':ERROR =>'|| SQLERRM);
802: end if;
803: END;

Line 800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info

796: EXCEPTION
797: WHEN OTHERS THEN
798: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
801: ||':ERROR =>'|| SQLERRM);
802: end if;
803: END;
804:

Line 982: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

978: x_response => l_result_rec);
979:
980:
981: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
982: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
983: fnd_log.string(fnd_log.LEVEL_STATEMENT,
984: G_PKG_NAME||l_procedure_name,
985: 'ERROR IN UPDATING CREDIT CARD');
986: fnd_log.string(fnd_log.LEVEL_STATEMENT,

Line 983: fnd_log.string(fnd_log.LEVEL_STATEMENT,

979:
980:
981: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
982: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
983: fnd_log.string(fnd_log.LEVEL_STATEMENT,
984: G_PKG_NAME||l_procedure_name,
985: 'ERROR IN UPDATING CREDIT CARD');
986: fnd_log.string(fnd_log.LEVEL_STATEMENT,
987: G_PKG_NAME||l_procedure_name,l_result_rec.result_code);

Line 986: fnd_log.string(fnd_log.LEVEL_STATEMENT,

982: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
983: fnd_log.string(fnd_log.LEVEL_STATEMENT,
984: G_PKG_NAME||l_procedure_name,
985: 'ERROR IN UPDATING CREDIT CARD');
986: fnd_log.string(fnd_log.LEVEL_STATEMENT,
987: G_PKG_NAME||l_procedure_name,l_result_rec.result_code);
988: end if;
989: x_msg_data := l_result_rec.result_code;
990: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1049: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1045: );
1046: -- Modified for Bug# 16262617 : End
1047:
1048: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1049: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1050: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1051: G_PKG_NAME||l_procedure_name,
1052: 'ERROR IN UPDATING BANK ACCOUNT');
1053: fnd_log.string(fnd_log.LEVEL_STATEMENT,

Line 1050: fnd_log.string(fnd_log.LEVEL_STATEMENT,

1046: -- Modified for Bug# 16262617 : End
1047:
1048: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1049: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1050: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1051: G_PKG_NAME||l_procedure_name,
1052: 'ERROR IN UPDATING BANK ACCOUNT');
1053: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1054: G_PKG_NAME||l_procedure_name,x_msg_data);

Line 1053: fnd_log.string(fnd_log.LEVEL_STATEMENT,

1049: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1050: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1051: G_PKG_NAME||l_procedure_name,
1052: 'ERROR IN UPDATING BANK ACCOUNT');
1053: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1054: G_PKG_NAME||l_procedure_name,x_msg_data);
1055: end if;
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: write_error_messages(x_msg_data, x_msg_count);

Line 1914: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1910: l_msg_data VARCHAR2(2000);
1911: BEGIN
1912: l_procedure_name := '.is_bank_account_duplicate';
1913:
1914: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1915: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,' Begin +');
1916: end if;
1917:
1918: IF p_routing_number IS NULL THEN

Line 1915: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,' Begin +');

1911: BEGIN
1912: l_procedure_name := '.is_bank_account_duplicate';
1913:
1914: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1915: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,' Begin +');
1916: end if;
1917:
1918: IF p_routing_number IS NULL THEN
1919:

Line 1920: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1916: end if;
1917:
1918: IF p_routing_number IS NULL THEN
1919:
1920: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1921: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,' Calling.. IBY_FNDCPT_SETUP_PUB.Card_Exists ');
1922: end if;
1923:
1924: IBY_FNDCPT_SETUP_PUB.Card_Exists(

Line 1921: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,' Calling.. IBY_FNDCPT_SETUP_PUB.Card_Exists ');

1917:
1918: IF p_routing_number IS NULL THEN
1919:
1920: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1921: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,' Calling.. IBY_FNDCPT_SETUP_PUB.Card_Exists ');
1922: end if;
1923:
1924: IBY_FNDCPT_SETUP_PUB.Card_Exists(
1925: p_api_version => 1.0,

Line 1935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1931: p_card_number => p_bank_account_number,
1932: x_card_instrument => l_create_credit_card,
1933: x_response => l_result_rec);
1934:
1935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_return_status :: ' || l_return_status);
1937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return 0 - credit card exists validation is not required from OIR');
1938: end if;
1939: --Bug 14534172 - As per bug, do not validate the credit card exists from OIR.

Line 1936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_return_status :: ' || l_return_status);

1932: x_card_instrument => l_create_credit_card,
1933: x_response => l_result_rec);
1934:
1935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_return_status :: ' || l_return_status);
1937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return 0 - credit card exists validation is not required from OIR');
1938: end if;
1939: --Bug 14534172 - As per bug, do not validate the credit card exists from OIR.
1940: return 0;

Line 1937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return 0 - credit card exists validation is not required from OIR');

1933: x_response => l_result_rec);
1934:
1935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_return_status :: ' || l_return_status);
1937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return 0 - credit card exists validation is not required from OIR');
1938: end if;
1939: --Bug 14534172 - As per bug, do not validate the credit card exists from OIR.
1940: return 0;
1941: /*

Line 1950: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1946: OPEN cc_cur(l_create_credit_card.card_id);
1947: FETCH cc_cur into cc_rec;
1948: CLOSE cc_cur;
1949:
1950: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1951: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.card_id :: ' || l_create_credit_card.card_id);
1952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'cc_rec.ca_exists :: ' || cc_rec.ca_exists);
1953: end if;
1954:

Line 1951: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.card_id :: ' || l_create_credit_card.card_id);

1947: FETCH cc_cur into cc_rec;
1948: CLOSE cc_cur;
1949:
1950: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1951: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.card_id :: ' || l_create_credit_card.card_id);
1952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'cc_rec.ca_exists :: ' || cc_rec.ca_exists);
1953: end if;
1954:
1955: if cc_rec.ca_exists = 0 then

Line 1952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'cc_rec.ca_exists :: ' || cc_rec.ca_exists);

1948: CLOSE cc_cur;
1949:
1950: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1951: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.card_id :: ' || l_create_credit_card.card_id);
1952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'cc_rec.ca_exists :: ' || cc_rec.ca_exists);
1953: end if;
1954:
1955: if cc_rec.ca_exists = 0 then
1956: return 0;

Line 1970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1966: open ba_cur;
1967: fetch ba_cur into ba_rec;
1968: close ba_cur;
1969:
1970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ba_rec.ba_exists :: ' || ba_rec.ba_exists);
1972: end if;
1973:
1974: if ba_rec.ba_exists = 0 then

Line 1971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ba_rec.ba_exists :: ' || ba_rec.ba_exists);

1967: fetch ba_cur into ba_rec;
1968: close ba_cur;
1969:
1970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ba_rec.ba_exists :: ' || ba_rec.ba_exists);
1972: end if;
1973:
1974: if ba_rec.ba_exists = 0 then
1975: return 0;

Line 3004: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3000:
3001: l_procedure_name := '.create_payment_instrument';
3002: l_commit := FND_API.G_FALSE;
3003:
3004: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3005: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_id :: ' ||p_bank_id);
3006: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_branch_id :: ' ||p_bank_branch_id);
3007: end if;
3008:

Line 3005: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_id :: ' ||p_bank_id);

3001: l_procedure_name := '.create_payment_instrument';
3002: l_commit := FND_API.G_FALSE;
3003:
3004: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3005: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_id :: ' ||p_bank_id);
3006: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_branch_id :: ' ||p_bank_branch_id);
3007: end if;
3008:
3009: IF (p_payment_instrument = 'BANK_ACCOUNT') THEN

Line 3006: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_branch_id :: ' ||p_bank_branch_id);

3002: l_commit := FND_API.G_FALSE;
3003:
3004: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3005: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_id :: ' ||p_bank_id);
3006: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_branch_id :: ' ||p_bank_branch_id);
3007: end if;
3008:
3009: IF (p_payment_instrument = 'BANK_ACCOUNT') THEN
3010:

Line 3024: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3020: l_bank_party_id := bank_branch_rec.bank_party_id;
3021: l_branch_party_id := bank_branch_rec.branch_party_id;
3022: l_address_country := bank_branch_rec.country_code;
3023:
3024: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3025: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank and Branch exist for this Routing Number'||p_routing_number);
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3027: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3028: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_address_country :: ' ||l_address_country);

Line 3025: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank and Branch exist for this Routing Number'||p_routing_number);

3021: l_branch_party_id := bank_branch_rec.branch_party_id;
3022: l_address_country := bank_branch_rec.country_code;
3023:
3024: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3025: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank and Branch exist for this Routing Number'||p_routing_number);
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3027: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3028: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_address_country :: ' ||l_address_country);
3029: end if;

Line 3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);

3022: l_address_country := bank_branch_rec.country_code;
3023:
3024: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3025: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank and Branch exist for this Routing Number'||p_routing_number);
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3027: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3028: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_address_country :: ' ||l_address_country);
3029: end if;
3030:

Line 3027: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);

3023:
3024: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3025: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank and Branch exist for this Routing Number'||p_routing_number);
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3027: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3028: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_address_country :: ' ||l_address_country);
3029: end if;
3030:
3031: l_bank_id := l_bank_party_id; --bug 8915943

Line 3028: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_address_country :: ' ||l_address_country);

3024: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3025: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank and Branch exist for this Routing Number'||p_routing_number);
3026: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3027: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3028: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_address_country :: ' ||l_address_country);
3029: end if;
3030:
3031: l_bank_id := l_bank_party_id; --bug 8915943
3032: l_branch_id := l_branch_party_id;

Line 3048: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3044: CLOSE bank_branch_name_cur;
3045: l_bank_name := bank_branch_name_rec.bank_name;
3046: l_branch_name := bank_branch_name_rec.branch_name;
3047:
3048: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3049: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Fetcheing Bank Name and Branch name for this routing number :: '||p_routing_number);
3050: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Name :: ' ||l_bank_name);
3051: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Name :: ' ||l_branch_name);
3052:

Line 3049: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Fetcheing Bank Name and Branch name for this routing number :: '||p_routing_number);

3045: l_bank_name := bank_branch_name_rec.bank_name;
3046: l_branch_name := bank_branch_name_rec.branch_name;
3047:
3048: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3049: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Fetcheing Bank Name and Branch name for this routing number :: '||p_routing_number);
3050: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Name :: ' ||l_bank_name);
3051: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Name :: ' ||l_branch_name);
3052:
3053: end if;

Line 3050: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Name :: ' ||l_bank_name);

3046: l_branch_name := bank_branch_name_rec.branch_name;
3047:
3048: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3049: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Fetcheing Bank Name and Branch name for this routing number :: '||p_routing_number);
3050: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Name :: ' ||l_bank_name);
3051: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Name :: ' ||l_branch_name);
3052:
3053: end if;
3054: ELSE

Line 3051: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Name :: ' ||l_branch_name);

3047:
3048: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3049: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Fetcheing Bank Name and Branch name for this routing number :: '||p_routing_number);
3050: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Name :: ' ||l_bank_name);
3051: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Name :: ' ||l_branch_name);
3052:
3053: end if;
3054: ELSE
3055: CLOSE bank_branch_name_cur;

Line 3066: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3062: IF (ce_chk_bank_exists_cur%FOUND and l_bank_name is not null) then
3063: CLOSE ce_chk_bank_exists_cur;
3064: l_bank_party_id := ce_chk_bank_exists_rec.bank_party_id;
3065:
3066: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');
3068: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3069: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3070: end if;

Line 3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');

3063: CLOSE ce_chk_bank_exists_cur;
3064: l_bank_party_id := ce_chk_bank_exists_rec.bank_party_id;
3065:
3066: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');
3068: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3069: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3070: end if;
3071:

Line 3068: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);

3064: l_bank_party_id := ce_chk_bank_exists_rec.bank_party_id;
3065:
3066: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');
3068: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3069: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3070: end if;
3071:
3072: ELSE

Line 3069: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);

3065:
3066: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');
3068: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3069: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3070: end if;
3071:
3072: ELSE
3073: CLOSE ce_chk_bank_exists_cur;

Line 3086: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3082: l_ext_branch_rec.branch_type := 'ABA';
3083: l_ext_branch_rec.bch_object_version_number :='1';
3084: l_ext_branch_rec.typ_object_version_number :='1';
3085:
3086: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3087: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3088: end if;
3089:
3090: iby_ext_bankacct_pub.create_ext_bank_branch(

Line 3087: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');

3083: l_ext_branch_rec.bch_object_version_number :='1';
3084: l_ext_branch_rec.typ_object_version_number :='1';
3085:
3086: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3087: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3088: end if;
3089:
3090: iby_ext_bankacct_pub.create_ext_bank_branch(
3091: -- IN parameters

Line 3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3098: x_msg_count => x_msg_count,
3099: x_msg_data => x_msg_data,
3100: x_response => l_branch_response);
3101:
3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);

Line 3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');

3099: x_msg_data => x_msg_data,
3100: x_response => l_branch_response);
3101:
3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3107: end if;

Line 3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);

3100: x_response => l_branch_response);
3101:
3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3107: end if;
3108:

Line 3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);

3101:
3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3107: end if;
3108:
3109: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);

3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3107: end if;
3108:
3109: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3110: l_bank_id := l_bank_party_id;

Line 3127: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3123: l_ext_bank_rec.institution_type := 'BANK';
3124: l_ext_bank_rec.country_code := 'US'; --Create banks are used from Federal Sites.. which has details about US banks only.
3125: l_ext_bank_rec.object_version_number := '1';
3126:
3127: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3128: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank .....');
3129: end if;
3130:
3131: iby_ext_bankacct_pub.create_ext_bank(

Line 3128: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank .....');

3124: l_ext_bank_rec.country_code := 'US'; --Create banks are used from Federal Sites.. which has details about US banks only.
3125: l_ext_bank_rec.object_version_number := '1';
3126:
3127: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3128: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank .....');
3129: end if;
3130:
3131: iby_ext_bankacct_pub.create_ext_bank(
3132: -- IN parameters

Line 3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3139: x_msg_count => x_msg_count,
3140: x_msg_data => x_msg_data,
3141: x_response => l_bank_response );
3142:
3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');
3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);
3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);

Line 3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');

3140: x_msg_data => x_msg_data,
3141: x_response => l_bank_response );
3142:
3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');
3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);
3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);
3148: end if;

Line 3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);

3141: x_response => l_bank_response );
3142:
3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');
3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);
3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);
3148: end if;
3149:

Line 3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);

3142:
3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');
3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);
3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);
3148: end if;
3149:
3150: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);

3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');
3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);
3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);
3148: end if;
3149:
3150: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3151: l_bank_id := l_bank_party_id;

Line 3162: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3158: l_ext_branch_rec.branch_type := 'ABA';
3159: l_ext_branch_rec.bch_object_version_number :='1';
3160: l_ext_branch_rec.typ_object_version_number :='1';
3161:
3162: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3163: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3164: end if;
3165:
3166: iby_ext_bankacct_pub.create_ext_bank_branch(

Line 3163: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');

3159: l_ext_branch_rec.bch_object_version_number :='1';
3160: l_ext_branch_rec.typ_object_version_number :='1';
3161:
3162: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3163: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3164: end if;
3165:
3166: iby_ext_bankacct_pub.create_ext_bank_branch(
3167: -- IN parameters

Line 3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3174: x_msg_count => x_msg_count,
3175: x_msg_data => x_msg_data,
3176: x_response => l_branch_response);
3177:
3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);

Line 3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');

3175: x_msg_data => x_msg_data,
3176: x_response => l_branch_response);
3177:
3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3183: end if;

Line 3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);

3176: x_response => l_branch_response);
3177:
3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3183: end if;
3184:

Line 3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);

3177:
3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3183: end if;
3184:
3185: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);

3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3183: end if;
3184:
3185: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3186: l_branch_id := l_branch_party_id;

Line 3191: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3187: end if;
3188: end if;
3189: -- Added for Bug# 16306925
3190: IF(l_bank_branch_cur_exists = 'Y') then
3191: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3192: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists = '||l_bank_branch_cur_exists);
3193: end if;
3194:
3195: -- select EXT_BANK_ACCOUNT_ID into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number;

Line 3192: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists = '||l_bank_branch_cur_exists);

3188: end if;
3189: -- Added for Bug# 16306925
3190: IF(l_bank_branch_cur_exists = 'Y') then
3191: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3192: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists = '||l_bank_branch_cur_exists);
3193: end if;
3194:
3195: -- select EXT_BANK_ACCOUNT_ID into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number;
3196: --l_bank_id := l_bank_party_id; --bug 8915943

Line 3201: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3197: -- l_branch_id := l_branch_party_id;
3198: begin
3199: select ext_bank_account_id into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number and bank_id = l_bank_id and branch_id = l_branch_id;
3200:
3201: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3202: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists,l_bank_account_id = '||l_bank_account_id);
3203: end if;
3204: exception
3205: when others then

Line 3202: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists,l_bank_account_id = '||l_bank_account_id);

3198: begin
3199: select ext_bank_account_id into l_bank_account_id from iby_ext_bank_accounts where BANK_ACCOUNT_NUM = p_account_number and bank_id = l_bank_id and branch_id = l_branch_id;
3200:
3201: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3202: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside when l_bank_branch_cur_exists,l_bank_account_id = '||l_bank_account_id);
3203: end if;
3204: exception
3205: when others then
3206: --------------------------------------------------------------------------------------------------------

Line 3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3220: l_ext_bank_act_rec.multi_currency_allowed_flag := 'Y';
3221: l_ext_bank_act_rec.acct_type := p_account_type;
3222: l_ext_bank_act_rec.iban := p_iban;
3223:
3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);

Line 3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');

3221: l_ext_bank_act_rec.acct_type := p_account_type;
3222: l_ext_bank_act_rec.iban := p_iban;
3223:
3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);

Line 3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);

3222: l_ext_bank_act_rec.iban := p_iban;
3223:
3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);

Line 3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);

3223:
3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);

Line 3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);

3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);

Line 3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);

3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);
3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );

Line 3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);

3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);
3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );
3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);

Line 3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);

3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);
3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );
3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);
3235: end if;

Line 3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);

3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);
3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );
3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);
3235: end if;
3236:

Line 3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );

3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);
3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);
3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );
3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);
3235: end if;
3236:
3237: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(

Line 3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);

3230: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_num ::' || l_ext_bank_act_rec.bank_account_num);
3231: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.currency ::' || l_ext_bank_act_rec.currency);
3232: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_account_name ::' || l_ext_bank_act_rec.bank_account_name);
3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );
3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);
3235: end if;
3236:
3237: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(
3238: p_api_version => 1.0,

Line 3404: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3400: p_status := x_return_status;
3401:
3402: write_debug_and_log('instrument_assignment_id :'||p_assignment_id );
3403:
3404: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3405: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Return status - '||x_return_status);
3406: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Count - '||x_msg_count);
3407: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Data - '||x_msg_data);
3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);

Line 3405: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Return status - '||x_return_status);

3401:
3402: write_debug_and_log('instrument_assignment_id :'||p_assignment_id );
3403:
3404: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3405: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Return status - '||x_return_status);
3406: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Count - '||x_msg_count);
3407: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Data - '||x_msg_data);
3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);
3409: end if;

Line 3406: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Count - '||x_msg_count);

3402: write_debug_and_log('instrument_assignment_id :'||p_assignment_id );
3403:
3404: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3405: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Return status - '||x_return_status);
3406: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Count - '||x_msg_count);
3407: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Data - '||x_msg_data);
3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);
3409: end if;
3410:

Line 3407: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Data - '||x_msg_data);

3403:
3404: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3405: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Return status - '||x_return_status);
3406: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Count - '||x_msg_count);
3407: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Data - '||x_msg_data);
3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);
3409: end if;
3410:
3411: IF (PG_DEBUG = 'Y') THEN

Line 3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);

3404: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3405: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Return status - '||x_return_status);
3406: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Count - '||x_msg_count);
3407: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Message Data - '||x_msg_data);
3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);
3409: end if;
3410:
3411: IF (PG_DEBUG = 'Y') THEN
3412: arp_standard.debug(l_debug_info);

Line 3591: fnd_log_repository.init;

3587: BEGIN
3588:
3589: l_procedure_name := '.create_receipt';
3590:
3591: fnd_log_repository.init;
3592:
3593: -----------------------------------------------------------------------------------------
3594: l_debug_info := 'Call public AR receipts API - create_cash - to create receipt for payment';
3595: -----------------------------------------------------------------------------------------

Line 3630: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3626: p_cash_receipt_id := l_cash_receipt_id;
3627: p_status := x_return_status;
3628: write_debug_and_log('p_receipt_currency_code:'||l_cash_receipt_id);
3629:
3630: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3631: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Rerturn status - '||x_return_status);
3632: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Count - '||x_msg_count);
3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);

Line 3631: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Rerturn status - '||x_return_status);

3627: p_status := x_return_status;
3628: write_debug_and_log('p_receipt_currency_code:'||l_cash_receipt_id);
3629:
3630: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3631: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Rerturn status - '||x_return_status);
3632: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Count - '||x_msg_count);
3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3635: end if;

Line 3632: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Count - '||x_msg_count);

3628: write_debug_and_log('p_receipt_currency_code:'||l_cash_receipt_id);
3629:
3630: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3631: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Rerturn status - '||x_return_status);
3632: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Count - '||x_msg_count);
3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3635: end if;
3636:

Line 3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);

3629:
3630: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3631: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Rerturn status - '||x_return_status);
3632: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Count - '||x_msg_count);
3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3635: end if;
3636:
3637: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);

Line 3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);

3630: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3631: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Rerturn status - '||x_return_status);
3632: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Count - '||x_msg_count);
3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3635: end if;
3636:
3637: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3638: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));

Line 3732: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3728: l_msg_count := 0;
3729: l_apply_err_count := 0;
3730: l_procedure_name := '.apply_cash';
3731:
3732: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3733: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'In apply_cash: p_customer_id='||p_customer_id ||','
3734: || 'p_site_use_id=' || p_site_use_id || ','
3735: || 'p_cash_receipt_id=' || p_cash_receipt_id);
3736: end if;

Line 3733: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'In apply_cash: p_customer_id='||p_customer_id ||','

3729: l_apply_err_count := 0;
3730: l_procedure_name := '.apply_cash';
3731:
3732: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3733: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'In apply_cash: p_customer_id='||p_customer_id ||','
3734: || 'p_site_use_id=' || p_site_use_id || ','
3735: || 'p_cash_receipt_id=' || p_cash_receipt_id);
3736: end if;
3737:

Line 3744: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3740: SELECT COUNT(*)
3741: INTO total_trx_count
3742: FROM ar_irec_payment_list_gt;
3743:
3744: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3745: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Total no of rows in ar_irec_payment_list_gt='||total_trx_count);
3746: end if;
3747:
3748: --Pring in the debug log : No of rows that will be picked by the cursor credit_trx_list

Line 3745: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Total no of rows in ar_irec_payment_list_gt='||total_trx_count);

3741: INTO total_trx_count
3742: FROM ar_irec_payment_list_gt;
3743:
3744: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3745: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Total no of rows in ar_irec_payment_list_gt='||total_trx_count);
3746: end if;
3747:
3748: --Pring in the debug log : No of rows that will be picked by the cursor credit_trx_list
3749:

Line 3757: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3753: WHERE customer_id = p_customer_id
3754: AND customer_site_use_id = nvl(decode(p_site_use_id, -1, null, p_site_use_id), customer_site_use_id)
3755: AND ( trx_class = 'CM' OR trx_class = 'PMT' );
3756:
3757: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'credit_trx_list_count: '||credit_trx_list_count);
3759: end if;
3760:
3761: --Pring in the debug log : No of rows that will be picked by the cursor debit_trx_list

Line 3758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'credit_trx_list_count: '||credit_trx_list_count);

3754: AND customer_site_use_id = nvl(decode(p_site_use_id, -1, null, p_site_use_id), customer_site_use_id)
3755: AND ( trx_class = 'CM' OR trx_class = 'PMT' );
3756:
3757: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'credit_trx_list_count: '||credit_trx_list_count);
3759: end if;
3760:
3761: --Pring in the debug log : No of rows that will be picked by the cursor debit_trx_list
3762:

Line 3775: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3771: trx_class = 'CB' OR
3772: trx_class = 'DEP'
3773: );
3774:
3775: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3776: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'debit_trx_list_count: ' || debit_trx_list_count);
3777: end if;
3778:
3779: --

Line 3776: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'debit_trx_list_count: ' || debit_trx_list_count);

3772: trx_class = 'DEP'
3773: );
3774:
3775: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3776: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'debit_trx_list_count: ' || debit_trx_list_count);
3777: end if;
3778:
3779: --
3780: -- Establish a save point

Line 3788: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3784: ----------------------------------------------------------------------------------
3785: l_debug_info := 'Step 1: Apply credits against the receipt (if any)';
3786: ----------------------------------------------------------------------------------
3787:
3788: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3789: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
3790: end if;
3791:
3792: FOR trx in credit_trx_list

Line 3789: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

3785: l_debug_info := 'Step 1: Apply credits against the receipt (if any)';
3786: ----------------------------------------------------------------------------------
3787:
3788: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3789: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
3790: end if;
3791:
3792: FOR trx in credit_trx_list
3793: LOOP

Line 3795: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3791:
3792: FOR trx in credit_trx_list
3793: LOOP
3794:
3795: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3796: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'trx.trx_class=' || trx.trx_class);
3797: end if;
3798:
3799: IF (trx.trx_class = 'CM') THEN

Line 3796: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'trx.trx_class=' || trx.trx_class);

3792: FOR trx in credit_trx_list
3793: LOOP
3794:
3795: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3796: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'trx.trx_class=' || trx.trx_class);
3797: end if;
3798:
3799: IF (trx.trx_class = 'CM') THEN
3800: -- The transaction is a credit memo

Line 3802: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3798:
3799: IF (trx.trx_class = 'CM') THEN
3800: -- The transaction is a credit memo
3801:
3802: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3803: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling AR_RECEIPT_API_PUB.apply for CM:'
3804: ||'trx.customer_trx_id=' || trx.customer_trx_id || ','
3805: ||'trx.terms_sequence_number=' || trx.terms_sequence_number || ','
3806: ||'trx.payment_schedule_id=' || trx.payment_schedule_id || ','

Line 3803: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling AR_RECEIPT_API_PUB.apply for CM:'

3799: IF (trx.trx_class = 'CM') THEN
3800: -- The transaction is a credit memo
3801:
3802: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3803: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling AR_RECEIPT_API_PUB.apply for CM:'
3804: ||'trx.customer_trx_id=' || trx.customer_trx_id || ','
3805: ||'trx.terms_sequence_number=' || trx.terms_sequence_number || ','
3806: ||'trx.payment_schedule_id=' || trx.payment_schedule_id || ','
3807: ||'trx.payment_amt=' || trx.payment_amt || ','

Line 3829: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3825: p_apply_date => trunc(trx.receipt_date),
3826: p_called_from => 'IREC'
3827: );
3828:
3829: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3830: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over');
3831: end if;
3832:
3833: ELSE

Line 3830: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over');

3826: p_called_from => 'IREC'
3827: );
3828:
3829: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3830: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over');
3831: end if;
3832:
3833: ELSE
3834: -- The transaction must be a payment

Line 3836: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3832:
3833: ELSE
3834: -- The transaction must be a payment
3835:
3836: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3837: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling AR_RECEIPT_API_PUB.apply_open_receipt for PMT:'
3838: || 'trx.cash_receipt_id=' || trx.cash_receipt_id ||','
3839: || 'trx.payment_amt=' || trx.payment_amt || ','
3840: || 'l_application_ref_num=' || l_application_ref_num || ','

Line 3837: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling AR_RECEIPT_API_PUB.apply_open_receipt for PMT:'

3833: ELSE
3834: -- The transaction must be a payment
3835:
3836: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3837: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling AR_RECEIPT_API_PUB.apply_open_receipt for PMT:'
3838: || 'trx.cash_receipt_id=' || trx.cash_receipt_id ||','
3839: || 'trx.payment_amt=' || trx.payment_amt || ','
3840: || 'l_application_ref_num=' || l_application_ref_num || ','
3841: || 'l_receivable_application_id=' || l_receivable_application_id || ','

Line 3865: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3861: x_acctd_amount_applied_from => l_acctd_amount_applied_from,
3862: x_acctd_amount_applied_to => l_acctd_amount_applied_to
3863: );
3864:
3865: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3866: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply_open_receipt is over');
3867: end if;
3868:
3869: END IF;

Line 3866: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply_open_receipt is over');

3862: x_acctd_amount_applied_to => l_acctd_amount_applied_to
3863: );
3864:
3865: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3866: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply_open_receipt is over');
3867: end if;
3868:
3869: END IF;
3870:

Line 3871: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3867: end if;
3868:
3869: END IF;
3870:
3871: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3872: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_return_status=' || x_return_status);
3873: end if;
3874:
3875: -- Check for errors and increment the count for

Line 3872: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_return_status=' || x_return_status);

3868:
3869: END IF;
3870:
3871: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3872: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_return_status=' || x_return_status);
3873: end if;
3874:
3875: -- Check for errors and increment the count for
3876: -- errored applcations

Line 3885: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3881: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;
3882: RETURN;
3883: END IF;
3884:
3885: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3886: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Applied receipt '||trx.trx_number||', Status: '||x_return_status);
3887: end if;
3888:
3889: write_debug_and_log('X_RETURN_STATUS=>'||X_RETURN_STATUS);

Line 3886: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Applied receipt '||trx.trx_number||', Status: '||x_return_status);

3882: RETURN;
3883: END IF;
3884:
3885: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3886: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Applied receipt '||trx.trx_number||', Status: '||x_return_status);
3887: end if;
3888:
3889: write_debug_and_log('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3890: write_debug_and_log('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));

Line 3897: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3893: ----------------------------------------------------------------------------------
3894: l_debug_info := 'Step 2: Apply debits against the receipt';
3895: ----------------------------------------------------------------------------------
3896:
3897: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3898: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
3899: end if;
3900:
3901: FOR trx in debit_trx_list

Line 3898: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

3894: l_debug_info := 'Step 2: Apply debits against the receipt';
3895: ----------------------------------------------------------------------------------
3896:
3897: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3898: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
3899: end if;
3900:
3901: FOR trx in debit_trx_list
3902: LOOP

Line 3904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3900:
3901: FOR trx in debit_trx_list
3902: LOOP
3903:
3904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Calling AR_RECEIPT_API_PUB.apply for debit trx: '
3906: || 'p_cash_receipt_id=' || p_cash_receipt_id || ','
3907: || 'trx.customer_trx_id=' || trx.customer_trx_id || ','
3908: || 'trx.payment_schedule_id=' || trx.payment_schedule_id || ','

Line 3905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Calling AR_RECEIPT_API_PUB.apply for debit trx: '

3901: FOR trx in debit_trx_list
3902: LOOP
3903:
3904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Calling AR_RECEIPT_API_PUB.apply for debit trx: '
3906: || 'p_cash_receipt_id=' || p_cash_receipt_id || ','
3907: || 'trx.customer_trx_id=' || trx.customer_trx_id || ','
3908: || 'trx.payment_schedule_id=' || trx.payment_schedule_id || ','
3909: || 'trx.payment_amt=' || trx.payment_amt || ','

Line 3935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3931: p_apply_date => trunc(trx.receipt_date),
3932: p_called_from => 'IREC'
3933: );
3934:
3935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over. Return Status=' || x_return_status);
3937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data=' || x_msg_data);
3938: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_count=' || x_msg_count);
3939: end if;

Line 3936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over. Return Status=' || x_return_status);

3932: p_called_from => 'IREC'
3933: );
3934:
3935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over. Return Status=' || x_return_status);
3937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data=' || x_msg_data);
3938: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_count=' || x_msg_count);
3939: end if;
3940:

Line 3937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data=' || x_msg_data);

3933: );
3934:
3935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over. Return Status=' || x_return_status);
3937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data=' || x_msg_data);
3938: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_count=' || x_msg_count);
3939: end if;
3940:
3941: -- Check for errors and increment the count for

Line 3938: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_count=' || x_msg_count);

3934:
3935: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3936: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Execution of AR_RECEIPT_API_PUB.apply is over. Return Status=' || x_return_status);
3937: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data=' || x_msg_data);
3938: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_count=' || x_msg_count);
3939: end if;
3940:
3941: -- Check for errors and increment the count for
3942: -- errored applcations

Line 3951: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3947: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;
3948: RETURN;
3949: END IF;
3950:
3951: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Applied Cash to '||trx.trx_number||' Status: '||x_return_status);
3953: end if;
3954:
3955: write_debug_and_log('X_RETURN_STATUS=>'||X_RETURN_STATUS);

Line 3952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Applied Cash to '||trx.trx_number||' Status: '||x_return_status);

3948: RETURN;
3949: END IF;
3950:
3951: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3952: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Applied Cash to '||trx.trx_number||' Status: '||x_return_status);
3953: end if;
3954:
3955: write_debug_and_log('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3956: write_debug_and_log('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));

Line 3966: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3962: -- There are no errored applications; set the
3963: -- return status to success
3964: p_return_status := FND_API.G_RET_STS_SUCCESS;
3965:
3966: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3967: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Exiting apply_cash with return status: '||p_return_status);
3968: end if;
3969:
3970: EXCEPTION

Line 3967: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Exiting apply_cash with return status: '||p_return_status);

3963: -- return status to success
3964: p_return_status := FND_API.G_RET_STS_SUCCESS;
3965:
3966: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3967: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Exiting apply_cash with return status: '||p_return_status);
3968: end if;
3969:
3970: EXCEPTION
3971: WHEN OTHERS THEN

Line 4227: fnd_log_repository.init;

4223: --Assign default values
4224: l_total_service_charge := 0;
4225: l_procedure_name := '.apply_service_charge';
4226:
4227: fnd_log_repository.init;
4228: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'+');
4230: end if;
4231:

Line 4228: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4224: l_total_service_charge := 0;
4225: l_procedure_name := '.apply_service_charge';
4226:
4227: fnd_log_repository.init;
4228: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'+');
4230: end if;
4231:
4232: l_count := 1;

Line 4229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'+');

4225: l_procedure_name := '.apply_service_charge';
4226:
4227: fnd_log_repository.init;
4228: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'+');
4230: end if;
4231:
4232: l_count := 1;
4233:

Line 4248: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4244: LOOP
4245:
4246: --l_count := invoice_rec.customer_trx_id;
4247: --l_invoice_list.EXTEND;
4248: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4249: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Index: '||l_count);
4250: end if;
4251: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
4252: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;

Line 4249: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Index: '||l_count);

4245:
4246: --l_count := invoice_rec.customer_trx_id;
4247: --l_invoice_list.EXTEND;
4248: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4249: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Index: '||l_count);
4250: end if;
4251: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
4252: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;
4253: l_invoice_list(l_count).customer_id := invoice_rec.customer_id;

Line 4288: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4284:
4285: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4286: -- bug 3672530 - Ensure graceful error handling
4287: x_return_status := FND_API.G_RET_STS_ERROR;
4288: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4289: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);
4290: end if;
4291: APP_EXCEPTION.RAISE_EXCEPTION;
4292: END IF;

Line 4289: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);

4285: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4286: -- bug 3672530 - Ensure graceful error handling
4287: x_return_status := FND_API.G_RET_STS_ERROR;
4288: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4289: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);
4290: end if;
4291: APP_EXCEPTION.RAISE_EXCEPTION;
4292: END IF;
4293:

Line 4294: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4290: end if;
4291: APP_EXCEPTION.RAISE_EXCEPTION;
4292: END IF;
4293:
4294: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4295: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'-');
4296: end if;
4297:
4298: EXCEPTION

Line 4295: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'-');

4291: APP_EXCEPTION.RAISE_EXCEPTION;
4292: END IF;
4293:
4294: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4295: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'-');
4296: end if;
4297:
4298: EXCEPTION
4299: WHEN OTHERS THEN

Line 4456: fnd_log_repository.init;

4452: x_msg_data := '';
4453: l_procedure_name := '.pay_multiple_invoices';
4454:
4455:
4456: fnd_log_repository.init;
4457:
4458: --------------------------------------------------------------------
4459: l_debug_info := 'In debug mode, log we have entered this procedure';
4460: --------------------------------------------------------------------

Line 4461: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4457:
4458: --------------------------------------------------------------------
4459: l_debug_info := 'In debug mode, log we have entered this procedure';
4460: --------------------------------------------------------------------
4461: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4462: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4463: 'Begin+');
4464: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4465: 'p_payment_amount ' ||p_payment_amount ||

Line 4462: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

4458: --------------------------------------------------------------------
4459: l_debug_info := 'In debug mode, log we have entered this procedure';
4460: --------------------------------------------------------------------
4461: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4462: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4463: 'Begin+');
4464: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4465: 'p_payment_amount ' ||p_payment_amount ||
4466: 'p_discount_amount ' ||p_discount_amount ||

Line 4464: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

4460: --------------------------------------------------------------------
4461: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4462: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4463: 'Begin+');
4464: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4465: 'p_payment_amount ' ||p_payment_amount ||
4466: 'p_discount_amount ' ||p_discount_amount ||
4467: 'p_customer_id ' || p_customer_id ||
4468: 'p_site_use_id ' ||p_site_use_id ||

Line 4533: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4529: END IF;
4530:
4531: IF p_cvv2 = 0 OR p_payment_instrument = 'BANK_ACCOUNT' THEN
4532: l_cvv2 := NULL;
4533: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4534: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4535: 'Since p_cvv2 is 0 or p_payment_instrument is BANK_ACCOUNT, setting l_cvv2 as null');
4536: end if;
4537: else

Line 4534: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

4530:
4531: IF p_cvv2 = 0 OR p_payment_instrument = 'BANK_ACCOUNT' THEN
4532: l_cvv2 := NULL;
4533: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4534: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4535: 'Since p_cvv2 is 0 or p_payment_instrument is BANK_ACCOUNT, setting l_cvv2 as null');
4536: end if;
4537: else
4538: l_cvv2 := p_cvv2;

Line 4539: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4535: 'Since p_cvv2 is 0 or p_payment_instrument is BANK_ACCOUNT, setting l_cvv2 as null');
4536: end if;
4537: else
4538: l_cvv2 := p_cvv2;
4539: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4540: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4541: 'Since p_cvv2 is not 0 and p_payment_instrument is not BANK_ACCOUNT, setting l_cvv2 as p_cvv2');
4542: end if;
4543: END IF;

Line 4540: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

4536: end if;
4537: else
4538: l_cvv2 := p_cvv2;
4539: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4540: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4541: 'Since p_cvv2 is not 0 and p_payment_instrument is not BANK_ACCOUNT, setting l_cvv2 as p_cvv2');
4542: end if;
4543: END IF;
4544:

Line 4546: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4542: end if;
4543: END IF;
4544:
4545:
4546: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4547: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4548: 'Calling get_payment_information');
4549: end if;
4550:

Line 4547: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

4543: END IF;
4544:
4545:
4546: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4547: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4548: 'Calling get_payment_information');
4549: end if;
4550:
4551:

Line 4586: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4582: p_trx_number => l_invoice_trx_number,
4583: p_payment_channel_code => l_payment_channel_code);
4584:
4585: --DEBUG
4586: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);
4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );

Line 4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);

4583: p_payment_channel_code => l_payment_channel_code);
4584:
4585: --DEBUG
4586: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);
4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );
4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );

Line 4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );

4584:
4585: --DEBUG
4586: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);
4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );
4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );
4592: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code => ' || l_receipt_currency_code);

Line 4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);

4585: --DEBUG
4586: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);
4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );
4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );
4592: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code => ' || l_receipt_currency_code);
4593: end if;

Line 4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );

4586: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);
4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );
4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );
4592: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code => ' || l_receipt_currency_code);
4593: end if;
4594:

Line 4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );

4587: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_curr => ' || l_receipt_currency_code);
4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );
4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );
4592: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code => ' || l_receipt_currency_code);
4593: end if;
4594:
4595: IF p_payment_instrument = 'CREDIT_CARD' THEN

Line 4592: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code => ' || l_receipt_currency_code);

4588: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_rct_method_id => ' ||l_receipt_method_id );
4589: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_remit_bank_account_id => ' || l_Remit_bank_account_id);
4590: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_creation_status => ' || l_receipt_creation_status );
4591: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_site_use_id => ' || l_site_use_id );
4592: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code => ' || l_receipt_currency_code);
4593: end if;
4594:
4595: IF p_payment_instrument = 'CREDIT_CARD' THEN
4596: get_payment_channel_attribs

Line 4607: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4603: x_msg_data => x_msg_data
4604: );
4605: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4606:
4607: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4608: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4609: G_PKG_NAME||l_procedure_name,
4610: 'ERROR IN GETTING IBY PAYMENT CHANNEL ATTRIBUTES');
4611: end if;

Line 4608: fnd_log.string(fnd_log.LEVEL_STATEMENT,

4604: );
4605: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4606:
4607: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4608: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4609: G_PKG_NAME||l_procedure_name,
4610: 'ERROR IN GETTING IBY PAYMENT CHANNEL ATTRIBUTES');
4611: end if;
4612:

Line 4682: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4678: x_msg_data => l_msg_data);
4679:
4680: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4681:
4682: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4683: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4684: G_PKG_NAME||l_procedure_name,
4685: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4686: end if;

Line 4683: fnd_log.string(fnd_log.LEVEL_STATEMENT,

4679:
4680: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4681:
4682: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4683: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4684: G_PKG_NAME||l_procedure_name,
4685: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4686: end if;
4687:

Line 4727: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4723: p_assignment_id => l_instr_assign_id,
4724: p_bank_account_id => l_bank_account_id) ;
4725: -- Check if the payment instrument was created successfully
4726: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4727: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4728: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4729: G_PKG_NAME||l_procedure_name,
4730: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4731: end if;

Line 4728: fnd_log.string(fnd_log.LEVEL_STATEMENT,

4724: p_bank_account_id => l_bank_account_id) ;
4725: -- Check if the payment instrument was created successfully
4726: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4727: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4728: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4729: G_PKG_NAME||l_procedure_name,
4730: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4731: end if;
4732:

Line 4742: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4738: -- When payment instrument is created successfully
4739: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, l_site_use_id) ) THEN
4740: -- If iRec set up is not to save CC then, if update of CC fails we should roll back even create.
4741: -- So here the commit flag is controlled by that profile
4742: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4743: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ARI_UTILITIES.save_payment_instrument_info is true');
4744: end if;
4745: commit;
4746: END IF;

Line 4743: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ARI_UTILITIES.save_payment_instrument_info is true');

4739: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, l_site_use_id) ) THEN
4740: -- If iRec set up is not to save CC then, if update of CC fails we should roll back even create.
4741: -- So here the commit flag is controlled by that profile
4742: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4743: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ARI_UTILITIES.save_payment_instrument_info is true');
4744: end if;
4745: commit;
4746: END IF;
4747: END IF;

Line 4755: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4751: l_instr_assign_id := p_instr_assign_id;
4752: END IF;
4753:
4754:
4755: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4756: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with bank Creation .....');
4757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Expiration date for bank account: ' || p_expiration_date);
4758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Id: '||l_bank_account_id);
4759: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Uses Id: '||l_bank_account_uses_id);

Line 4756: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with bank Creation .....');

4752: END IF;
4753:
4754:
4755: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4756: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with bank Creation .....');
4757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Expiration date for bank account: ' || p_expiration_date);
4758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Id: '||l_bank_account_id);
4759: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Uses Id: '||l_bank_account_uses_id);
4760: end if;

Line 4757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Expiration date for bank account: ' || p_expiration_date);

4753:
4754:
4755: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4756: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with bank Creation .....');
4757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Expiration date for bank account: ' || p_expiration_date);
4758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Id: '||l_bank_account_id);
4759: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Uses Id: '||l_bank_account_uses_id);
4760: end if;
4761:

Line 4758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Id: '||l_bank_account_id);

4754:
4755: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4756: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with bank Creation .....');
4757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Expiration date for bank account: ' || p_expiration_date);
4758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Id: '||l_bank_account_id);
4759: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Uses Id: '||l_bank_account_uses_id);
4760: end if;
4761:
4762: -----------------------------------------------------------------------------------------

Line 4759: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Uses Id: '||l_bank_account_uses_id);

4755: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4756: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with bank Creation .....');
4757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Expiration date for bank account: ' || p_expiration_date);
4758: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Id: '||l_bank_account_id);
4759: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Acct Uses Id: '||l_bank_account_uses_id);
4760: end if;
4761:
4762: -----------------------------------------------------------------------------------------
4763: l_debug_info := 'Call public IBY API - create TRANSACTION EXTENSION';

Line 4807: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4803: x_entity_id => l_extn_id,
4804: x_response => l_result_rec);
4805:
4806: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4807: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4808: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4809: G_PKG_NAME||l_procedure_name,
4810: 'ERROR IN CREATING TRANSACTION EXTENSION');
4811: fnd_log.string(fnd_log.LEVEL_STATEMENT,

Line 4808: fnd_log.string(fnd_log.LEVEL_STATEMENT,

4804: x_response => l_result_rec);
4805:
4806: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4807: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4808: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4809: G_PKG_NAME||l_procedure_name,
4810: 'ERROR IN CREATING TRANSACTION EXTENSION');
4811: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4812: G_PKG_NAME||l_procedure_name,l_result_rec.result_code);

Line 4811: fnd_log.string(fnd_log.LEVEL_STATEMENT,

4807: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4808: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4809: G_PKG_NAME||l_procedure_name,
4810: 'ERROR IN CREATING TRANSACTION EXTENSION');
4811: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4812: G_PKG_NAME||l_procedure_name,l_result_rec.result_code);
4813: end if;
4814: x_msg_count := x_msg_count + l_msg_count;
4815: if (l_msg_data is not null) then

Line 4826: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4822: write_error_messages(x_msg_data, x_msg_count);
4823: RETURN;
4824: END IF;
4825:
4826: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4827: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with create trxn extn.....');
4828: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_extn_id : ' ||l_extn_id);
4829: end if;
4830: write_debug_and_log('l_receipt_currency_code : ' || l_receipt_currency_code);

Line 4827: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with create trxn extn.....');

4823: RETURN;
4824: END IF;
4825:
4826: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4827: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with create trxn extn.....');
4828: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_extn_id : ' ||l_extn_id);
4829: end if;
4830: write_debug_and_log('l_receipt_currency_code : ' || l_receipt_currency_code);
4831: write_debug_and_log('l_invoice_exchange_rate : ' || to_char(l_invoice_exchange_rate));

Line 4828: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_extn_id : ' ||l_extn_id);

4824: END IF;
4825:
4826: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4827: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with create trxn extn.....');
4828: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_extn_id : ' ||l_extn_id);
4829: end if;
4830: write_debug_and_log('l_receipt_currency_code : ' || l_receipt_currency_code);
4831: write_debug_and_log('l_invoice_exchange_rate : ' || to_char(l_invoice_exchange_rate));
4832: write_debug_and_log('l_extn_id : ' || l_extn_id);

Line 4844: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4840: p_exchange_rate => l_receipt_exchange_rate,
4841: p_exchange_rate_type => l_receipt_exchange_rate_type,
4842: p_exchange_rate_date => l_receipt_exchange_rate_date);
4843:
4844: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4845: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with getexchangerate.....');
4846: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code : ' || l_receipt_currency_code);
4847: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_exchange_rate : ' || to_char(l_invoice_exchange_rate));
4848: end if;

Line 4845: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with getexchangerate.....');

4841: p_exchange_rate_type => l_receipt_exchange_rate_type,
4842: p_exchange_rate_date => l_receipt_exchange_rate_date);
4843:
4844: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4845: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with getexchangerate.....');
4846: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code : ' || l_receipt_currency_code);
4847: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_exchange_rate : ' || to_char(l_invoice_exchange_rate));
4848: end if;
4849:

Line 4846: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code : ' || l_receipt_currency_code);

4842: p_exchange_rate_date => l_receipt_exchange_rate_date);
4843:
4844: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4845: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with getexchangerate.....');
4846: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code : ' || l_receipt_currency_code);
4847: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_exchange_rate : ' || to_char(l_invoice_exchange_rate));
4848: end if;
4849:
4850: -- for demo purposes only: if fnd function ARIPAYMENTDEMOMODE

Line 4847: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_exchange_rate : ' || to_char(l_invoice_exchange_rate));

4843:
4844: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4845: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with getexchangerate.....');
4846: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_currency_code : ' || l_receipt_currency_code);
4847: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_receipt_exchange_rate : ' || to_char(l_invoice_exchange_rate));
4848: end if;
4849:
4850: -- for demo purposes only: if fnd function ARIPAYMENTDEMOMODE
4851: -- is added to the menu of the current responsibility, supress

Line 4880: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4876: | Standard start of API savepoint |
4877: +------------------------------------*/
4878: SAVEPOINT ARI_Create_Receipt_PVT; -- added for bug 11654712
4879:
4880: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4881: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling create_receipt api ....');
4882: end if;
4883:
4884: create_receipt (p_payment_amount => p_payment_amount,

Line 4881: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling create_receipt api ....');

4877: +------------------------------------*/
4878: SAVEPOINT ARI_Create_Receipt_PVT; -- added for bug 11654712
4879:
4880: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4881: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling create_receipt api ....');
4882: end if;
4883:
4884: create_receipt (p_payment_amount => p_payment_amount,
4885: p_customer_id => p_customer_id,

Line 4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4900:
4901: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);
4902: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4903:
4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);
4907: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Cash Receipt Id: '||to_char(p_cash_receipt_id));
4908: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Account Id: '||to_char(p_bank_account_id));

Line 4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');

4901: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);
4902: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4903:
4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);
4907: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Cash Receipt Id: '||to_char(p_cash_receipt_id));
4908: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Account Id: '||to_char(p_bank_account_id));
4909: end if;

Line 4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);

4902: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4903:
4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);
4907: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Cash Receipt Id: '||to_char(p_cash_receipt_id));
4908: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Account Id: '||to_char(p_bank_account_id));
4909: end if;
4910:

Line 4907: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Cash Receipt Id: '||to_char(p_cash_receipt_id));

4903:
4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);
4907: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Cash Receipt Id: '||to_char(p_cash_receipt_id));
4908: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Account Id: '||to_char(p_bank_account_id));
4909: end if;
4910:
4911: -- Check for error in receipt creation. If it is an error

Line 4908: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Account Id: '||to_char(p_bank_account_id));

4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);
4907: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Cash Receipt Id: '||to_char(p_cash_receipt_id));
4908: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Account Id: '||to_char(p_bank_account_id));
4909: end if;
4910:
4911: -- Check for error in receipt creation. If it is an error
4912: -- the rollback and return.

Line 4970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4966: );
4967:
4968: -- Check if any of the applications errored out
4969: -- If so the rollback everything and return
4970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Apply Cash call ended with Status : '||x_return_status);
4972: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_apply_err_count : '||l_apply_err_count);
4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);
4974: end if;

Line 4971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Apply Cash call ended with Status : '||x_return_status);

4967:
4968: -- Check if any of the applications errored out
4969: -- If so the rollback everything and return
4970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Apply Cash call ended with Status : '||x_return_status);
4972: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_apply_err_count : '||l_apply_err_count);
4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);
4974: end if;
4975:

Line 4972: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_apply_err_count : '||l_apply_err_count);

4968: -- Check if any of the applications errored out
4969: -- If so the rollback everything and return
4970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Apply Cash call ended with Status : '||x_return_status);
4972: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_apply_err_count : '||l_apply_err_count);
4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);
4974: end if;
4975:
4976: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);

4969: -- If so the rollback everything and return
4970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4971: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Apply Cash call ended with Status : '||x_return_status);
4972: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_apply_err_count : '||l_apply_err_count);
4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);
4974: end if;
4975:
4976: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4977: p_status := FND_API.G_RET_STS_ERROR;

Line 5016: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5012: l_home_country := null;
5013: END IF;
5014: END;
5015:
5016: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5017: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Got home country code..'||l_home_country);
5018: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling process_payment .....');
5019: end if;
5020:

Line 5017: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Got home country code..'||l_home_country);

5013: END IF;
5014: END;
5015:
5016: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5017: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Got home country code..'||l_home_country);
5018: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling process_payment .....');
5019: end if;
5020:
5021: l_payee_rec.Int_Bank_Country_Code := l_home_country;

Line 5018: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling process_payment .....');

5014: END;
5015:
5016: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5017: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Got home country code..'||l_home_country);
5018: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling process_payment .....');
5019: end if;
5020:
5021: l_payee_rec.Int_Bank_Country_Code := l_home_country;
5022: --------------------------------------------------------------------

Line 5036: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5032: x_return_status => x_return_status,
5033: p_cc_auth_code => p_cc_auth_code,
5034: x_auth_result => x_auth_result);
5035: l_auth_id := x_auth_result.Auth_Id;
5036: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5037: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Process Payment ended with Status : '||x_return_status);
5038: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Response Code: '|| l_response_error_code);
5039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_auth_id: '|| l_auth_id);
5040: end if;

Line 5037: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Process Payment ended with Status : '||x_return_status);

5033: p_cc_auth_code => p_cc_auth_code,
5034: x_auth_result => x_auth_result);
5035: l_auth_id := x_auth_result.Auth_Id;
5036: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5037: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Process Payment ended with Status : '||x_return_status);
5038: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Response Code: '|| l_response_error_code);
5039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_auth_id: '|| l_auth_id);
5040: end if;
5041: -- If the payment processor call fails, then we need to rollback all the changes

Line 5038: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Response Code: '|| l_response_error_code);

5034: x_auth_result => x_auth_result);
5035: l_auth_id := x_auth_result.Auth_Id;
5036: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5037: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Process Payment ended with Status : '||x_return_status);
5038: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Response Code: '|| l_response_error_code);
5039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_auth_id: '|| l_auth_id);
5040: end if;
5041: -- If the payment processor call fails, then we need to rollback all the changes
5042: -- made in the create() and apply() routines also.

Line 5039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_auth_id: '|| l_auth_id);

5035: l_auth_id := x_auth_result.Auth_Id;
5036: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5037: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Process Payment ended with Status : '||x_return_status);
5038: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Response Code: '|| l_response_error_code);
5039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_auth_id: '|| l_auth_id);
5040: end if;
5041: -- If the payment processor call fails, then we need to rollback all the changes
5042: -- made in the create() and apply() routines also.
5043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 5072: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5068: l_create_credit_card.Active_Flag := 'N';
5069: l_create_credit_card.Inactive_Date := TRUNC(SYSDATE - 1);
5070: l_create_credit_card.single_use_flag := 'Y';
5071:
5072: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5073: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Before Calling IBY_FNDCPT_SETUP_PUB.Update_Card .....');
5074: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5075: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5076: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);

Line 5073: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Before Calling IBY_FNDCPT_SETUP_PUB.Update_Card .....');

5069: l_create_credit_card.Inactive_Date := TRUNC(SYSDATE - 1);
5070: l_create_credit_card.single_use_flag := 'Y';
5071:
5072: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5073: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Before Calling IBY_FNDCPT_SETUP_PUB.Update_Card .....');
5074: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5075: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5076: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5077: end if;

Line 5074: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);

5070: l_create_credit_card.single_use_flag := 'Y';
5071:
5072: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5073: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Before Calling IBY_FNDCPT_SETUP_PUB.Update_Card .....');
5074: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5075: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5076: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5077: end if;
5078:

Line 5075: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);

5071:
5072: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5073: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Before Calling IBY_FNDCPT_SETUP_PUB.Update_Card .....');
5074: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5075: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5076: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5077: end if;
5078:
5079: IBY_FNDCPT_SETUP_PUB.Update_Card

Line 5076: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);

5072: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5073: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Before Calling IBY_FNDCPT_SETUP_PUB.Update_Card .....');
5074: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5075: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5076: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5077: end if;
5078:
5079: IBY_FNDCPT_SETUP_PUB.Update_Card
5080: (

Line 5116: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5112: -- Bug#14797865 : Removed the condition if billing_addr_use is required
5113: IF(l_cc_bill_to_site_id <> 0 AND l_cc_bill_to_site_id <> -1) THEN
5114: l_create_credit_card.Billing_Address_Id := l_cc_bill_to_site_id;
5115: END IF;
5116: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');
5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);

Line 5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');

5113: IF(l_cc_bill_to_site_id <> 0 AND l_cc_bill_to_site_id <> -1) THEN
5114: l_create_credit_card.Billing_Address_Id := l_cc_bill_to_site_id;
5115: END IF;
5116: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');
5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5121: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Inactive_Date: '||l_create_credit_card.Inactive_Date);

Line 5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);

5114: l_create_credit_card.Billing_Address_Id := l_cc_bill_to_site_id;
5115: END IF;
5116: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');
5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5121: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Inactive_Date: '||l_create_credit_card.Inactive_Date);
5122: end if;

Line 5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);

5115: END IF;
5116: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');
5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5121: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Inactive_Date: '||l_create_credit_card.Inactive_Date);
5122: end if;
5123:

Line 5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);

5116: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');
5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5121: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Inactive_Date: '||l_create_credit_card.Inactive_Date);
5122: end if;
5123:
5124: IBY_FNDCPT_SETUP_PUB.Update_Card

Line 5121: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Inactive_Date: '||l_create_credit_card.Inactive_Date);

5117: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Inside Else,Save payment instr set to yes..before update CC');
5118: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Card_Id : ' || l_create_credit_card.Card_Id);
5119: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Active_Flag : '||l_create_credit_card.Active_Flag);
5120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.single_use_flag : '||l_create_credit_card.single_use_flag);
5121: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_create_credit_card.Inactive_Date: '||l_create_credit_card.Inactive_Date);
5122: end if;
5123:
5124: IBY_FNDCPT_SETUP_PUB.Update_Card
5125: (

Line 5180: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5176: END IF;
5177:
5178: p_status := FND_API.G_RET_STS_SUCCESS;
5179:
5180: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
5182: 'End-');
5183: end if;
5184:

Line 5181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

5177:
5178: p_status := FND_API.G_RET_STS_SUCCESS;
5179:
5180: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
5182: 'End-');
5183: end if;
5184:
5185: EXCEPTION

Line 5917: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5913: FETCH cc_profile_pmt_method_info_cur INTO cc_profile_pmt_method_info;
5914: /* If CC Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
5915: IF cc_profile_pmt_method_info_cur%FOUND THEN
5916: l_debug_info := 'Payment Method Set in the profile OIR_CC_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5917: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5918: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5919: end if;
5920: RETURN 1;
5921: ELSE

Line 5918: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

5914: /* If CC Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
5915: IF cc_profile_pmt_method_info_cur%FOUND THEN
5916: l_debug_info := 'Payment Method Set in the profile OIR_CC_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5917: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5918: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5919: end if;
5920: RETURN 1;
5921: ELSE
5922: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');

Line 5923: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5919: end if;
5920: RETURN 1;
5921: ELSE
5922: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5923: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5924: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5925: end if;
5926: RETURN 0;
5927: END IF;

Line 5924: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

5920: RETURN 1;
5921: ELSE
5922: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5923: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5924: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5925: end if;
5926: RETURN 0;
5927: END IF;
5928: CLOSE cc_profile_pmt_method_info_cur;

Line 5934: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5930: END IF;
5931:
5932: l_debug_info := 'No value is set in the profile OIR_CC_PMT_METHOD. Checking at customer site, acct and system options level.';
5933:
5934: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5935: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5936: end if;
5937:
5938: /* Default behavior, as no Credit Card Payment method is mentioned in the OIR_CC_PMT_METHOD profile */

Line 5935: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

5931:
5932: l_debug_info := 'No value is set in the profile OIR_CC_PMT_METHOD. Checking at customer site, acct and system options level.';
5933:
5934: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5935: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5936: end if;
5937:
5938: /* Default behavior, as no Credit Card Payment method is mentioned in the OIR_CC_PMT_METHOD profile */
5939:

Line 6104: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6100: FETCH ba_profile_pmt_method_info_cur INTO ba_profile_pmt_method_info;
6101: /* If Bank Account Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
6102: IF ba_profile_pmt_method_info_cur%FOUND THEN
6103: l_debug_info := 'Payment Method Set in the profile OIR_BA_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6104: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6106: end if;
6107: RETURN 1;
6108: ELSE

Line 6105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

6101: /* If Bank Account Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
6102: IF ba_profile_pmt_method_info_cur%FOUND THEN
6103: l_debug_info := 'Payment Method Set in the profile OIR_BA_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6104: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6106: end if;
6107: RETURN 1;
6108: ELSE
6109: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');

Line 6110: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6106: end if;
6107: RETURN 1;
6108: ELSE
6109: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6110: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6111: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6112: end if;
6113: RETURN 0;
6114: END IF;

Line 6111: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

6107: RETURN 1;
6108: ELSE
6109: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6110: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6111: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6112: end if;
6113: RETURN 0;
6114: END IF;
6115: CLOSE ba_profile_pmt_method_info_cur;

Line 6121: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6117: END IF;
6118:
6119: l_debug_info := 'No value is set in the profile OIR_BA_PMT_METHOD. Checking at customer site, acct and system options level.';
6120:
6121: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6122: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6123: end if;
6124:
6125: /* Default behavior, as no Bank Account Payment method is mentioned in the OIR_BA_PMT_METHOD profile */

Line 6122: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);

6118:
6119: l_debug_info := 'No value is set in the profile OIR_BA_PMT_METHOD. Checking at customer site, acct and system options level.';
6120:
6121: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6122: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6123: end if;
6124:
6125: /* Default behavior, as no Bank Account Payment method is mentioned in the OIR_BA_PMT_METHOD profile */
6126:

Line 6751: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6747:
6748: l_procedure_name := '.get_customer_site_use_id';
6749: l_customer_site_use_id := NULL;
6750:
6751: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6752: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Begin+');
6753: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
6754: 'p_session_id=' || p_session_id ||
6755: 'p_user_id=' || FND_GLOBAL.user_id ||

Line 6752: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Begin+');

6748: l_procedure_name := '.get_customer_site_use_id';
6749: l_customer_site_use_id := NULL;
6750:
6751: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6752: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Begin+');
6753: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
6754: 'p_session_id=' || p_session_id ||
6755: 'p_user_id=' || FND_GLOBAL.user_id ||
6756: 'p_customer_id=' || p_customer_id);

Line 6753: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,

6749: l_customer_site_use_id := NULL;
6750:
6751: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6752: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'Begin+');
6753: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
6754: 'p_session_id=' || p_session_id ||
6755: 'p_user_id=' || FND_GLOBAL.user_id ||
6756: 'p_customer_id=' || p_customer_id);
6757: end if;

Line 6763: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6759:
6760: ---------------------------------------------------------------------------
6761: l_debug_info := 'Check if the user has access to the primary bill to site id';
6762: ---------------------------------------------------------------------------
6763: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6764: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
6765: end if;
6766:
6767: BEGIN

Line 6764: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);

6760: ---------------------------------------------------------------------------
6761: l_debug_info := 'Check if the user has access to the primary bill to site id';
6762: ---------------------------------------------------------------------------
6763: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6764: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,l_debug_info);
6765: end if;
6766:
6767: BEGIN
6768:

Line 6786: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6782: WHEN NO_DATA_FOUND THEN
6783: l_customer_site_use_id := NULL;
6784: END;
6785:
6786: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6787: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Check for acess to the Primary bill to site returned site id=' || l_customer_site_use_id);
6788: end if;
6789:
6790: IF (l_customer_site_use_id IS NULL) THEN

Line 6787: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Check for acess to the Primary bill to site returned site id=' || l_customer_site_use_id);

6783: l_customer_site_use_id := NULL;
6784: END;
6785:
6786: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6787: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Check for acess to the Primary bill to site returned site id=' || l_customer_site_use_id);
6788: end if;
6789:
6790: IF (l_customer_site_use_id IS NULL) THEN
6791: /* So, user does not have access to primary bill to site

Line 6799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6795: LOOP
6796: FETCH get_cust_site_use_id_cur INTO l_customer_site_use_id ;
6797:
6798: IF get_cust_site_use_id_cur%ROWCOUNT >1 THEN
6799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'The selected transactions belong to more than one site');
6801: end if;
6802: l_customer_site_use_id := -1;
6803: EXIT;

Line 6800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'The selected transactions belong to more than one site');

6796: FETCH get_cust_site_use_id_cur INTO l_customer_site_use_id ;
6797:
6798: IF get_cust_site_use_id_cur%ROWCOUNT >1 THEN
6799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'The selected transactions belong to more than one site');
6801: end if;
6802: l_customer_site_use_id := -1;
6803: EXIT;
6804: ELSIF get_cust_site_use_id_cur%ROWCOUNT = 0 THEN

Line 6805: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6801: end if;
6802: l_customer_site_use_id := -1;
6803: EXIT;
6804: ELSIF get_cust_site_use_id_cur%ROWCOUNT = 0 THEN
6805: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6806: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Query on ar_irec_payment_list_gt returned 0 rows');
6807: end if;
6808: RAISE e_no_rows_in_GT;
6809: EXIT;

Line 6806: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Query on ar_irec_payment_list_gt returned 0 rows');

6802: l_customer_site_use_id := -1;
6803: EXIT;
6804: ELSIF get_cust_site_use_id_cur%ROWCOUNT = 0 THEN
6805: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6806: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Query on ar_irec_payment_list_gt returned 0 rows');
6807: end if;
6808: RAISE e_no_rows_in_GT;
6809: EXIT;
6810: END IF;

Line 6818: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

6814: CLOSE get_cust_site_use_id_cur;
6815:
6816: END IF;
6817:
6818: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6819: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return val: l_customer_site_use_id=' || l_customer_site_use_id);
6820: end if;
6821:
6822: RETURN l_customer_site_use_id;

Line 6819: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return val: l_customer_site_use_id=' || l_customer_site_use_id);

6815:
6816: END IF;
6817:
6818: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6819: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return val: l_customer_site_use_id=' || l_customer_site_use_id);
6820: end if;
6821:
6822: RETURN l_customer_site_use_id;
6823: