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 933: OE_DEBUG_PUB.Add('return_status='||l_return_status);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1526: l_arrival_set_id number;
1527: l_control_rec OE_GLOBALS.Control_Rec_Type;
1528: l_counter Integer := 0;
1529: l_current_org_id Number;
1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1531: l_error_count NUMBER := 0;
1532: l_header_id Number;
1533: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1534: l_line_id Number;

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

1564:
1565:
1566: BEGIN
1567: IF l_debug_level > 0 THEN
1568: oe_debug_pub.add('Entering OE_MASS_CHANGE_PVT.Process_Line_Scalar');
1569: END IF;
1570:
1571: p_error_count := l_error_count;
1572:

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

1576: G_NUM_OF_LINES := p_num_of_records;
1577: END IF;
1578:
1579: IF l_debug_level > 0 THEN
1580: oe_debug_pub.add(' block_name:'|| p_block_name);
1581: oe_debug_pub.add(' num of records:'|| p_num_of_records);
1582: END IF;
1583: --bug4529937 end
1584:

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

1577: END IF;
1578:
1579: IF l_debug_level > 0 THEN
1580: oe_debug_pub.add(' block_name:'|| p_block_name);
1581: oe_debug_pub.add(' num of records:'|| p_num_of_records);
1582: END IF;
1583: --bug4529937 end
1584:
1585: IS_MASS_CHANGE := 'T'; --Added for bug 4911340

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

1596: LOOP -- Outer loop
1597: -- Setting context whenever org_id changes.
1598: IF p_multi_ou AND l_current_org_id <> l_old_org_id THEN
1599: IF l_debug_level > 0 THEN
1600: oe_debug_pub.add('Setting policy - ' || l_current_org_id);
1601: END IF;
1602:
1603: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_current_org_id);
1604: END IF;

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

1604: END IF;
1605:
1606: BEGIN
1607: IF l_debug_level > 0 THEN
1608: oe_debug_pub.add('l_rec - ' || l_rec);
1609: END IF;
1610:
1611: IF l_rec > 0 THEN
1612: l_init_msg_list := FND_API.G_FALSE;

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

1633:
1634: G_COUNTER := G_COUNTER + 1;
1635:
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add('Line Id - ' || l_line_id);
1638: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1639: oe_debug_pub.add('Header Id - ' || l_header_id);
1640: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1641: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);

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

1634: G_COUNTER := G_COUNTER + 1;
1635:
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add('Line Id - ' || l_line_id);
1638: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1639: oe_debug_pub.add('Header Id - ' || l_header_id);
1640: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1641: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1642: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);

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

1635:
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add('Line Id - ' || l_line_id);
1638: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1639: oe_debug_pub.add('Header Id - ' || l_header_id);
1640: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1641: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1642: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1643: END IF;

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

1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add('Line Id - ' || l_line_id);
1638: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1639: oe_debug_pub.add('Header Id - ' || l_header_id);
1640: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1641: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1642: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1643: END IF;
1644:

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

1637: oe_debug_pub.add('Line Id - ' || l_line_id);
1638: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1639: oe_debug_pub.add('Header Id - ' || l_header_id);
1640: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1641: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1642: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1643: END IF;
1644:
1645: l_old_header_id := l_header_id;

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

1638: oe_debug_pub.add('Org Id - ' || l_current_org_id);
1639: oe_debug_pub.add('Header Id - ' || l_header_id);
1640: oe_debug_pub.add('Arrival Set Id - ' || l_arrival_set_id);
1641: oe_debug_pub.add('Ship Set Id - ' || l_ship_set_id);
1642: oe_debug_pub.add('Top Model Line Id - ' || l_top_model_line_id);
1643: END IF;
1644:
1645: l_old_header_id := l_header_id;
1646: l_old_arrival_set_id := l_arrival_set_id;

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

