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 FND_API

Line 78: , p_mc_err_handling_flag IN NUMBER DEFAULT FND_API.G_MISS_NUM

74: , p_change_comments IN VARCHAR2
75: , p_msg_count OUT NOCOPY NUMBER
76: , p_msg_data OUT NOCOPY VARCHAR2
77: , p_return_status OUT NOCOPY VARCHAR2
78: , p_mc_err_handling_flag IN NUMBER DEFAULT FND_API.G_MISS_NUM
79: , p_error_count OUT NOCOPY NUMBER
80: , p_accounting_rule_id IN NUMBER
81: , p_accounting_rule_duration IN NUMBER
82: , p_agreement_id IN NUMBER

Line 341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

337: ( x_return_status => l_return_status
338: , p_x_header_rec => l_x_header_rec
339: , p_header_id => l_header_id);
340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338: , p_x_header_rec => l_x_header_rec
339: , p_header_id => l_header_id);
340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:

Line 343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

339: , p_header_id => l_header_id);
340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347:

Line 344: RAISE FND_API.G_EXC_ERROR;

340:
341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347:
348:

Line 923: p_validation_level => FND_API.G_VALID_LEVEL_FULL

919: --End of bug 4882981
920:
921: Oe_Order_Pvt.Header
922: (
923: p_validation_level => FND_API.G_VALID_LEVEL_FULL
924: , p_init_msg_list => l_init_msg_list
925: , p_control_rec => l_control_rec
926: , p_x_header_rec => l_header_rec
927: , p_x_old_header_rec => l_old_header_rec

Line 934: if l_return_status in(FND_API.G_RET_STS_ERROR,

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;
938:

Line 935: FND_API.G_RET_STS_UNEXP_ERROR) then

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;
938:
939: l_error_count := l_error_count + 1;

Line 955: WHEN FND_API.G_EXC_ERROR THEN

951:
952: end if;
953: -- loop exception handling
954: Exception
955: WHEN FND_API.G_EXC_ERROR THEN
956: p_return_status := FND_API.G_RET_STS_ERROR ;
957: OE_MSG_PUB.Count_And_Get
958: ( p_count => p_msg_count,
959: p_data => p_msg_data

Line 956: p_return_status := FND_API.G_RET_STS_ERROR ;

952: end if;
953: -- loop exception handling
954: Exception
955: WHEN FND_API.G_EXC_ERROR THEN
956: p_return_status := FND_API.G_RET_STS_ERROR ;
957: OE_MSG_PUB.Count_And_Get
958: ( p_count => p_msg_count,
959: p_data => p_msg_data
960: );

Line 971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

967: if l_mc_err_handling_flag in (EXIT_FIRST_ERROR,SKIP_CONTINUE) then
968: exit;
969: end if;
970:
971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
973: OE_MSG_PUB.Count_And_Get
974: ( p_count => p_msg_count,
975: p_data => p_msg_data

Line 972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

968: exit;
969: end if;
970:
971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
973: OE_MSG_PUB.Count_And_Get
974: ( p_count => p_msg_count,
975: p_data => p_msg_data
976: );

Line 989: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

985: end if;
986:
987:
988: WHEN OTHERS THEN
989: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
990: IF OE_MSG_PUB.Check_Msg_Level
991: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: OE_MSG_PUB.Add_Exc_Msg

Line 1014: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

1010: END;
1011:
1012: --End LOOP; /* end of FOR loop */
1013: -- moved execution of delayed request inside the for loop for bug 4882981
1014: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
1015: --{ SUCCESS from OE_ORDER_PVT.Header
1016: BEGIN
1017: -- call to post_line_process is not needed for headers mass change
1018: /*

Line 1070: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1066: p_count => p_msg_count,
1067: p_data => p_msg_data
1068: );
1069:
1070: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1067: p_data => p_msg_data
1068: );
1069:
1070: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075:

Line 1072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1068: );
1069:
1070: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075:
1076:

Line 1073: RAISE FND_API.G_EXC_ERROR;

1069:
1070: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
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);

Line 1093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
1097: END IF;

Line 1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1097: END IF;
1098: --}

Line 1095: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
1097: END IF;
1098: --}
1099: END IF;

Line 1096: RAISE FND_API.G_EXC_ERROR;

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;
1097: END IF;
1098: --}
1099: END IF;
1100: -- End of Cascade Header changes in Mass Change ER 7509356

Line 1105: WHEN FND_API.G_EXC_ERROR THEN

1101:
1102:
1103:
1104: EXCEPTION
1105: WHEN FND_API.G_EXC_ERROR THEN
1106: l_error_count := l_error_count + 1;
1107: p_error_count := l_error_count;
1108: p_return_status := FND_API.G_RET_STS_ERROR ;
1109: OE_MSG_PUB.Count_And_Get

Line 1108: p_return_status := FND_API.G_RET_STS_ERROR ;

1104: EXCEPTION
1105: WHEN FND_API.G_EXC_ERROR THEN
1106: l_error_count := l_error_count + 1;
1107: p_error_count := l_error_count;
1108: p_return_status := FND_API.G_RET_STS_ERROR ;
1109: OE_MSG_PUB.Count_And_Get
1110: ( p_count => p_msg_count,
1111: p_data => p_msg_data
1112: );

Line 1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1116: G_ERROR_COUNT := G_ERROR_COUNT + 1;
1117: ROLLBACK TO SAVEPOINT Process_Order_Scalar;
1118:
1119:
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: l_error_count := l_error_count + 1;
1122: p_error_count := l_error_count;
1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: OE_MSG_PUB.Count_And_Get

Line 1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1119:
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: l_error_count := l_error_count + 1;
1122: p_error_count := l_error_count;
1123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: OE_MSG_PUB.Count_And_Get
1125: ( p_count => p_msg_count,
1126: p_data => p_msg_data
1127: );

Line 1137: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1133:
1134: WHEN OTHERS THEN
1135: l_error_count := l_error_count + 1;
1136: p_error_count := l_error_count;
1137: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1138: IF OE_MSG_PUB.Check_Msg_Level
1139: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1140: THEN
1141: OE_MSG_PUB.Add_Exc_Msg

Line 1177: , p_mc_err_handling_flag IN NUMBER := FND_API.G_MISS_NUM

1173: , p_change_comments IN VARCHAR2
1174: , p_msg_count OUT NOCOPY NUMBER
1175: , p_msg_data OUT NOCOPY VARCHAR2
1176: , p_return_status OUT NOCOPY VARCHAR2
1177: , p_mc_err_handling_flag IN NUMBER := FND_API.G_MISS_NUM
1178: , p_error_count OUT NOCOPY NUMBER
1179: , p_header_id IN NUMBER
1180: , p_accounting_rule_id IN NUMBER
1181: , p_accounting_rule_duration IN NUMBER

Line 1533: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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;
1535: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1536: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag;
1537: l_num_of_records NUMBER;

Line 1612: l_init_msg_list := FND_API.G_FALSE;

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;
1613: END IF;
1614:
1615: --Bug 7566697
1616: --Will be creating new savepoint only if the header has changed

Line 1664: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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
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);

Line 1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1703: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;
1704: l_line_tbl(l_rec).line_id := l_line_id;
1705: G_COUNTER := G_COUNTER + 1;
1706: end loop; --bug# 13067303
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1709: --bug# 13067303
1710: loop
1711: IF l_debug_level > 0 THEN

Line 1708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1704: l_line_tbl(l_rec).line_id := l_line_id;
1705: G_COUNTER := G_COUNTER + 1;
1706: end loop; --bug# 13067303
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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);

Line 1751: RAISE FND_API.G_EXC_ERROR;

1747: l_line_tbl(l_rec) := OE_ORDER_PUB.G_MISS_LINE_REC;
1748: l_line_tbl(l_rec).line_id := l_line_id;
1749: G_COUNTER := G_COUNTER + 1;
1750: end loop; --End of bug# 13067303
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753:
1754: l_line_tbl(l_rec).operation := OE_GLOBALS.G_OPR_UPDATE;
1755:

Line 2932: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2928: -- bug 4339639
2929: OE_Versioning_Util.G_UI_CALLED := TRUE;
2930:
2931: Oe_Order_Pvt.Lines
2932: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2933: p_init_msg_list => l_init_msg_list,
2934: p_control_rec => l_control_rec,
2935: p_x_line_tbl => l_line_tbl,
2936: p_x_old_line_tbl => l_old_line_tbl,

Line 2943: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
2945: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: END IF;

Line 2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2945: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: END IF;
2948:

Line 2945: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
2945: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: END IF;
2948:
2949: l_control_rec.controlled_operation := TRUE;

Line 2946: RAISE FND_API.G_EXC_ERROR;

2942:
2943: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2945: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2946: RAISE FND_API.G_EXC_ERROR;
2947: END IF;
2948:
2949: l_control_rec.controlled_operation := TRUE;
2950: l_control_rec.process := TRUE;

Line 2988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2984: -- as a result of the delayed request execution
2985: OE_MSG_PUB.Count_and_Get(p_count => p_msg_count,
2986: p_data => p_msg_data);
2987:
2988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;

Line 2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2985: OE_MSG_PUB.Count_and_Get(p_count => p_msg_count,
2986: p_data => p_msg_data);
2987:
2988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;
2993: EXCEPTION

Line 2990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2986: p_data => p_msg_data);
2987:
2988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;
2993: EXCEPTION
2994:

Line 2991: RAISE FND_API.G_EXC_ERROR;

2987:
2988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;
2993: EXCEPTION
2994:
2995: WHEN FND_API.G_EXC_ERROR THEN

Line 2995: WHEN FND_API.G_EXC_ERROR THEN

2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;
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:

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 3000: p_return_status := FND_API.G_RET_STS_ERROR ;

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
3002: OE_SET_UTIL.G_SET_OPT_TBL.delete; -- bug#2428456
3003:
3004: oe_delayed_requests_pvt.Clear_Request(x_return_status=> l_return_status);

Line 3052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
3054: oe_debug_pub.ADD('Exception - FND_API.G_EXC_UNEXPECTED_ERROR');
3055: END IF;
3056:

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 3057: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
3059: OE_SET_UTIL.G_SET_OPT_TBL.delete; -- bug#2428456
3060:
3061: oe_delayed_requests_pvt.Clear_Request(x_return_status=> l_return_status);

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 3114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
3116: OE_SET_UTIL.G_SET_OPT_TBL.delete; -- bug#2428456
3117:
3118: oe_delayed_requests_pvt.Clear_Request(x_return_status=> l_return_status);