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_CNCL_ORDER_IMPORT_PVT dependencies on OE_DEBUG_PUB

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

1205:
1206:
1207:
1208: --
1209: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1210: --
1211: --13906241 start
1212: l_serv_num_cnt NUMBER := 0;
1213: l_servref_lineid NUMBER := 0;

Line 1223: oe_debug_pub.add( 'BEFORE INITIALIZING MESSAGES LIST' ) ;

1219: -----------------------------------------------------------
1220: */
1221: IF p_init_msg_list = FND_API.G_TRUE THEN
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'BEFORE INITIALIZING MESSAGES LIST' ) ;
1224: END IF;
1225: OE_MSG_PUB.Initialize;
1226: END IF;
1227:

Line 1233: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;

1229: Set message context
1230: -----------------------------------------------------------
1231: */
1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;
1234: END IF;
1235:
1236: OE_MSG_PUB.set_msg_context(
1237: p_entity_code => 'HEADER'

Line 1259: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;

1255: Initialization
1256: -----------------------------------------------------------
1257: */
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;
1260: END IF;
1261: begin
1262: select DECODE(p_validate_only,'Y','T','N','F',p_validate_only)
1263: into l_validate_only

Line 1344: oe_debug_pub.add( 'BEFORE HEADERS LOOP' ) ;

1340: Headers
1341: -----------------------------------------------------------
1342: */
1343: IF l_debug_level > 0 THEN
1344: oe_debug_pub.add( 'BEFORE HEADERS LOOP' ) ;
1345: END IF;
1346:
1347: l_header_count := 0;
1348:

Line 1578: oe_debug_pub.add( 'AFTER FETCH HEADER CURSOR' ) ;

1574: ;
1575: --EXIT WHEN l_header_cursor%NOTFOUND;
1576:
1577: IF l_debug_level > 0 THEN
1578: oe_debug_pub.add( 'AFTER FETCH HEADER CURSOR' ) ;
1579: END IF;
1580:
1581: l_header_count := l_header_count + 1;
1582:

Line 1596: oe_debug_pub.add('Order Source Id: ' || l_order_source_id);

1592: END IF;
1593: */
1594:
1595:
1596: oe_debug_pub.add('Order Source Id: ' || l_order_source_id);
1597: oe_debug_pub.add('Orig Sys Reference: '|| l_orig_sys_document_ref);
1598: oe_debug_pub.add('Sold to Org Id: ' || l_sold_to_org_id);
1599: oe_debug_pub.add('Sold to Org: ' || l_sold_to_org);
1600: oe_debug_pub.add('Change Sequence: ' || l_change_sequence);

Line 1597: oe_debug_pub.add('Orig Sys Reference: '|| l_orig_sys_document_ref);

1593: */
1594:
1595:
1596: oe_debug_pub.add('Order Source Id: ' || l_order_source_id);
1597: oe_debug_pub.add('Orig Sys Reference: '|| l_orig_sys_document_ref);
1598: oe_debug_pub.add('Sold to Org Id: ' || l_sold_to_org_id);
1599: oe_debug_pub.add('Sold to Org: ' || l_sold_to_org);
1600: oe_debug_pub.add('Change Sequence: ' || l_change_sequence);
1601:

Line 1598: oe_debug_pub.add('Sold to Org Id: ' || l_sold_to_org_id);

1594:
1595:
1596: oe_debug_pub.add('Order Source Id: ' || l_order_source_id);
1597: oe_debug_pub.add('Orig Sys Reference: '|| l_orig_sys_document_ref);
1598: oe_debug_pub.add('Sold to Org Id: ' || l_sold_to_org_id);
1599: oe_debug_pub.add('Sold to Org: ' || l_sold_to_org);
1600: oe_debug_pub.add('Change Sequence: ' || l_change_sequence);
1601:
1602:

Line 1599: oe_debug_pub.add('Sold to Org: ' || l_sold_to_org);

1595:
1596: oe_debug_pub.add('Order Source Id: ' || l_order_source_id);
1597: oe_debug_pub.add('Orig Sys Reference: '|| l_orig_sys_document_ref);
1598: oe_debug_pub.add('Sold to Org Id: ' || l_sold_to_org_id);
1599: oe_debug_pub.add('Sold to Org: ' || l_sold_to_org);
1600: oe_debug_pub.add('Change Sequence: ' || l_change_sequence);
1601:
1602:
1603: --Default unpopulated transaction_phase_code to 'F' for bug 3576009

Line 1600: oe_debug_pub.add('Change Sequence: ' || l_change_sequence);

1596: oe_debug_pub.add('Order Source Id: ' || l_order_source_id);
1597: oe_debug_pub.add('Orig Sys Reference: '|| l_orig_sys_document_ref);
1598: oe_debug_pub.add('Sold to Org Id: ' || l_sold_to_org_id);
1599: oe_debug_pub.add('Sold to Org: ' || l_sold_to_org);
1600: oe_debug_pub.add('Change Sequence: ' || l_change_sequence);
1601:
1602:
1603: --Default unpopulated transaction_phase_code to 'F' for bug 3576009
1604: IF l_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN

Line 1618: oe_debug_pub.add( 'header level sold to org id is g_miss_num, so it was not populated' ) ;

1614:
1615: ******/
1616: if l_sold_to_org_id = FND_API.G_MISS_NUM then
1617: IF l_debug_level > 0 THEN
1618: oe_debug_pub.add( 'header level sold to org id is g_miss_num, so it was not populated' ) ;
1619: END IF;
1620:
1621: if l_sold_to_org is not null then
1622:

Line 1632: oe_debug_pub.add( 'returned value for sold_to_org_id was g_miss_num') ;

1628: /* if oe_value_to_id returned g_miss_num, reassign sold_to_org_id back to null */
1629:
1630: if l_header_rec.sold_to_org_id = FND_API.G_MISS_NUM then
1631: IF l_debug_level > 0 THEN
1632: oe_debug_pub.add( 'returned value for sold_to_org_id was g_miss_num') ;
1633: END IF;
1634: l_header_rec.sold_to_org_id := null;
1635: end if;
1636:

Line 1639: oe_debug_pub.add( 'sold to org is NULL') ;

1635: end if;
1636:
1637: else
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'sold to org is NULL') ;
1640: END IF;
1641: end if;
1642:
1643: end if;

Line 1731: oe_debug_pub.add( 'BEFORE HEADER ADJUSTMENTS LOOP' ) ;