1657: p_x_line_rec => l_x_line_rec,
1658: p_line_id => l_line_id );
1659:
1660: IF l_debug_level > 0 THEN
1661: OE_DEBUG_PUB.Add('After Lock Row - ' || l_return_status);
1662: END IF;
1663:
1664: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1665: --Start of bug# 13067303

Line 1668: oe_debug_pub.add('another loop into inner loop, iteration'||'line id'||l_line_id);

1664: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1665: --Start of bug# 13067303
1666: loop
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('another loop into inner loop, iteration'||'line id'||l_line_id);
1669: END IF;
1670: fetch c1 into l_line_id, l_current_org_id, l_header_id, l_arrival_set_id,l_ship_set_id, l_top_model_line_id;
1671: exit when c1%notfound;
1672: IF l_debug_level > 0 THEN

Line 1673: oe_debug_pub.add('old arrival'||l_old_arrival_set_id||'old ship'||l_old_ship_set_id||'old top'||l_old_top_model_line_id);

1669: END IF;
1670: fetch c1 into l_line_id, l_current_org_id, l_header_id, l_arrival_set_id,l_ship_set_id, l_top_model_line_id;
1671: exit when c1%notfound;
1672: IF l_debug_level > 0 THEN
1673: oe_debug_pub.add('old arrival'||l_old_arrival_set_id||'old ship'||l_old_ship_set_id||'old top'||l_old_top_model_line_id);
1674: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);
1675: END IF;
1676: if ( l_old_arrival_set_id is null and l_old_ship_set_id is null and l_old_top_model_line_id is null ) then
1677: IF l_debug_level > 0 THEN

Line 1674: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);

1670: fetch c1 into l_line_id, l_current_org_id, l_header_id, l_arrival_set_id,l_ship_set_id, l_top_model_line_id;
1671: exit when c1%notfound;
1672: IF l_debug_level > 0 THEN
1673: oe_debug_pub.add('old arrival'||l_old_arrival_set_id||'old ship'||l_old_ship_set_id||'old top'||l_old_top_model_line_id);
1674: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);
1675: END IF;
1676: if ( l_old_arrival_set_id is null and l_old_ship_set_id is null and l_old_top_model_line_id is null ) then
1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add('all are null');

Line 1678: oe_debug_pub.add('all are null');

1674: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);
1675: END IF;
1676: if ( l_old_arrival_set_id is null and l_old_ship_set_id is null and l_old_top_model_line_id is null ) then
1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add('all are null');
1679: END IF;
1680: exit;
1681: end if;
1682:

Line 1690: oe_debug_pub.add('value changed');

1686: nvl(l_ship_set_id, 0) <> nvl(l_old_ship_set_id, 0) or
1687: nvl(l_top_model_line_id, 0) <> nvl(l_old_top_model_line_id, 0)
1688: then
1689: IF l_debug_level > 0 THEN
1690: oe_debug_pub.add('value changed');
1691: END IF;
1692: exit;
1693: end if;
1694: IF l_debug_level > 0 THEN

Line 1695: oe_debug_pub.add('after comparison ,assiging the new to old, going to next iteration, line_id:'||l_line_id);

1691: END IF;
1692: exit;
1693: end if;
1694: IF l_debug_level > 0 THEN
1695: oe_debug_pub.add('after comparison ,assiging the new to old, going to next iteration, line_id:'||l_line_id);
1696: END IF;
1697: l_old_header_id := l_header_id;
1698: l_old_arrival_set_id := l_arrival_set_id;
1699: l_old_ship_set_id := l_ship_set_id;

Line 1712: oe_debug_pub.add('another loop into inner loop, iteration'||'line id'||l_line_id);

1708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1709: --bug# 13067303
1710: loop
1711: IF l_debug_level > 0 THEN
1712: oe_debug_pub.add('another loop into inner loop, iteration'||'line id'||l_line_id);
1713: END IF;
1714: fetch c1 into l_line_id, l_current_org_id, l_header_id, l_arrival_set_id,l_ship_set_id, l_top_model_line_id;
1715: exit when c1%notfound;
1716: IF l_debug_level > 0 THEN

Line 1717: oe_debug_pub.add('old arrival'||l_old_arrival_set_id||'old ship'||l_old_ship_set_id||'old top'||l_old_top_model_line_id);

1713: END IF;
1714: fetch c1 into l_line_id, l_current_org_id, l_header_id, l_arrival_set_id,l_ship_set_id, l_top_model_line_id;
1715: exit when c1%notfound;
1716: IF l_debug_level > 0 THEN
1717: oe_debug_pub.add('old arrival'||l_old_arrival_set_id||'old ship'||l_old_ship_set_id||'old top'||l_old_top_model_line_id);
1718: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);
1719: END IF;
1720: if ( l_old_arrival_set_id is null and l_old_ship_set_id is null and l_old_top_model_line_id is null ) then
1721: IF l_debug_level > 0 THEN

Line 1718: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);

1714: fetch c1 into l_line_id, l_current_org_id, l_header_id, l_arrival_set_id,l_ship_set_id, l_top_model_line_id;
1715: exit when c1%notfound;
1716: IF l_debug_level > 0 THEN
1717: oe_debug_pub.add('old arrival'||l_old_arrival_set_id||'old ship'||l_old_ship_set_id||'old top'||l_old_top_model_line_id);
1718: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);
1719: END IF;
1720: if ( l_old_arrival_set_id is null and l_old_ship_set_id is null and l_old_top_model_line_id is null ) then
1721: IF l_debug_level > 0 THEN
1722: oe_debug_pub.add('all are null');

Line 1722: oe_debug_pub.add('all are null');

1718: oe_debug_pub.add('header'||l_header_id||'line'||l_line_id||'arrival'||l_arrival_set_id||'ship'||l_ship_set_id||'l_top_model_line_id'||l_top_model_line_id);
1719: END IF;
1720: if ( l_old_arrival_set_id is null and l_old_ship_set_id is null and l_old_top_model_line_id is null ) then
1721: IF l_debug_level > 0 THEN
1722: oe_debug_pub.add('all are null');
1723: END IF;
1724: exit;
1725: end if;
1726:

Line 1734: oe_debug_pub.add('value changed');

1730: nvl(l_ship_set_id, 0) <> nvl(l_old_ship_set_id, 0) or
1731: nvl(l_top_model_line_id, 0) <> nvl(l_old_top_model_line_id, 0)
1732: then
1733: IF l_debug_level > 0 THEN
1734: oe_debug_pub.add('value changed');
1735: END IF;
1736: exit;
1737: end if;
1738: IF l_debug_level > 0 THEN

Line 1739: oe_debug_pub.add('after comparison ,assiging the new to old, going to next iteration, line_id:'||l_line_id);

1735: END IF;
1736: exit;
1737: end if;
1738: IF l_debug_level > 0 THEN
1739: oe_debug_pub.add('after comparison ,assiging the new to old, going to next iteration, line_id:'||l_line_id);
1740: END IF;
1741: l_old_header_id := l_header_id;
1742: l_old_arrival_set_id := l_arrival_set_id;
1743: l_old_ship_set_id := l_ship_set_id;

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

2872:
2873: IF l_header_id <> l_old_header_id
2874: THEN
2875: IF l_debug_level>0 THEN
2876: oe_debug_pub.ADD('header id got changed'||l_header_id||' '||l_old_header_id);
2877: END IF;
2878: G_HEADER_CHANGED :=1;
2879:
2880: --Bug 7566697

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

2919: G_NUM_OF_LINES := G_NUM_OF_LINES - l_line_tbl.count;
2920: END IF;
2921:
2922: IF l_debug_level > 0 THEN
2923: oe_debug_pub.add('Lines Remaining: ' || G_NUM_OF_LINES);
2924: OE_DEBUG_PUB.Add('Before Call to Process Order From MC');
2925: END IF;
2926: --bug4529937 end
2927:

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

2920: END IF;
2921:
2922: IF l_debug_level > 0 THEN
2923: oe_debug_pub.add('Lines Remaining: ' || G_NUM_OF_LINES);
2924: OE_DEBUG_PUB.Add('Before Call to Process Order From MC');
2925: END IF;
2926: --bug4529937 end
2927:
2928: -- bug 4339639

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

2936: p_x_old_line_tbl => l_old_line_tbl,
2937: x_return_status => l_return_status);
2938:
2939: IF l_debug_level > 0 THEN
2940: OE_DEBUG_PUB.Add('After Call to Process Order From MC - ' || l_return_status);
2941: END IF;
2942:
2943: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2974: p_old_line_tbl => l_old_line_tbl,
2975: p_line_tbl => l_line_tbl) ;
2976:
2977: IF l_debug_level > 0 THEN
2978: oe_debug_pub.ADD('OEXVMSCB: Completed Process_Delayed_Requests '
2979: || ' with return status' || l_return_status, 2);
2980: END IF;
2981: G_HEADER_CHANGED :=NULL ; -- - bug 6850537,7210480
2982: -- Bug 1809955

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

2993: EXCEPTION
2994:
2995: WHEN FND_API.G_EXC_ERROR THEN
2996: IF l_debug_level > 0 THEN
2997: oe_debug_pub.ADD('Exception - FND_API.G_EXC_ERROR');
2998: END IF;
2999:
3000: p_return_status := FND_API.G_RET_STS_ERROR ;
3001: OE_SET_UTIL.G_SET_TBL.delete; --bug#2428456

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

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

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

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

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

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

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

3038: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3039: END IF;
3040:
3041: IF l_debug_level > 0 THEN
3042: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3043: END IF;
3044:
3045: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3046: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

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

3042: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3043: END IF;
3044:
3045: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3046: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3047: exit;
3048: else
3049: OE_DEBUG_PUB.Add('SKIP_ALL');
3050: end if;

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

3045: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3046: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3047: exit;
3048: else
3049: OE_DEBUG_PUB.Add('SKIP_ALL');
3050: end if;
3051:
3052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3053: IF l_debug_level > 0 THEN

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

3050: end if;
3051:
3052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3053: IF l_debug_level > 0 THEN
3054: oe_debug_pub.ADD('Exception - FND_API.G_EXC_UNEXPECTED_ERROR');
3055: END IF;
3056:
3057: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3058: OE_SET_UTIL.G_SET_TBL.delete; --bug#2428456

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

3062:
3063: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
3064:
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '
3067: || OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT);
3068: END IF;
3069:
3070: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN -- moved for the bug 3726337

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

3077: l_error_count := l_error_count + 1;
3078: p_error_count := l_error_count;
3079:
3080: IF l_debug_level > 0 THEN
3081: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);
3082: END IF;
3083:
3084: IF (l_line_tbl.count >0 ) then
3085: G_ERROR_COUNT := G_ERROR_COUNT + l_line_tbl.COUNT;

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

3090: --Bug 7566697
3091: OE_Globals.G_PRICING_RECURSION := 'N';
3092: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3093: THEN
3094: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3095: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3096: END IF;
3097:
3098: IF l_debug_level > 0 THEN

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

3095: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3096: END IF;
3097:
3098: IF l_debug_level > 0 THEN
3099: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3100: END IF;
3101:
3102: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3103: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

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

3099: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3100: END IF;
3101:
3102: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3103: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3104: exit;
3105: else
3106: OE_DEBUG_PUB.Add('SKIP_ALL');
3107: end if;

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

3102: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3103: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3104: exit;
3105: else
3106: OE_DEBUG_PUB.Add('SKIP_ALL');
3107: end if;
3108:
3109: WHEN OTHERS THEN
3110: IF l_debug_level > 0 THEN

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

3107: end if;
3108:
3109: WHEN OTHERS THEN
3110: IF l_debug_level > 0 THEN
3111: oe_debug_pub.ADD('Exception - FND_API.G_EXC_ERROR');
3112: END IF;
3113:
3114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115: OE_SET_UTIL.G_SET_TBL.delete; --bug#2428456

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

3119:
3120: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
3121:
3122: IF l_debug_level > 0 THEN
3123: oe_debug_pub.ADD ('OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT - '
3124: || OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT);
3125: END IF;
3126:
3127: IF OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.COUNT > 0 THEN -- moved for the bug 3726337

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

3139: l_error_count := l_error_count + 1;
3140: p_error_count := l_error_count;
3141:
3142: IF l_debug_level > 0 THEN
3143: oe_debug_pub.ADD ('l_line_tbl.count - ' || l_line_tbl.count);
3144: END IF;
3145:
3146: IF (l_line_tbl.count >0 ) then
3147: G_ERROR_COUNT := G_ERROR_COUNT + l_line_tbl.COUNT;

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

3152: --Bug 7566697
3153: OE_Globals.G_PRICING_RECURSION := 'N';
3154: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3155: THEN
3156: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3157: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3158: END IF;
3159:
3160:

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

3158: END IF;
3159:
3160:
3161: IF l_debug_level > 0 THEN
3162: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3163: END IF;
3164:
3165: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3166: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');

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

3162: oe_debug_pub.ADD ('l_mc_err_handling_flag - ' || l_mc_err_handling_flag);
3163: END IF;
3164:
3165: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3166: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3167: exit;
3168: else
3169: OE_DEBUG_PUB.Add('SKIP_ALL');
3170: end if;

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

3165: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
3166: OE_DEBUG_PUB.Add('EXIT_FIRST_ERROR SKIP_CONTINUE');
3167: exit;
3168: else
3169: OE_DEBUG_PUB.Add('SKIP_ALL');
3170: end if;
3171: END;
3172:
3173: exit when c1%notfound;

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

3178: G_HEADER_CHANGED :=NULL ; -- - bug 6850537,7210480
3179: IS_MASS_CHANGE := 'F'; --Added for bug 4911340
3180:
3181: IF l_debug_level > 0 THEN
3182: oe_debug_pub.add('Exiting OE_MASS_CHANGE_PVT.Process_Line_Scalar');
3183: END IF;
3184: end Process_Line_Scalar;
3185:
3186: Procedure MC_Rollback

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

3216: Procedure save_messages
3217: IS
3218: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
3219: begin
3220: OE_DEBUG_PUB.ADD('Inside save_messages',1);
3221: FOR I IN 1..l_count_msg LOOP
3222: OE_DEBUG_PUB.ADD('calling insert_message',1);
3223: insert_message(I);
3224: End Loop;

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

3218: l_count_msg NUMBER := OE_MSG_PUB.Count_Msg;
3219: begin
3220: OE_DEBUG_PUB.ADD('Inside save_messages',1);
3221: FOR I IN 1..l_count_msg LOOP
3222: OE_DEBUG_PUB.ADD('calling insert_message',1);
3223: insert_message(I);
3224: End Loop;
3225: OE_DEBUG_PUB.ADD('exiting save_messages',1);
3226: commit;

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

3221: FOR I IN 1..l_count_msg LOOP
3222: OE_DEBUG_PUB.ADD('calling insert_message',1);
3223: insert_message(I);
3224: End Loop;
3225: OE_DEBUG_PUB.ADD('exiting save_messages',1);
3226: commit;
3227: end;
3228:
3229: procedure insert_message (

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

3254: ,l_source_document_id
3255: ,l_source_document_line_id
3256: ,l_attribute_code);*/
3257:
3258: OE_DEBUG_PUB.ADd('l_msg_data='||l_msg_data);
3259:
3260: /*
3261: if p_msg_index IS NOT NULL then
3262: insert into OE_ERROR_MESSAGES