DBA Data[Home] [Help]

APPS.ECE_RULES_PKG dependencies on ECE_TRADING_PARTNERS_PUB

Line 2021: g_bank, ece_trading_partners_pub.g_bank,

2017: else
2018: xProgress := 'ECERULEB-130-1190';
2019: ec_debug.pl(3,'Address Type',ec_utils.g_stack(l_stack_pos).variable_value);
2020: select DECODE (ec_utils.g_stack(l_stack_pos).variable_value,
2021: g_bank, ece_trading_partners_pub.g_bank,
2022: g_customer, ece_trading_partners_pub.g_customer,
2023: g_supplier, ece_trading_partners_pub.g_supplier,
2024: g_hr_location, ece_trading_partners_pub.g_hr_location,
2025: NULL) into l_address_type from dual;

Line 2022: g_customer, ece_trading_partners_pub.g_customer,

2018: xProgress := 'ECERULEB-130-1190';
2019: ec_debug.pl(3,'Address Type',ec_utils.g_stack(l_stack_pos).variable_value);
2020: select DECODE (ec_utils.g_stack(l_stack_pos).variable_value,
2021: g_bank, ece_trading_partners_pub.g_bank,
2022: g_customer, ece_trading_partners_pub.g_customer,
2023: g_supplier, ece_trading_partners_pub.g_supplier,
2024: g_hr_location, ece_trading_partners_pub.g_hr_location,
2025: NULL) into l_address_type from dual;
2026: end if;

Line 2023: g_supplier, ece_trading_partners_pub.g_supplier,

2019: ec_debug.pl(3,'Address Type',ec_utils.g_stack(l_stack_pos).variable_value);
2020: select DECODE (ec_utils.g_stack(l_stack_pos).variable_value,
2021: g_bank, ece_trading_partners_pub.g_bank,
2022: g_customer, ece_trading_partners_pub.g_customer,
2023: g_supplier, ece_trading_partners_pub.g_supplier,
2024: g_hr_location, ece_trading_partners_pub.g_hr_location,
2025: NULL) into l_address_type from dual;
2026: end if;
2027:

Line 2024: g_hr_location, ece_trading_partners_pub.g_hr_location,

2020: select DECODE (ec_utils.g_stack(l_stack_pos).variable_value,
2021: g_bank, ece_trading_partners_pub.g_bank,
2022: g_customer, ece_trading_partners_pub.g_customer,
2023: g_supplier, ece_trading_partners_pub.g_supplier,
2024: g_hr_location, ece_trading_partners_pub.g_hr_location,
2025: NULL) into l_address_type from dual;
2026: end if;
2027:
2028: xProgress := 'ECERULEB-130-1200';

Line 2207: ece_trading_partners_pub.ece_get_address_wrapper(

2203: if l_found_on_tbl = 'N' then -- Bug 2614728
2204:
2205: -- Call the address derivation api to get the address information. hgandiko1
2206: xProgress := 'ECERULEB-130-1220';
2207: ece_trading_partners_pub.ece_get_address_wrapper(
2208: p_api_version_number => 1.0,
2209: x_return_status => l_return_status,
2210: x_msg_count => l_msg_count,
2211: x_msg_data => l_msg_data,

Line 2289: if (l_status_code = ece_trading_partners_pub.g_no_errors) then

2285:
2286: -- assign the address info that got from address derivation to
2287: -- pl/sql table.
2288: xProgress := 'ECERULEB-130-1240';
2289: if (l_status_code = ece_trading_partners_pub.g_no_errors) then
2290: xProgress := 'ECERULEB-130-1250';
2291: l_valid_rule := 'Y';
2292:
2293: if (p_entity_id_pos is not null) and (x_entity_id is not null) then

Line 2399: elsif (l_status_code = ece_trading_partners_pub.g_inconsistent_addr_comp) then

2395: end if;
2396:
2397: /* bug 2151462 Added new messages and modified the existing ones */
2398:
2399: elsif (l_status_code = ece_trading_partners_pub.g_inconsistent_addr_comp) then
2400: xProgress := 'ECERULEB-130-1450';
2401: fnd_message.set_name ('EC', 'ECE_INCONSISENT_ADDRESS');
2402: fnd_message.set_token ('ADDRESS', p_address);
2403: fnd_message.set_token ('A1', l_addr1);

Line 2415: elsif (l_status_code = ece_trading_partners_pub.g_multiple_addr_found) then

2411: l_msg_text := fnd_message.get;
2412: ec_debug.pl (0, l_msg_text);
2413: l_valid_rule := 'N';
2414:
2415: elsif (l_status_code = ece_trading_partners_pub.g_multiple_addr_found) then
2416: xProgress := 'ECERULEB-130-1460';
2417: fnd_message.set_name ('EC', 'ECE_MULTIPLE_ADDR_FOUND');
2418: fnd_message.set_token ('ADDRESS', p_address);
2419: fnd_message.set_token ('A1', l_addr1);

Line 2431: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr) then

2427: l_msg_text := fnd_message.get;
2428: ec_debug.pl (0, l_msg_text);
2429: l_valid_rule := 'N';
2430:
2431: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr) then
2432: xProgress := 'ECERULEB-130-1470';
2433: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS');
2434: fnd_message.set_token ('ADDRESS', p_address);
2435: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