1727: Header Discounts/Price adjustments
1728: -----------------------------------------------------------
1729: */
1730: IF l_debug_level > 0 THEN
1731: oe_debug_pub.add( 'BEFORE HEADER ADJUSTMENTS LOOP' ) ;
1732: END IF;
1733:
1734: l_header_adj_count := 0;
1735:

Line 1823: oe_debug_pub.add( 'HEADER ADJ REF ( '||L_HEADER_ADJ_COUNT||' ) : '|| L_HEADER_ADJ_TBL ( L_HEADER_ADJ_COUNT ) .ORIG_SYS_DISCOUNT_REF ) ;

1819: l_header_adj_tbl (l_header_adj_count) := l_header_adj_rec;
1820: l_header_adj_val_tbl (l_header_adj_count) := l_header_adj_val_rec;
1821:
1822: IF l_debug_level > 0 THEN
1823: oe_debug_pub.add( 'HEADER ADJ REF ( '||L_HEADER_ADJ_COUNT||' ) : '|| L_HEADER_ADJ_TBL ( L_HEADER_ADJ_COUNT ) .ORIG_SYS_DISCOUNT_REF ) ;
1824: END IF;
1825:
1826:
1827: BEGIN

Line 1915: oe_debug_pub.add( 'BEFORE HEADER SALES CREDITS LOOP' ) ;

1911: Header Sales Credits
1912: -----------------------------------------------------------
1913: */
1914: IF l_debug_level > 0 THEN
1915: oe_debug_pub.add( 'BEFORE HEADER SALES CREDITS LOOP' ) ;
1916: END IF;
1917:
1918: l_header_scredit_count := 0;
1919:

Line 1962: oe_debug_pub.add( 'HEADER SALESCREDIT ( '|| L_HEADER_SCREDIT_COUNT||' ) : '|| L_HEADER_SCREDIT_TBL ( L_HEADER_SCREDIT_COUNT ) .ORIG_SYS_CREDIT_REF ) ;

1958: l_header_scredit_tbl (l_header_scredit_count) := l_header_scredit_rec;
1959: l_header_scredit_val_tbl (l_header_scredit_count) := l_header_scredit_val_rec;
1960:
1961: IF l_debug_level > 0 THEN
1962: oe_debug_pub.add( 'HEADER SALESCREDIT ( '|| L_HEADER_SCREDIT_COUNT||' ) : '|| L_HEADER_SCREDIT_TBL ( L_HEADER_SCREDIT_COUNT ) .ORIG_SYS_CREDIT_REF ) ;
1963: END IF;
1964:
1965: BEGIN
1966: --

Line 2051: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;

2047: Lines
2048: -----------------------------------------------------------
2049: */
2050: IF l_debug_level > 0 THEN
2051: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;
2052: END IF;
2053:
2054: l_line_count := 0;
2055:

Line 2414: oe_debug_pub.add('value inserted'||l_line_rec.end_customer_id); -- added for bug 4240715

2410: ,l_line_val_rec.ib_installed_at_location_dsp
2411: -- Distributer Order related change }
2412: ;
2413: IF l_debug_level > 0 THEN
2414: oe_debug_pub.add('value inserted'||l_line_rec.end_customer_id); -- added for bug 4240715
2415: END IF;
2416: EXIT WHEN l_line_cursor%NOTFOUND;
2417:
2418: IF l_debug_level > 0 THEN

Line 2419: oe_debug_pub.add( 'AFTER LINE FETCH ' ) ;

