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 323: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

319: l_cust_info_tbl OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE;
320: l_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
321:
322: I NUMBER;
323: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
324: BEGIN
325:
326: IF l_debug_level > 0 THEN /* added for 3677092 */
327: oe_debug_pub.add( 'ENTERING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

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

323: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
324: BEGIN
325:
326: IF l_debug_level > 0 THEN /* added for 3677092 */
327: oe_debug_pub.add( 'ENTERING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;
328: END IF;
329:
330: l_return_status := FND_API.G_RET_STS_SUCCESS; --Nocopy changes
331:

Line 708: oe_debug_pub.add( 'EXITING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

704:
705: END IF; -- End if service level is validation only
706:
707: IF l_debug_level > 0 THEN /* added for 13435459 */
708: oe_debug_pub.add( 'EXITING OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;
709: END IF;
710:
711: EXCEPTION
712:

Line 716: oe_debug_pub.add( 'ERROR IN OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

712:
713: WHEN FND_API.G_EXC_ERROR THEN
714:
715: IF l_debug_level > 0 THEN /* added for 13435459 */
716: oe_debug_pub.add( 'ERROR IN OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;
717: END IF;
718:
719: x_return_status := FND_API.G_RET_STS_ERROR;
720:

Line 731: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729:
730: IF l_debug_level > 0 THEN /* added for 13435459 */
731: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;
732: END IF;
733:
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735:

Line 746: oe_debug_pub.add( 'OTHERS EXCEPTION IN OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;

742:
743: WHEN OTHERS THEN
744:
745: IF l_debug_level > 0 THEN /* added for 13435459 */
746: oe_debug_pub.add( 'OTHERS EXCEPTION IN OE_ORDER_GRP.PROCESS_ORDER', 0.5) ;
747: END IF;
748:
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
750:

Line 2773: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

2769:
2770: type line_acct_needed_tbl is table of line_acct index by binary_integer;
2771: l_line_acct_needed line_acct_needed_tbl;
2772:
2773: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
2774:
2775: BEGIN
2776: --oe_create_account_info.set_debug_on();
2777:

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

2775: BEGIN
2776: --oe_create_account_info.set_debug_on();
2777:
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add(' AAC:Inside Process Order: Automatic Account Creation');
2780: oe_debug_pub.add(' operation='||p_header_rec.operation);
2781: END IF;
2782:
2783: /* copy input records to output records */

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

2776: --oe_create_account_info.set_debug_on();
2777:
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add(' AAC:Inside Process Order: Automatic Account Creation');
2780: oe_debug_pub.add(' operation='||p_header_rec.operation);
2781: END IF;
2782:
2783: /* copy input records to output records */
2784: x_header_rec := p_header_rec;

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

2791: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2792: p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2793:
2794: IF l_debug_level > 0 THEN
2795: oe_debug_pub.add('AAC: Selecting Customer Based on old sold_to_org_id');
2796: END IF;
2797: SELECT SOLD_TO_ORG_ID
2798: INTO l_sold_to_org_id
2799: FROM OE_ORDER_HEADERS

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

2803:
2804:
2805:
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2808: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2809: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2810: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2811: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);

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

2804:
2805:
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2808: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2809: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2810: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2811: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2812: END IF;

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

2805:
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2808: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2809: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2810: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2811: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2812: END IF;
2813:

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

2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2808: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2809: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2810: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2811: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2812: END IF;
2813:
2814: /* check to see if we need account creation at all, return ASAP if not{ */

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

2807: oe_debug_pub.add('AAC: header_id:'||p_header_rec.header_id);
2808: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2809: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2810: oe_debug_pub.add('AAC: sold_to_org_id:'|| p_header_rec.sold_to_org_id);
2811: oe_debug_pub.add('AAC: l_sold_to_org_id:'|| l_sold_to_org_id);
2812: END IF;
2813:
2814: /* check to see if we need account creation at all, return ASAP if not{ */
2815: /* check header level party info */

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

2823: and (nvl(p_header_val_Rec.sold_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2824: or nvl(p_header_Rec.sold_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)))
2825: THEN
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');
2828: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2829: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2830: END IF;
2831: l_create_account := TRUE;

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

2824: or nvl(p_header_Rec.sold_to_org_contact_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)))
2825: THEN
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');
2828: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2829: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2830: END IF;
2831: l_create_account := TRUE;
2832: l_create_hdr_account := TRUE;

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

2825: THEN
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.add('AAC: sold_to_org_id/sold_to_contact_id creation needed');
2828: oe_debug_pub.add('AAC: sold_to_party_id:'|| p_header_rec.sold_to_party_id);
2829: oe_debug_pub.add('AAC: sold_to_party_number:'|| p_header_rec.sold_to_party_number);
2830: END IF;
2831: l_create_account := TRUE;
2832: l_create_hdr_account := TRUE;
2833: END IF;

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

2855: nvl(p_header_val_Rec.ship_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
2856: nvl(p_header_val_Rec.ship_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)))
2857: THEN
2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add('AAC: ship_to sites creation needed');
2860: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);

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

2856: nvl(p_header_val_Rec.ship_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)))
2857: THEN
2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add('AAC: ship_to sites creation needed');
2860: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);

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

2857: THEN
2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add('AAC: ship_to sites creation needed');
2860: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);

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

2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add('AAC: ship_to sites creation needed');
2860: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);

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

2859: oe_debug_pub.add('AAC: ship_to sites creation needed');
2860: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);

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

2860: oe_debug_pub.add('AAC: ship_to_org_id :'|| p_header_Rec.ship_to_org_id);
2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2868: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);

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

2861: oe_debug_pub.add('AAC: ship_to_party_id :'|| p_header_rec.ship_to_party_id);
2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2868: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2869: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);

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

2862: oe_debug_pub.add('AAC: ship_to_party_number :'|| p_header_rec.ship_to_party_number);
2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2868: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2869: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2870: END IF;

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

2863: oe_debug_pub.add('AAC: ship_to_party_site_id :'|| p_header_rec.ship_to_party_site_id);
2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2868: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2869: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2870: END IF;
2871:

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

2864: oe_debug_pub.add('AAC: ship_to_party_site_use_id:'|| p_header_rec.ship_to_party_site_use_id);
2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2868: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2869: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2870: END IF;
2871:
2872: l_create_account := TRUE;

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