Line 2441: elsif (l_status_code = ece_trading_partners_pub.g_multiple_loc_found) then

2437: l_msg_text := fnd_message.get;
2438: ec_debug.pl (0, l_msg_text);
2439: l_valid_rule := 'N';
2440:
2441: elsif (l_status_code = ece_trading_partners_pub.g_multiple_loc_found) then
2442: xProgress := 'ECERULEB-130-1480';
2443: fnd_message.set_name ('EC', 'ECE_MULTIPLE_LOC_FOUND');
2444: fnd_message.set_token ('ADDRESS', p_address);
2445: fnd_message.set_token ('LOCATION_CODE', l_tp_location_code);

Line 2451: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr_id) then

2447: l_msg_text := fnd_message.get;
2448: ec_debug.pl (0, l_msg_text);
2449: l_valid_rule := 'N';
2450:
2451: elsif (l_status_code = ece_trading_partners_pub.g_cannot_derive_addr_id) then
2452: xProgress := 'ECERULEB-130-1490';
2453: fnd_message.set_name ('EC', 'ECE_CANNOT_DERIVE_ADDRESS_ID');
2454: fnd_message.set_token ('ADDRESS', p_address);
2455: l_msg_text := fnd_message.get;

Line 2461: if (l_status_code = ece_trading_partners_pub.g_invalid_addr_id) then

2457: l_valid_rule := 'N';
2458: end if;
2459:
2460: else
2461: if (l_status_code = ece_trading_partners_pub.g_invalid_addr_id) then
2462: xProgress := 'ECERULEB-130-1500';
2463: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_ID');
2464: fnd_message.set_token ('ADDRESS', p_address);
2465: fnd_message.set_token ('ADDRESS_ID', l_addr_id);

Line 2471: elsif (l_status_code = ece_trading_partners_pub.g_invalid_org_id) then

2467: l_msg_text := fnd_message.get;
2468: ec_debug.pl (0, l_msg_text);
2469: l_valid_rule := 'N';
2470:
2471: elsif (l_status_code = ece_trading_partners_pub.g_invalid_org_id) then
2472: xProgress := 'ECERULEB-130-1510';
2473: fnd_message.set_name ('EC', 'ECE_INVALID_ORG_ID');
2474: fnd_message.set_token ('ORG_ID', l_org_id);
2475: l_msg_text := fnd_message.get;

Line 2479: elsif (l_status_code = ece_trading_partners_pub.g_invalid_parameter) then

2475: l_msg_text := fnd_message.get;
2476: ec_debug.pl (0, l_msg_text);
2477: l_valid_rule := 'N';
2478:
2479: elsif (l_status_code = ece_trading_partners_pub.g_invalid_parameter) then
2480: xProgress := 'ECERULEB-130-1520';
2481: fnd_message.set_name ('EC', 'ECE_INVALID_ADDR_PARAMETER');
2482: fnd_message.set_token ('ADDRESS', p_address);
2483: l_msg_text := fnd_message.get;