2415: END IF;
2416: EXIT WHEN l_line_cursor%NOTFOUND;
2417:
2418: IF l_debug_level > 0 THEN
2419: oe_debug_pub.add( 'AFTER LINE FETCH ' ) ;
2420: END IF;
2421: /*
2422: IF l_line_rec.operation = 'INSERT' THEN
2423: l_line_rec.operation := 'CREATE';

Line 2439: oe_debug_pub.add( 'line level sold to org id is g_miss_num, so it was not populated. defaulting to header level sold to org id' ) ;

2435:
2436:
2437: if l_line_rec.sold_to_org_id = FND_API.G_MISS_NUM then
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add( 'line level sold to org id is g_miss_num, so it was not populated. defaulting to header level sold to org id' ) ;
2440: END IF;
2441: l_line_rec.sold_to_org_id := l_header_rec.sold_to_org_id;
2442: end if;
2443:

Line 2449: oe_debug_pub.add( 'L_LINE_REC.SERVICE_REFERENCE_ORDER ' || ASCII ( L_LINE_REC.SERVICE_REFERENCE_ORDER ) ) ;

2445:
2446: l_line_count := l_line_count + 1;
2447: if l_line_rec.service_reference_order = FND_API.G_MISS_CHAR then
2448: IF l_debug_level > 0 THEN
2449: oe_debug_pub.add( 'L_LINE_REC.SERVICE_REFERENCE_ORDER ' || ASCII ( L_LINE_REC.SERVICE_REFERENCE_ORDER ) ) ;
2450: END IF;
2451: end if;
2452: if l_line_val_rec.sold_to_org = FND_API.G_MISS_CHAR then
2453: IF l_debug_level > 0 THEN

Line 2454: oe_debug_pub.add( 'L_LINE_VAL_REC.SOLD_TO_ORG ' || ASCII ( L_LINE_VAL_REC.SOLD_TO_ORG ) ) ;

2450: END IF;
2451: end if;
2452: if l_line_val_rec.sold_to_org = FND_API.G_MISS_CHAR then
2453: IF l_debug_level > 0 THEN
2454: oe_debug_pub.add( 'L_LINE_VAL_REC.SOLD_TO_ORG ' || ASCII ( L_LINE_VAL_REC.SOLD_TO_ORG ) ) ;
2455: END IF;
2456: end if;
2457:
2458: --populate l_line_rec.inventory_item_id with ccid if any of the

Line 2482: oe_debug_pub.add( 'INSIDE GET CCID ROUTINE' ) ;

2478: (l_segment_array(18) IS NOT NULL) OR
2479: (l_segment_array(19) IS NOT NULL) OR
2480: (l_segment_array(20) IS NOT NULL)) THEN
2481: IF l_debug_level > 0 THEN
2482: oe_debug_pub.add( 'INSIDE GET CCID ROUTINE' ) ;
2483: END IF;
2484: FND_FLEX_KEY_API.SET_SESSION_MODE('customer_data');
2485: IF l_debug_level > 0 THEN
2486: oe_debug_pub.add( 'AFTER CALL TO SET SESSION' ) ;

Line 2486: oe_debug_pub.add( 'AFTER CALL TO SET SESSION' ) ;

2482: oe_debug_pub.add( 'INSIDE GET CCID ROUTINE' ) ;
2483: END IF;
2484: FND_FLEX_KEY_API.SET_SESSION_MODE('customer_data');
2485: IF l_debug_level > 0 THEN
2486: oe_debug_pub.add( 'AFTER CALL TO SET SESSION' ) ;
2487: END IF;
2488: l_flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD('INV', 'MSTK');
2489: IF l_debug_level > 0 THEN
2490: oe_debug_pub.add( 'AFTER FIND FLEXFIELD' ) ;

Line 2490: oe_debug_pub.add( 'AFTER FIND FLEXFIELD' ) ;

2486: oe_debug_pub.add( 'AFTER CALL TO SET SESSION' ) ;
2487: END IF;
2488: l_flexfield := FND_FLEX_KEY_API.FIND_FLEXFIELD('INV', 'MSTK');
2489: IF l_debug_level > 0 THEN
2490: oe_debug_pub.add( 'AFTER FIND FLEXFIELD' ) ;
2491: END IF;
2492: l_structure.structure_number := 101;
2493: FND_FLEX_KEY_API.GET_SEGMENTS(l_flexfield, l_structure, TRUE, l_n_segments, l_segments);
2494: IF l_debug_level > 0 THEN

Line 2495: oe_debug_pub.add( 'SEGMENTS ENABLED = '||L_N_SEGMENTS ) ;

2491: END IF;
2492: l_structure.structure_number := 101;
2493: FND_FLEX_KEY_API.GET_SEGMENTS(l_flexfield, l_structure, TRUE, l_n_segments, l_segments);
2494: IF l_debug_level > 0 THEN
2495: oe_debug_pub.add( 'SEGMENTS ENABLED = '||L_N_SEGMENTS ) ;
2496: END IF;
2497: IF l_debug_level > 0 THEN
2498: oe_debug_pub.add( 'ORG_ID = '||L_LINE_REC.ORG_ID ) ;
2499: END IF;

Line 2498: oe_debug_pub.add( 'ORG_ID = '||L_LINE_REC.ORG_ID ) ;

2494: IF l_debug_level > 0 THEN
2495: oe_debug_pub.add( 'SEGMENTS ENABLED = '||L_N_SEGMENTS ) ;
2496: END IF;
2497: IF l_debug_level > 0 THEN
2498: oe_debug_pub.add( 'ORG_ID = '||L_LINE_REC.ORG_ID ) ;
2499: END IF;
2500: IF l_debug_level > 0 THEN
2501: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||L_VALIDATION_ORG ) ;
2502: END IF;

Line 2501: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||L_VALIDATION_ORG ) ;

2497: IF l_debug_level > 0 THEN
2498: oe_debug_pub.add( 'ORG_ID = '||L_LINE_REC.ORG_ID ) ;
2499: END IF;
2500: IF l_debug_level > 0 THEN
2501: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||L_VALIDATION_ORG ) ;
2502: END IF;
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'ARRAY1 = '||L_SEGMENT_ARRAY ( 1 ) ) ;
2505: END IF;

Line 2504: oe_debug_pub.add( 'ARRAY1 = '||L_SEGMENT_ARRAY ( 1 ) ) ;

2500: IF l_debug_level > 0 THEN
2501: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||L_VALIDATION_ORG ) ;
2502: END IF;
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'ARRAY1 = '||L_SEGMENT_ARRAY ( 1 ) ) ;
2505: END IF;
2506: IF FND_FLEX_EXT.GET_COMBINATION_ID('INV', 'MSTK', 101, SYSDATE, l_n_segments, l_segment_array, l_id, l_validation_org) THEN
2507: l_line_rec.inventory_item_id := l_id;
2508: IF l_debug_level > 0 THEN

Line 2509: oe_debug_pub.add( 'GET CCID = '||L_LINE_REC.INVENTORY_ITEM_ID ) ;

2505: END IF;
2506: IF FND_FLEX_EXT.GET_COMBINATION_ID('INV', 'MSTK', 101, SYSDATE, l_n_segments, l_segment_array, l_id, l_validation_org) THEN
2507: l_line_rec.inventory_item_id := l_id;
2508: IF l_debug_level > 0 THEN
2509: oe_debug_pub.add( 'GET CCID = '||L_LINE_REC.INVENTORY_ITEM_ID ) ;
2510: END IF;
2511: ELSE
2512: IF l_debug_level > 0 THEN
2513: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;

Line 2513: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;

2509: oe_debug_pub.add( 'GET CCID = '||L_LINE_REC.INVENTORY_ITEM_ID ) ;
2510: END IF;
2511: ELSE
2512: IF l_debug_level > 0 THEN
2513: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;
2514: END IF;
2515: failure_message := fnd_flex_ext.get_message;
2516: OE_MSG_PUB.Add_TEXT(failure_message);
2517: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2520: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;

2516: OE_MSG_PUB.Add_TEXT(failure_message);
2517: p_return_status := FND_API.G_RET_STS_ERROR;
2518: l_validate_only := FND_API.G_TRUE;
2519: IF l_debug_level > 0 THEN
2520: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;
2521: END IF;
2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 51 , 50 ) ) ;
2524: END IF;

Line 2523: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 51 , 50 ) ) ;

2519: IF l_debug_level > 0 THEN
2520: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;
2521: END IF;
2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 51 , 50 ) ) ;
2524: END IF;
2525: IF l_debug_level > 0 THEN
2526: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 101 , 50 ) ) ;
2527: END IF;

Line 2526: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 101 , 50 ) ) ;

2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 51 , 50 ) ) ;
2524: END IF;
2525: IF l_debug_level > 0 THEN
2526: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 101 , 50 ) ) ;
2527: END IF;
2528: END IF;
2529:
2530: ELSIF l_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND

Line 2552: oe_debug_pub.add( 'INSIDE ROUTINE WHERE BOTH ID AND SEG ARE POPULATED' ) ;

2548: (l_segment_array(18) IS NOT NULL) OR
2549: (l_segment_array(19) IS NOT NULL) OR
2550: (l_segment_array(20) IS NOT NULL)) THEN
2551: IF l_debug_level > 0 THEN
2552: oe_debug_pub.add( 'INSIDE ROUTINE WHERE BOTH ID AND SEG ARE POPULATED' ) ;
2553: END IF;
2554: l_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
2555: FND_MESSAGE.SET_NAME('ONT','OE_OIM_INVALID_ITEM_ID');
2556: FND_MESSAGE.SET_TOKEN('ORDER_NO', l_orig_sys_document_ref);

Line 2562: oe_debug_pub.add( 'CANNOT IMPORT ORDER AS BOTH INVENTORY_ITEM_ID AND INVENTORY_ITEM_SEGMENTS ARE POPULATED' ) ;

2558: OE_MSG_PUB.Add;
2559: p_return_status := FND_API.G_RET_STS_ERROR;
2560: l_validate_only := FND_API.G_TRUE;
2561: IF l_debug_level > 0 THEN
2562: oe_debug_pub.add( 'CANNOT IMPORT ORDER AS BOTH INVENTORY_ITEM_ID AND INVENTORY_ITEM_SEGMENTS ARE POPULATED' ) ;
2563: END IF;
2564: IF l_debug_level > 0 THEN
2565: oe_debug_pub.add( 'ORDER NO: '||L_ORIG_SYS_DOCUMENT_REF ) ;
2566: END IF;

Line 2565: oe_debug_pub.add( 'ORDER NO: '||L_ORIG_SYS_DOCUMENT_REF ) ;

2561: IF l_debug_level > 0 THEN
2562: oe_debug_pub.add( 'CANNOT IMPORT ORDER AS BOTH INVENTORY_ITEM_ID AND INVENTORY_ITEM_SEGMENTS ARE POPULATED' ) ;
2563: END IF;
2564: IF l_debug_level > 0 THEN
2565: oe_debug_pub.add( 'ORDER NO: '||L_ORIG_SYS_DOCUMENT_REF ) ;
2566: END IF;
2567: IF l_debug_level > 0 THEN
2568: oe_debug_pub.add( 'ORDER SOURCE: '||L_ORDER_SOURCE_ID ) ;
2569: END IF;

Line 2568: oe_debug_pub.add( 'ORDER SOURCE: '||L_ORDER_SOURCE_ID ) ;

2564: IF l_debug_level > 0 THEN
2565: oe_debug_pub.add( 'ORDER NO: '||L_ORIG_SYS_DOCUMENT_REF ) ;
2566: END IF;
2567: IF l_debug_level > 0 THEN
2568: oe_debug_pub.add( 'ORDER SOURCE: '||L_ORDER_SOURCE_ID ) ;
2569: END IF;
2570:
2571: END IF;
2572:

Line 2581: oe_debug_pub.add( 'L_LINE_TBL.SERVICE_REFERENCE_ORDER ' || ASCII ( L_LINE_TBL ( L_LINE_COUNT ) .SERVICE_REFERENCE_ORDER ) ) ;

2577: l_line_tbl (l_line_count) := l_line_rec;
2578: l_line_val_tbl(l_line_count) := l_line_val_rec;
2579: if l_line_val_tbl(l_line_count).sold_to_org = FND_API.G_MISS_CHAR then
2580: IF l_debug_level > 0 THEN
2581: oe_debug_pub.add( 'L_LINE_TBL.SERVICE_REFERENCE_ORDER ' || ASCII ( L_LINE_TBL ( L_LINE_COUNT ) .SERVICE_REFERENCE_ORDER ) ) ;
2582: END IF;
2583: IF l_debug_level > 0 THEN
2584: oe_debug_pub.add( 'L_LINE_VAL_TBL.SOLD_TO_ORG ' || ASCII ( L_LINE_VAL_TBL ( L_LINE_COUNT ) .SOLD_TO_ORG ) ) ;
2585: END IF;

Line 2584: oe_debug_pub.add( 'L_LINE_VAL_TBL.SOLD_TO_ORG ' || ASCII ( L_LINE_VAL_TBL ( L_LINE_COUNT ) .SOLD_TO_ORG ) ) ;

2580: IF l_debug_level > 0 THEN
2581: oe_debug_pub.add( 'L_LINE_TBL.SERVICE_REFERENCE_ORDER ' || ASCII ( L_LINE_TBL ( L_LINE_COUNT ) .SERVICE_REFERENCE_ORDER ) ) ;
2582: END IF;
2583: IF l_debug_level > 0 THEN
2584: oe_debug_pub.add( 'L_LINE_VAL_TBL.SOLD_TO_ORG ' || ASCII ( L_LINE_VAL_TBL ( L_LINE_COUNT ) .SOLD_TO_ORG ) ) ;
2585: END IF;
2586: end if;
2587:
2588: l_orig_sys_line_ref := l_line_rec.orig_sys_line_ref;

Line 2592: oe_debug_pub.add( 'ORIG SYS LINE REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_LINE_REF ) ;

2588: l_orig_sys_line_ref := l_line_rec.orig_sys_line_ref;
2589: l_orig_sys_shipment_ref := l_line_rec.orig_sys_shipment_ref;
2590:
2591: IF l_debug_level > 0 THEN
2592: oe_debug_pub.add( 'ORIG SYS LINE REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_LINE_REF ) ;
2593: END IF;
2594:
2595: IF l_debug_level > 0 THEN
2596: oe_debug_pub.add( 'ORIG SYS SHIPMENT REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_SHIPMENT_REF ) ;

Line 2596: oe_debug_pub.add( 'ORIG SYS SHIPMENT REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_SHIPMENT_REF ) ;

2592: oe_debug_pub.add( 'ORIG SYS LINE REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_LINE_REF ) ;
2593: END IF;
2594:
2595: IF l_debug_level > 0 THEN
2596: oe_debug_pub.add( 'ORIG SYS SHIPMENT REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_SHIPMENT_REF ) ;
2597: END IF;
2598:
2599: BEGIN
2600: oe_Debug_pub.add('calling get line ids'); --bug 4240715

Line 2600: oe_Debug_pub.add('calling get line ids'); --bug 4240715

2596: oe_debug_pub.add( 'ORIG SYS SHIPMENT REF ( '||L_LINE_COUNT||' ) : '|| L_LINE_TBL ( L_LINE_COUNT ) .ORIG_SYS_SHIPMENT_REF ) ;
2597: END IF;
2598:
2599: BEGIN
2600: oe_Debug_pub.add('calling get line ids'); --bug 4240715
2601: OE_CNCL_UTIL.get_line_ids(l_line_rec,l_line_val_rec);
2602: oe_debug_pub.add('after calling get line ids'||l_line_rec.end_customer_id); --bug 4240715
2603: --
2604: IF l_line_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2602: oe_debug_pub.add('after calling get line ids'||l_line_rec.end_customer_id); --bug 4240715

2598:
2599: BEGIN
2600: oe_Debug_pub.add('calling get line ids'); --bug 4240715
2601: OE_CNCL_UTIL.get_line_ids(l_line_rec,l_line_val_rec);
2602: oe_debug_pub.add('after calling get line ids'||l_line_rec.end_customer_id); --bug 4240715
2603: --
2604: IF l_line_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2605: --
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2616: oe_debug_pub.add('after calling convert miss to null'||l_line_rec.end_customer_id); --bug 4240715

2612: END IF;
2613: --
2614: --
2615: OE_CNCL_Util.Convert_Miss_To_Null(l_line_rec);
2616: oe_debug_pub.add('after calling convert miss to null'||l_line_rec.end_customer_id); --bug 4240715
2617: --
2618:
2619: OE_CNCL_Validate_Line.Attributes( x_return_status => l_return_status
2620: , p_x_line_rec => l_line_rec);

Line 2621: oe_debug_pub.add('after calling validate line'||l_line_rec.end_customer_id); --bug 4240715

2617: --
2618:
2619: OE_CNCL_Validate_Line.Attributes( x_return_status => l_return_status
2620: , p_x_line_rec => l_line_rec);
2621: oe_debug_pub.add('after calling validate line'||l_line_rec.end_customer_id); --bug 4240715
2622: --
2623: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2624: --
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2636: oe_debug_pub.add('after calling entity'||l_line_rec.end_customer_id); --bug 4240715

2632: --
2633:
2634: OE_CNCL_Validate_Line.Entity( x_return_status => l_return_status
2635: , p_line_rec => l_line_rec);
2636: oe_debug_pub.add('after calling entity'||l_line_rec.end_customer_id); --bug 4240715
2637: --
2638: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2639: --
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2686: oe_debug_pub.add( 'BEFORE LINE ADJUSTMENTS LOOP' ) ;

2682: Line Discounts/Price adjustments
2683: -----------------------------------------------------------
2684: */
2685: IF l_debug_level > 0 THEN
2686: oe_debug_pub.add( 'BEFORE LINE ADJUSTMENTS LOOP' ) ;
2687: END IF;
2688:
2689: OPEN l_line_adj_cursor;
2690: LOOP

Line 2781: oe_debug_pub.add( 'LINE ADJUSTMENT REF ( '||L_LINE_ADJ_COUNT||' ) : '|| L_LINE_ADJ_TBL ( L_LINE_ADJ_COUNT ) .ORIG_SYS_DISCOUNT_REF ) ;

2777:
2778: l_adj_line_ref_tbl(l_line_adj_count) := l_adj_line_ref;
2779:
2780: IF l_debug_level > 0 THEN
2781: oe_debug_pub.add( 'LINE ADJUSTMENT REF ( '||L_LINE_ADJ_COUNT||' ) : '|| L_LINE_ADJ_TBL ( L_LINE_ADJ_COUNT ) .ORIG_SYS_DISCOUNT_REF ) ;
2782: END IF;
2783:
2784:
2785: BEGIN

Line 2871: oe_debug_pub.add( 'BEFORE LINE SALES CREDITS LOOP' ) ;

2867: Line Sales Credits
2868: -----------------------------------------------------------
2869: */
2870: IF l_debug_level > 0 THEN
2871: oe_debug_pub.add( 'BEFORE LINE SALES CREDITS LOOP' ) ;
2872: END IF;
2873:
2874: OPEN l_line_scredit_cursor;
2875: LOOP

Line 2921: oe_debug_pub.add( 'LINE SALESCREDITS REF ( '||L_LINE_SCREDIT_COUNT||' ) : '|| L_LINE_SCREDIT_TBL ( L_LINE_SCREDIT_COUNT ) .ORIG_SYS_CREDIT_REF ) ;

2917:
2918: l_scredit_line_ref_tbl(l_line_scredit_count) := l_scredit_line_ref;
2919:
2920: IF l_debug_level > 0 THEN
2921: oe_debug_pub.add( 'LINE SALESCREDITS REF ( '||L_LINE_SCREDIT_COUNT||' ) : '|| L_LINE_SCREDIT_TBL ( L_LINE_SCREDIT_COUNT ) .ORIG_SYS_CREDIT_REF ) ;
2922: END IF;
2923:
2924:
2925: BEGIN

Line 3027: oe_debug_pub.add( 'ORDER NUMBER'|| L_HEADER_REC.ORDER_NUMBER , 2 ) ;

3023: OE_Header_Util.get_order_number(l_header_rec,l_header_rec_old);
3024:
3025:
3026: IF l_debug_level > 0 THEN
3027: oe_debug_pub.add( 'ORDER NUMBER'|| L_HEADER_REC.ORDER_NUMBER , 2 ) ;
3028: END IF;
3029: --
3030: SELECT OE_ORDER_HEADERS_S.NEXTVAL
3031: INTO l_header_rec.header_id

Line 3049: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;

3045: l_header_rec.open_flag := 'N';
3046: l_header_rec.flow_status_code := 'CLOSED';
3047: --
3048: IF l_debug_level > 0 THEN
3049: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;
3050: END IF;
3051: IF l_debug_level > 0 THEN
3052: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3053: END IF;

Line 3052: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;

3048: IF l_debug_level > 0 THEN
3049: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;
3050: END IF;
3051: IF l_debug_level > 0 THEN
3052: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3053: END IF;
3054: IF l_debug_level > 0 THEN
3055: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3056: END IF;

Line 3055: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;

3051: IF l_debug_level > 0 THEN
3052: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3053: END IF;
3054: IF l_debug_level > 0 THEN
3055: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3056: END IF;
3057:
3058: --
3059: OE_Header_Util.Insert_Row(l_header_rec);

Line 3062: oe_debug_pub.add( 'HEADER ID : ' || L_HEADER_REC.HEADER_ID , 2 ) ;

3058: --
3059: OE_Header_Util.Insert_Row(l_header_rec);
3060: --
3061: IF l_debug_level > 0 THEN
3062: oe_debug_pub.add( 'HEADER ID : ' || L_HEADER_REC.HEADER_ID , 2 ) ;
3063: END IF;
3064:
3065:
3066: EXCEPTION

Line 3260: oe_debug_pub.add( 'ITEM TYPE CODE => ' || L_LINE_TBL ( I ) .ITEM_TYPE_CODE ) ;

3256: l_line_tbl(I).item_type_code := OE_CNCL_Validate_Line.get_item_type
3257: (l_line_rec);
3258:
3259: IF l_debug_level > 0 THEN
3260: oe_debug_pub.add( 'ITEM TYPE CODE => ' || L_LINE_TBL ( I ) .ITEM_TYPE_CODE ) ;
3261: END IF;
3262: -- End Before insert check is the item_type_code}
3263:
3264: --

Line 3282: oe_debug_pub.add( 'OEXVCIMB 1 Entered for ref type ORDER');

3278: -- The logic for reference type ORDER never got executed earlier
3279: IF l_line_tbl(I).service_reference_type_code = 'ORDER' THEN
3280:
3281: IF l_debug_level > 0 THEN
3282: oe_debug_pub.add( 'OEXVCIMB 1 Entered for ref type ORDER');
3283: END IF;
3284: --
3285: FOR N IN 1..l_line_tbl.COUNT
3286: --

Line 3314: oe_debug_pub.add( 'OEXVCIMB 2 service num= '||l_serv_num_cnt);

3310:
3311: l_serv_num_cnt := l_serv_num_cnt+1;
3312:
3313: IF l_debug_level > 0 THEN
3314: oe_debug_pub.add( 'OEXVCIMB 2 service num= '||l_serv_num_cnt);
3315: END IF;
3316: --
3317: l_line_tbl(I).service_reference_line_id := l_line_tbl(N).line_id;
3318: l_line_tbl(I).service_number := l_serv_num_cnt;

Line 3534: oe_debug_pub.add( ' ORIG SYS LINE REF ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .ORIG_SYS_LINE_REF ) ;

3530: --
3531: END IF;
3532: --
3533:
3534: oe_debug_pub.add( ' ORIG SYS LINE REF ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .ORIG_SYS_LINE_REF ) ;
3535: oe_debug_pub.add( ' top_model_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_ref ) ;
3536: oe_debug_pub.add( ' top_model_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_id ) ;
3537: oe_debug_pub.add( ' link_to_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_ref ) ;
3538: oe_debug_pub.add( ' link_to_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_id ) ;

Line 3535: oe_debug_pub.add( ' top_model_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_ref ) ;

3531: END IF;
3532: --
3533:
3534: oe_debug_pub.add( ' ORIG SYS LINE REF ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .ORIG_SYS_LINE_REF ) ;
3535: oe_debug_pub.add( ' top_model_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_ref ) ;
3536: oe_debug_pub.add( ' top_model_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_id ) ;
3537: oe_debug_pub.add( ' link_to_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_ref ) ;
3538: oe_debug_pub.add( ' link_to_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_id ) ;
3539:

Line 3536: oe_debug_pub.add( ' top_model_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_id ) ;

3532: --
3533:
3534: oe_debug_pub.add( ' ORIG SYS LINE REF ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .ORIG_SYS_LINE_REF ) ;
3535: oe_debug_pub.add( ' top_model_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_ref ) ;
3536: oe_debug_pub.add( ' top_model_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_id ) ;
3537: oe_debug_pub.add( ' link_to_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_ref ) ;
3538: oe_debug_pub.add( ' link_to_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_id ) ;
3539:
3540: OE_Line_Util.Insert_Row(l_line_tbl(L));

Line 3537: oe_debug_pub.add( ' link_to_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_ref ) ;

3533:
3534: oe_debug_pub.add( ' ORIG SYS LINE REF ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .ORIG_SYS_LINE_REF ) ;
3535: oe_debug_pub.add( ' top_model_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_ref ) ;
3536: oe_debug_pub.add( ' top_model_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_id ) ;
3537: oe_debug_pub.add( ' link_to_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_ref ) ;
3538: oe_debug_pub.add( ' link_to_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_id ) ;
3539:
3540: OE_Line_Util.Insert_Row(l_line_tbl(L));
3541:

Line 3538: oe_debug_pub.add( ' link_to_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_id ) ;

3534: oe_debug_pub.add( ' ORIG SYS LINE REF ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .ORIG_SYS_LINE_REF ) ;
3535: oe_debug_pub.add( ' top_model_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_ref ) ;
3536: oe_debug_pub.add( ' top_model_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .top_model_line_id ) ;
3537: oe_debug_pub.add( ' link_to_line_ref ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_ref ) ;
3538: oe_debug_pub.add( ' link_to_line_id ( '|| L ||' ) : '|| L_LINE_TBL ( L ) .link_to_line_id ) ;
3539:
3540: OE_Line_Util.Insert_Row(l_line_tbl(L));
3541:
3542: FOR J in 1..l_line_scredit_tbl.COUNT

Line 3550: oe_debug_pub.add( TO_CHAR ( J ) , 2 ) ;

3546: BEGIN
3547: --
3548: --
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( TO_CHAR ( J ) , 2 ) ;
3551: END IF;
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add( 'L_SCREDIT_LINE_REF_TBL ' || L_SCREDIT_LINE_REF_TBL ( J ) , 2 ) ;
3554: END IF;

Line 3553: oe_debug_pub.add( 'L_SCREDIT_LINE_REF_TBL ' || L_SCREDIT_LINE_REF_TBL ( J ) , 2 ) ;

3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( TO_CHAR ( J ) , 2 ) ;
3551: END IF;
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add( 'L_SCREDIT_LINE_REF_TBL ' || L_SCREDIT_LINE_REF_TBL ( J ) , 2 ) ;
3554: END IF;
3555: IF l_scredit_line_ref_tbl(J) = l_line_tbl(L).orig_sys_line_ref THEN
3556: --
3557: IF l_debug_level > 0 THEN

Line 3558: oe_debug_pub.add( 'INSIDE IF STATEMENT**********************' , 2 ) ;

3554: END IF;
3555: IF l_scredit_line_ref_tbl(J) = l_line_tbl(L).orig_sys_line_ref THEN
3556: --
3557: IF l_debug_level > 0 THEN
3558: oe_debug_pub.add( 'INSIDE IF STATEMENT**********************' , 2 ) ;
3559: END IF;
3560: SELECT OE_SALES_CREDITS_S.NEXTVAL
3561: INTO l_line_scredit_tbl(J).sales_credit_id
3562: FROM DUAL;

Line 3768: oe_debug_pub.add( 'L_VALIDATE_ONLY '||L_VALIDATE_ONLY ) ;

3764: -----------------------------------------------------------
3765: */
3766: -- aksingh
3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add( 'L_VALIDATE_ONLY '||L_VALIDATE_ONLY ) ;
3769: END IF;
3770: IF l_debug_level > 0 THEN
3771: oe_debug_pub.add( 'P_RETURN_STATUS '||P_RETURN_STATUS ) ;
3772: END IF;

Line 3771: oe_debug_pub.add( 'P_RETURN_STATUS '||P_RETURN_STATUS ) ;

3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add( 'L_VALIDATE_ONLY '||L_VALIDATE_ONLY ) ;
3769: END IF;
3770: IF l_debug_level > 0 THEN
3771: oe_debug_pub.add( 'P_RETURN_STATUS '||P_RETURN_STATUS ) ;
3772: END IF;
3773:
3774: -- aksingh IF p_validate_only = FND_API.G_FALSE AND
3775: IF l_validate_only = FND_API.G_FALSE AND

Line 3784: oe_debug_pub.add( 'DELETE FLAG '||L_DELETE_FLAG ) ;

3780: l_delete_flag := 'N';
3781: END IF;
3782:
3783: IF l_debug_level > 0 THEN
3784: oe_debug_pub.add( 'DELETE FLAG '||L_DELETE_FLAG ) ;
3785: END IF;
3786:
3787: IF l_delete_flag = 'Y' THEN
3788:

Line 3790: oe_debug_pub.add( 'BEFORE DELETING ORDER FROM INTERFACE TABLES' ) ;

3786:
3787: IF l_delete_flag = 'Y' THEN
3788:
3789: IF l_debug_level > 0 THEN
3790: oe_debug_pub.add( 'BEFORE DELETING ORDER FROM INTERFACE TABLES' ) ;
3791: END IF;
3792:
3793: OE_ORDER_IMPORT_UTIL_PVT.Delete_Order (
3794: p_request_id => l_request_id,

Line 3808: oe_debug_pub.add( 'DELETE ORDER RETURN STATUS: '||L_RETURN_STATUS_DEL_ORD ) ;

3804: Set Return Status
3805: -----------------------------------------------------------
3806: */
3807: IF l_debug_level > 0 THEN
3808: oe_debug_pub.add( 'DELETE ORDER RETURN STATUS: '||L_RETURN_STATUS_DEL_ORD ) ;
3809: END IF;
3810:
3811: IF l_return_status_del_ord IN (FND_API.G_RET_STS_ERROR)
3812: AND p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

Line 3828: oe_debug_pub.add( 'BEFORE COMMIT OR ROLLBACK' ) ;

3824: Commit or rollback the transaction
3825: -----------------------------------------------------------
3826: */
3827: IF l_debug_level > 0 THEN
3828: oe_debug_pub.add( 'BEFORE COMMIT OR ROLLBACK' ) ;
3829: END IF;
3830:
3831: IF l_validate_only = FND_API.G_TRUE
3832: OR p_return_status in (FND_API.G_RET_STS_ERROR, -- E:Expected error

Line 3841: oe_debug_pub.add( 'COMMIT FLAG '||L_COMMIT_FLAG ) ;

3837: l_commit_flag := 'Y';
3838: END IF;
3839:
3840: IF l_debug_level > 0 THEN
3841: oe_debug_pub.add( 'COMMIT FLAG '||L_COMMIT_FLAG ) ;
3842: END IF;
3843:
3844: IF l_commit_flag = 'Y' THEN
3845: COMMIT;

Line 3860: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER' ) ;

3856: THEN
3857: BEGIN
3858: BEGIN
3859: IF l_debug_level > 0 THEN
3860: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER' ) ;
3861: END IF;
3862:
3863: UPDATE oe_headers_interface
3864: SET error_flag = 'Y'

Line 3878: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

3874: = nvl(l_request_id, FND_API.G_MISS_NUM);
3875: EXCEPTION
3876: WHEN OTHERS THEN
3877: IF l_debug_level > 0 THEN
3878: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3879: END IF;
3880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3881: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3882: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

Line 3890: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER PRICE ADJUSTMENTS' ) ;

3886: BEGIN
3887: FOR I in 1..l_header_adj_tbl.count
3888: LOOP
3889: IF l_debug_level > 0 THEN
3890: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER PRICE ADJUSTMENTS' ) ;
3891: END IF;
3892: IF l_header_adj_tbl(I).return_status IN (
3893: FND_API.G_RET_STS_ERROR,
3894: FND_API.G_RET_STS_UNEXP_ERROR)

Line 3915: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

3911: FND_API.G_MISS_CHAR);
3912: EXCEPTION
3913: WHEN OTHERS THEN
3914: IF l_debug_level > 0 THEN
3915: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3916: END IF;
3917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3918: THEN
3919: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3931: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER SALES CREDITS' ) ;

3927: BEGIN
3928: FOR I in 1..l_header_scredit_tbl.count
3929: LOOP
3930: IF l_debug_level > 0 THEN
3931: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER SALES CREDITS' ) ;
3932: END IF;
3933: IF l_header_scredit_tbl(I).return_status IN (
3934: FND_API.G_RET_STS_ERROR,
3935: FND_API.G_RET_STS_UNEXP_ERROR)

Line 3956: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

3952: FND_API.G_MISS_CHAR);
3953: EXCEPTION
3954: WHEN OTHERS THEN
3955: IF l_debug_level > 0 THEN
3956: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3957: END IF;
3958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3959: THEN
3960: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3972: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR LINES' ) ;

3968: BEGIN
3969: FOR I in 1..l_line_tbl.count
3970: LOOP
3971: IF l_debug_level > 0 THEN
3972: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR LINES' ) ;
3973: END IF;
3974: IF l_line_tbl(I).return_status IN (
3975: FND_API.G_RET_STS_ERROR,
3976: FND_API.G_RET_STS_UNEXP_ERROR)

Line 3998: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

3994: = nvl(l_line_tbl(I).orig_sys_shipment_ref,FND_API.G_MISS_CHAR);
3995: EXCEPTION
3996: WHEN OTHERS THEN
3997: IF l_debug_level > 0 THEN
3998: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3999: END IF;
4000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4001: THEN
4002: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4015: oe_debug_pub.add( 'UPDATE ERROR_FLAG RETURN STATUS: '||L_RETURN_STATUS_UPD_ERR ) ;

4011: Set Return Status
4012: -----------------------------------------------------------
4013: */
4014: IF l_debug_level > 0 THEN
4015: oe_debug_pub.add( 'UPDATE ERROR_FLAG RETURN STATUS: '||L_RETURN_STATUS_UPD_ERR ) ;
4016: END IF;
4017:
4018: IF l_return_status_upd_err IN (FND_API.G_RET_STS_ERROR)
4019: AND p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

Line 4051: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;

4047: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count
4048: ,p_data => p_msg_data);
4049:
4050: IF l_debug_level > 0 THEN
4051: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;
4052: END IF;
4053:
4054: IF p_msg_count > 0 THEN
4055:

Line 4057: oe_debug_pub.add( 'BEFORE UPDATING THE PROCESSING MESSAGES TABLE' ) ;

4053:
4054: IF p_msg_count > 0 THEN
4055:
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.add( 'BEFORE UPDATING THE PROCESSING MESSAGES TABLE' ) ;
4058: END IF;
4059:
4060: FOR k IN 1 .. p_msg_count
4061: LOOP

Line 4063: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;

4059:
4060: FOR k IN 1 .. p_msg_count
4061: LOOP
4062: IF l_debug_level > 0 THEN
4063: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;
4064: END IF;
4065: oe_msg_pub.get (
4066: p_msg_index => -2
4067: ,p_encoded => 'F'

Line 4083: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;

4079: l_msg_entity_ref := '';
4080:
4081: begin
4082: IF l_debug_level > 0 THEN
4083: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;
4084: END IF;
4085: oe_msg_pub.get_msg_context (
4086: p_msg_index => l_msg_index
4087: ,x_entity_code => l_msg_entity_code

Line 4110: oe_debug_pub.add( 'UNEXPECTED ERROR IN GET MSG : '||SQLERRM ) ;

4106:
4107: exception
4108: when others then
4109: IF l_debug_level > 0 THEN
4110: oe_debug_pub.add( 'UNEXPECTED ERROR IN GET MSG : '||SQLERRM ) ;
4111: END IF;
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add( 'IGNORING ABOVE MESSAGE' ) ;
4114: END IF;

Line 4113: oe_debug_pub.add( 'IGNORING ABOVE MESSAGE' ) ;

4109: IF l_debug_level > 0 THEN
4110: oe_debug_pub.add( 'UNEXPECTED ERROR IN GET MSG : '||SQLERRM ) ;
4111: END IF;
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add( 'IGNORING ABOVE MESSAGE' ) ;
4114: END IF;
4115: l_error_index_flag := 'Y';
4116: end;
4117: -- bug 4195533 - changed the condition below from <> to =

Line 4122: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;

4118: if l_error_index_flag = 'Y' then
4119: goto out_error;
4120: end if;
4121: IF l_debug_level > 0 THEN
4122: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
4123: END IF;
4124: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;

Line 4126: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;

4122: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
4123: END IF;
4124: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
4127: END IF;
4128: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');
4129: END IF;
4130:

Line 4177: oe_debug_pub.add( L_MSG_DATA ) ;

4173: END IF;
4174: l_msg_data := 'Msg-'||k||' for '||l_msg_context||': '||p_msg_data;
4175:
4176: IF l_debug_level > 0 THEN
4177: oe_debug_pub.add( L_MSG_DATA ) ;
4178: END IF;
4179: -- start bug 4195533
4180: IF p_return_status = FND_API.G_RET_STS_SUCCESS
4181: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN

Line 4183: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;

4179: -- start bug 4195533
4180: IF p_return_status = FND_API.G_RET_STS_SUCCESS
4181: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
4182: IF l_debug_level > 0 THEN
4183: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;
4184: END IF;
4185: oe_msg_pub.g_msg_tbl(l_msg_index).header_id := l_header_rec.header_id;
4186: END IF;
4187: -- end bug 4195533

Line 4198: oe_debug_pub.add( 'BEFORE DELETING OLD MESSAGES FROM THE DATABASE TABLE' ) ;

4194: Delete messages from the database table
4195: -----------------------------------------------------------
4196: */
4197: IF l_debug_level > 0 THEN
4198: oe_debug_pub.add( 'BEFORE DELETING OLD MESSAGES FROM THE DATABASE TABLE' ) ;
4199: END IF;
4200:
4201: /*
4202: OE_ORDER_IMPORT_UTIL_PVT.Delete_Messages (

Line 4217: oe_debug_pub.add( 'DELETE MESSAGES RETURN STATUS: '||L_RETURN_STATUS_DEL_MSG ) ;

4213: Set Return Status
4214: -----------------------------------------------------------
4215: */
4216: IF l_debug_level > 0 THEN
4217: oe_debug_pub.add( 'DELETE MESSAGES RETURN STATUS: '||L_RETURN_STATUS_DEL_MSG ) ;
4218: END IF;
4219:
4220: IF l_return_status_del_msg IN (FND_API.G_RET_STS_ERROR)
4221: AND p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

Line 4235: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;

4231: Save messages in the database table
4232: -----------------------------------------------------------
4233: */
4234: IF l_debug_level > 0 THEN
4235: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;
4236: END IF;
4237:
4238: IF p_msg_count > 0 THEN
4239: OE_MSG_PUB.save_messages (l_request_id);

Line 4262: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;

4258: Report final order processing results
4259: -----------------------------------------------------------
4260: */
4261: IF l_debug_level > 0 THEN
4262: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;
4263: END IF;
4264:
4265: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
4266: IF l_debug_level > 0 THEN

Line 4267: oe_debug_pub.add( 'ORDER FAILED WITH ERROR ( S ) ' ) ;

4263: END IF;
4264:
4265: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
4266: IF l_debug_level > 0 THEN
4267: oe_debug_pub.add( 'ORDER FAILED WITH ERROR ( S ) ' ) ;
4268: END IF;
4269: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4270: IF l_debug_level > 0 THEN
4271: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;

Line 4271: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;

4267: oe_debug_pub.add( 'ORDER FAILED WITH ERROR ( S ) ' ) ;
4268: END IF;
4269: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4270: IF l_debug_level > 0 THEN
4271: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;
4272: END IF;
4273: ELSE
4274: IF l_debug_level > 0 THEN
4275: oe_debug_pub.add( 'ORDER PROCESSED SUCCESSFULLY' ) ;

Line 4275: oe_debug_pub.add( 'ORDER PROCESSED SUCCESSFULLY' ) ;

4271: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;
4272: END IF;
4273: ELSE
4274: IF l_debug_level > 0 THEN
4275: oe_debug_pub.add( 'ORDER PROCESSED SUCCESSFULLY' ) ;
4276: END IF;
4277: END IF;
4278:
4279: --END LOOP; /* Headers cursor */

Line 4287: --oe_debug_pub.add('End of Order Import');

4283: /*-----------------------------------------------------------
4284: End of Order Import
4285: -----------------------------------------------------------
4286: */
4287: --oe_debug_pub.add('End of Order Import');
4288:
4289:
4290: EXCEPTION
4291: --

Line 4294: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

4290: EXCEPTION
4291: --
4292: WHEN OTHERS THEN
4293: IF l_debug_level > 0 THEN
4294: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
4295: END IF;
4296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4297: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4298: END IF;