2865: oe_debug_pub.add('AAC: ship_to_org_contact_id :'|| p_header_rec.ship_to_org_contact_id);
2866: oe_debug_pub.add('AAC: ship_to_org :'|| p_header_val_Rec.ship_to_org);
2867: oe_debug_pub.add('AAC: ship_to_customer_number :'|| p_header_val_Rec.ship_to_customer_number_oi);
2868: oe_debug_pub.add('AAC: ship_to_customer_name :'|| p_header_val_Rec.ship_to_customer_name_oi);
2869: oe_debug_pub.add('AAC: ship_to_contact :'|| p_header_val_Rec.ship_to_contact);
2870: END IF;
2871:
2872: l_create_account := TRUE;
2873: l_create_hdr_account := TRUE;

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

2926: nvl(p_header_val_Rec.deliver_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)))
2927:
2928: THEN
2929: IF l_debug_level > 0 THEN
2930: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2931: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);

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

2927:
2928: THEN
2929: IF l_debug_level > 0 THEN
2930: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2931: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);

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

2928: THEN
2929: IF l_debug_level > 0 THEN
2930: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2931: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);

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

2929: IF l_debug_level > 0 THEN
2930: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2931: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);

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

2930: oe_debug_pub.add('AAC: deliver_to sites creation needed');
2931: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);

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

2931: oe_debug_pub.add('AAC: deliver_to_org_id :'|| p_header_rec.deliver_to_org_id);
2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2939: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);

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

2932: oe_debug_pub.add('AAC: deliver_to_party_id :'|| p_header_rec.deliver_to_party_id);
2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2939: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2940: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);

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

2933: oe_debug_pub.add('AAC: deliver_to_party_number :'|| p_header_rec.deliver_to_party_number);
2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2939: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2940: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2941: END IF;

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

2934: oe_debug_pub.add('AAC: deliver_to_party_site_id :'|| p_header_rec.deliver_to_party_site_id);
2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2939: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2940: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2941: END IF;
2942:

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

2935: oe_debug_pub.add('AAC: deliver_to_party_site_use_id:'|| p_header_rec.deliver_to_party_site_use_id);
2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2939: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2940: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2941: END IF;
2942:
2943: l_create_account := TRUE;

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

2936: oe_debug_pub.add('AAC: deliver_to_org_contact_id :'|| p_header_rec.deliver_to_org_contact_id);
2937: oe_debug_pub.add('AAC: deliver_to_org :'|| p_header_val_Rec.deliver_to_org);
2938: oe_debug_pub.add('AAC: deliver_to_customer_number :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2939: oe_debug_pub.add('AAC: deliver_to_customer_name :'|| p_header_val_Rec.deliver_to_customer_number_oi);
2940: oe_debug_pub.add('AAC: deliver_to_contact :'|| p_header_val_Rec.deliver_to_contact);
2941: END IF;
2942:
2943: l_create_account := TRUE;
2944: l_create_hdr_account := TRUE;

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

2997: nvl(p_header_val_Rec.invoice_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
2998:
2999: THEN
3000: IF l_debug_level > 0 THEN
3001: oe_debug_pub.add('AAC: invoice_to sites creation needed');
3002: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);

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

2998:
2999: THEN
3000: IF l_debug_level > 0 THEN
3001: oe_debug_pub.add('AAC: invoice_to sites creation needed');
3002: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);

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

2999: THEN
3000: IF l_debug_level > 0 THEN
3001: oe_debug_pub.add('AAC: invoice_to sites creation needed');
3002: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);

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

3000: IF l_debug_level > 0 THEN
3001: oe_debug_pub.add('AAC: invoice_to sites creation needed');
3002: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);

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

3001: oe_debug_pub.add('AAC: invoice_to sites creation needed');
3002: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
3009: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);

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

3002: oe_debug_pub.add('AAC: invoice_to_party_id :'|| p_header_rec.invoice_to_party_id);
3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
3009: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
3010: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);

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

3003: oe_debug_pub.add('AAC: invoice_to_party_number :'|| p_header_rec.invoice_to_party_number);
3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
3009: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
3010: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
3011: END IF;

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

3004: oe_debug_pub.add('AAC: invoice_to_party_site_id :'|| p_header_rec.invoice_to_party_site_id);
3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
3009: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
3010: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
3011: END IF;
3012:

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

3005: oe_debug_pub.add('AAC: invoice_to_party_site_use_id:'|| p_header_rec.invoice_to_party_site_use_id);
3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
3009: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
3010: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
3011: END IF;
3012:
3013: l_create_account := TRUE;

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

3006: oe_debug_pub.add('AAC: invoice_to_org_contact_id :'|| p_header_rec.invoice_to_org_contact_id);
3007: oe_debug_pub.add('AAC: invoice_to_org :'|| p_header_val_Rec.invoice_to_org);
3008: oe_debug_pub.add('AAC: invoice_to_customer_number :'|| p_header_val_Rec.invoice_to_customer_number_oi);
3009: oe_debug_pub.add('AAC: invoice_to_customer_name :'|| p_header_val_Rec.invoice_to_customer_name_oi);
3010: oe_debug_pub.add('AAC: invoice_to_contact :'|| p_header_val_Rec.invoice_to_contact);
3011: END IF;
3012:
3013: l_create_account := TRUE;
3014: l_create_hdr_account := TRUE;

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

3060: p_site_tbl(l_site_tbl_counter).p_party_number := p_header_rec.end_customer_party_number;
3061: p_site_tbl(l_site_tbl_counter).p_cust_account_number := p_header_val_Rec.end_customer_number;
3062: p_site_tbl(l_site_tbl_counter).p_site_use_code := 'END_CUST';
3063: IF l_debug_level > 0 THEN
3064: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
3065: oe_debug_pub.add('AAC: end customer account creation needed');
3066: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
3067: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
3068: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);

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

3061: p_site_tbl(l_site_tbl_counter).p_cust_account_number := p_header_val_Rec.end_customer_number;
3062: p_site_tbl(l_site_tbl_counter).p_site_use_code := 'END_CUST';
3063: IF l_debug_level > 0 THEN
3064: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
3065: oe_debug_pub.add('AAC: end customer account creation needed');
3066: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
3067: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
3068: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
3069: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);

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

3062: p_site_tbl(l_site_tbl_counter).p_site_use_code := 'END_CUST';
3063: IF l_debug_level > 0 THEN
3064: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
3065: oe_debug_pub.add('AAC: end customer account creation needed');
3066: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
3067: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
3068: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
3069: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
3070: END IF;

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

3063: IF l_debug_level > 0 THEN
3064: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
3065: oe_debug_pub.add('AAC: end customer account creation needed');
3066: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
3067: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
3068: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
3069: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
3070: END IF;
3071:

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

