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.OE_ORDER_GRP dependencies on OE_DEBUG_PUB

Line 313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

309:
310: l_aac_header_rec OE_Order_PUB.Header_Rec_Type;
311: l_aac_line_tbl OE_Order_PUB.Line_Tbl_Type;
312: I NUMBER;
313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
314: BEGIN
315:
316: IF l_debug_level > 0 THEN /* added for 3677092 */
317: oe_debug_pub.add( 'ENTERING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

Line 317: oe_debug_pub.add( 'ENTERING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
314: BEGIN
315:
316: IF l_debug_level > 0 THEN /* added for 3677092 */
317: oe_debug_pub.add( 'ENTERING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;
318: END IF;
319:
320: l_return_status := FND_API.G_RET_STS_SUCCESS; --Nocopy changes
321:

Line 2676: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

2672:
2673: type line_acct_needed_tbl is table of line_acct index by binary_integer;
2674: l_line_acct_needed line_acct_needed_tbl;
2675:
2676: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
2677:
2678: BEGIN
2679: --oe_create_account_info.set_debug_on();
2680:

Line 2682: oe_debug_pub.add(' AAC:Inside Process Order: Automatic Account Creation');

2678: BEGIN
2679: --oe_create_account_info.set_debug_on();
2680:
2681: IF l_debug_level > 0 THEN
2682: oe_debug_pub.add(' AAC:Inside Process Order: Automatic Account Creation');
2683: oe_debug_pub.add(' operation='||p_header_rec.operation);
2684: END IF;
2685:
2686: /* copy input records to output records */

Line 2683: oe_debug_pub.add(' operation='||p_header_rec.operation);

2679: --oe_create_account_info.set_debug_on();
2680:
2681: IF l_debug_level > 0 THEN
2682: oe_debug_pub.add(' AAC:Inside Process Order: Automatic Account Creation');
2683: oe_debug_pub.add(' operation='||p_header_rec.operation);
2684: END IF;
2685:
2686: /* copy input records to output records */
2687: x_header_rec := p_header_rec;

Line 2698: oe_debug_pub.add('AAC: Selecting Customer Based on old sold_to_org_id');

2694: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2695: p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2696:
2697: IF l_debug_level > 0 THEN
2698: oe_debug_pub.add('AAC: Selecting Customer Based on old sold_to_org_id');
2699: END IF;
2700: SELECT SOLD_TO_ORG_ID
2701: INTO l_sold_to_org_id
2702: FROM OE_ORDER_HEADERS

Line 2710: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);

2706:
2707:
2708:
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2711: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2712: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2713: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2714: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);

Line 2711: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);

2707:
2708:
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2711: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2712: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2713: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2714: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2715: END IF;

Line 2712: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);

2708:
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2711: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2712: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2713: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2714: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2715: END IF;
2716:

Line 2713: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);

2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2711: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2712: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2713: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2714: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2715: END IF;
2716:
2717: /* check to see if we need account creation at all, return ASAP if not{ */

Line 2714: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);

2710: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2711: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2712: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2713: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2714: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2715: END IF;
2716:
2717: /* check to see if we need account creation at all, return ASAP if not{ */
2718: /* check header level party info */

Line 2730: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');

2726: and (nvl(p_header_val_Rec.sold_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2727: or nvl(p_header_Rec.sold_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)))
2728: THEN
2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');
2731: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2732: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2733: END IF;
2734: l_create_account := TRUE;

Line 2731: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);

2727: or nvl(p_header_Rec.sold_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)))
2728: THEN
2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');
2731: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2732: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2733: END IF;
2734: l_create_account := TRUE;
2735: l_create_hdr_account := TRUE;

Line 2732: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);

2728: THEN
2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');
2731: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2732: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2733: END IF;
2734: l_create_account := TRUE;
2735: l_create_hdr_account := TRUE;
2736: END IF;

Line 2762: oe_debug_pub.add('AAC: ship_to sites creation needed');

2758: nvl(p_header_val_Rec.ship_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
2759: nvl(p_header_val_Rec.ship_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)))
2760: THEN
2761: IF l_debug_level > 0 THEN
2762: oe_debug_pub.add('AAC: ship_to sites creation needed');
2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);

Line 2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);

2759: nvl(p_header_val_Rec.ship_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)))
2760: THEN
2761: IF l_debug_level > 0 THEN
2762: oe_debug_pub.add('AAC: ship_to sites creation needed');
2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);

Line 2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);

2760: THEN
2761: IF l_debug_level > 0 THEN
2762: oe_debug_pub.add('AAC: ship_to sites creation needed');
2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);

Line 2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);

2761: IF l_debug_level > 0 THEN
2762: oe_debug_pub.add('AAC: ship_to sites creation needed');
2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);

Line 2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);

2762: oe_debug_pub.add('AAC: ship_to sites creation needed');
2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);

Line 2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);

2763: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);

Line 2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);

2764: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2772: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);

Line 2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);

2765: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2772: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2773: END IF;

Line 2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);

2766: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2772: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2773: END IF;
2774:

Line 2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);

2767: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2772: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2773: END IF;
2774:
2775: l_create_account := TRUE;

Line 2772: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);

2768: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2769: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2770: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2771: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2772: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2773: END IF;
2774:
2775: l_create_account := TRUE;
2776: l_create_hdr_account := TRUE;

Line 2833: oe_debug_pub.add('AAC: deliver_to sites creation needed');

2829: nvl(p_header_val_Rec.deliver_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)))
2830:
2831: THEN
2832: IF l_debug_level > 0 THEN
2833: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);

Line 2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);

2830:
2831: THEN
2832: IF l_debug_level > 0 THEN
2833: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);

Line 2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);

2831: THEN
2832: IF l_debug_level > 0 THEN
2833: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);

Line 2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);

2832: IF l_debug_level > 0 THEN
2833: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);

Line 2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);

2833: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);

Line 2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);

2834: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);

Line 2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);

2835: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2843: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);

Line 2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);

2836: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2843: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2844: END IF;

Line 2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);

2837: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2843: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2844: END IF;
2845:

Line 2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);

2838: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2843: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2844: END IF;
2845:
2846: l_create_account := TRUE;

Line 2843: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);

2839: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2840: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2841: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2842: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2843: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2844: END IF;
2845:
2846: l_create_account := TRUE;
2847: l_create_hdr_account := TRUE;

Line 2904: oe_debug_pub.add('AAC: invoice_to sites creation needed');

2900: nvl(p_header_val_Rec.invoice_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
2901:
2902: THEN
2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add('AAC: invoice_to sites creation needed');
2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);

Line 2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);

2901:
2902: THEN
2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add('AAC: invoice_to sites creation needed');
2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);

Line 2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);

2902: THEN
2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add('AAC: invoice_to sites creation needed');
2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);

Line 2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);

2903: IF l_debug_level > 0 THEN
2904: oe_debug_pub.add('AAC: invoice_to sites creation needed');
2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);

Line 2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);

2904: oe_debug_pub.add('AAC: invoice_to sites creation needed');
2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);

Line 2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);

2905: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
2913: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);

Line 2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);

2906: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
2913: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
2914: END IF;

Line 2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);

2907: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
2913: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
2914: END IF;
2915:

Line 2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);

2908: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
2913: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
2914: END IF;
2915:
2916: l_create_account := TRUE;

Line 2913: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);

2909: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
2910: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
2911: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
2912: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
2913: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
2914: END IF;
2915:
2916: l_create_account := TRUE;
2917: l_create_hdr_account := TRUE;

Line 2967: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem

2963: p_site_tbl(l_site_tbl_counter).p_party_number := p_header_rec.end_customer_party_number;
2964: p_site_tbl(l_site_tbl_counter).p_cust_account_number := p_header_val_Rec.end_customer_number;
2965: p_site_tbl(l_site_tbl_counter).p_site_use_code := 'END_CUST';
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
2968: oe_debug_pub.add('AAC: end customer account creation needed');
2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);

Line 2968: oe_debug_pub.add('AAC: end customer account creation needed');

2964: p_site_tbl(l_site_tbl_counter).p_cust_account_number := p_header_val_Rec.end_customer_number;
2965: p_site_tbl(l_site_tbl_counter).p_site_use_code := 'END_CUST';
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
2968: oe_debug_pub.add('AAC: end customer account creation needed');
2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
2972: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);

Line 2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);

2965: p_site_tbl(l_site_tbl_counter).p_site_use_code := 'END_CUST';
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
2968: oe_debug_pub.add('AAC: end customer account creation needed');
2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
2972: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
2973: END IF;

Line 2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);

2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
2968: oe_debug_pub.add('AAC: end customer account creation needed');
2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
2972: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
2973: END IF;
2974:

Line 2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);

2967: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
2968: oe_debug_pub.add('AAC: end customer account creation needed');
2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
2972: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
2973: END IF;
2974:
2975:

Line 2972: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);

2968: oe_debug_pub.add('AAC: end customer account creation needed');
2969: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
2970: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
2971: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
2972: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
2973: END IF;
2974:
2975:
2976: IF p_header_rec.end_customer_party_site_id is not null or

Line 2990: oe_debug_pub.add('AAC: end customer sites creation needed');

2986: nvl(p_header_val_Rec.end_customer_site_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
2987: nvl(p_header_val_Rec.end_customer_site_postal_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR then
2988:
2989: IF l_debug_level > 0 THEN
2990: oe_debug_pub.add('AAC: end customer sites creation needed');
2991: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
2992: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
2993: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
2994: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);

Line 2991: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);

2987: nvl(p_header_val_Rec.end_customer_site_postal_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR then
2988:
2989: IF l_debug_level > 0 THEN
2990: oe_debug_pub.add('AAC: end customer sites creation needed');
2991: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
2992: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
2993: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
2994: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
2995: END IF;

Line 2992: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);

2988:
2989: IF l_debug_level > 0 THEN
2990: oe_debug_pub.add('AAC: end customer sites creation needed');
2991: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
2992: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
2993: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
2994: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
2995: END IF;
2996:

Line 2993: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);

2989: IF l_debug_level > 0 THEN
2990: oe_debug_pub.add('AAC: end customer sites creation needed');
2991: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
2992: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
2993: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
2994: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
2995: END IF;
2996:
2997:

Line 2994: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);

2990: oe_debug_pub.add('AAC: end customer sites creation needed');
2991: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
2992: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
2993: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
2994: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
2995: END IF;
2996:
2997:
2998: if(p_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM)

Line 3029: oe_debug_pub.add('AAC: no header level account creation needed, checking all lines');

3025:
3026: /* if no header level account creation needed, check all lines{ */
3027: IF (l_create_account = FALSE )
3028: THEN
3029: oe_debug_pub.add('AAC: no header level account creation needed, checking all lines');
3030: if x_line_tbl.COUNT > 0 then
3031:
3032: IF l_debug_level > 0 THEN
3033: oe_debug_pub.add('X1');

Line 3033: oe_debug_pub.add('X1');

3029: oe_debug_pub.add('AAC: no header level account creation needed, checking all lines');
3030: if x_line_tbl.COUNT > 0 then
3031:
3032: IF l_debug_level > 0 THEN
3033: oe_debug_pub.add('X1');
3034: END IF;
3035: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3036: IF l_debug_level > 0 THEN
3037: oe_debug_pub.add('X2');

Line 3037: oe_debug_pub.add('X2');

3033: oe_debug_pub.add('X1');
3034: END IF;
3035: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3036: IF l_debug_level > 0 THEN
3037: oe_debug_pub.add('X2');
3038: END IF;
3039: /* l_create_account might change in this loop, so keep checking */
3040: IF ( l_create_Account = FALSE
3041: and

Line 3068: oe_debug_pub.add('AAC: line level account creation needed');

3064: x_line_tbl(i).end_customer_party_site_use_id is not null))
3065: ))
3066: THEN
3067: IF l_debug_level > 0 THEN
3068: oe_debug_pub.add('AAC: line level account creation needed');
3069: END IF;
3070: l_create_account := TRUE;
3071: END IF; /* ok, we need account creation */
3072:

Line 3090: oe_debug_pub.add('ship to value present line#'||i);

3086: nvl(p_line_val_tbl(i).ship_to_customer_name_oi,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3087: nvl(p_line_val_tbl(i).ship_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3088: then
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add('ship to value present line#'||i);
3091: END IF;
3092: l_create_account := TRUE;
3093: end if;
3094:

Line 3109: oe_debug_pub.add('deliver to value present line#'||i);

3105: nvl(p_line_val_tbl(i).deliver_to_customer_name_oi,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3106: nvl(p_line_val_tbl(i).deliver_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3107: then
3108: IF l_debug_level > 0 THEN
3109: oe_debug_pub.add('deliver to value present line#'||i);
3110: END IF;
3111: l_create_account := TRUE;
3112: end if;
3113:

Line 3136: oe_debug_pub.add('invoice to value present line#'||i);

3132: IF (x_line_tbl(i).invoice_to_org_contact_id is not null or
3133: nvl(p_line_val_tbl(i).invoice_to_contact,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
3134: then
3135: IF l_debug_level > 0 THEN
3136: oe_debug_pub.add('invoice to value present line#'||i);
3137: END IF;
3138: l_create_account := TRUE;
3139: End If;
3140:

Line 3150: oe_debug_pub.add('once');

3146: nvl(x_line_tbl(i).end_customer_party_number,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3147: nvl(p_line_val_tbl(i).end_customer_number,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3148: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)
3149: then
3150: oe_debug_pub.add('once');
3151: l_create_account := TRUE;
3152: end if;
3153:
3154: oe_debug_pub.add('checking before org contactid');

Line 3154: oe_debug_pub.add('checking before org contactid');

3150: oe_debug_pub.add('once');
3151: l_create_account := TRUE;
3152: end if;
3153:
3154: oe_debug_pub.add('checking before org contactid');
3155:
3156: IF (x_line_tbl(i).end_customer_org_contact_id is not null or
3157: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
3158: then

Line 3160: oe_debug_pub.add('end customer value present line#'||i);

3156: IF (x_line_tbl(i).end_customer_org_contact_id is not null or
3157: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
3158: then
3159: IF l_debug_level > 0 THEN
3160: oe_debug_pub.add('end customer value present line#'||i);
3161: END IF;
3162: l_create_account := TRUE;
3163: --bug 4240715}
3164: END IF;

Line 3169: oe_debug_pub.add('AAC: done checking...');

3165: end loop;
3166: end if;
3167:
3168: /* done checking lines} */
3169: oe_debug_pub.add('AAC: done checking...');
3170: IF (l_create_account = FALSE)
3171: THEN
3172: /* we don't actually need account creation. return */
3173: x_return_status := 'S';

Line 3175: oe_debug_pub.add('AAC: no account creation needed. returning...');

3171: THEN
3172: /* we don't actually need account creation. return */
3173: x_return_status := 'S';
3174: IF l_debug_level > 0 THEN
3175: oe_debug_pub.add('AAC: no account creation needed. returning...');
3176: END IF;
3177: return;
3178: END IF;
3179:

Line 3231: oe_debug_pub.add('AAC: before calling Create_Account_layer for header level site creation{ ');

3227: if (l_create_hdr_account = TRUE)
3228: then
3229:
3230: IF l_debug_level > 0 THEN
3231: oe_debug_pub.add('AAC: before calling Create_Account_layer for header level site creation{ ');
3232: END IF;
3233:
3234: oe_create_account_info.Create_Account_Layer(
3235: p_control_rec =>p_control_rec

Line 3245: oe_debug_pub.add('AAC: after calling Create_Account_layer for header level site creation} ');

3241: ,p_account_tbl =>p_account_tbl
3242: ,p_contact_tbl =>p_contact_tbl
3243: );
3244: IF l_debug_level > 0 THEN
3245: oe_debug_pub.add('AAC: after calling Create_Account_layer for header level site creation} ');
3246: END IF;
3247:
3248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3249: l_count :=oe_msg_pub.count_msg;

Line 3252: oe_debug_pub.add('AAC: Main Status is not success'||

3248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3249: l_count :=oe_msg_pub.count_msg;
3250:
3251: IF l_debug_level > 0 THEN
3252: oe_debug_pub.add('AAC: Main Status is not success'||
3253: ' msg='||x_msg_data||
3254: ' count='||x_msg_count
3255: );
3256: END IF;

Line 3260: oe_debug_pub.add('AAC: Status is success');

3256: END IF;
3257: RAISE FND_API.G_EXC_ERROR;
3258:
3259: ELSE
3260: oe_debug_pub.add('AAC: Status is success');
3261:
3262:
3263: -- Error out IF only party and no site information
3264: IF p_account_tbl.COUNT = 0 AND p_party_customer_rec.p_party_id IS NOT NULL

Line 3267: oe_debug_pub.add('AAC: Only party, no site. error out'||

3263: -- Error out IF only party and no site information
3264: IF p_account_tbl.COUNT = 0 AND p_party_customer_rec.p_party_id IS NOT NULL
3265: THEN
3266: IF l_debug_level > 0 THEN
3267: oe_debug_pub.add('AAC: Only party, no site. error out'||
3268: ' msg='||x_msg_data||
3269: ' count='||x_msg_count);
3270: END IF;
3271: RAISE FND_API.G_EXC_ERROR;

Line 3281: oe_debug_pub.add(' More than one party site/account record'||

3277: IF p_account_tbl.COUNT <> 1
3278: THEN
3279: --error
3280: IF l_debug_level > 0 and l_header_end_cust_exists = 'N' THEN --modified for bug 4240715
3281: oe_debug_pub.add(' More than one party site/account record'||
3282: ' msg='||x_msg_data||
3283: ' count='||x_msg_count
3284: );
3285: END IF;

Line 3299: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);

3295: end if;
3296:
3297:
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);
3300: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);
3301: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');
3302: END IF;
3303:

Line 3300: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);

3296:
3297:
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);
3300: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);
3301: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');
3302: END IF;
3303:
3304: /* get the relevant ship/deliver/invoice to fields */

Line 3301: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');

3297:
3298: IF l_debug_level > 0 THEN
3299: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);
3300: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);
3301: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');
3302: END IF;
3303:
3304: /* get the relevant ship/deliver/invoice to fields */
3305: IF p_site_tbl.COUNT > 0 then

Line 3313: oe_debug_pub.add('AAC: header SHIP_TO org_id:'|| p_site_tbl(i).p_site_use_id);

3309: IF (p_site_tbl(i).p_site_use_code = 'SHIP_TO')
3310: THEN
3311:
3312: IF l_debug_level > 0 THEN
3313: oe_debug_pub.add('AAC: header SHIP_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3314: oe_debug_pub.add('AAC: header SHIP_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3315: END IF;
3316: x_header_rec.ship_to_org_id := p_site_tbl(i).p_site_use_id;
3317: x_header_rec.ship_to_customer_id := p_site_tbl(i).p_cust_account_id;

Line 3314: oe_debug_pub.add('AAC: header SHIP_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);

3310: THEN
3311:
3312: IF l_debug_level > 0 THEN
3313: oe_debug_pub.add('AAC: header SHIP_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3314: oe_debug_pub.add('AAC: header SHIP_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3315: END IF;
3316: x_header_rec.ship_to_org_id := p_site_tbl(i).p_site_use_id;
3317: x_header_rec.ship_to_customer_id := p_site_tbl(i).p_cust_account_id;
3318: x_header_rec.ship_to_contact_id := p_site_tbl(i).p_cust_account_role_id;

Line 3323: oe_debug_pub.add('AAC: header DELIVER_TO org_id:'|| p_site_tbl(i).p_site_use_id);

3319:
3320: ELSIF (p_site_tbl(i).p_site_use_code = 'DELIVER_TO')
3321: THEN
3322: IF l_debug_level > 0 THEN
3323: oe_debug_pub.add('AAC: header DELIVER_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3324: oe_debug_pub.add('AAC: header DELIVER_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3325: END IF;
3326: x_header_rec.deliver_to_org_id := p_site_tbl(i).p_site_use_id;
3327: x_header_rec.deliver_to_customer_id := p_site_tbl(i).p_cust_account_id;

Line 3324: oe_debug_pub.add('AAC: header DELIVER_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);

3320: ELSIF (p_site_tbl(i).p_site_use_code = 'DELIVER_TO')
3321: THEN
3322: IF l_debug_level > 0 THEN
3323: oe_debug_pub.add('AAC: header DELIVER_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3324: oe_debug_pub.add('AAC: header DELIVER_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3325: END IF;
3326: x_header_rec.deliver_to_org_id := p_site_tbl(i).p_site_use_id;
3327: x_header_rec.deliver_to_customer_id := p_site_tbl(i).p_cust_account_id;
3328: x_header_rec.deliver_to_contact_id := p_site_tbl(i).p_cust_account_role_id;

Line 3334: oe_debug_pub.add('AAC: header INVOICE_TO org_id:'|| p_site_tbl(i).p_site_use_id);

3330: ELSIF (p_site_tbl(i).p_site_use_code = 'BILL_TO')
3331: THEN
3332:
3333: IF l_debug_level > 0 THEN
3334: oe_debug_pub.add('AAC: header INVOICE_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3335: oe_debug_pub.add('AAC: header INVOICE_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3336: END IF;
3337: x_header_rec.invoice_to_org_id := p_site_tbl(i).p_site_use_id;
3338: x_header_rec.invoice_to_customer_id := p_site_tbl(i).p_cust_account_id;

Line 3335: oe_debug_pub.add('AAC: header INVOICE_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);

3331: THEN
3332:
3333: IF l_debug_level > 0 THEN
3334: oe_debug_pub.add('AAC: header INVOICE_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3335: oe_debug_pub.add('AAC: header INVOICE_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3336: END IF;
3337: x_header_rec.invoice_to_org_id := p_site_tbl(i).p_site_use_id;
3338: x_header_rec.invoice_to_customer_id := p_site_tbl(i).p_cust_account_id;
3339: x_header_rec.invoice_to_contact_id := p_site_tbl(i).p_cust_account_role_id;

Line 3344: oe_debug_pub.add('AAC: header End Customer :'|| p_site_tbl(i).p_site_use_id);

3340: ELSIF (p_site_tbl(i).p_site_use_code = 'END_CUST') /* end customer changes -bug 4240715 */
3341: THEN
3342:
3343: IF l_debug_level > 0 THEN
3344: oe_debug_pub.add('AAC: header End Customer :'|| p_site_tbl(i).p_site_use_id);
3345: oe_debug_pub.add('AAC: header End Customer cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3346: END IF;
3347: x_header_rec.end_customer_site_use_id := p_site_tbl(i).p_site_use_id;
3348: x_header_rec.end_customer_id := p_site_tbl(i).p_cust_account_id;

Line 3345: oe_debug_pub.add('AAC: header End Customer cust_account_id:'|| p_site_tbl(i).p_cust_account_id);

3341: THEN
3342:
3343: IF l_debug_level > 0 THEN
3344: oe_debug_pub.add('AAC: header End Customer :'|| p_site_tbl(i).p_site_use_id);
3345: oe_debug_pub.add('AAC: header End Customer cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3346: END IF;
3347: x_header_rec.end_customer_site_use_id := p_site_tbl(i).p_site_use_id;
3348: x_header_rec.end_customer_id := p_site_tbl(i).p_cust_account_id;
3349: x_header_rec.end_customer_contact_id := p_site_tbl(i).p_cust_account_role_id;

Line 3350: oe_debug_pub.add('here the end custoemr id'||x_header_rec.end_customer_contact_id);

3346: END IF;
3347: x_header_rec.end_customer_site_use_id := p_site_tbl(i).p_site_use_id;
3348: x_header_rec.end_customer_id := p_site_tbl(i).p_cust_account_id;
3349: x_header_rec.end_customer_contact_id := p_site_tbl(i).p_cust_account_role_id;
3350: oe_debug_pub.add('here the end custoemr id'||x_header_rec.end_customer_contact_id);
3351: END IF;
3352:
3353: END LOOP;
3354: end if;

Line 3358: oe_debug_pub.add('AAC: cache: start header level cache lookup... ');

3354: end if;
3355: end if; --end header level account creation
3356:
3357: IF l_debug_level > 0 THEN
3358: oe_debug_pub.add('AAC: cache: start header level cache lookup... ');
3359: END IF;
3360:
3361: /* loop through all the lines, looking for lines with party
3362: information similar to header level info, replace if

Line 3373: oe_debug_pub.add('AAC: checking if account creation needed for line.'||i);

3369:
3370: IF x_line_tbl.COUNT > 0 then
3371: FOR i IN x_line_tbl.FIRST..x_line_tbl.LAST loop
3372: IF l_debug_level > 0 THEN
3373: oe_debug_pub.add('AAC: checking if account creation needed for line.'||i);
3374: END IF;
3375: IF ((nvl(x_line_tbl(i).ship_to_org_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3376: and
3377: (x_line_tbl(i).ship_to_party_id is not null or

Line 3386: oe_debug_pub.add('AAC: ship party info not null line#'||i);

3382: (nvl(x_line_tbl(i).ship_to_contact_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3383: and x_line_tbl(i).ship_to_org_contact_id is not null ))
3384: then
3385: IF l_debug_level > 0 THEN
3386: oe_debug_pub.add('AAC: ship party info not null line#'||i);
3387: END IF;
3388:
3389: /* look for similar ship_to_party_id s */
3390: IF (nvl(x_line_tbl(i).ship_to_party_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.ship_to_party_id,FND_API.G_MISS_NUM) and

Line 3396: oe_debug_pub.add('AAC: cache: >> matching header ship_to_org_id:'||x_header_rec.ship_to_org_id||' found');

3392: nvl(x_line_tbl(i).ship_to_party_site_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.ship_to_party_site_id,FND_API.G_MISS_NUM) and
3393: nvl(x_line_tbl(i).ship_to_party_site_use_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.ship_to_party_site_use_id,FND_API.G_MISS_NUM))
3394: THEN
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add('AAC: cache: >> matching header ship_to_org_id:'||x_header_rec.ship_to_org_id||' found');
3397: END IF;
3398: x_line_tbl(i).ship_to_org_id := x_header_rec.ship_to_org_id;
3399: x_line_tbl(i).ship_to_party_id := x_header_rec.ship_to_party_id;
3400: else

Line 3403: oe_debug_pub.add('AAC: need ship account creation for line#'||i);

3399: x_line_tbl(i).ship_to_party_id := x_header_rec.ship_to_party_id;
3400: else
3401:
3402: IF l_debug_level > 0 THEN
3403: oe_debug_pub.add('AAC: need ship account creation for line#'||i);
3404: END IF;
3405: l_line_acct_needed(i).ship := TRUE;
3406: END IF;
3407: end if;

Line 3421: oe_debug_pub.add('AAC: deliver party info not null line#'||i);

3417: and x_line_tbl(i).deliver_to_org_contact_id is not null))
3418: then
3419:
3420: IF l_debug_level > 0 THEN
3421: oe_debug_pub.add('AAC: deliver party info not null line#'||i);
3422: END IF;
3423:
3424: /* look for similar deliver_to_party_id s */
3425: IF (nvl(x_line_tbl(i).deliver_to_party_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.deliver_to_party_id,FND_API.G_MISS_NUM) and

Line 3431: oe_debug_pub.add('AAC: cache: >> matching header deliver_to_org_id:'||x_header_rec.deliver_to_org_id||' found');

3427: nvl(x_line_tbl(i).deliver_to_party_site_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.deliver_to_party_site_id,FND_API.G_MISS_NUM) and
3428: nvl(x_line_tbl(i).deliver_to_party_site_use_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.deliver_to_party_site_use_id,FND_API.G_MISS_NUM))
3429: THEN
3430: IF l_debug_level > 0 THEN
3431: oe_debug_pub.add('AAC: cache: >> matching header deliver_to_org_id:'||x_header_rec.deliver_to_org_id||' found');
3432: END IF;
3433: x_line_tbl(i).deliver_to_org_id := x_header_rec.deliver_to_org_id;
3434: x_line_tbl(i).deliver_to_party_id := x_header_rec.deliver_to_party_id;
3435: else

Line 3437: oe_debug_pub.add('AAC: need deliver account creation for line#'||i);

3433: x_line_tbl(i).deliver_to_org_id := x_header_rec.deliver_to_org_id;
3434: x_line_tbl(i).deliver_to_party_id := x_header_rec.deliver_to_party_id;
3435: else
3436: IF l_debug_level > 0 THEN
3437: oe_debug_pub.add('AAC: need deliver account creation for line#'||i);
3438: END IF;
3439: l_line_acct_needed(i).deliver := TRUE;
3440: END IF;
3441:

Line 3456: oe_debug_pub.add('AAC: invoice party info not null line#'||i);

3452: (nvl(x_line_tbl(i).invoice_to_contact_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3453: and x_line_tbl(i).invoice_to_org_contact_id is not null))
3454: THEN
3455: IF l_debug_level > 0 THEN
3456: oe_debug_pub.add('AAC: invoice party info not null line#'||i);
3457: END IF;
3458: /* look for similar invoice_to_party_id s */
3459: IF (nvl(x_line_tbl(i).invoice_to_party_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.invoice_to_party_id,FND_API.G_MISS_NUM) and
3460: nvl(x_line_tbl(i).invoice_to_party_number,FND_API.G_MISS_CHAR)=nvl(p_header_rec.invoice_to_party_number,FND_API.G_MISS_CHAR) and

Line 3465: oe_debug_pub.add('AAC: cache: >> matching header invoice_to_org_id:'||x_header_rec.invoice_to_org_id||' found');

3461: nvl(x_line_tbl(i).invoice_to_party_site_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.invoice_to_party_site_id,FND_API.G_MISS_NUM) and
3462: nvl(x_line_tbl(i).invoice_to_party_site_use_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.invoice_to_party_site_use_id,FND_API.G_MISS_NUM))
3463: THEN
3464: IF l_debug_level > 0 THEN
3465: oe_debug_pub.add('AAC: cache: >> matching header invoice_to_org_id:'||x_header_rec.invoice_to_org_id||' found');
3466: END IF;
3467: x_line_tbl(i).invoice_to_org_id := x_header_rec.invoice_to_org_id;
3468: x_line_tbl(i).invoice_to_party_id := x_header_rec.invoice_to_party_id;
3469: else

Line 3471: oe_debug_pub.add('AAC: need invoice account creation for line#'||i);

3467: x_line_tbl(i).invoice_to_org_id := x_header_rec.invoice_to_org_id;
3468: x_line_tbl(i).invoice_to_party_id := x_header_rec.invoice_to_party_id;
3469: else
3470: IF l_debug_level > 0 THEN
3471: oe_debug_pub.add('AAC: need invoice account creation for line#'||i);
3472: END IF;
3473: l_line_acct_needed(i).invoice := TRUE;
3474: END IF;
3475: end if;

Line 3489: oe_debug_pub.add('AAC: end customer party info not null line#'||i);

3485: (nvl(x_line_tbl(i).end_customer_contact_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3486: and x_line_tbl(i).end_customer_org_contact_id is not null))
3487: THEN
3488: IF l_debug_level > 0 THEN
3489: oe_debug_pub.add('AAC: end customer party info not null line#'||i);
3490: END IF;
3491: IF (nvl(x_line_tbl(i).end_customer_party_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.end_customer_party_id,FND_API.G_MISS_NUM) and
3492: nvl(x_line_tbl(i).end_customer_party_number,FND_API.G_MISS_CHAR)=nvl(p_header_rec.end_customer_party_number,FND_API.G_MISS_CHAR) and
3493: nvl(x_line_tbl(i).end_customer_party_site_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.end_customer_party_site_id,FND_API.G_MISS_NUM) and

Line 3497: oe_debug_pub.add('AAC: cache: >> matching header end customer id:'||x_header_rec.end_customer_id||' found');

3493: nvl(x_line_tbl(i).end_customer_party_site_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.end_customer_party_site_id,FND_API.G_MISS_NUM) and
3494: nvl(x_line_tbl(i).end_customer_party_site_use_id,FND_API.G_MISS_NUM)=nvl(p_header_rec.invoice_to_party_site_use_id,FND_API.G_MISS_NUM))
3495: THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('AAC: cache: >> matching header end customer id:'||x_header_rec.end_customer_id||' found');
3498: END IF;
3499: x_line_tbl(i).end_customer_id := x_header_rec.end_customer_id;
3500: x_line_tbl(i).end_customer_party_id := x_header_rec.end_customer_party_id;
3501: else

Line 3503: oe_debug_pub.add('AAC: need end customer account creation for line#'||i);

3499: x_line_tbl(i).end_customer_id := x_header_rec.end_customer_id;
3500: x_line_tbl(i).end_customer_party_id := x_header_rec.end_customer_party_id;
3501: else
3502: IF l_debug_level > 0 THEN
3503: oe_debug_pub.add('AAC: need end customer account creation for line#'||i);
3504: END IF;
3505: l_line_acct_needed(i).end_customer := TRUE;
3506: END IF;
3507: end if;

Line 3514: oe_debug_pub.add('AAC: cache: done header level cache lookup ');

3510: END loop;
3511: end if;
3512:
3513: IF l_debug_level > 0 THEN
3514: oe_debug_pub.add('AAC: cache: done header level cache lookup ');
3515: END IF;
3516:
3517: IF p_line_val_tbl.COUNT > 0 then
3518: for i in p_line_val_tbl.FIRST..p_line_val_tbl.LAST loop

Line 3536: oe_debug_pub.add('ship to present:ship_to_org:'||p_line_val_tbl(i).ship_to_org|| 'ship_to_customer_number:'||p_line_val_tbl(i).ship_to_customer_number_oi||' ship_to_contact:'||p_line_val_tbl(i).ship_to_contact);

3532: nvl(p_line_val_tbl(i).ship_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3533: nvl(p_line_val_tbl(i).ship_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR) )
3534: then
3535: IF l_debug_level > 0 THEN
3536: oe_debug_pub.add('ship to present:ship_to_org:'||p_line_val_tbl(i).ship_to_org|| 'ship_to_customer_number:'||p_line_val_tbl(i).ship_to_customer_number_oi||' ship_to_contact:'||p_line_val_tbl(i).ship_to_contact);
3537: END IF;
3538: l_line_acct_needed(i).ship := TRUE;
3539: l_line_acct_needed(i).ship_value := TRUE;
3540: end if;

Line 3546: oe_debug_pub.add('ship to contact present');

3542: IF (x_line_tbl.EXISTS(i) and (nvl(x_line_tbl(i).ship_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM or
3543: nvl(p_line_val_tbl(i).ship_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)) then
3544:
3545: IF l_debug_level > 0 THEN
3546: oe_debug_pub.add('ship to contact present');
3547: END IF;
3548: l_line_acct_needed(i).ship := TRUE;
3549: l_line_acct_needed(i).ship_value := TRUE;
3550: END IF;

Line 3568: oe_debug_pub.add('deliver to present:deliver_to_org:'||p_line_val_tbl(i).deliver_to_org|| 'deliver_to_customer_number:'||p_line_val_tbl(i).deliver_to_customer_number_oi||' deliver_to_contact:'||p_line_val_tbl(i).deliver_to_contact);

3564: nvl(p_line_val_tbl(i).deliver_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3565: nvl(p_line_val_tbl(i).deliver_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3566: then
3567: IF l_debug_level > 0 THEN
3568: oe_debug_pub.add('deliver to present:deliver_to_org:'||p_line_val_tbl(i).deliver_to_org|| 'deliver_to_customer_number:'||p_line_val_tbl(i).deliver_to_customer_number_oi||' deliver_to_contact:'||p_line_val_tbl(i).deliver_to_contact);
3569: END IF;
3570: l_line_acct_needed(i).deliver := TRUE;
3571: l_line_acct_needed(i).deliver_value := TRUE;
3572: end if;

Line 3578: oe_debug_pub.add('deliver to contact present');

3574: IF (x_line_tbl.EXISTS(i) and (nvl(x_line_tbl(i).deliver_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM or
3575: nvl(p_line_val_tbl(i).deliver_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3576: then
3577: IF l_debug_level > 0 THEN
3578: oe_debug_pub.add('deliver to contact present');
3579: END IF;
3580: l_line_acct_needed(i).deliver := TRUE;
3581: l_line_acct_needed(i).deliver_value := TRUE;
3582: END IF;

Line 3600: oe_debug_pub.add('invoice to present:invoice_to_org:'||p_line_val_tbl(i).invoice_to_org|| 'invoice_to_customer_number:'||p_line_val_tbl(i).invoice_to_customer_number_oi||' invoice_to_contact:'||p_line_val_tbl(i).invoice_to_contact);

3596: nvl(p_line_val_tbl(i).invoice_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3597: nvl(p_line_val_tbl(i).invoice_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3598: then
3599: IF l_debug_level > 0 THEN
3600: oe_debug_pub.add('invoice to present:invoice_to_org:'||p_line_val_tbl(i).invoice_to_org|| 'invoice_to_customer_number:'||p_line_val_tbl(i).invoice_to_customer_number_oi||' invoice_to_contact:'||p_line_val_tbl(i).invoice_to_contact);
3601: END IF;
3602: l_line_acct_needed(i).invoice := TRUE;
3603: l_line_acct_needed(i).invoice_value := TRUE;
3604: end if;

Line 3610: oe_debug_pub.add('invoice to contact present');

3606: IF (x_line_tbl.EXISTS(i) and (nvl(x_line_tbl(i).invoice_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM or
3607: nvl(p_line_val_tbl(i).invoice_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3608: then
3609: IF l_debug_level > 0 THEN
3610: oe_debug_pub.add('invoice to contact present');
3611: END IF;
3612: l_line_acct_needed(i).invoice := TRUE;
3613: l_line_acct_needed(i).invoice_value := TRUE;
3614: END IF;

Line 3634: oe_debug_pub.add('end customer present:end customer name:'||p_line_val_tbl(i).end_customer_name|| 'end_customer_number:'||p_line_val_tbl(i).end_customer_number||' invoice_to_contact:'||p_line_val_tbl(i).end_customer_contact);

3630: nvl(p_line_val_tbl(i).end_customer_site_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3631: nvl(p_line_val_tbl(i).end_customer_site_postal_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3632: then
3633: IF l_debug_level > 0 THEN
3634: oe_debug_pub.add('end customer present:end customer name:'||p_line_val_tbl(i).end_customer_name|| 'end_customer_number:'||p_line_val_tbl(i).end_customer_number||' invoice_to_contact:'||p_line_val_tbl(i).end_customer_contact);
3635: END IF;
3636: l_line_acct_needed(i).end_customer := TRUE;
3637: l_line_acct_needed(i).end_customer_value := TRUE;
3638: end if;

Line 3644: oe_debug_pub.add('end_customer contact present');

3640: IF (x_line_tbl.EXISTS(i) and (nvl(x_line_tbl(i).end_customer_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM or
3641: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3642: then
3643: IF l_debug_level > 0 THEN
3644: oe_debug_pub.add('end_customer contact present');
3645: END IF;
3646: l_line_acct_needed(i).end_customer := TRUE;
3647: l_line_acct_needed(i).end_customer_value := TRUE;
3648: END IF;

Line 3654: oe_debug_pub.add('AAC: cache: start line level account creation and cache lookups...');

3650: end loop;
3651: end if;
3652:
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add('AAC: cache: start line level account creation and cache lookups...');
3655: END IF;
3656:
3657: /* Loop through all the line records:
3658: 1. decide if we want to create an account, (check in l_line_acct_needed(i) )

Line 3668: oe_debug_pub.add(' AAC: processing line_id:'||x_line_tbl(i).line_id);

3664: IF x_line_tbl.COUNT > 0 then
3665: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3666:
3667: IF l_debug_level > 0 THEN
3668: oe_debug_pub.add(' AAC: processing line_id:'||x_line_tbl(i).line_id);
3669: oe_debug_pub.add(' AAC: line#'||i);
3670: END IF;
3671:
3672: /* check if we need to create account for this line{ */

Line 3669: oe_debug_pub.add(' AAC: line#'||i);

3665: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3666:
3667: IF l_debug_level > 0 THEN
3668: oe_debug_pub.add(' AAC: processing line_id:'||x_line_tbl(i).line_id);
3669: oe_debug_pub.add(' AAC: line#'||i);
3670: END IF;
3671:
3672: /* check if we need to create account for this line{ */
3673: IF (l_line_acct_needed.EXISTS(i)

Line 3700: oe_debug_pub.add('AAC: cache: >> matching line ship_to_org_id:'||x_line_tbl(j).ship_to_org_id||' found ');

3696: nvl(x_line_tbl(i).ship_to_party_site_use_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).ship_to_party_site_use_id,FND_API.G_MISS_NUM))
3697: THEN
3698: /* this ship_to line matches, copy record */
3699: IF l_debug_level > 0 THEN
3700: oe_debug_pub.add('AAC: cache: >> matching line ship_to_org_id:'||x_line_tbl(j).ship_to_org_id||' found ');
3701: END IF;
3702: x_line_tbl(i).ship_to_org_id := x_line_tbl(j).ship_to_org_id;
3703: x_line_tbl(i).ship_to_customer_id:= x_line_tbl(j).ship_to_customer_id;
3704: l_line_acct_matched := l_line_acct_matched+1;

Line 3707: oe_debug_pub.add(' AAC: X_ship#'||i||'.'||j);

3703: x_line_tbl(i).ship_to_customer_id:= x_line_tbl(j).ship_to_customer_id;
3704: l_line_acct_matched := l_line_acct_matched+1;
3705: END IF;
3706: IF l_debug_level > 0 THEN
3707: oe_debug_pub.add(' AAC: X_ship#'||i||'.'||j);
3708: END IF;
3709: IF(nvl(x_line_tbl(i).deliver_to_party_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).deliver_to_party_id,FND_API.G_MISS_NUM) and
3710: nvl(x_line_tbl(i).deliver_to_party_number,FND_API.G_MISS_CHAR) = nvl(x_line_tbl(j).deliver_to_party_number,FND_API.G_MISS_CHAR) and
3711: nvl(x_line_tbl(i).deliver_to_party_site_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).deliver_to_party_site_id,FND_API.G_MISS_NUM) and

Line 3716: oe_debug_pub.add('AAC: cache: >> matching line deliver_to_org_id:'||x_line_tbl(j).deliver_to_org_id||' found ');

3712: nvl(x_line_tbl(i).deliver_to_party_site_use_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).deliver_to_party_site_use_id,FND_API.G_MISS_NUM))
3713: THEN
3714: /* this deliver_to line matches, copy record */
3715: IF l_debug_level > 0 THEN
3716: oe_debug_pub.add('AAC: cache: >> matching line deliver_to_org_id:'||x_line_tbl(j).deliver_to_org_id||' found ');
3717: END IF;
3718: x_line_tbl(i).deliver_to_org_id := x_line_tbl(j).deliver_to_org_id;
3719: x_line_tbl(i).deliver_to_customer_id:= x_line_tbl(j).deliver_to_customer_id;
3720: l_line_acct_matched := l_line_acct_matched+1;

Line 3723: oe_debug_pub.add(' AAC: X_deliver#'||i||'.'||j);

3719: x_line_tbl(i).deliver_to_customer_id:= x_line_tbl(j).deliver_to_customer_id;
3720: l_line_acct_matched := l_line_acct_matched+1;
3721: END IF;
3722: IF l_debug_level > 0 THEN
3723: oe_debug_pub.add(' AAC: X_deliver#'||i||'.'||j);
3724: END IF;
3725: IF(nvl(x_line_tbl(i).invoice_to_party_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).invoice_to_party_id,FND_API.G_MISS_NUM) and
3726: nvl(x_line_tbl(i).invoice_to_party_number,FND_API.G_MISS_CHAR) = nvl(x_line_tbl(j).invoice_to_party_number,FND_API.G_MISS_CHAR) and
3727: nvl(x_line_tbl(i).invoice_to_party_site_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).invoice_to_party_site_id,FND_API.G_MISS_NUM) and

Line 3732: oe_debug_pub.add('AAC: cache: >> matching line invoice_to_org_id:'||x_line_tbl(j).invoice_to_org_id||' found ');

3728: nvl(x_line_tbl(i).invoice_to_party_site_use_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).invoice_to_party_site_use_id,FND_API.G_MISS_NUM))
3729: THEN
3730: /* this invoice_to line matches, copy record */
3731: IF l_debug_level > 0 THEN
3732: oe_debug_pub.add('AAC: cache: >> matching line invoice_to_org_id:'||x_line_tbl(j).invoice_to_org_id||' found ');
3733: END IF;
3734: x_line_tbl(i).invoice_to_org_id := x_line_tbl(j).invoice_to_org_id;
3735: x_line_tbl(i).invoice_to_customer_id:= x_line_tbl(j).invoice_to_customer_id;
3736: l_line_acct_matched := l_line_acct_matched+1;

Line 3739: oe_debug_pub.add(' AAC: X_invoice#'||i||'.'||j);

3735: x_line_tbl(i).invoice_to_customer_id:= x_line_tbl(j).invoice_to_customer_id;
3736: l_line_acct_matched := l_line_acct_matched+1;
3737: END IF;
3738: IF l_debug_level > 0 THEN
3739: oe_debug_pub.add(' AAC: X_invoice#'||i||'.'||j);
3740: END IF;
3741:
3742: --{added for bug 4240715
3743: IF (nvl(x_line_tbl(i).end_customer_party_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).end_customer_party_id,FND_API.G_MISS_NUM) and

Line 3750: oe_debug_pub.add('AAC: cache: >> matching line end customer:'||x_line_tbl(j).end_customer_id||' found ');

3746: nvl(x_line_tbl(i).end_customer_party_site_use_id,FND_API.G_MISS_NUM) = nvl(x_line_tbl(j).end_customer_party_site_use_id,FND_API.G_MISS_NUM))
3747: THEN
3748: /* this end_customer line matches, copy record */
3749: IF l_debug_level > 0 THEN
3750: oe_debug_pub.add('AAC: cache: >> matching line end customer:'||x_line_tbl(j).end_customer_id||' found ');
3751: END IF;
3752: x_line_tbl(i).end_customer_site_use_id := x_line_tbl(j).end_customer_site_use_id;
3753: x_line_tbl(i).end_customer_id:= x_line_tbl(j).end_customer_id;
3754: l_line_acct_matched := l_line_acct_matched+1;

Line 3758: oe_debug_pub.add(' AAC: X_End Customer#'||i||'.'||j);

3754: l_line_acct_matched := l_line_acct_matched+1;
3755: END IF;
3756:
3757: IF l_debug_level > 0 THEN
3758: oe_debug_pub.add(' AAC: X_End Customer#'||i||'.'||j);
3759: END IF;
3760: --bug 4240715
3761: oe_debug_pub.add('tested all four for line'||j);
3762:

Line 3761: oe_debug_pub.add('tested all four for line'||j);

3757: IF l_debug_level > 0 THEN
3758: oe_debug_pub.add(' AAC: X_End Customer#'||i||'.'||j);
3759: END IF;
3760: --bug 4240715
3761: oe_debug_pub.add('tested all four for line'||j);
3762:
3763: END IF;
3764: /* Done looking for similar accounts in prev lines */
3765: END loop;

Line 3768: oe_debug_pub.add('AAC: Cache: done cache lookup for line: '||l_line_acct_matched||' matches found');

3764: /* Done looking for similar accounts in prev lines */
3765: END loop;
3766:
3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add('AAC: Cache: done cache lookup for line: '||l_line_acct_matched||' matches found');
3769: END IF;
3770:
3771: /* conservative search */
3772: IF (l_line_acct_matched <> 3 ) THEN

Line 3775: oe_debug_pub.add('AAC: line: creating new account sites for line');

3771: /* conservative search */
3772: IF (l_line_acct_matched <> 3 ) THEN
3773: /* we have to create a new site{ */
3774: IF l_debug_level > 0 THEN
3775: oe_debug_pub.add('AAC: line: creating new account sites for line');
3776: END IF;
3777:
3778: l_site_tbl_counter := 1;
3779:

Line 3783: oe_debug_pub.add('AAC: line: creating new ship to account site for line');

3779:
3780: IF (l_line_acct_needed(i).ship = TRUE)
3781: then
3782: IF l_debug_level > 0 THEN
3783: oe_debug_pub.add('AAC: line: creating new ship to account site for line');
3784: END IF;
3785: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).ship_to_party_site_id;
3786: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).ship_to_party_site_use_id;
3787:

Line 3825: oe_debug_pub.add('AAC: line: creating new deliver to account site for line');

3821:
3822: IF (l_line_acct_needed(i).deliver = TRUE)
3823: then
3824: IF l_debug_level > 0 THEN
3825: oe_debug_pub.add('AAC: line: creating new deliver to account site for line');
3826: END IF;
3827: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).deliver_to_party_site_id;
3828: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).deliver_to_party_site_use_id;
3829:

Line 3867: oe_debug_pub.add('AAC: line: creating new invoice to account site for line');

3863:
3864: IF (l_line_acct_needed(i).invoice = TRUE)
3865: then
3866: IF l_debug_level > 0 THEN
3867: oe_debug_pub.add('AAC: line: creating new invoice to account site for line');
3868: END IF;
3869: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).invoice_to_party_site_id;
3870: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).invoice_to_party_site_use_id;
3871:

Line 3912: oe_debug_pub.add('AAC: line: creating new end customer account site for line');

3908:
3909: IF (l_line_acct_needed(i).end_customer = TRUE)
3910: then
3911: IF l_debug_level > 0 THEN
3912: oe_debug_pub.add('AAC: line: creating new end customer account site for line');
3913: END IF;
3914: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).end_customer_party_site_id;
3915: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).end_customer_party_site_use_id;
3916:

Line 3954: oe_debug_pub.add('end customer party_id'||x_line_tbl(i).end_customer_party_id ||'p_custacc'||p_line_site_tbl(l_site_tbl_counter).p_cust_account_id||'counter is'||l_site_tbl_counter);

3950: p_line_site_tbl(l_site_tbl_counter).p_cust_account_id := x_line_tbl(i).end_customer_id;
3951: end if;
3952:
3953:
3954: oe_debug_pub.add('end customer party_id'||x_line_tbl(i).end_customer_party_id ||'p_custacc'||p_line_site_tbl(l_site_tbl_counter).p_cust_account_id||'counter is'||l_site_tbl_counter);
3955:
3956: l_site_tbl_counter := l_site_tbl_counter + 1;
3957:
3958: end if;

Line 3962: oe_debug_pub.add('AAC: line: calling Create_Account_Layer...');

3958: end if;
3959: -- bug 4240715}
3960:
3961: IF l_debug_level > 0 THEN
3962: oe_debug_pub.add('AAC: line: calling Create_Account_Layer...');
3963: END IF;
3964: oe_create_account_info.Create_Account_Layer(
3965: p_control_rec =>p_control_rec
3966: ,x_return_status =>x_return_status

Line 3977: oe_debug_pub.add('AAC: line: after calling create_account_layer');

3973: );
3974:
3975:
3976: IF l_debug_level > 0 THEN
3977: oe_debug_pub.add('AAC: line: after calling create_account_layer');
3978: END IF;
3979:
3980: /* check for errors{ */
3981: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

Line 3985: oe_debug_pub.add('AAC: line: Main Status is not success'||

3981: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3982: l_count :=oe_msg_pub.count_msg;
3983:
3984: IF l_debug_level > 0 THEN
3985: oe_debug_pub.add('AAC: line: Main Status is not success'||
3986: ' msg='||x_msg_data||
3987: ' count='||x_msg_count
3988: );
3989: END IF;

Line 3993: oe_debug_pub.add('AAC: line: Status is success');

3989: END IF;
3990: RAISE FND_API.G_EXC_ERROR;
3991: ELSE
3992: IF l_debug_level > 0 THEN
3993: oe_debug_pub.add('AAC: line: Status is success');
3994: END IF;
3995:
3996: END IF; /* END checking for errors} */
3997:

Line 4005: oe_debug_pub.add('AAC: line SHIP_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);

4001:
4002: IF (p_line_site_tbl(j).p_site_use_code = 'SHIP_TO')
4003: THEN
4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add('AAC: line SHIP_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4006: oe_debug_pub.add('AAC: line SHIP_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4007: END IF;
4008:
4009: x_line_tbl(i).ship_to_org_id := p_line_site_tbl(j).p_site_use_id;

Line 4006: oe_debug_pub.add('AAC: line SHIP_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);

4002: IF (p_line_site_tbl(j).p_site_use_code = 'SHIP_TO')
4003: THEN
4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add('AAC: line SHIP_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4006: oe_debug_pub.add('AAC: line SHIP_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4007: END IF;
4008:
4009: x_line_tbl(i).ship_to_org_id := p_line_site_tbl(j).p_site_use_id;
4010: x_line_tbl(i).ship_to_customer_id := p_line_site_tbl(j).p_cust_account_id;

Line 4017: oe_debug_pub.add('AAC: line DELIVER_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);

4013: ELSIF (p_line_site_tbl(j).p_site_use_code = 'DELIVER_TO')
4014: THEN
4015:
4016: IF l_debug_level > 0 THEN
4017: oe_debug_pub.add('AAC: line DELIVER_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4018: oe_debug_pub.add('AAC: line DELIVER_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4019: END IF;
4020: x_line_tbl(i).deliver_to_org_id := p_line_site_tbl(j).p_site_use_id;
4021: x_line_tbl(i).deliver_to_customer_id := p_line_site_tbl(j).p_cust_account_id;

Line 4018: oe_debug_pub.add('AAC: line DELIVER_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);

4014: THEN
4015:
4016: IF l_debug_level > 0 THEN
4017: oe_debug_pub.add('AAC: line DELIVER_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4018: oe_debug_pub.add('AAC: line DELIVER_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4019: END IF;
4020: x_line_tbl(i).deliver_to_org_id := p_line_site_tbl(j).p_site_use_id;
4021: x_line_tbl(i).deliver_to_customer_id := p_line_site_tbl(j).p_cust_account_id;
4022: x_line_tbl(i).deliver_to_contact_id := p_line_site_tbl(j).p_cust_account_role_id;

Line 4027: oe_debug_pub.add('AAC: line INVOICE_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);

4023: x_line_tbl(i).deliver_to_party_id := p_line_site_tbl(j).p_party_id;
4024: ELSIF (p_line_site_tbl(j).p_site_use_code = 'BILL_TO')
4025: THEN
4026: IF l_debug_level > 0 THEN
4027: oe_debug_pub.add('AAC: line INVOICE_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4028: oe_debug_pub.add('AAC: line INVOICE_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4029: END IF;
4030: x_line_tbl(i).invoice_to_org_id := p_line_site_tbl(j).p_site_use_id;
4031: x_line_tbl(i).invoice_to_customer_id := p_line_site_tbl(j).p_cust_account_id;

Line 4028: oe_debug_pub.add('AAC: line INVOICE_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);

4024: ELSIF (p_line_site_tbl(j).p_site_use_code = 'BILL_TO')
4025: THEN
4026: IF l_debug_level > 0 THEN
4027: oe_debug_pub.add('AAC: line INVOICE_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4028: oe_debug_pub.add('AAC: line INVOICE_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4029: END IF;
4030: x_line_tbl(i).invoice_to_org_id := p_line_site_tbl(j).p_site_use_id;
4031: x_line_tbl(i).invoice_to_customer_id := p_line_site_tbl(j).p_cust_account_id;
4032: x_line_tbl(i).invoice_to_contact_id := p_line_site_tbl(j).p_cust_account_role_id;

Line 4039: oe_debug_pub.add('AAC: line End customer site use id:'|| p_line_site_tbl(j).p_site_use_id);

4035: --{ added for bug 4240715
4036: ELSIF (p_line_site_tbl(j).p_site_use_code = 'END_CUST') -- end customer changes
4037: THEN
4038: IF l_debug_level > 0 THEN
4039: oe_debug_pub.add('AAC: line End customer site use id:'|| p_line_site_tbl(j).p_site_use_id);
4040: oe_debug_pub.add('AAC: line End customer cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4041: END IF;
4042: x_line_tbl(i).end_customer_site_use_id := p_line_site_tbl(j).p_site_use_id;
4043: x_line_tbl(i).end_customer_id := p_line_site_tbl(j).p_cust_account_id;

Line 4040: oe_debug_pub.add('AAC: line End customer cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);

4036: ELSIF (p_line_site_tbl(j).p_site_use_code = 'END_CUST') -- end customer changes
4037: THEN
4038: IF l_debug_level > 0 THEN
4039: oe_debug_pub.add('AAC: line End customer site use id:'|| p_line_site_tbl(j).p_site_use_id);
4040: oe_debug_pub.add('AAC: line End customer cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4041: END IF;
4042: x_line_tbl(i).end_customer_site_use_id := p_line_site_tbl(j).p_site_use_id;
4043: x_line_tbl(i).end_customer_id := p_line_site_tbl(j).p_cust_account_id;
4044: x_line_tbl(i).end_customer_contact_id := p_line_site_tbl(j).p_cust_account_role_id;

Line 4061: oe_debug_pub.add('AAC: Exiting Process Order Automatic Account Creation}');

4057: END loop;
4058: end if;
4059:
4060: IF l_debug_level > 0 THEN
4061: oe_debug_pub.add('AAC: Exiting Process Order Automatic Account Creation}');
4062: END IF;
4063:
4064: EXCEPTION
4065: