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: BEGIN
1212:
1213: /* -----------------------------------------------------------

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

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

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

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

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

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

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

1336: Headers
1337: -----------------------------------------------------------
1338: */
1339: IF l_debug_level > 0 THEN
1340: oe_debug_pub.add( 'BEFORE HEADERS LOOP' ) ;
1341: END IF;
1342:
1343: l_header_count := 0;
1344:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1631: end if;
1632:
1633: else
1634: IF l_debug_level > 0 THEN
1635: oe_debug_pub.add( 'sold to org is NULL') ;
1636: END IF;
1637: end if;
1638:
1639: end if;

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

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

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

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

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

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

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

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

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

2043: Lines
2044: -----------------------------------------------------------
2045: */
2046: IF l_debug_level > 0 THEN
2047: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;
2048: END IF;
2049:
2050: l_line_count := 0;
2051:

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

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

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

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

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

2431:
2432:
2433: if l_line_rec.sold_to_org_id = FND_API.G_MISS_NUM then
2434: IF l_debug_level > 0 THEN
2435: 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' ) ;
2436: END IF;
2437: l_line_rec.sold_to_org_id := l_header_rec.sold_to_org_id;
2438: end if;
2439:

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

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

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

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

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

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

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

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

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

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

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

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

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

2490: IF l_debug_level > 0 THEN
2491: oe_debug_pub.add( 'SEGMENTS ENABLED = '||L_N_SEGMENTS ) ;
2492: END IF;
2493: IF l_debug_level > 0 THEN
2494: oe_debug_pub.add( 'ORG_ID = '||L_LINE_REC.ORG_ID ) ;
2495: END IF;
2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||L_VALIDATION_ORG ) ;
2498: END IF;

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

2493: IF l_debug_level > 0 THEN
2494: oe_debug_pub.add( 'ORG_ID = '||L_LINE_REC.ORG_ID ) ;
2495: END IF;
2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||L_VALIDATION_ORG ) ;
2498: END IF;
2499: IF l_debug_level > 0 THEN
2500: oe_debug_pub.add( 'ARRAY1 = '||L_SEGMENT_ARRAY ( 1 ) ) ;
2501: END IF;

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

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

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

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

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

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

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

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

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

2515: IF l_debug_level > 0 THEN
2516: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;
2517: END IF;
2518: IF l_debug_level > 0 THEN
2519: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 51 , 50 ) ) ;
2520: END IF;
2521: IF l_debug_level > 0 THEN
2522: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 101 , 50 ) ) ;
2523: END IF;

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

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

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

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

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

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

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

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

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

2560: IF l_debug_level > 0 THEN
2561: oe_debug_pub.add( 'ORDER NO: '||L_ORIG_SYS_DOCUMENT_REF ) ;
2562: END IF;
2563: IF l_debug_level > 0 THEN
2564: oe_debug_pub.add( 'ORDER SOURCE: '||L_ORDER_SOURCE_ID ) ;
2565: END IF;
2566:
2567: END IF;
2568:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2773:
2774: l_adj_line_ref_tbl(l_line_adj_count) := l_adj_line_ref;
2775:
2776: IF l_debug_level > 0 THEN
2777: oe_debug_pub.add( 'LINE ADJUSTMENT REF ( '||L_LINE_ADJ_COUNT||' ) : '|| L_LINE_ADJ_TBL ( L_LINE_ADJ_COUNT ) .ORIG_SYS_DISCOUNT_REF ) ;
2778: END IF;
2779:
2780:
2781: BEGIN

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

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

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

2913:
2914: l_scredit_line_ref_tbl(l_line_scredit_count) := l_scredit_line_ref;
2915:
2916: IF l_debug_level > 0 THEN
2917: oe_debug_pub.add( 'LINE SALESCREDITS REF ( '||L_LINE_SCREDIT_COUNT||' ) : '|| L_LINE_SCREDIT_TBL ( L_LINE_SCREDIT_COUNT ) .ORIG_SYS_CREDIT_REF ) ;
2918: END IF;
2919:
2920:
2921: BEGIN

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

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

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

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

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

3044: IF l_debug_level > 0 THEN
3045: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;
3046: END IF;
3047: IF l_debug_level > 0 THEN
3048: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3049: END IF;
3050: IF l_debug_level > 0 THEN
3051: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3052: END IF;

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

3047: IF l_debug_level > 0 THEN
3048: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3049: END IF;
3050: IF l_debug_level > 0 THEN
3051: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3052: END IF;
3053:
3054: --
3055: OE_Header_Util.Insert_Row(l_header_rec);

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

3054: --
3055: OE_Header_Util.Insert_Row(l_header_rec);
3056: --
3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'HEADER ID : ' || L_HEADER_REC.HEADER_ID , 2 ) ;
3059: END IF;
3060:
3061:
3062: EXCEPTION

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

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

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

3477: BEGIN
3478: --
3479: --
3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add( TO_CHAR ( J ) , 2 ) ;
3482: END IF;
3483: IF l_debug_level > 0 THEN
3484: oe_debug_pub.add( 'L_SCREDIT_LINE_REF_TBL ' || L_SCREDIT_LINE_REF_TBL ( J ) , 2 ) ;
3485: END IF;

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

3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add( TO_CHAR ( J ) , 2 ) ;
3482: END IF;
3483: IF l_debug_level > 0 THEN
3484: oe_debug_pub.add( 'L_SCREDIT_LINE_REF_TBL ' || L_SCREDIT_LINE_REF_TBL ( J ) , 2 ) ;
3485: END IF;
3486: IF l_scredit_line_ref_tbl(J) = l_line_tbl(L).orig_sys_line_ref THEN
3487: --
3488: IF l_debug_level > 0 THEN

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

3485: END IF;
3486: IF l_scredit_line_ref_tbl(J) = l_line_tbl(L).orig_sys_line_ref THEN
3487: --
3488: IF l_debug_level > 0 THEN
3489: oe_debug_pub.add( 'INSIDE IF STATEMENT**********************' , 2 ) ;
3490: END IF;
3491: SELECT OE_SALES_CREDITS_S.NEXTVAL
3492: INTO l_line_scredit_tbl(J).sales_credit_id
3493: FROM DUAL;

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

3695: -----------------------------------------------------------
3696: */
3697: -- aksingh
3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add( 'L_VALIDATE_ONLY '||L_VALIDATE_ONLY ) ;
3700: END IF;
3701: IF l_debug_level > 0 THEN
3702: oe_debug_pub.add( 'P_RETURN_STATUS '||P_RETURN_STATUS ) ;
3703: END IF;

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

3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add( 'L_VALIDATE_ONLY '||L_VALIDATE_ONLY ) ;
3700: END IF;
3701: IF l_debug_level > 0 THEN
3702: oe_debug_pub.add( 'P_RETURN_STATUS '||P_RETURN_STATUS ) ;
3703: END IF;
3704:
3705: -- aksingh IF p_validate_only = FND_API.G_FALSE AND
3706: IF l_validate_only = FND_API.G_FALSE AND

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

3711: l_delete_flag := 'N';
3712: END IF;
3713:
3714: IF l_debug_level > 0 THEN
3715: oe_debug_pub.add( 'DELETE FLAG '||L_DELETE_FLAG ) ;
3716: END IF;
3717:
3718: IF l_delete_flag = 'Y' THEN
3719:

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

3717:
3718: IF l_delete_flag = 'Y' THEN
3719:
3720: IF l_debug_level > 0 THEN
3721: oe_debug_pub.add( 'BEFORE DELETING ORDER FROM INTERFACE TABLES' ) ;
3722: END IF;
3723:
3724: OE_ORDER_IMPORT_UTIL_PVT.Delete_Order (
3725: p_request_id => l_request_id,

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

3735: Set Return Status
3736: -----------------------------------------------------------
3737: */
3738: IF l_debug_level > 0 THEN
3739: oe_debug_pub.add( 'DELETE ORDER RETURN STATUS: '||L_RETURN_STATUS_DEL_ORD ) ;
3740: END IF;
3741:
3742: IF l_return_status_del_ord IN (FND_API.G_RET_STS_ERROR)
3743: AND p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

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

3755: Commit or rollback the transaction
3756: -----------------------------------------------------------
3757: */
3758: IF l_debug_level > 0 THEN
3759: oe_debug_pub.add( 'BEFORE COMMIT OR ROLLBACK' ) ;
3760: END IF;
3761:
3762: IF l_validate_only = FND_API.G_TRUE
3763: OR p_return_status in (FND_API.G_RET_STS_ERROR, -- E:Expected error

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

3768: l_commit_flag := 'Y';
3769: END IF;
3770:
3771: IF l_debug_level > 0 THEN
3772: oe_debug_pub.add( 'COMMIT FLAG '||L_COMMIT_FLAG ) ;
3773: END IF;
3774:
3775: IF l_commit_flag = 'Y' THEN
3776: COMMIT;

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

3787: THEN
3788: BEGIN
3789: BEGIN
3790: IF l_debug_level > 0 THEN
3791: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER' ) ;
3792: END IF;
3793:
3794: UPDATE oe_headers_interface
3795: SET error_flag = 'Y'

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

3805: = nvl(l_request_id, FND_API.G_MISS_NUM);
3806: EXCEPTION
3807: WHEN OTHERS THEN
3808: IF l_debug_level > 0 THEN
3809: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3810: END IF;
3811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3812: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3813: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

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

3817: BEGIN
3818: FOR I in 1..l_header_adj_tbl.count
3819: LOOP
3820: IF l_debug_level > 0 THEN
3821: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER PRICE ADJUSTMENTS' ) ;
3822: END IF;
3823: IF l_header_adj_tbl(I).return_status IN (
3824: FND_API.G_RET_STS_ERROR,
3825: FND_API.G_RET_STS_UNEXP_ERROR)

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

3842: FND_API.G_MISS_CHAR);
3843: EXCEPTION
3844: WHEN OTHERS THEN
3845: IF l_debug_level > 0 THEN
3846: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3847: END IF;
3848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3849: THEN
3850: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;

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

3858: BEGIN
3859: FOR I in 1..l_header_scredit_tbl.count
3860: LOOP
3861: IF l_debug_level > 0 THEN
3862: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR HEADER SALES CREDITS' ) ;
3863: END IF;
3864: IF l_header_scredit_tbl(I).return_status IN (
3865: FND_API.G_RET_STS_ERROR,
3866: FND_API.G_RET_STS_UNEXP_ERROR)

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

3883: FND_API.G_MISS_CHAR);
3884: EXCEPTION
3885: WHEN OTHERS THEN
3886: IF l_debug_level > 0 THEN
3887: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3888: END IF;
3889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3890: THEN
3891: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;

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

3899: BEGIN
3900: FOR I in 1..l_line_tbl.count
3901: LOOP
3902: IF l_debug_level > 0 THEN
3903: oe_debug_pub.add( 'BEFORE UPDATING ERROR FLAG FOR LINES' ) ;
3904: END IF;
3905: IF l_line_tbl(I).return_status IN (
3906: FND_API.G_RET_STS_ERROR,
3907: FND_API.G_RET_STS_UNEXP_ERROR)

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

3925: = nvl(l_line_tbl(I).orig_sys_shipment_ref,FND_API.G_MISS_CHAR);
3926: EXCEPTION
3927: WHEN OTHERS THEN
3928: IF l_debug_level > 0 THEN
3929: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3930: END IF;
3931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3932: THEN
3933: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;

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

3942: Set Return Status
3943: -----------------------------------------------------------
3944: */
3945: IF l_debug_level > 0 THEN
3946: oe_debug_pub.add( 'UPDATE ERROR_FLAG RETURN STATUS: '||L_RETURN_STATUS_UPD_ERR ) ;
3947: END IF;
3948:
3949: IF l_return_status_upd_err IN (FND_API.G_RET_STS_ERROR)
3950: AND p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

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

3978: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count
3979: ,p_data => p_msg_data);
3980:
3981: IF l_debug_level > 0 THEN
3982: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;
3983: END IF;
3984:
3985: IF p_msg_count > 0 THEN
3986:

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

3984:
3985: IF p_msg_count > 0 THEN
3986:
3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add( 'BEFORE UPDATING THE PROCESSING MESSAGES TABLE' ) ;
3989: END IF;
3990:
3991: FOR k IN 1 .. p_msg_count
3992: LOOP

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

3990:
3991: FOR k IN 1 .. p_msg_count
3992: LOOP
3993: IF l_debug_level > 0 THEN
3994: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;
3995: END IF;
3996: oe_msg_pub.get (
3997: p_msg_index => -2
3998: ,p_encoded => 'F'

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

4010: l_msg_entity_ref := '';
4011:
4012: begin
4013: IF l_debug_level > 0 THEN
4014: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;
4015: END IF;
4016: oe_msg_pub.get_msg_context (
4017: p_msg_index => l_msg_index
4018: ,x_entity_code => l_msg_entity_code

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

4037:
4038: exception
4039: when others then
4040: IF l_debug_level > 0 THEN
4041: oe_debug_pub.add( 'UNEXPECTED ERROR IN GET MSG : '||SQLERRM ) ;
4042: END IF;
4043: IF l_debug_level > 0 THEN
4044: oe_debug_pub.add( 'IGNORING ABOVE MESSAGE' ) ;
4045: END IF;

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

4040: IF l_debug_level > 0 THEN
4041: oe_debug_pub.add( 'UNEXPECTED ERROR IN GET MSG : '||SQLERRM ) ;
4042: END IF;
4043: IF l_debug_level > 0 THEN
4044: oe_debug_pub.add( 'IGNORING ABOVE MESSAGE' ) ;
4045: END IF;
4046: l_error_index_flag := 'Y';
4047: end;
4048: -- bug 4195533 - changed the condition below from <> to =

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

4049: if l_error_index_flag = 'Y' then
4050: goto out_error;
4051: end if;
4052: IF l_debug_level > 0 THEN
4053: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
4054: END IF;
4055: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;

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

4053: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
4054: END IF;
4055: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
4058: END IF;
4059: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');
4060: END IF;
4061:

Line 4108: oe_debug_pub.add( L_MSG_DATA ) ;

4104: END IF;
4105: l_msg_data := 'Msg-'||k||' for '||l_msg_context||': '||p_msg_data;
4106:
4107: IF l_debug_level > 0 THEN
4108: oe_debug_pub.add( L_MSG_DATA ) ;
4109: END IF;
4110: -- start bug 4195533
4111: IF p_return_status = FND_API.G_RET_STS_SUCCESS
4112: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN

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

4110: -- start bug 4195533
4111: IF p_return_status = FND_API.G_RET_STS_SUCCESS
4112: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
4113: IF l_debug_level > 0 THEN
4114: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;
4115: END IF;
4116: oe_msg_pub.g_msg_tbl(l_msg_index).header_id := l_header_rec.header_id;
4117: END IF;
4118: -- end bug 4195533

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

4125: Delete messages from the database table
4126: -----------------------------------------------------------
4127: */
4128: IF l_debug_level > 0 THEN
4129: oe_debug_pub.add( 'BEFORE DELETING OLD MESSAGES FROM THE DATABASE TABLE' ) ;
4130: END IF;
4131:
4132: /*
4133: OE_ORDER_IMPORT_UTIL_PVT.Delete_Messages (

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

4144: Set Return Status
4145: -----------------------------------------------------------
4146: */
4147: IF l_debug_level > 0 THEN
4148: oe_debug_pub.add( 'DELETE MESSAGES RETURN STATUS: '||L_RETURN_STATUS_DEL_MSG ) ;
4149: END IF;
4150:
4151: IF l_return_status_del_msg IN (FND_API.G_RET_STS_ERROR)
4152: AND p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

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

4162: Save messages in the database table
4163: -----------------------------------------------------------
4164: */
4165: IF l_debug_level > 0 THEN
4166: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;
4167: END IF;
4168:
4169: IF p_msg_count > 0 THEN
4170: OE_MSG_PUB.save_messages (l_request_id);

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

4189: Report final order processing results
4190: -----------------------------------------------------------
4191: */
4192: IF l_debug_level > 0 THEN
4193: oe_debug_pub.add( 'RETURN_STATUS: '||P_RETURN_STATUS ) ;
4194: END IF;
4195:
4196: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
4197: IF l_debug_level > 0 THEN

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

4194: END IF;
4195:
4196: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
4197: IF l_debug_level > 0 THEN
4198: oe_debug_pub.add( 'ORDER FAILED WITH ERROR ( S ) ' ) ;
4199: END IF;
4200: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4201: IF l_debug_level > 0 THEN
4202: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;

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

4198: oe_debug_pub.add( 'ORDER FAILED WITH ERROR ( S ) ' ) ;
4199: END IF;
4200: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4201: IF l_debug_level > 0 THEN
4202: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;
4203: END IF;
4204: ELSE
4205: IF l_debug_level > 0 THEN
4206: oe_debug_pub.add( 'ORDER PROCESSED SUCCESSFULLY' ) ;

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

4202: oe_debug_pub.add( 'ORDER FAILED WITH UNEXPECTED ERROR ( S ) ' ) ;
4203: END IF;
4204: ELSE
4205: IF l_debug_level > 0 THEN
4206: oe_debug_pub.add( 'ORDER PROCESSED SUCCESSFULLY' ) ;
4207: END IF;
4208: END IF;
4209:
4210: --END LOOP; /* Headers cursor */

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

4214: /*-----------------------------------------------------------
4215: End of Order Import
4216: -----------------------------------------------------------
4217: */
4218: --oe_debug_pub.add('End of Order Import');
4219:
4220:
4221: EXCEPTION
4222: --

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

4221: EXCEPTION
4222: --
4223: WHEN OTHERS THEN
4224: IF l_debug_level > 0 THEN
4225: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
4226: END IF;
4227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4228: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4229: END IF;