APPS.ECE_TRADING_PARTNERS_PUB dependencies on EC_TRADING_PARTNER_PVT

Line 2975: if ( p_info_type = EC_Trading_Partner_PVT.G_CUSTOMER)

2971:
2972: p_return_status := FND_API.G_RET_STS_SUCCESS;
2973:
2974:
2975: if ( p_info_type = EC_Trading_Partner_PVT.G_CUSTOMER)
2976: then
2977: for addr in ra_add
2978: loop
2979: l_entity_id := addr.cust_account_id;

Line 2983: elsif (p_info_type = EC_Trading_Partner_PVT.G_SUPPLIER)

2979: l_entity_id := addr.cust_account_id;
2980: l_entity_address_id := addr.cust_acct_site_id;
2981: end loop;
2982:
2983: elsif (p_info_type = EC_Trading_Partner_PVT.G_SUPPLIER)
2984: then
2985: for site in po_site
2986: loop
2987: l_entity_id := site.vendor_id;

Line 2991: elsif (p_info_type = EC_Trading_Partner_PVT.G_BANK)

2987: l_entity_id := site.vendor_id;
2988: l_entity_address_id := site.vendor_site_id;
2989: end loop;
2990:
2991: elsif (p_info_type = EC_Trading_Partner_PVT.G_BANK)
2992: then
2993: for bank in ap_bank
2994: loop
2995: l_entity_id := -1;

Line 3005: p_return_status := EC_Trading_Partner_PVT.G_TP_NOT_FOUND;

3001:
3002: if l_entity_id is NULL
3003: and l_entity_address_id is NULL
3004: then
3005: p_return_status := EC_Trading_Partner_PVT.G_TP_NOT_FOUND;
3006: fnd_message.set_name('EC','ECE_TP_NOT_FOUND');
3007: p_msg_data := fnd_message.get;
3008: else
3009: p_entity_id := l_entity_id;

Line 3198: if ( p_info_type = EC_Trading_Partner_PVT.G_CUSTOMER)

3194:
3195: p_return_status := FND_API.G_RET_STS_SUCCESS;
3196:
3197:
3198: if ( p_info_type = EC_Trading_Partner_PVT.G_CUSTOMER)
3199: then
3200: for addr in ra_add
3201: loop
3202: l_entity_id := addr.cust_account_id;

Line 3206: elsif (p_info_type = EC_Trading_Partner_PVT.G_SUPPLIER)

3202: l_entity_id := addr.cust_account_id;
3203: l_entity_address_id := addr.cust_acct_site_id;
3204: end loop;
3205:
3206: elsif (p_info_type = EC_Trading_Partner_PVT.G_SUPPLIER)
3207: then
3208: for site in po_site
3209: loop
3210: l_entity_id := site.vendor_id;

Line 3214: elsif (p_info_type = EC_Trading_Partner_PVT.G_BANK)

3210: l_entity_id := site.vendor_id;
3211: l_entity_address_id := site.vendor_site_id;
3212: end loop;
3213:
3214: elsif (p_info_type = EC_Trading_Partner_PVT.G_BANK)
3215: then
3216: for bank in ap_bank
3217: loop
3218: l_entity_id := -1;

Line 3228: p_return_status := EC_Trading_Partner_PVT.G_TP_NOT_FOUND;

3224:
3225: if l_entity_id is NULL
3226: and l_entity_address_id is NULL
3227: then
3228: p_return_status := EC_Trading_Partner_PVT.G_TP_NOT_FOUND;
3229: fnd_message.set_name('EC','ECE_TP_NOT_FOUND');
3230: p_msg_data := fnd_message.get;
3231: else
3232: p_entity_id := l_entity_id;

Line 3411: if ( p_info_type = EC_Trading_Partner_PVT.G_CUSTOMER)

3407:
3408: p_return_status := FND_API.G_RET_STS_SUCCESS;
3409:
3410:
3411: if ( p_info_type = EC_Trading_Partner_PVT.G_CUSTOMER)
3412: then
3413: for addr in ra_add loop
3414: l_location_code_ext := addr.ece_tp_location_code;
3415: p_reference_ext1 := addr.tp_reference_ext1;

Line 3420: elsif (p_info_type = EC_Trading_Partner_PVT.G_SUPPLIER)

3416: p_reference_ext2 := addr.tp_reference_ext2;
3417: end loop;
3418:
3419:
3420: elsif (p_info_type = EC_Trading_Partner_PVT.G_SUPPLIER)
3421: then
3422: for site in po_site loop
3423: l_location_code_ext := site.ece_tp_location_code;
3424: p_reference_ext1 := site.tp_reference_ext1;

Line 3428: elsif (p_info_type = EC_Trading_Partner_PVT.G_BANK)

3424: p_reference_ext1 := site.tp_reference_ext1;
3425: p_reference_ext2 := site.tp_reference_ext2;
3426: end loop;
3427:
3428: elsif (p_info_type = EC_Trading_Partner_PVT.G_BANK)
3429: then
3430: for bank in ap_bank loop
3431: l_location_code_ext := bank.edi_ece_tp_location_code;
3432: p_reference_ext1 := bank.tp_reference_ext1;

Line 3441: p_return_status := EC_Trading_Partner_PVT.G_TP_NOT_FOUND;

3437: end if;
3438:
3439: if l_location_code_ext is NULL
3440: then
3441: p_return_status := EC_Trading_Partner_PVT.G_TP_NOT_FOUND;
3442: fnd_message.set_name('EC','ECE_TP_NOT_FOUND');
3443: p_msg_data := fnd_message.get;
3444: else
3445: p_location_code_ext := l_location_code_ext;