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

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

10: G_HEADER_CHANGED NUMBER; --- added for bug 6850537,7210480
11:
12: Function Lines_Remaining Return Varchar2
13: IS
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: BEGIN
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('In function Lines_Remaining',1);
18: oe_debug_pub.add('G_BLK_NAME' || G_BLK_NAME);

Line 17: oe_debug_pub.add('In function Lines_Remaining',1);

13: IS
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: BEGIN
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('In function Lines_Remaining',1);
18: oe_debug_pub.add('G_BLK_NAME' || G_BLK_NAME);
19: oe_debug_pub.add('G_NUM_OF_LINES' || G_NUM_OF_LINES);
20: END IF;
21:

Line 18: oe_debug_pub.add('G_BLK_NAME' || G_BLK_NAME);

14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: BEGIN
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('In function Lines_Remaining',1);
18: oe_debug_pub.add('G_BLK_NAME' || G_BLK_NAME);
19: oe_debug_pub.add('G_NUM_OF_LINES' || G_NUM_OF_LINES);
20: END IF;
21:
22: --Start Bug 6850537 ,7210480

Line 19: oe_debug_pub.add('G_NUM_OF_LINES' || G_NUM_OF_LINES);

15: BEGIN
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('In function Lines_Remaining',1);
18: oe_debug_pub.add('G_BLK_NAME' || G_BLK_NAME);
19: oe_debug_pub.add('G_NUM_OF_LINES' || G_NUM_OF_LINES);
20: END IF;
21:
22: --Start Bug 6850537 ,7210480
23:

Line 27: oe_debug_pub.ADD('NO more lines remains or header_id has changed');

23:
24: IF G_BLK_NAME = 'LINES_SUMMARY' THEN
25: IF G_NUM_OF_LINES = 0 OR G_HEADER_CHANGED =1 THEN
26: IF l_debug_level>0 THEN
27: oe_debug_pub.ADD('NO more lines remains or header_id has changed');
28: END IF;
29: RETURN('N');
30: ELSE
31: IF l_debug_level >0 THEN

Line 32: oe_debug_pub.ADD('There are some line remaining ');

28: END IF;
29: RETURN('N');
30: ELSE
31: IF l_debug_level >0 THEN
32: oe_debug_pub.ADD('There are some line remaining ');
33: END IF;
34: RETURN('Y');
35: END IF;
36: END IF;

Line 42: oe_debug_pub.add('No more lines remaining');

38:
39: IF G_BLK_NAME = 'LINE' THEN
40: IF G_NUM_OF_LINES = 0 THEN
41: IF l_debug_level > 0 THEN
42: oe_debug_pub.add('No more lines remaining');
43: END IF;
44: RETURN('N');
45: ELSE
46: IF l_debug_level > 0 THEN

Line 47: oe_debug_pub.add('There are some more lines remaining');

43: END IF;
44: RETURN('N');
45: ELSE
46: IF l_debug_level > 0 THEN
47: oe_debug_pub.add('There are some more lines remaining');
48: END IF;
49: RETURN('Y');
50: END IF;
51: ELSE

Line 931: OE_DEBUG_PUB.Add('return_status='||l_return_status);

927: );
928:
929:
930: p_return_status := l_return_status;
931: OE_DEBUG_PUB.Add('return_status='||l_return_status);
932: if l_return_status in(FND_API.G_RET_STS_ERROR,
933: FND_API.G_RET_STS_UNEXP_ERROR) then
934: ROLLBACK TO SAVEPOINT Process_Order_Scalar;
935: G_ERROR_COUNT := G_ERROR_COUNT + 1;

Line 944: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

940: ( p_count => p_msg_count,
941: p_data => p_msg_data
942: );
943: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
944: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
945: exit;
946: else
947: OE_DEBUG_PUB.Add('SKIP_ALL');
948: end if;

Line 947: OE_DEBUG_PUB.Add('SKIP_ALL');

943: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
944: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
945: exit;
946: else
947: OE_DEBUG_PUB.Add('SKIP_ALL');
948: end if;
949:
950: end if;
951: -- loop exception handling

Line 1055: oe_debug_pub.ADD('OEXVMSCB: Completed Process_Delayed_Requests '

1051: x_return_status => l_return_status
1052: );
1053:
1054: */
1055: oe_debug_pub.ADD('OEXVMSCB: Completed Process_Delayed_Requests '
1056: || ' with return status' || l_return_status, 1);
1057:
1058: oe_debug_pub.add('calling count and get to display errors');
1059:

Line 1058: oe_debug_pub.add('calling count and get to display errors');

1054: */
1055: oe_debug_pub.ADD('OEXVMSCB: Completed Process_Delayed_Requests '
1056: || ' with return status' || l_return_status, 1);
1057:
1058: oe_debug_pub.add('calling count and get to display errors');
1059:
1060: -- Bug 1809955
1061: -- Display any errors/messages that were caused
1062: -- as a result of the delayed request execution

Line 1075: oe_debug_pub.add('p_cascade_header_changes' || p_cascade_header_changes);

1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073:
1074:
1075: oe_debug_pub.add('p_cascade_header_changes' || p_cascade_header_changes);
1076: -- Begin of Cascade Header changes in Mass Change ER 7509356
1077: IF p_cascade_header_changes = 'Y' THEN
1078: --{
1079: oe_debug_pub.add('Just before calling cascade_header_attributes from process_order_scalar for header_id :' || l_header_rec.header_id);

Line 1079: oe_debug_pub.add('Just before calling cascade_header_attributes from process_order_scalar for header_id :' || l_header_rec.header_id);

1075: oe_debug_pub.add('p_cascade_header_changes' || p_cascade_header_changes);
1076: -- Begin of Cascade Header changes in Mass Change ER 7509356
1077: IF p_cascade_header_changes = 'Y' THEN
1078: --{
1079: oe_debug_pub.add('Just before calling cascade_header_attributes from process_order_scalar for header_id :' || l_header_rec.header_id);
1080:
1081: OE_OE_FORM_HEADER.CASCADE_HEADER_ATTRIBUTES
1082: (
1083: p_old_db_header_rec => l_old_header_rec

Line 1090: oe_debug_pub.add('return_status from cascade_header_attributes '|| l_return_status);

1086: ,x_msg_count => p_msg_count
1087: ,x_msg_data => p_msg_data
1088: );
1089:
1090: oe_debug_pub.add('return_status from cascade_header_attributes '|| l_return_status);
1091: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;

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

1518: l_arrival_set_id number;
1519: l_control_rec OE_GLOBALS.Control_Rec_Type;
1520: l_counter Integer := 0;
1521: l_current_org_id Number;
1522: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1523: l_error_count NUMBER := 0;
1524: l_header_id Number;
1525: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1526: l_line_id Number;

Line 1560: oe_debug_pub.add('Entering OE_MASS_CHANGE_PVT.Process_Line_Scalar');

1556:
1557:
1558: BEGIN
1559: IF l_debug_level > 0 THEN
1560: oe_debug_pub.add('Entering OE_MASS_CHANGE_PVT.Process_Line_Scalar');
1561: END IF;
1562:
1563: p_error_count := l_error_count;
1564:

Line 1572: oe_debug_pub.add(' block_name:'|| p_block_name);

1568: G_NUM_OF_LINES := p_num_of_records;
1569: END IF;
1570:
1571: IF l_debug_level > 0 THEN
1572: oe_debug_pub.add(' block_name:'|| p_block_name);
1573: oe_debug_pub.add(' num of records:'|| p_num_of_records);
1574: END IF;
1575: --bug4529937 end
1576:

Line 1573: oe_debug_pub.add(' num of records:'|| p_num_of_records);

1569: END IF;
1570:
1571: IF l_debug_level > 0 THEN
1572: oe_debug_pub.add(' block_name:'|| p_block_name);
1573: oe_debug_pub.add(' num of records:'|| p_num_of_records);
1574: END IF;
1575: --bug4529937 end
1576:
1577: IS_MASS_CHANGE := 'T'; --Added for bug 4911340

Line 1592: oe_debug_pub.add('Setting policy - ' || l_current_org_id);

1588: LOOP -- Outer loop
1589: -- Setting context whenever org_id changes.
1590: IF p_multi_ou AND l_current_org_id <> l_old_org_id THEN
1591: IF l_debug_level > 0 THEN
1592: oe_debug_pub.add('Setting policy - ' || l_current_org_id);
1593: END IF;
1594:
1595: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_current_org_id);
1596: END IF;

Line 1600: oe_debug_pub.add('l_rec - ' || l_rec);

1596: END IF;
1597:
1598: BEGIN
1599: IF l_debug_level > 0 THEN
1600: oe_debug_pub.add('l_rec - ' || l_rec);
1601: END IF;
1602:
1603: IF l_rec > 0 THEN
1604: l_init_msg_list := FND_API.G_FALSE;

Line 1629: oe_debug_pub.add('Line Id - ' || l_line_id);

1625:
1626: G_COUNTER := G_COUNTER + 1;
1627:
1628: IF l_debug_level > 0 THEN
1629: oe_debug_pub.add('Line Id - ' || l_line_id);
1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1631: oe_debug_pub.add('Header Id - ' || l_header_id);
1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);

Line 1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);

1626: G_COUNTER := G_COUNTER + 1;
1627:
1628: IF l_debug_level > 0 THEN
1629: oe_debug_pub.add('Line Id - ' || l_line_id);
1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1631: oe_debug_pub.add('Header Id - ' || l_header_id);
1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1634: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);

Line 1631: oe_debug_pub.add('Header Id - ' || l_header_id);

1627:
1628: IF l_debug_level > 0 THEN
1629: oe_debug_pub.add('Line Id - ' || l_line_id);
1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1631: oe_debug_pub.add('Header Id - ' || l_header_id);
1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1634: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1635: END IF;

Line 1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);

1628: IF l_debug_level > 0 THEN
1629: oe_debug_pub.add('Line Id - ' || l_line_id);
1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1631: oe_debug_pub.add('Header Id - ' || l_header_id);
1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1634: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1635: END IF;
1636:

Line 1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);

1629: oe_debug_pub.add('Line Id - ' || l_line_id);
1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1631: oe_debug_pub.add('Header Id - ' || l_header_id);
1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1634: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1635: END IF;
1636:
1637: l_old_header_id := l_header_id;

Line 1634: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);

1630: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1631: oe_debug_pub.add('Header Id - ' || l_header_id);
1632: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1633: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1634: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1635: END IF;
1636:
1637: l_old_header_id := l_header_id;
1638: l_old_arrival_set_id := l_arrival_set_id;

Line 1653: OE_DEBUG_PUB.Add('After Lock Row - ' || l_return_status);

1649: p_x_line_rec => l_x_line_rec,
1650: p_line_id => l_line_id );
1651:
1652: IF l_debug_level > 0 THEN
1653: OE_DEBUG_PUB.Add('After Lock Row - ' || l_return_status);
1654: END IF;
1655:
1656: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2760: oe_debug_pub.ADD('header id got changed'||l_header_id||' '||l_old_header_id);

2756:
2757: IF l_header_id <> l_old_header_id
2758: THEN
2759: IF l_debug_level>0 THEN
2760: oe_debug_pub.ADD('header id got changed'||l_header_id||' '||l_old_header_id);
2761: END IF;
2762: G_HEADER_CHANGED :=1;
2763:
2764: --Bug 7566697

Line 2807: oe_debug_pub.add('Lines Remaining: ' || G_NUM_OF_LINES);

2803: G_NUM_OF_LINES := G_NUM_OF_LINES - l_line_tbl.count;
2804: END IF;
2805:
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('Lines Remaining: ' || G_NUM_OF_LINES);
2808: OE_DEBUG_PUB.Add('Before Call to Process Order From MC');
2809: END IF;
2810: --bug4529937 end
2811:

Line 2808: OE_DEBUG_PUB.Add('Before Call to Process Order From MC');

2804: END IF;
2805:
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.add('Lines Remaining: ' || G_NUM_OF_LINES);
2808: OE_DEBUG_PUB.Add('Before Call to Process Order From MC');
2809: END IF;
2810: --bug4529937 end
2811:
2812: -- bug 4339639

Line 2824: OE_DEBUG_PUB.Add('After Call to Process Order From MC - ' || l_return_status);

2820: p_x_old_line_tbl => l_old_line_tbl,
2821: x_return_status => l_return_status);
2822:
2823: IF l_debug_level > 0 THEN
2824: OE_DEBUG_PUB.Add('After Call to Process Order From MC - ' || l_return_status);
2825: END IF;
2826:
2827: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2862: oe_debug_pub.ADD('OEXVMSCB: Completed Process_Delayed_Requests '

2858: p_old_line_tbl => l_old_line_tbl,
2859: p_line_tbl => l_line_tbl) ;
2860:
2861: IF l_debug_level > 0 THEN
2862: oe_debug_pub.ADD('OEXVMSCB: Completed Process_Delayed_Requests '
2863: || ' with return status' || l_return_status, 2);
2864: END IF;
2865: G_HEADER_CHANGED :=NULL ; -- - bug 6850537,7210480
2866: -- Bug 1809955

Line 2881: oe_debug_pub.ADD('Exception - FND_API.G_EXC_ERROR');

2877: EXCEPTION
2878:
2879: WHEN FND_API.G_EXC_ERROR THEN
2880: IF l_debug_level > 0 THEN
2881: oe_debug_pub.ADD('Exception - FND_API.G_EXC_ERROR');
2882: END IF;
2883:
2884: p_return_status := FND_API.G_RET_STS_ERROR ;
2885: OE_SET_UTIL.G_SET_TBL.delete; --bug#2428456

Line 2893: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '

2889:
2890: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
2891:
2892: IF l_debug_level > 0 THEN
2893: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '
2894: || OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT);
2895: END IF;
2896:
2897: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN -- moved for the bug 3726337

Line 2908: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);

2904: l_error_count := l_error_count + 1;
2905: p_error_count := l_error_count;
2906:
2907: IF l_debug_level > 0 THEN
2908: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);
2909: END IF;
2910:
2911: IF (l_line_tbl.count >0 ) then
2912: G_ERROR_COUNT := G_ERROR_COUNT + l_line_tbl.COUNT;

Line 2921: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');

2917: --Bug 7566697
2918: OE_Globals.G_PRICING_RECURSION := 'N';
2919: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
2920: THEN
2921: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
2922: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
2923: END IF;
2924:
2925: IF l_debug_level > 0 THEN

Line 2926: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);

2922: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
2923: END IF;
2924:
2925: IF l_debug_level > 0 THEN
2926: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
2927: END IF;
2928:
2929: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
2930: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

Line 2930: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

2926: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
2927: END IF;
2928:
2929: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
2930: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
2931: exit;
2932: else
2933: OE_DEBUG_PUB.Add('SKIP_ALL');
2934: end if;

Line 2933: OE_DEBUG_PUB.Add('SKIP_ALL');

2929: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
2930: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
2931: exit;
2932: else
2933: OE_DEBUG_PUB.Add('SKIP_ALL');
2934: end if;
2935:
2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: IF l_debug_level > 0 THEN

Line 2938: oe_debug_pub.ADD('Exception - FND_API.G_EXC_UNEXPECTED_ERROR');

2934: end if;
2935:
2936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2937: IF l_debug_level > 0 THEN
2938: oe_debug_pub.ADD('Exception - FND_API.G_EXC_UNEXPECTED_ERROR');
2939: END IF;
2940:
2941: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2942: OE_SET_UTIL.G_SET_TBL.delete; --bug#2428456

Line 2950: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '

2946:
2947: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
2948:
2949: IF l_debug_level > 0 THEN
2950: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '
2951: || OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT);
2952: END IF;
2953:
2954: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN -- moved for the bug 3726337

Line 2965: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);

2961: l_error_count := l_error_count + 1;
2962: p_error_count := l_error_count;
2963:
2964: IF l_debug_level > 0 THEN
2965: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);
2966: END IF;
2967:
2968: IF (l_line_tbl.count >0 ) then
2969: G_ERROR_COUNT := G_ERROR_COUNT + l_line_tbl.COUNT;

Line 2978: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');

2974: --Bug 7566697
2975: OE_Globals.G_PRICING_RECURSION := 'N';
2976: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
2977: THEN
2978: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
2979: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
2980: END IF;
2981:
2982: IF l_debug_level > 0 THEN

Line 2983: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);

2979: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
2980: END IF;
2981:
2982: IF l_debug_level > 0 THEN
2983: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
2984: END IF;
2985:
2986: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
2987: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

Line 2987: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

2983: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
2984: END IF;
2985:
2986: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
2987: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
2988: exit;
2989: else
2990: OE_DEBUG_PUB.Add('SKIP_ALL');
2991: end if;

Line 2990: OE_DEBUG_PUB.Add('SKIP_ALL');

2986: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
2987: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
2988: exit;
2989: else
2990: OE_DEBUG_PUB.Add('SKIP_ALL');
2991: end if;
2992:
2993: WHEN OTHERS THEN
2994: IF l_debug_level > 0 THEN

Line 2995: oe_debug_pub.ADD('Exception - FND_API.G_EXC_ERROR');

2991: end if;
2992:
2993: WHEN OTHERS THEN
2994: IF l_debug_level > 0 THEN
2995: oe_debug_pub.ADD('Exception - FND_API.G_EXC_ERROR');
2996: END IF;
2997:
2998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2999: OE_SET_UTIL.G_SET_TBL.delete; --bug#2428456

Line 3007: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '

3003:
3004: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
3005:
3006: IF l_debug_level > 0 THEN
3007: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '
3008: || OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT);
3009: END IF;
3010:
3011: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN -- moved for the bug 3726337

Line 3027: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);

3023: l_error_count := l_error_count + 1;
3024: p_error_count := l_error_count;
3025:
3026: IF l_debug_level > 0 THEN
3027: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);
3028: END IF;
3029:
3030: IF (l_line_tbl.count >0 ) then
3031: G_ERROR_COUNT := G_ERROR_COUNT + l_line_tbl.COUNT;

Line 3040: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');

3036: --Bug 7566697
3037: OE_Globals.G_PRICING_RECURSION := 'N';
3038: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3039: THEN
3040: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3041: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3042: END IF;
3043:
3044:

Line 3046: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);

3042: END IF;
3043:
3044:
3045: IF l_debug_level > 0 THEN
3046: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3047: END IF;
3048:
3049: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3050: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

Line 3050: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

3046: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3047: END IF;
3048:
3049: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3050: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3051: exit;
3052: else
3053: OE_DEBUG_PUB.Add('SKIP_ALL');
3054: end if;

Line 3053: OE_DEBUG_PUB.Add('SKIP_ALL');

3049: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3050: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3051: exit;
3052: else
3053: OE_DEBUG_PUB.Add('SKIP_ALL');
3054: end if;
3055: END;
3056:
3057: exit when c1%notfound;

Line 3066: oe_debug_pub.add('Exiting OE_MASS_CHANGE_PVT.Process_Line_Scalar');

3062: G_HEADER_CHANGED :=NULL ; -- - bug 6850537,7210480
3063: IS_MASS_CHANGE := 'F'; --Added for bug 4911340
3064:
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Exiting OE_MASS_CHANGE_PVT.Process_Line_Scalar');
3067: END IF;
3068: end Process_Line_Scalar;
3069:
3070: Procedure MC_Rollback

Line 3104: OE_DEBUG_PUB.ADD('Inside save_messages',1);

3100: Procedure save_messages
3101: IS
3102: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
3103: begin
3104: OE_DEBUG_PUB.ADD('Inside save_messages',1);
3105: FOR I IN 1..l_count_msg LOOP
3106: OE_DEBUG_PUB.ADD('calling insert_message',1);
3107: insert_message(I);
3108: End Loop;

Line 3106: OE_DEBUG_PUB.ADD('calling insert_message',1);

3102: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
3103: begin
3104: OE_DEBUG_PUB.ADD('Inside save_messages',1);
3105: FOR I IN 1..l_count_msg LOOP
3106: OE_DEBUG_PUB.ADD('calling insert_message',1);
3107: insert_message(I);
3108: End Loop;
3109: OE_DEBUG_PUB.ADD('exiting save_messages',1);
3110: commit;

Line 3109: OE_DEBUG_PUB.ADD('exiting save_messages',1);

3105: FOR I IN 1..l_count_msg LOOP
3106: OE_DEBUG_PUB.ADD('calling insert_message',1);
3107: insert_message(I);
3108: End Loop;
3109: OE_DEBUG_PUB.ADD('exiting save_messages',1);
3110: commit;
3111: end;
3112:
3113: procedure insert_message (

Line 3142: OE_DEBUG_PUB.ADd('l_msg_data='||l_msg_data);

3138: ,l_source_document_id
3139: ,l_source_document_line_id
3140: ,l_attribute_code);*/
3141:
3142: OE_DEBUG_PUB.ADd('l_msg_data='||l_msg_data);
3143:
3144: /*
3145: if p_msg_index IS NOT NULL then
3146: insert into OE_ERROR_MESSAGES