3064: oe_debug_pub.add('AAC: VALUE OF l_create_account: TRUE'); --remem
3065: oe_debug_pub.add('AAC: end customer account creation needed');
3066: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
3067: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
3068: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
3069: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
3070: END IF;
3071:
3072:

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

3065: oe_debug_pub.add('AAC: end customer account creation needed');
3066: oe_debug_pub.add('AAC: end_customer_party_id :'|| p_header_rec.end_customer_party_id);
3067: oe_debug_pub.add('AAC: end_customer_party_number :'|| p_header_rec.end_customer_party_number);
3068: oe_debug_pub.add('AAC: end_customer :'|| p_header_val_Rec.end_customer_name);
3069: oe_debug_pub.add('AAC: end_customer_number :'|| p_header_val_Rec.end_customer_number);
3070: END IF;
3071:
3072:
3073: IF p_header_rec.end_customer_party_site_id is not null or

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

3083: nvl(p_header_val_Rec.end_customer_site_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3084: nvl(p_header_val_Rec.end_customer_site_postal_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR then
3085:
3086: IF l_debug_level > 0 THEN
3087: oe_debug_pub.add('AAC: end customer sites creation needed');
3088: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
3089: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
3090: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
3091: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);

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

3084: nvl(p_header_val_Rec.end_customer_site_postal_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR then
3085:
3086: IF l_debug_level > 0 THEN
3087: oe_debug_pub.add('AAC: end customer sites creation needed');
3088: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
3089: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
3090: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
3091: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
3092: END IF;

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

3085:
3086: IF l_debug_level > 0 THEN
3087: oe_debug_pub.add('AAC: end customer sites creation needed');
3088: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
3089: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
3090: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
3091: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
3092: END IF;
3093:

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

3086: IF l_debug_level > 0 THEN
3087: oe_debug_pub.add('AAC: end customer sites creation needed');
3088: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
3089: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
3090: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
3091: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
3092: END IF;
3093:
3094:

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

3087: oe_debug_pub.add('AAC: end customer sites creation needed');
3088: oe_debug_pub.add('AAC: end_customer_party_site_id :'|| p_header_rec.end_customer_party_site_id);
3089: oe_debug_pub.add('AAC: end_customer_party_site_use_id:'|| p_header_rec.end_customer_party_site_use_id);
3090: oe_debug_pub.add('AAC: end_customer_org_contact_id :'|| p_header_rec.end_customer_org_contact_id);
3091: oe_debug_pub.add('AAC: end_customer_contact :'|| p_header_val_Rec.end_customer_contact);
3092: END IF;
3093:
3094:
3095: if(p_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM)

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

3122:
3123: /* if no header level account creation needed, check all lines{ */
3124: IF (l_create_account = FALSE )
3125: THEN
3126: oe_debug_pub.add('AAC: no header level account creation needed, checking all lines');
3127: if x_line_tbl.COUNT > 0 then
3128:
3129: IF l_debug_level > 0 THEN
3130: oe_debug_pub.add('X1');

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

3126: oe_debug_pub.add('AAC: no header level account creation needed, checking all lines');
3127: if x_line_tbl.COUNT > 0 then
3128:
3129: IF l_debug_level > 0 THEN
3130: oe_debug_pub.add('X1');
3131: END IF;
3132: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3133: IF l_debug_level > 0 THEN
3134: oe_debug_pub.add('X2');

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

3130: oe_debug_pub.add('X1');
3131: END IF;
3132: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3133: IF l_debug_level > 0 THEN
3134: oe_debug_pub.add('X2');
3135: END IF;
3136: /* l_create_account might change in this loop, so keep checking */
3137: IF ( l_create_Account = FALSE
3138: and

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

3161: x_line_tbl(i).end_customer_party_site_use_id is not null))
3162: ))
3163: THEN
3164: IF l_debug_level > 0 THEN
3165: oe_debug_pub.add('AAC: line level account creation needed');
3166: END IF;
3167: l_create_account := TRUE;
3168: END IF; /* ok, we need account creation */
3169:

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

3183: nvl(p_line_val_tbl(i).ship_to_customer_name_oi,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3184: nvl(p_line_val_tbl(i).ship_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3185: then
3186: IF l_debug_level > 0 THEN
3187: oe_debug_pub.add('ship to value present line#'||i);
3188: END IF;
3189: l_create_account := TRUE;
3190: end if;
3191:

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

3202: nvl(p_line_val_tbl(i).deliver_to_customer_name_oi,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3203: nvl(p_line_val_tbl(i).deliver_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3204: then
3205: IF l_debug_level > 0 THEN
3206: oe_debug_pub.add('deliver to value present line#'||i);
3207: END IF;
3208: l_create_account := TRUE;
3209: end if;
3210:

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

3229: IF (x_line_tbl(i).invoice_to_org_contact_id is not null or
3230: nvl(p_line_val_tbl(i).invoice_to_contact,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
3231: then
3232: IF l_debug_level > 0 THEN
3233: oe_debug_pub.add('invoice to value present line#'||i);
3234: END IF;
3235: l_create_account := TRUE;
3236: End If;
3237:

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

3243: nvl(x_line_tbl(i).end_customer_party_number,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3244: nvl(p_line_val_tbl(i).end_customer_number,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3245: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)
3246: then
3247: oe_debug_pub.add('once');
3248: l_create_account := TRUE;
3249: end if;
3250:
3251: oe_debug_pub.add('checking before org contactid');

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

3247: oe_debug_pub.add('once');
3248: l_create_account := TRUE;
3249: end if;
3250:
3251: oe_debug_pub.add('checking before org contactid');
3252:
3253: IF (x_line_tbl(i).end_customer_org_contact_id is not null or
3254: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
3255: then

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

3253: IF (x_line_tbl(i).end_customer_org_contact_id is not null or
3254: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
3255: then
3256: IF l_debug_level > 0 THEN
3257: oe_debug_pub.add('end customer value present line#'||i);
3258: END IF;
3259: l_create_account := TRUE;
3260: --bug 4240715}
3261: END IF;

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

3262: end loop;
3263: end if;
3264:
3265: /* done checking lines} */
3266: oe_debug_pub.add('AAC: done checking...');
3267: IF (l_create_account = FALSE)
3268: THEN
3269: /* we don't actually need account creation. return */
3270: x_return_status := 'S';

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

3268: THEN
3269: /* we don't actually need account creation. return */
3270: x_return_status := 'S';
3271: IF l_debug_level > 0 THEN
3272: oe_debug_pub.add('AAC: no account creation needed. returning...');
3273: END IF;
3274: return;
3275: END IF;
3276:

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

3324: if (l_create_hdr_account = TRUE)
3325: then
3326:
3327: IF l_debug_level > 0 THEN
3328: oe_debug_pub.add('AAC: before calling Create_Account_layer for header level site creation{ ');
3329: END IF;
3330:
3331: oe_create_account_info.Create_Account_Layer(
3332: p_control_rec =>p_control_rec

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

3338: ,p_account_tbl =>p_account_tbl
3339: ,p_contact_tbl =>p_contact_tbl
3340: );
3341: IF l_debug_level > 0 THEN
3342: oe_debug_pub.add('AAC: after calling Create_Account_layer for header level site creation} ');
3343: END IF;
3344:
3345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3346: l_count :=oe_msg_pub.count_msg;

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

3345: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3346: l_count :=oe_msg_pub.count_msg;
3347:
3348: IF l_debug_level > 0 THEN
3349: oe_debug_pub.add('AAC: Main Status is not success'||
3350: ' msg='||x_msg_data||
3351: ' count='||x_msg_count
3352: );
3353: END IF;

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

3353: END IF;
3354: RAISE FND_API.G_EXC_ERROR;
3355:
3356: ELSE
3357: oe_debug_pub.add('AAC: Status is success');
3358:
3359:
3360: -- Error out IF only party and no site information
3361: IF p_account_tbl.COUNT = 0 AND p_party_customer_rec.p_party_id IS NOT NULL

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

3360: -- Error out IF only party and no site information
3361: IF p_account_tbl.COUNT = 0 AND p_party_customer_rec.p_party_id IS NOT NULL
3362: THEN
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add('AAC: Only party, no site. error out'||
3365: ' msg='||x_msg_data||
3366: ' count='||x_msg_count);
3367: END IF;
3368: RAISE FND_API.G_EXC_ERROR;

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

3374: IF p_account_tbl.COUNT <> 1
3375: THEN
3376: --error
3377: IF l_debug_level > 0 and l_header_end_cust_exists = 'N' THEN --modified for bug 4240715
3378: oe_debug_pub.add(' More than one party site/account record'||
3379: ' msg='||x_msg_data||
3380: ' count='||x_msg_count
3381: );
3382: END IF;

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

3392: end if;
3393:
3394:
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);
3397: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);
3398: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');
3399: END IF;
3400:

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

3393:
3394:
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);
3397: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);
3398: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');
3399: END IF;
3400:
3401: /* get the relevant ship/deliver/invoice to fields */

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

3394:
3395: IF l_debug_level > 0 THEN
3396: oe_debug_pub.add('AAC: sold_to_org_id :'||x_header_rec.sold_to_org_id);
3397: oe_debug_pub.add('AAC: sold_to_contact_id :'||x_header_rec.sold_to_contact_id);
3398: oe_debug_pub.add('AAC: p_site_tbl has '||p_site_tbl.COUNT||' rows');
3399: END IF;
3400:
3401: /* get the relevant ship/deliver/invoice to fields */
3402: IF p_site_tbl.COUNT > 0 then

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

3406: IF (p_site_tbl(i).p_site_use_code = 'SHIP_TO')
3407: THEN
3408:
3409: IF l_debug_level > 0 THEN
3410: oe_debug_pub.add('AAC: header SHIP_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3411: oe_debug_pub.add('AAC: header SHIP_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3412: END IF;
3413: x_header_rec.ship_to_org_id := p_site_tbl(i).p_site_use_id;
3414: x_header_rec.ship_to_customer_id := p_site_tbl(i).p_cust_account_id;

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

3407: THEN
3408:
3409: IF l_debug_level > 0 THEN
3410: oe_debug_pub.add('AAC: header SHIP_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3411: oe_debug_pub.add('AAC: header SHIP_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3412: END IF;
3413: x_header_rec.ship_to_org_id := p_site_tbl(i).p_site_use_id;
3414: x_header_rec.ship_to_customer_id := p_site_tbl(i).p_cust_account_id;
3415: x_header_rec.ship_to_contact_id := p_site_tbl(i).p_cust_account_role_id;

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

3416:
3417: ELSIF (p_site_tbl(i).p_site_use_code = 'DELIVER_TO')
3418: THEN
3419: IF l_debug_level > 0 THEN
3420: oe_debug_pub.add('AAC: header DELIVER_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3421: oe_debug_pub.add('AAC: header DELIVER_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3422: END IF;
3423: x_header_rec.deliver_to_org_id := p_site_tbl(i).p_site_use_id;
3424: x_header_rec.deliver_to_customer_id := p_site_tbl(i).p_cust_account_id;

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

3417: ELSIF (p_site_tbl(i).p_site_use_code = 'DELIVER_TO')
3418: THEN
3419: IF l_debug_level > 0 THEN
3420: oe_debug_pub.add('AAC: header DELIVER_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3421: oe_debug_pub.add('AAC: header DELIVER_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3422: END IF;
3423: x_header_rec.deliver_to_org_id := p_site_tbl(i).p_site_use_id;
3424: x_header_rec.deliver_to_customer_id := p_site_tbl(i).p_cust_account_id;
3425: x_header_rec.deliver_to_contact_id := p_site_tbl(i).p_cust_account_role_id;

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

3427: ELSIF (p_site_tbl(i).p_site_use_code = 'BILL_TO')
3428: THEN
3429:
3430: IF l_debug_level > 0 THEN
3431: oe_debug_pub.add('AAC: header INVOICE_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3432: oe_debug_pub.add('AAC: header INVOICE_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3433: END IF;
3434: x_header_rec.invoice_to_org_id := p_site_tbl(i).p_site_use_id;
3435: x_header_rec.invoice_to_customer_id := p_site_tbl(i).p_cust_account_id;

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

3428: THEN
3429:
3430: IF l_debug_level > 0 THEN
3431: oe_debug_pub.add('AAC: header INVOICE_TO org_id:'|| p_site_tbl(i).p_site_use_id);
3432: oe_debug_pub.add('AAC: header INVOICE_TO cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3433: END IF;
3434: x_header_rec.invoice_to_org_id := p_site_tbl(i).p_site_use_id;
3435: x_header_rec.invoice_to_customer_id := p_site_tbl(i).p_cust_account_id;
3436: x_header_rec.invoice_to_contact_id := p_site_tbl(i).p_cust_account_role_id;

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

3437: ELSIF (p_site_tbl(i).p_site_use_code = 'END_CUST') /* end customer changes -bug 4240715 */
3438: THEN
3439:
3440: IF l_debug_level > 0 THEN
3441: oe_debug_pub.add('AAC: header End Customer :'|| p_site_tbl(i).p_site_use_id);
3442: oe_debug_pub.add('AAC: header End Customer cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3443: END IF;
3444: x_header_rec.end_customer_site_use_id := p_site_tbl(i).p_site_use_id;
3445: x_header_rec.end_customer_id := p_site_tbl(i).p_cust_account_id;

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

3438: THEN
3439:
3440: IF l_debug_level > 0 THEN
3441: oe_debug_pub.add('AAC: header End Customer :'|| p_site_tbl(i).p_site_use_id);
3442: oe_debug_pub.add('AAC: header End Customer cust_account_id:'|| p_site_tbl(i).p_cust_account_id);
3443: END IF;
3444: x_header_rec.end_customer_site_use_id := p_site_tbl(i).p_site_use_id;
3445: x_header_rec.end_customer_id := p_site_tbl(i).p_cust_account_id;
3446: x_header_rec.end_customer_contact_id := p_site_tbl(i).p_cust_account_role_id;

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

3443: END IF;
3444: x_header_rec.end_customer_site_use_id := p_site_tbl(i).p_site_use_id;
3445: x_header_rec.end_customer_id := p_site_tbl(i).p_cust_account_id;
3446: x_header_rec.end_customer_contact_id := p_site_tbl(i).p_cust_account_role_id;
3447: oe_debug_pub.add('here the end custoemr id'||x_header_rec.end_customer_contact_id);
3448: END IF;
3449:
3450: END LOOP;
3451: end if;

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

3451: end if;
3452: end if; --end header level account creation
3453:
3454: IF l_debug_level > 0 THEN
3455: oe_debug_pub.add('AAC: cache: start header level cache lookup... ');
3456: END IF;
3457:
3458: /* loop through all the lines, looking for lines with party
3459: information similar to header level info, replace if

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

3466:
3467: IF x_line_tbl.COUNT > 0 then
3468: FOR i IN x_line_tbl.FIRST..x_line_tbl.LAST loop
3469: IF l_debug_level > 0 THEN
3470: oe_debug_pub.add('AAC: checking if account creation needed for line.'||i);
3471: END IF;
3472: IF ((nvl(x_line_tbl(i).ship_to_org_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3473: and
3474: (x_line_tbl(i).ship_to_party_id is not null or

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

3479: (nvl(x_line_tbl(i).ship_to_contact_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3480: and x_line_tbl(i).ship_to_org_contact_id is not null ))
3481: then
3482: IF l_debug_level > 0 THEN
3483: oe_debug_pub.add('AAC: ship party info not null line#'||i);
3484: END IF;
3485:
3486: /* look for similar ship_to_party_id s */
3487: 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 3493: oe_debug_pub.add('AAC: cache: >> matching header ship_to_org_id:'||x_header_rec.ship_to_org_id||' found');

3489: 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
3490: 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))
3491: THEN
3492: IF l_debug_level > 0 THEN
3493: oe_debug_pub.add('AAC: cache: >> matching header ship_to_org_id:'||x_header_rec.ship_to_org_id||' found');
3494: END IF;
3495: x_line_tbl(i).ship_to_org_id := x_header_rec.ship_to_org_id;
3496: x_line_tbl(i).ship_to_party_id := x_header_rec.ship_to_party_id;
3497: else

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

3496: x_line_tbl(i).ship_to_party_id := x_header_rec.ship_to_party_id;
3497: else
3498:
3499: IF l_debug_level > 0 THEN
3500: oe_debug_pub.add('AAC: need ship account creation for line#'||i);
3501: END IF;
3502: l_line_acct_needed(i).ship := TRUE;
3503: END IF;
3504: end if;

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

3514: and x_line_tbl(i).deliver_to_org_contact_id is not null))
3515: then
3516:
3517: IF l_debug_level > 0 THEN
3518: oe_debug_pub.add('AAC: deliver party info not null line#'||i);
3519: END IF;
3520:
3521: /* look for similar deliver_to_party_id s */
3522: 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 3528: oe_debug_pub.add('AAC: cache: >> matching header deliver_to_org_id:'||x_header_rec.deliver_to_org_id||' found');

3524: 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
3525: 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))
3526: THEN
3527: IF l_debug_level > 0 THEN
3528: oe_debug_pub.add('AAC: cache: >> matching header deliver_to_org_id:'||x_header_rec.deliver_to_org_id||' found');
3529: END IF;
3530: x_line_tbl(i).deliver_to_org_id := x_header_rec.deliver_to_org_id;
3531: x_line_tbl(i).deliver_to_party_id := x_header_rec.deliver_to_party_id;
3532: else

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

3530: x_line_tbl(i).deliver_to_org_id := x_header_rec.deliver_to_org_id;
3531: x_line_tbl(i).deliver_to_party_id := x_header_rec.deliver_to_party_id;
3532: else
3533: IF l_debug_level > 0 THEN
3534: oe_debug_pub.add('AAC: need deliver account creation for line#'||i);
3535: END IF;
3536: l_line_acct_needed(i).deliver := TRUE;
3537: END IF;
3538:

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

3549: (nvl(x_line_tbl(i).invoice_to_contact_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3550: and x_line_tbl(i).invoice_to_org_contact_id is not null))
3551: THEN
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add('AAC: invoice party info not null line#'||i);
3554: END IF;
3555: /* look for similar invoice_to_party_id s */
3556: 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
3557: 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 3562: oe_debug_pub.add('AAC: cache: >> matching header invoice_to_org_id:'||x_header_rec.invoice_to_org_id||' found');

3558: 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
3559: 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))
3560: THEN
3561: IF l_debug_level > 0 THEN
3562: oe_debug_pub.add('AAC: cache: >> matching header invoice_to_org_id:'||x_header_rec.invoice_to_org_id||' found');
3563: END IF;
3564: x_line_tbl(i).invoice_to_org_id := x_header_rec.invoice_to_org_id;
3565: x_line_tbl(i).invoice_to_party_id := x_header_rec.invoice_to_party_id;
3566: else

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

3564: x_line_tbl(i).invoice_to_org_id := x_header_rec.invoice_to_org_id;
3565: x_line_tbl(i).invoice_to_party_id := x_header_rec.invoice_to_party_id;
3566: else
3567: IF l_debug_level > 0 THEN
3568: oe_debug_pub.add('AAC: need invoice account creation for line#'||i);
3569: END IF;
3570: l_line_acct_needed(i).invoice := TRUE;
3571: END IF;
3572: end if;

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

3582: (nvl(x_line_tbl(i).end_customer_contact_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3583: and x_line_tbl(i).end_customer_org_contact_id is not null))
3584: THEN
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add('AAC: end customer party info not null line#'||i);
3587: END IF;
3588: 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
3589: 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
3590: 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 3594: oe_debug_pub.add('AAC: cache: >> matching header end customer id:'||x_header_rec.end_customer_id||' found');

3590: 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
3591: 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))
3592: THEN
3593: IF l_debug_level > 0 THEN
3594: oe_debug_pub.add('AAC: cache: >> matching header end customer id:'||x_header_rec.end_customer_id||' found');
3595: END IF;
3596: x_line_tbl(i).end_customer_id := x_header_rec.end_customer_id;
3597: x_line_tbl(i).end_customer_party_id := x_header_rec.end_customer_party_id;
3598: else

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

3596: x_line_tbl(i).end_customer_id := x_header_rec.end_customer_id;
3597: x_line_tbl(i).end_customer_party_id := x_header_rec.end_customer_party_id;
3598: else
3599: IF l_debug_level > 0 THEN
3600: oe_debug_pub.add('AAC: need end customer account creation for line#'||i);
3601: END IF;
3602: l_line_acct_needed(i).end_customer := TRUE;
3603: END IF;
3604: end if;

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

3607: END loop;
3608: end if;
3609:
3610: IF l_debug_level > 0 THEN
3611: oe_debug_pub.add('AAC: cache: done header level cache lookup ');
3612: END IF;
3613:
3614: IF p_line_val_tbl.COUNT > 0 then
3615: for i in p_line_val_tbl.FIRST..p_line_val_tbl.LAST loop

Line 3633: 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);

3629: nvl(p_line_val_tbl(i).ship_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3630: nvl(p_line_val_tbl(i).ship_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR) )
3631: then
3632: IF l_debug_level > 0 THEN
3633: 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);
3634: END IF;
3635: l_line_acct_needed(i).ship := TRUE;
3636: l_line_acct_needed(i).ship_value := TRUE;
3637: end if;

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

3639: 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
3640: nvl(p_line_val_tbl(i).ship_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR)) then
3641:
3642: IF l_debug_level > 0 THEN
3643: oe_debug_pub.add('ship to contact present');
3644: END IF;
3645: l_line_acct_needed(i).ship := TRUE;
3646: l_line_acct_needed(i).ship_value := TRUE;
3647: END IF;

Line 3665: 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);

3661: nvl(p_line_val_tbl(i).deliver_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3662: nvl(p_line_val_tbl(i).deliver_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3663: then
3664: IF l_debug_level > 0 THEN
3665: 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);
3666: END IF;
3667: l_line_acct_needed(i).deliver := TRUE;
3668: l_line_acct_needed(i).deliver_value := TRUE;
3669: end if;

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

3671: 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
3672: nvl(p_line_val_tbl(i).deliver_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3673: then
3674: IF l_debug_level > 0 THEN
3675: oe_debug_pub.add('deliver to contact present');
3676: END IF;
3677: l_line_acct_needed(i).deliver := TRUE;
3678: l_line_acct_needed(i).deliver_value := TRUE;
3679: END IF;

Line 3697: 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);

3693: nvl(p_line_val_tbl(i).invoice_to_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3694: nvl(p_line_val_tbl(i).invoice_to_zip,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3695: then
3696: IF l_debug_level > 0 THEN
3697: 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);
3698: END IF;
3699: l_line_acct_needed(i).invoice := TRUE;
3700: l_line_acct_needed(i).invoice_value := TRUE;
3701: end if;

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

3703: 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
3704: nvl(p_line_val_tbl(i).invoice_to_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3705: then
3706: IF l_debug_level > 0 THEN
3707: oe_debug_pub.add('invoice to contact present');
3708: END IF;
3709: l_line_acct_needed(i).invoice := TRUE;
3710: l_line_acct_needed(i).invoice_value := TRUE;
3711: END IF;

Line 3731: 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);

3727: nvl(p_line_val_tbl(i).end_customer_site_city,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR or
3728: nvl(p_line_val_tbl(i).end_customer_site_postal_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3729: then
3730: IF l_debug_level > 0 THEN
3731: 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);
3732: END IF;
3733: l_line_acct_needed(i).end_customer := TRUE;
3734: l_line_acct_needed(i).end_customer_value := TRUE;
3735: end if;

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

3737: 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
3738: nvl(p_line_val_tbl(i).end_customer_contact,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR))
3739: then
3740: IF l_debug_level > 0 THEN
3741: oe_debug_pub.add('end_customer contact present');
3742: END IF;
3743: l_line_acct_needed(i).end_customer := TRUE;
3744: l_line_acct_needed(i).end_customer_value := TRUE;
3745: END IF;

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

3747: end loop;
3748: end if;
3749:
3750: IF l_debug_level > 0 THEN
3751: oe_debug_pub.add('AAC: cache: start line level account creation and cache lookups...');
3752: END IF;
3753:
3754: /* Loop through all the line records:
3755: 1. decide if we want to create an account, (check in l_line_acct_needed(i) )

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

3761: IF x_line_tbl.COUNT > 0 then
3762: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3763:
3764: IF l_debug_level > 0 THEN
3765: oe_debug_pub.add(' AAC: processing line_id:'||x_line_tbl(i).line_id);
3766: oe_debug_pub.add(' AAC: line#'||i);
3767: END IF;
3768:
3769: /* check if we need to create account for this line{ */

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

3762: for i in x_line_tbl.FIRST..x_line_tbl.LAST loop
3763:
3764: IF l_debug_level > 0 THEN
3765: oe_debug_pub.add(' AAC: processing line_id:'||x_line_tbl(i).line_id);
3766: oe_debug_pub.add(' AAC: line#'||i);
3767: END IF;
3768:
3769: /* check if we need to create account for this line{ */
3770: IF (l_line_acct_needed.EXISTS(i)

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

3793: 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))
3794: THEN
3795: /* this ship_to line matches, copy record */
3796: IF l_debug_level > 0 THEN
3797: oe_debug_pub.add('AAC: cache: >> matching line ship_to_org_id:'||x_line_tbl(j).ship_to_org_id||' found ');
3798: END IF;
3799: x_line_tbl(i).ship_to_org_id := x_line_tbl(j).ship_to_org_id;
3800: x_line_tbl(i).ship_to_customer_id:= x_line_tbl(j).ship_to_customer_id;
3801: l_line_acct_matched := l_line_acct_matched+1;

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

3800: x_line_tbl(i).ship_to_customer_id:= x_line_tbl(j).ship_to_customer_id;
3801: l_line_acct_matched := l_line_acct_matched+1;
3802: END IF;
3803: IF l_debug_level > 0 THEN
3804: oe_debug_pub.add(' AAC: X_ship#'||i||'.'||j);
3805: END IF;
3806: 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
3807: 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
3808: 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 3813: oe_debug_pub.add('AAC: cache: >> matching line deliver_to_org_id:'||x_line_tbl(j).deliver_to_org_id||' found ');

3809: 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))
3810: THEN
3811: /* this deliver_to line matches, copy record */
3812: IF l_debug_level > 0 THEN
3813: oe_debug_pub.add('AAC: cache: >> matching line deliver_to_org_id:'||x_line_tbl(j).deliver_to_org_id||' found ');
3814: END IF;
3815: x_line_tbl(i).deliver_to_org_id := x_line_tbl(j).deliver_to_org_id;
3816: x_line_tbl(i).deliver_to_customer_id:= x_line_tbl(j).deliver_to_customer_id;
3817: l_line_acct_matched := l_line_acct_matched+1;

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

3816: x_line_tbl(i).deliver_to_customer_id:= x_line_tbl(j).deliver_to_customer_id;
3817: l_line_acct_matched := l_line_acct_matched+1;
3818: END IF;
3819: IF l_debug_level > 0 THEN
3820: oe_debug_pub.add(' AAC: X_deliver#'||i||'.'||j);
3821: END IF;
3822: 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
3823: 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
3824: 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 3829: oe_debug_pub.add('AAC: cache: >> matching line invoice_to_org_id:'||x_line_tbl(j).invoice_to_org_id||' found ');

3825: 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))
3826: THEN
3827: /* this invoice_to line matches, copy record */
3828: IF l_debug_level > 0 THEN
3829: oe_debug_pub.add('AAC: cache: >> matching line invoice_to_org_id:'||x_line_tbl(j).invoice_to_org_id||' found ');
3830: END IF;
3831: x_line_tbl(i).invoice_to_org_id := x_line_tbl(j).invoice_to_org_id;
3832: x_line_tbl(i).invoice_to_customer_id:= x_line_tbl(j).invoice_to_customer_id;
3833: l_line_acct_matched := l_line_acct_matched+1;

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

3832: x_line_tbl(i).invoice_to_customer_id:= x_line_tbl(j).invoice_to_customer_id;
3833: l_line_acct_matched := l_line_acct_matched+1;
3834: END IF;
3835: IF l_debug_level > 0 THEN
3836: oe_debug_pub.add(' AAC: X_invoice#'||i||'.'||j);
3837: END IF;
3838:
3839: --{added for bug 4240715
3840: 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 3847: oe_debug_pub.add('AAC: cache: >> matching line end customer:'||x_line_tbl(j).end_customer_id||' found ');

3843: 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))
3844: THEN
3845: /* this end_customer line matches, copy record */
3846: IF l_debug_level > 0 THEN
3847: oe_debug_pub.add('AAC: cache: >> matching line end customer:'||x_line_tbl(j).end_customer_id||' found ');
3848: END IF;
3849: x_line_tbl(i).end_customer_site_use_id := x_line_tbl(j).end_customer_site_use_id;
3850: x_line_tbl(i).end_customer_id:= x_line_tbl(j).end_customer_id;
3851: l_line_acct_matched := l_line_acct_matched+1;

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

3851: l_line_acct_matched := l_line_acct_matched+1;
3852: END IF;
3853:
3854: IF l_debug_level > 0 THEN
3855: oe_debug_pub.add(' AAC: X_End Customer#'||i||'.'||j);
3856: END IF;
3857: --bug 4240715
3858: oe_debug_pub.add('tested all four for line'||j);
3859:

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

3854: IF l_debug_level > 0 THEN
3855: oe_debug_pub.add(' AAC: X_End Customer#'||i||'.'||j);
3856: END IF;
3857: --bug 4240715
3858: oe_debug_pub.add('tested all four for line'||j);
3859:
3860: END IF;
3861: /* Done looking for similar accounts in prev lines */
3862: END loop;

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

3861: /* Done looking for similar accounts in prev lines */
3862: END loop;
3863:
3864: IF l_debug_level > 0 THEN
3865: oe_debug_pub.add('AAC: Cache: done cache lookup for line: '||l_line_acct_matched||' matches found');
3866: END IF;
3867:
3868: /* conservative search */
3869: IF (l_line_acct_matched <> 3 ) THEN

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

3868: /* conservative search */
3869: IF (l_line_acct_matched <> 3 ) THEN
3870: /* we have to create a new site{ */
3871: IF l_debug_level > 0 THEN
3872: oe_debug_pub.add('AAC: line: creating new account sites for line');
3873: END IF;
3874:
3875: l_site_tbl_counter := 1;
3876:

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

3876:
3877: IF (l_line_acct_needed(i).ship = TRUE)
3878: then
3879: IF l_debug_level > 0 THEN
3880: oe_debug_pub.add('AAC: line: creating new ship to account site for line');
3881: END IF;
3882: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).ship_to_party_site_id;
3883: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).ship_to_party_site_use_id;
3884:

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

3918:
3919: IF (l_line_acct_needed(i).deliver = TRUE)
3920: then
3921: IF l_debug_level > 0 THEN
3922: oe_debug_pub.add('AAC: line: creating new deliver to account site for line');
3923: END IF;
3924: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).deliver_to_party_site_id;
3925: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).deliver_to_party_site_use_id;
3926:

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

3960:
3961: IF (l_line_acct_needed(i).invoice = TRUE)
3962: then
3963: IF l_debug_level > 0 THEN
3964: oe_debug_pub.add('AAC: line: creating new invoice to account site for line');
3965: END IF;
3966: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).invoice_to_party_site_id;
3967: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).invoice_to_party_site_use_id;
3968:

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

4005:
4006: IF (l_line_acct_needed(i).end_customer = TRUE)
4007: then
4008: IF l_debug_level > 0 THEN
4009: oe_debug_pub.add('AAC: line: creating new end customer account site for line');
4010: END IF;
4011: p_line_site_tbl(l_site_tbl_counter).p_party_site_id := x_line_tbl(i).end_customer_party_site_id;
4012: p_line_site_tbl(l_site_tbl_counter).p_party_site_use_id := x_line_tbl(i).end_customer_party_site_use_id;
4013:

Line 4051: 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);

4047: p_line_site_tbl(l_site_tbl_counter).p_cust_account_id := x_line_tbl(i).end_customer_id;
4048: end if;
4049:
4050:
4051: 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);
4052:
4053: l_site_tbl_counter := l_site_tbl_counter + 1;
4054:
4055: end if;

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

4055: end if;
4056: -- bug 4240715}
4057:
4058: IF l_debug_level > 0 THEN
4059: oe_debug_pub.add('AAC: line: calling Create_Account_Layer...');
4060: END IF;
4061: oe_create_account_info.Create_Account_Layer(
4062: p_control_rec =>p_control_rec
4063: ,x_return_status =>x_return_status

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

4070: );
4071:
4072:
4073: IF l_debug_level > 0 THEN
4074: oe_debug_pub.add('AAC: line: after calling create_account_layer');
4075: END IF;
4076:
4077: /* check for errors{ */
4078: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

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

4078: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4079: l_count :=oe_msg_pub.count_msg;
4080:
4081: IF l_debug_level > 0 THEN
4082: oe_debug_pub.add('AAC: line: Main Status is not success'||
4083: ' msg='||x_msg_data||
4084: ' count='||x_msg_count
4085: );
4086: END IF;

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

4086: END IF;
4087: RAISE FND_API.G_EXC_ERROR;
4088: ELSE
4089: IF l_debug_level > 0 THEN
4090: oe_debug_pub.add('AAC: line: Status is success');
4091: END IF;
4092:
4093: END IF; /* END checking for errors} */
4094:

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

4098:
4099: IF (p_line_site_tbl(j).p_site_use_code = 'SHIP_TO')
4100: THEN
4101: IF l_debug_level > 0 THEN
4102: oe_debug_pub.add('AAC: line SHIP_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4103: oe_debug_pub.add('AAC: line SHIP_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4104: END IF;
4105:
4106: x_line_tbl(i).ship_to_org_id := p_line_site_tbl(j).p_site_use_id;

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

4099: IF (p_line_site_tbl(j).p_site_use_code = 'SHIP_TO')
4100: THEN
4101: IF l_debug_level > 0 THEN
4102: oe_debug_pub.add('AAC: line SHIP_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4103: oe_debug_pub.add('AAC: line SHIP_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4104: END IF;
4105:
4106: x_line_tbl(i).ship_to_org_id := p_line_site_tbl(j).p_site_use_id;
4107: x_line_tbl(i).ship_to_customer_id := p_line_site_tbl(j).p_cust_account_id;

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

4110: ELSIF (p_line_site_tbl(j).p_site_use_code = 'DELIVER_TO')
4111: THEN
4112:
4113: IF l_debug_level > 0 THEN
4114: oe_debug_pub.add('AAC: line DELIVER_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4115: oe_debug_pub.add('AAC: line DELIVER_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4116: END IF;
4117: x_line_tbl(i).deliver_to_org_id := p_line_site_tbl(j).p_site_use_id;
4118: x_line_tbl(i).deliver_to_customer_id := p_line_site_tbl(j).p_cust_account_id;

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

4111: THEN
4112:
4113: IF l_debug_level > 0 THEN
4114: oe_debug_pub.add('AAC: line DELIVER_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4115: oe_debug_pub.add('AAC: line DELIVER_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4116: END IF;
4117: x_line_tbl(i).deliver_to_org_id := p_line_site_tbl(j).p_site_use_id;
4118: x_line_tbl(i).deliver_to_customer_id := p_line_site_tbl(j).p_cust_account_id;
4119: x_line_tbl(i).deliver_to_contact_id := p_line_site_tbl(j).p_cust_account_role_id;

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

4120: x_line_tbl(i).deliver_to_party_id := p_line_site_tbl(j).p_party_id;
4121: ELSIF (p_line_site_tbl(j).p_site_use_code = 'BILL_TO')
4122: THEN
4123: IF l_debug_level > 0 THEN
4124: oe_debug_pub.add('AAC: line INVOICE_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4125: oe_debug_pub.add('AAC: line INVOICE_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4126: END IF;
4127: x_line_tbl(i).invoice_to_org_id := p_line_site_tbl(j).p_site_use_id;
4128: x_line_tbl(i).invoice_to_customer_id := p_line_site_tbl(j).p_cust_account_id;

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

4121: ELSIF (p_line_site_tbl(j).p_site_use_code = 'BILL_TO')
4122: THEN
4123: IF l_debug_level > 0 THEN
4124: oe_debug_pub.add('AAC: line INVOICE_TO org_id:'|| p_line_site_tbl(j).p_site_use_id);
4125: oe_debug_pub.add('AAC: line INVOICE_TO cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4126: END IF;
4127: x_line_tbl(i).invoice_to_org_id := p_line_site_tbl(j).p_site_use_id;
4128: x_line_tbl(i).invoice_to_customer_id := p_line_site_tbl(j).p_cust_account_id;
4129: x_line_tbl(i).invoice_to_contact_id := p_line_site_tbl(j).p_cust_account_role_id;

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

4132: --{ added for bug 4240715
4133: ELSIF (p_line_site_tbl(j).p_site_use_code = 'END_CUST') -- end customer changes
4134: THEN
4135: IF l_debug_level > 0 THEN
4136: oe_debug_pub.add('AAC: line End customer site use id:'|| p_line_site_tbl(j).p_site_use_id);
4137: oe_debug_pub.add('AAC: line End customer cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4138: END IF;
4139: x_line_tbl(i).end_customer_site_use_id := p_line_site_tbl(j).p_site_use_id;
4140: x_line_tbl(i).end_customer_id := p_line_site_tbl(j).p_cust_account_id;

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

4133: ELSIF (p_line_site_tbl(j).p_site_use_code = 'END_CUST') -- end customer changes
4134: THEN
4135: IF l_debug_level > 0 THEN
4136: oe_debug_pub.add('AAC: line End customer site use id:'|| p_line_site_tbl(j).p_site_use_id);
4137: oe_debug_pub.add('AAC: line End customer cust_account_id:'|| p_line_site_tbl(j).p_cust_account_id);
4138: END IF;
4139: x_line_tbl(i).end_customer_site_use_id := p_line_site_tbl(j).p_site_use_id;
4140: x_line_tbl(i).end_customer_id := p_line_site_tbl(j).p_cust_account_id;
4141: x_line_tbl(i).end_customer_contact_id := p_line_site_tbl(j).p_cust_account_role_id;

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

4154: END loop;
4155: end if;
4156:
4157: IF l_debug_level > 0 THEN
4158: oe_debug_pub.add('AAC: Exiting Process Order Automatic Account Creation}');
4159: END IF;
4160:
4161: EXCEPTION
4162: