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_OE_FORM_HEADER dependencies on FND_API

Line 170: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE

166:
167: -- Call Oe_Order_Pvt.Header
168:
169: Oe_Order_Pvt.Header
170: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE
171: , p_init_msg_list => FND_API.G_TRUE
172: , p_control_rec =>l_control_rec
173: , p_x_header_rec =>x_header_rec
174: , p_x_old_header_rec =>x_old_header_rec

Line 171: , p_init_msg_list => FND_API.G_TRUE

167: -- Call Oe_Order_Pvt.Header
168:
169: Oe_Order_Pvt.Header
170: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE
171: , p_init_msg_list => FND_API.G_TRUE
172: , p_control_rec =>l_control_rec
173: , p_x_header_rec =>x_header_rec
174: , p_x_old_header_rec =>x_old_header_rec
175: , x_return_status =>l_return_status

Line 179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

175: , x_return_status =>l_return_status
176:
177: );
178:
179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176:
177: );
178:
179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:

Line 181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

177: );
178:
179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185:

Line 182: RAISE FND_API.G_EXC_ERROR;

178:
179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185:
186: -- Load OUT NOCOPY /* file.sql.39 change */ parameters.

Line 195: x_header_rec.db_flag := FND_API.G_FALSE;

191:
192: -- Write to cache.
193: -- Set db_flag to False before writing to cache
194:
195: x_header_rec.db_flag := FND_API.G_FALSE;
196:
197: Write_header
198: ( p_header_rec => x_header_rec
199: );

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: OE_GLOBALS.G_UI_FLAG := FALSE;
203:
204: -- Set return status.
205:
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: -- Get message count and data
209:
210: OE_MSG_PUB.Count_And_Get

Line 219: WHEN FND_API.G_EXC_ERROR THEN

215: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);
216:
217: EXCEPTION
218:
219: WHEN FND_API.G_EXC_ERROR THEN
220:
221: OE_GLOBALS.G_UI_FLAG := FALSE;
222:
223: x_return_status := FND_API.G_RET_STS_ERROR;

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: WHEN FND_API.G_EXC_ERROR THEN
220:
221: OE_GLOBALS.G_UI_FLAG := FALSE;
222:
223: x_return_status := FND_API.G_RET_STS_ERROR;
224:
225: -- Get message count and data
226:
227: OE_MSG_PUB.Count_And_Get

Line 232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

228: ( p_count => x_msg_count
229: , p_data => x_msg_data
230: );
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233:
234: OE_GLOBALS.G_UI_FLAG := FALSE;
235:
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233:
234: OE_GLOBALS.G_UI_FLAG := FALSE;
235:
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237:
238: -- Get message count and data
239:
240: OE_MSG_PUB.Count_And_Get

Line 249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

245: WHEN OTHERS THEN
246:
247: OE_GLOBALS.G_UI_FLAG := FALSE;
248:
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
250:
251: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: OE_MSG_PUB.Add_Exc_Msg

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: , 'Unrecognized attribute'
723: );
724: END IF;
725:
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727:
728: END IF;
729:
730: -- Set Operation.

Line 732: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN

728: END IF;
729:
730: -- Set Operation.
731:
732: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN
733: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
734: ELSE
735: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
736: END IF;

Line 746: p_validation_level => FND_API.G_VALID_LEVEL_NONE

742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header
745: (
746: p_validation_level => FND_API.G_VALID_LEVEL_NONE
747: , p_init_msg_list => FND_API.G_TRUE
748: , p_control_rec => l_control_rec
749: , p_x_header_rec => x_header_rec
750: , p_x_old_header_rec => x_old_header_rec

Line 747: , p_init_msg_list => FND_API.G_TRUE

743:
744: Oe_Order_Pvt.Header
745: (
746: p_validation_level => FND_API.G_VALID_LEVEL_NONE
747: , p_init_msg_list => FND_API.G_TRUE
748: , p_control_rec => l_control_rec
749: , p_x_header_rec => x_header_rec
750: , p_x_old_header_rec => x_old_header_rec
751: , x_return_status => l_return_status

Line 758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;

Line 759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:

Line 760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:
764:

Line 761: RAISE FND_API.G_EXC_ERROR;

757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763:
764:
765: -- Init OUT NOCOPY parameters to missing.

Line 808: x_return_status := FND_API.G_RET_STS_SUCCESS;

804: OE_GLOBALS.G_UI_FLAG := FALSE;
805:
806: -- Set return status.
807:
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: -- Get message count and data
811:
812: OE_MSG_PUB.Count_And_Get

Line 821: WHEN FND_API.G_EXC_ERROR THEN

817: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
818:
819: EXCEPTION
820:
821: WHEN FND_API.G_EXC_ERROR THEN
822:
823: OE_GLOBALS.G_UI_FLAG := FALSE;
824:
825: x_return_status := FND_API.G_RET_STS_ERROR;

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: WHEN FND_API.G_EXC_ERROR THEN
822:
823: OE_GLOBALS.G_UI_FLAG := FALSE;
824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: -- Get message count and data
828:
829: OE_MSG_PUB.Count_And_Get

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: ( p_count => x_msg_count
831: , p_data => x_msg_data
832: );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835:
836: OE_GLOBALS.G_UI_FLAG := FALSE;
837:
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835:
836: OE_GLOBALS.G_UI_FLAG := FALSE;
837:
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839:
840: -- Get message count and data
841:
842: OE_MSG_PUB.Count_And_Get

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

847: WHEN OTHERS THEN
848:
849: OE_GLOBALS.G_UI_FLAG := FALSE;
850:
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852:
853: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: OE_MSG_PUB.Add_Exc_Msg

Line 950: IF FND_API.To_Boolean(l_x_header_rec.db_flag) THEN

946: /* End Audit Trail */
947:
948: -- Set Operation.
949:
950: IF FND_API.To_Boolean(l_x_header_rec.db_flag) THEN
951: l_x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
952: ELSE
953: l_x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
954: END IF;

Line 959: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

955:
956: -- Call Oe_Order_Pvt.Header
957:
958: Oe_Order_Pvt.Header
959: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
960: , p_init_msg_list => FND_API.G_TRUE
961: , p_control_rec => l_control_rec
962: , p_x_header_rec => l_x_header_rec
963: , p_x_old_header_rec => l_x_old_header_rec

Line 960: , p_init_msg_list => FND_API.G_TRUE

956: -- Call Oe_Order_Pvt.Header
957:
958: Oe_Order_Pvt.Header
959: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
960: , p_init_msg_list => FND_API.G_TRUE
961: , p_control_rec => l_control_rec
962: , p_x_header_rec => l_x_header_rec
963: , p_x_old_header_rec => l_x_old_header_rec
964: , x_return_status => l_return_status

Line 968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

964: , x_return_status => l_return_status
965: );
966:
967:
968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

965: );
966:
967:
968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973:

Line 970: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

966:
967:
968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973:
974: /* The Process Requests and Notify should be invoked for */

Line 971: RAISE FND_API.G_EXC_ERROR;

967:
968: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973:
974: /* The Process Requests and Notify should be invoked for */
975: /* Pre-Pack H code level */

Line 981: , p_init_msg_list => FND_API.G_FALSE

977: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
978:
979: Oe_Order_Pvt.Process_Requests_And_Notify
980: ( p_process_requests => FALSE
981: , p_init_msg_list => FND_API.G_FALSE
982: , p_notify => TRUE
983: , x_return_status => l_return_status
984: , p_header_rec => l_x_header_rec
985: , p_old_header_rec => l_x_old_header_rec

Line 988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

984: , p_header_rec => l_x_header_rec
985: , p_old_header_rec => l_x_old_header_rec
986: );
987:
988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;

Line 989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

985: , p_old_header_rec => l_x_old_header_rec
986: );
987:
988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:

Line 990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

986: );
987:
988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994: END IF; /* code release level check */

Line 991: RAISE FND_API.G_EXC_ERROR;

987:
988: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994: END IF; /* code release level check */
995:

Line 1044: x_return_status := FND_API.G_RET_STS_SUCCESS;

1040: OE_GLOBALS.G_UI_FLAG := FALSE;
1041:
1042: -- Set return status.
1043:
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046: -- Get message count and data
1047:
1048: OE_MSG_PUB.Count_And_Get

Line 1057: WHEN FND_API.G_EXC_ERROR THEN

1053: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);
1054:
1055: EXCEPTION
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN
1058:
1059: OE_GLOBALS.G_UI_FLAG := FALSE;
1060: IF Nvl(OE_HEADER_UTIL.g_rollback_done,'N') <> 'Y' THEN -- bug 12759791
1061: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060: IF Nvl(OE_HEADER_UTIL.g_rollback_done,'N') <> 'Y' THEN -- bug 12759791
1061: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
1062: END IF;
1063:
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065:
1066: -- Get message count and data
1067:
1068: OE_MSG_PUB.Count_And_Get

Line 1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1069: ( p_count => x_msg_count
1070: , p_data => x_msg_data
1071: );
1072:
1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1074:
1075: OE_GLOBALS.G_UI_FLAG := FALSE;
1076:
1077: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;

Line 1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1075: OE_GLOBALS.G_UI_FLAG := FALSE;
1076:
1077: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
1078:
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1080:
1081: -- Get message count and data
1082:
1083: OE_MSG_PUB.Count_And_Get

Line 1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1090: OE_GLOBALS.G_UI_FLAG := FALSE;
1091:
1092: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
1093:
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1097: THEN
1098: OE_MSG_PUB.Add_Exc_Msg

Line 1166: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1162:
1163: -- Call Oe_Order_Pvt.Header
1164:
1165: Oe_Order_Pvt.Header
1166: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1167: , p_init_msg_list => FND_API.G_TRUE
1168: , p_control_rec => l_control_rec
1169: , p_x_header_rec => l_x_header_rec
1170: , p_x_old_header_rec => l_x_old_header_rec

Line 1167: , p_init_msg_list => FND_API.G_TRUE

1163: -- Call Oe_Order_Pvt.Header
1164:
1165: Oe_Order_Pvt.Header
1166: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1167: , p_init_msg_list => FND_API.G_TRUE
1168: , p_control_rec => l_control_rec
1169: , p_x_header_rec => l_x_header_rec
1170: , p_x_old_header_rec => l_x_old_header_rec
1171: , x_return_status => l_return_status

Line 1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1170: , p_x_old_header_rec => l_x_old_header_rec
1171: , x_return_status => l_return_status
1172: );
1173:
1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: , x_return_status => l_return_status
1172: );
1173:
1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:

Line 1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1172: );
1173:
1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1180:

Line 1177: RAISE FND_API.G_EXC_ERROR;

1173:
1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1180:
1181: -- Clear header record cache

Line 1190: x_return_status := FND_API.G_RET_STS_SUCCESS;

1186: OE_GLOBALS.G_UI_FLAG := FALSE;
1187:
1188: -- Set return status.
1189:
1190: x_return_status := FND_API.G_RET_STS_SUCCESS;
1191:
1192: -- Get message count and data
1193:
1194: OE_MSG_PUB.Count_And_Get

Line 1203: WHEN FND_API.G_EXC_ERROR THEN

1199: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DELETE_ROW', 1);
1200:
1201: EXCEPTION
1202:
1203: WHEN FND_API.G_EXC_ERROR THEN
1204: ROLLBACK TO SAVEPOINT Header_Delete ;
1205: OE_GLOBALS.G_UI_FLAG := FALSE;
1206:
1207: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1207: x_return_status := FND_API.G_RET_STS_ERROR;

1203: WHEN FND_API.G_EXC_ERROR THEN
1204: ROLLBACK TO SAVEPOINT Header_Delete ;
1205: OE_GLOBALS.G_UI_FLAG := FALSE;
1206:
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208:
1209: -- Get message count and data
1210:
1211: OE_MSG_PUB.Count_And_Get

Line 1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1212: ( p_count => x_msg_count
1213: , p_data => x_msg_data
1214: );
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO SAVEPOINT Header_Delete ;
1218:
1219: OE_GLOBALS.G_UI_FLAG := FALSE;
1220:

Line 1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1217: ROLLBACK TO SAVEPOINT Header_Delete ;
1218:
1219: OE_GLOBALS.G_UI_FLAG := FALSE;
1220:
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222:
1223: -- Get message count and data
1224:
1225: OE_MSG_PUB.Count_And_Get

Line 1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1231: ROLLBACK TO SAVEPOINT Header_Delete ;
1232:
1233: OE_GLOBALS.G_UI_FLAG := FALSE;
1234:
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236:
1237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: OE_MSG_PUB.Add_Exc_Msg

Line 1276: , p_init_msg_list => FND_API.G_TRUE

1272:
1273:
1274: Oe_Order_Pvt.Process_Requests_And_Notify
1275: ( p_process_requests => TRUE
1276: , p_init_msg_list => FND_API.G_TRUE
1277: , p_notify => FALSE
1278: , x_return_status => l_return_status
1279: );
1280:

Line 1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1278: , x_return_status => l_return_status
1279: );
1280:
1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;

Line 1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1279: );
1280:
1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:

Line 1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1280:
1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288: -- Re-set the UI flag to FALSE

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288: -- Re-set the UI flag to FALSE
1289: OE_GLOBALS.G_UI_FLAG := FALSE;

Line 1293: x_return_status := FND_API.G_RET_STS_SUCCESS;

1289: OE_GLOBALS.G_UI_FLAG := FALSE;
1290:
1291: -- Set return status.
1292:
1293: x_return_status := FND_API.G_RET_STS_SUCCESS;
1294:
1295: -- Get message count and data
1296:
1297: OE_MSG_PUB.Count_And_Get

Line 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);
1303:
1304: EXCEPTION
1305:
1306: WHEN FND_API.G_EXC_ERROR THEN
1307:
1308: OE_GLOBALS.G_UI_FLAG := FALSE;
1309:
1310: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1310: x_return_status := FND_API.G_RET_STS_ERROR;

1306: WHEN FND_API.G_EXC_ERROR THEN
1307:
1308: OE_GLOBALS.G_UI_FLAG := FALSE;
1309:
1310: x_return_status := FND_API.G_RET_STS_ERROR;
1311:
1312: -- Get message count and data
1313:
1314: OE_MSG_PUB.Count_And_Get

Line 1319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1315: ( p_count => x_msg_count
1316: , p_data => x_msg_data
1317: );
1318:
1319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1320:
1321: OE_GLOBALS.G_UI_FLAG := FALSE;
1322:
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1320:
1321: OE_GLOBALS.G_UI_FLAG := FALSE;
1322:
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1324:
1325: -- Get message count and data
1326:
1327: OE_MSG_PUB.Count_And_Get

Line 1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1332: WHEN OTHERS THEN
1333:
1334: OE_GLOBALS.G_UI_FLAG := FALSE;
1335:
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337:
1338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1339: THEN
1340: OE_MSG_PUB.Add_Exc_Msg

Line 1418: , p_init_msg_list => FND_API.G_FALSE

1414: , p_x_line_tbl => l_line_tbl );
1415:
1416: Oe_Order_Pvt.Process_Requests_And_Notify
1417: ( p_process_requests => TRUE
1418: , p_init_msg_list => FND_API.G_FALSE
1419: , p_notify => TRUE
1420: , x_return_status => l_return_status
1421: );
1422:

Line 1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1420: , x_return_status => l_return_status
1421: );
1422:
1423:
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;

Line 1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1421: );
1422:
1423:
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:

Line 1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1422:
1423:
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:
1430: x_cascade_flag := OE_GLOBALS.G_CASCADING_REQUEST_LOGGED;

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423:
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:
1430: x_cascade_flag := OE_GLOBALS.G_CASCADING_REQUEST_LOGGED;
1431: -- Re-set the UI flag to FALSE

Line 1436: x_return_status := FND_API.G_RET_STS_SUCCESS;

1432: OE_GLOBALS.G_UI_FLAG := FALSE;
1433:
1434: -- Set return status.
1435:
1436: x_return_status := FND_API.G_RET_STS_SUCCESS;
1437:
1438: -- Get message count and data
1439:
1440: OE_MSG_PUB.Count_And_Get

Line 1452: WHEN FND_API.G_EXC_ERROR THEN

1448: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);
1449:
1450: EXCEPTION
1451:
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1454: OE_GLOBALS.G_UI_FLAG := FALSE;
1455:
1456: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1456: x_return_status := FND_API.G_RET_STS_ERROR;

1452: WHEN FND_API.G_EXC_ERROR THEN
1453: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1454: OE_GLOBALS.G_UI_FLAG := FALSE;
1455:
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457:
1458: -- Get message count and data
1459:
1460: OE_MSG_PUB.Count_And_Get

Line 1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1461: ( p_count => x_msg_count
1462: , p_data => x_msg_data
1463: );
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1467: OE_GLOBALS.G_UI_FLAG := FALSE;
1468:
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1467: OE_GLOBALS.G_UI_FLAG := FALSE;
1468:
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1470:
1471: -- Get message count and data
1472:
1473: OE_MSG_PUB.Count_And_Get

Line 1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1478: WHEN OTHERS THEN
1479: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1480: OE_GLOBALS.G_UI_FLAG := FALSE;
1481:
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1483:
1484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1485: THEN
1486: OE_MSG_PUB.Add_Exc_Msg

Line 1534: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1530: OE_Header_Util.Lock_Row
1531: ( x_return_status => l_return_status
1532: , p_x_header_rec => l_x_header_rec );
1533:
1534: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1535:
1536: -- Set DB flag and write record to cache.
1537:
1538: l_x_header_rec.db_flag := FND_API.G_TRUE;

Line 1538: l_x_header_rec.db_flag := FND_API.G_TRUE;

1534: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1535:
1536: -- Set DB flag and write record to cache.
1537:
1538: l_x_header_rec.db_flag := FND_API.G_TRUE;
1539:
1540: Write_header
1541: ( p_header_rec => l_x_header_rec
1542: , p_db_record => TRUE

Line 1550: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1546:
1547: -- Set return status.
1548:
1549: x_return_status := l_return_status;
1550: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;

Line 1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1547: -- Set return status.
1548:
1549: x_return_status := l_return_status;
1550: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:

Line 1552: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1548:
1549: x_return_status := l_return_status;
1550: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556:

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: x_return_status := l_return_status;
1550: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556:
1557: -- Get message count and data

Line 1567: WHEN FND_API.G_EXC_ERROR THEN

1563:
1564: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.LOCK_ROW', 1);
1565:
1566: EXCEPTION
1567: WHEN FND_API.G_EXC_ERROR THEN
1568:
1569: OE_GLOBALS.G_UI_FLAG := FALSE;
1570:
1571: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1571: x_return_status := FND_API.G_RET_STS_ERROR;

1567: WHEN FND_API.G_EXC_ERROR THEN
1568:
1569: OE_GLOBALS.G_UI_FLAG := FALSE;
1570:
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572:
1573: -- Get message count and data
1574:
1575: oe_msg_pub.count_and_get

Line 1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1576: ( p_count => x_msg_count
1577: , p_data => x_msg_data
1578: );
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581:
1582: OE_GLOBALS.G_UI_FLAG := FALSE;
1583:
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581:
1582: OE_GLOBALS.G_UI_FLAG := FALSE;
1583:
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1585:
1586: -- Get message count and data
1587:
1588: oe_msg_pub.count_and_get

Line 1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1598: , 'Lock_Row'
1599: );
1600: END IF;
1601:
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603:
1604: -- Get message count and data
1605:
1606: OE_MSG_PUB.Count_And_Get

Line 1647: IF p_header_id <> NVL(g_header_rec.header_id,FND_API.G_MISS_NUM)

1643: BEGIN
1644:
1645: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_HEADER', 1);
1646:
1647: IF p_header_id <> NVL(g_header_rec.header_id,FND_API.G_MISS_NUM)
1648: THEN
1649:
1650: -- Query row from DB
1651:

Line 1657: g_header_rec.db_flag := FND_API.G_TRUE;

1653: ( p_header_id => p_header_id,
1654: x_header_rec =>g_header_rec
1655: );
1656:
1657: g_header_rec.db_flag := FND_API.G_TRUE;
1658:
1659: -- Load DB record
1660:
1661: g_db_header_rec := g_header_rec;

Line 1706: x_return_status := FND_API.G_RET_STS_SUCCESS;

1702: l_header_id NUMBER;
1703: l_return_status Varchar2(30);
1704: BEGIN
1705: OE_MSG_PUB.initialize;
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707:
1708:
1709: OE_ORDER_CACHE.g_header_rec:=null;
1710: OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(

Line 1723: l_return_status := FND_API.G_RET_STS_ERROR;

1719:
1720: IF OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
1721:
1722: oe_debug_pub.add('Request does not exist, reset versioning globals'); IF (NOT OE_Versioning_Util.Reset_Globals) THEN
1723: l_return_status := FND_API.G_RET_STS_ERROR;
1724: RETURN;
1725: END IF;
1726: END IF;
1727:

Line 1747: x_return_status := FND_API.G_RET_STS_ERROR;

1743: OE_MSG_PUB.Count_And_Get
1744: ( p_count => x_msg_count
1745: , p_data => x_msg_data
1746: );
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748:
1749: END Clear_Record;
1750:
1751:

Line 1763: x_return_status := FND_API.G_RET_STS_SUCCESS;

1759: IS
1760: l_return_status Varchar2(30);
1761: BEGIN
1762: OE_MSG_PUB.initialize;
1763: x_return_status := FND_API.G_RET_STS_SUCCESS;
1764: OE_DELAYED_REQUESTS_PVT.Clear_Request(
1765: x_return_status => l_return_status);
1766:
1767: EXCEPTION

Line 1781: x_return_status := FND_API.G_RET_STS_ERROR;

1777: OE_MSG_PUB.Count_And_Get
1778: ( p_count => x_msg_count
1779: , p_data => x_msg_data
1780: );
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782:
1783: END Delete_All_Requests;
1784:
1785:

Line 1809: x_return_status := FND_API.G_RET_STS_SUCCESS;

1805:
1806: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.SALES_PERSON', 1);
1807:
1808: OE_MSG_PUB.initialize;
1809: x_return_status := FND_API.G_RET_STS_SUCCESS;
1810: p_multiple_sales_credits := 'N';
1811: open C_HSC_COUNT(p_header_id);
1812: fetch C_HSC_COUNT into l_count;
1813: close C_HSC_COUNT;

Line 1818: RAISE FND_API.G_EXC_ERROR;

1814: if l_count > 1 then
1815: p_multiple_sales_credits := 'Y';
1816: FND_MESSAGE.SET_NAME('ONT','OE_TOO_MANY_HSCREDIT');
1817: OE_MSG_PUB.Add;
1818: RAISE FND_API.G_EXC_ERROR;
1819: end if;
1820: -- add delayed request to default headers sales credits for the salesrep
1821: OE_Delayed_Requests_Pvt.Log_Request
1822: (p_entity_code=>OE_GLOBALS.G_ENTITY_Header

Line 1831: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1827: ,p_param1 => to_char(p_header_id)
1828: ,p_param2 => to_char(p_salesrep_id)
1829: ,x_return_status =>l_return_status);
1830:
1831: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;

Line 1832: RAISE FND_API.G_EXC_ERROR;

1828: ,p_param2 => to_char(p_salesrep_id)
1829: ,x_return_status =>l_return_status);
1830:
1831: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836:

Line 1833: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1829: ,x_return_status =>l_return_status);
1830:
1831: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);

Line 1834: RAISE FND_API.G_EXC_ERROR;

1830:
1831: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);
1838:

Line 1841: WHEN FND_API.G_EXC_ERROR THEN

1837: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);
1838:
1839: EXCEPTION
1840:
1841: WHEN FND_API.G_EXC_ERROR THEN
1842:
1843: x_return_status := FND_API.G_RET_STS_ERROR;
1844:
1845: -- Get message count and data

Line 1843: x_return_status := FND_API.G_RET_STS_ERROR;

1839: EXCEPTION
1840:
1841: WHEN FND_API.G_EXC_ERROR THEN
1842:
1843: x_return_status := FND_API.G_RET_STS_ERROR;
1844:
1845: -- Get message count and data
1846:
1847: OE_MSG_PUB.Count_And_Get

Line 1870: x_return_status := FND_API.G_RET_STS_ERROR;

1866: ( p_count => x_msg_count
1867: , p_data => x_msg_data
1868: );
1869:
1870: x_return_status := FND_API.G_RET_STS_ERROR;
1871:
1872: End Sales_Person;
1873:
1874: PROCEDURE Get_Form_Startup_Values

Line 1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1899: 'Get_Form_Startup_Values'
1900: );
1901: END IF;
1902:
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1904:
1905:
1906: END Get_Form_Startup_Values;
1907:

Line 2590: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2586: ,x_msg_data => x_msg_data
2587: ,x_return_status => x_return_status
2588: );
2589:
2590: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2591: x_header_val_rec.pay_now_total := null;
2592: END IF;
2593: ELSE
2594: x_header_val_rec.pay_now_total := null;

Line 2759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2755: 'Load_Set_Of_Books'
2756: );
2757: END IF;
2758:
2759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2760:
2761: END Load_Set_Of_Books;
2762:
2763:

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

2888: l_return_status VARCHAR2(1);
2889: --serla begin
2890: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2891: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2892: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2893: --serla end
2894: BEGIN
2895: SAVEPOINT Header_Cascade_Attributes;
2896: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute');

Line 2977: p_header_rec.header_id <> FND_API.G_MISS_NUM THEN

2973: -- End Of Enhanced Cascading
2974:
2975: THEN
2976: IF p_header_rec.header_id IS NOT NULL AND
2977: p_header_rec.header_id <> FND_API.G_MISS_NUM THEN
2978: OE_Line_Util.Query_Rows
2979: ( p_header_id => p_header_rec.header_id
2980: , x_line_tbl => l_x_line_tbl
2981: );

Line 3269: l_init_msg_list := FND_API.G_FALSE;

3265: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-Before PO');
3266:
3267: -- Added for cascading in Mass Change ER 7509356
3268: IF OE_MASS_CHANGE_PVT.IS_MASS_CHANGE = 'T' THEN
3269: l_init_msg_list := FND_API.G_FALSE;
3270: END IF;
3271:
3272: OE_GLOBALS.G_UI_FLAG := TRUE;
3273: Oe_Order_Pvt.Process_order

Line 3307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3303:
3304: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-After PO');
3305:
3306:
3307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;

Line 3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3304: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-After PO');
3305:
3306:
3307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:

Line 3309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3305:
3306:
3307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313:

Line 3310: RAISE FND_API.G_EXC_ERROR;

3306:
3307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313:
3314: -- Re-set the UI flag to FALSE

Line 3319: x_return_status := FND_API.G_RET_STS_SUCCESS;

3315: OE_GLOBALS.G_UI_FLAG := FALSE;
3316:
3317: -- Set return status.
3318:
3319: x_return_status := FND_API.G_RET_STS_SUCCESS;
3320:
3321: -- Get message count and data
3322: -- Commenting out for now not to display the same messages multiple times
3323: /*

Line 3332: WHEN FND_API.G_EXC_ERROR THEN

3328:
3329:
3330: EXCEPTION
3331:
3332: WHEN FND_API.G_EXC_ERROR THEN
3333: ROLLBACK TO SAVEPOINT Header_Cascade_Attributes;
3334: OE_GLOBALS.G_UI_FLAG := FALSE;
3335:
3336: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3336: x_return_status := FND_API.G_RET_STS_ERROR;

3332: WHEN FND_API.G_EXC_ERROR THEN
3333: ROLLBACK TO SAVEPOINT Header_Cascade_Attributes;
3334: OE_GLOBALS.G_UI_FLAG := FALSE;
3335:
3336: x_return_status := FND_API.G_RET_STS_ERROR;
3337:
3338: -- Get message count and data
3339:
3340: OE_MSG_PUB.Count_And_Get

Line 3345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3341: ( p_count => x_msg_count
3342: , p_data => x_msg_data
3343: );
3344:
3345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3346: ROLLBACK TO SAVEPOINT Header_Cascade_Attributes;
3347:
3348: OE_GLOBALS.G_UI_FLAG := FALSE;
3349:

Line 3350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3346: ROLLBACK TO SAVEPOINT Header_Cascade_Attributes;
3347:
3348: OE_GLOBALS.G_UI_FLAG := FALSE;
3349:
3350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3351:
3352: -- Get message count and data
3353:
3354: OE_MSG_PUB.Count_And_Get

Line 3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3360: ROLLBACK TO SAVEPOINT Header_Cascade_Attributes;
3361:
3362: OE_GLOBALS.G_UI_FLAG := FALSE;
3363:
3364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3365:
3366: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3367: THEN
3368: OE_MSG_PUB.Add_Exc_Msg

Line 3478: p_agreement_rec.agreement_id := FND_API.G_MISS_NUM;

3474: p_agreement_rec.revision_date := sysdate;
3475: p_agreement_rec.term_id := p_term_id;
3476: p_agreement_rec.OVERRIDE_IRULE_FLAG := 'Y';
3477: p_agreement_rec.OVERRIDE_ARULE_FLAG := 'Y';
3478: p_agreement_rec.agreement_id := FND_API.G_MISS_NUM;
3479: p_agreement_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3480: p_agreement_rec.price_list_id := p_price_list_id;
3481: p_agreement_rec.sold_to_org_id := p_sold_to_org_id;
3482: oe_debug_pub.add('Before Process_Agreement', 1);

Line 3487: , p_init_msg_list => FND_API.G_TRUE

3483:
3484: OE_Pricing_Cont_PUB.Process_Agreement
3485: ( p_api_version_number => 1.0
3486:
3487: , p_init_msg_list => FND_API.G_TRUE
3488: , p_return_values => FND_API.G_FALSE
3489: , p_commit => FND_API.G_FALSE
3490: , x_return_status => x_return_status
3491: , x_msg_count => x_msg_count

Line 3488: , p_return_values => FND_API.G_FALSE

3484: OE_Pricing_Cont_PUB.Process_Agreement
3485: ( p_api_version_number => 1.0
3486:
3487: , p_init_msg_list => FND_API.G_TRUE
3488: , p_return_values => FND_API.G_FALSE
3489: , p_commit => FND_API.G_FALSE
3490: , x_return_status => x_return_status
3491: , x_msg_count => x_msg_count
3492: , x_msg_data => x_msg_data

Line 3489: , p_commit => FND_API.G_FALSE

3485: ( p_api_version_number => 1.0
3486:
3487: , p_init_msg_list => FND_API.G_TRUE
3488: , p_return_values => FND_API.G_FALSE
3489: , p_commit => FND_API.G_FALSE
3490: , x_return_status => x_return_status
3491: , x_msg_count => x_msg_count
3492: , x_msg_data => x_msg_data
3493: , p_Agreement_rec => p_Agreement_rec

Line 3507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3503: );
3504: oe_debug_pub.add('After Process_Agreement', 1);
3505:
3506:
3507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511:

Line 3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3504: oe_debug_pub.add('After Process_Agreement', 1);
3505:
3506:
3507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511:
3512: END IF;

Line 3509: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3505:
3506:
3507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511:
3512: END IF;
3513: oe_debug_pub.add('Before Commit', 1);

Line 3510: RAISE FND_API.G_EXC_ERROR;

3506:
3507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511:
3512: END IF;
3513: oe_debug_pub.add('Before Commit', 1);
3514:

Line 3520: WHEN FND_API.G_EXC_ERROR THEN

3516: oe_debug_pub.add('After Commit', 1);
3517:
3518: EXCEPTION
3519:
3520: WHEN FND_API.G_EXC_ERROR THEN
3521: ROLLBACK;
3522: x_return_status := FND_API.G_RET_STS_ERROR;
3523:
3524: -- Get message count and data

Line 3522: x_return_status := FND_API.G_RET_STS_ERROR;

3518: EXCEPTION
3519:
3520: WHEN FND_API.G_EXC_ERROR THEN
3521: ROLLBACK;
3522: x_return_status := FND_API.G_RET_STS_ERROR;
3523:
3524: -- Get message count and data
3525: OE_MSG_PUB.Count_And_Get
3526: ( p_count => x_msg_count

Line 3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3528: );
3529:
3530:
3531:
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: ROLLBACK;
3534:
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3536: OE_MSG_PUB.Count_And_Get

Line 3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3531:
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: ROLLBACK;
3534:
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3536: OE_MSG_PUB.Count_And_Get
3537: ( p_count => x_msg_count
3538: , p_data => x_msg_data
3539: );

Line 3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3541:
3542: WHEN OTHERS THEN
3543: ROLLBACK;
3544:
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3546: OE_MSG_PUB.Count_And_Get
3547: ( p_count => x_msg_count
3548: , p_data => x_msg_data
3549: );

Line 3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)

3561: IF OE_CODE_CONTROL.Code_Release_Level >= '110508' THEN
3562:
3563:
3564: IF (( OE_ORDER_UTIL.g_header_rec.header_id is not null
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0

Line 3581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3577: , p_notify => FALSE
3578: , x_return_status => l_return_status
3579: );
3580:
3581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3585: END IF;

Line 3582: RAISE FND_API.G_EXC_ERROR;

3578: , x_return_status => l_return_status
3579: );
3580:
3581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3585: END IF;
3586:

Line 3583: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3579: );
3580:
3581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3585: END IF;
3586:
3587: --zbutt change bug#4772531 begin

Line 3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3580:
3581: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3585: END IF;
3586:
3587: --zbutt change bug#4772531 begin
3588: oe_order_util.clear_global_picture(l_return_status) ;

Line 3589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3585: END IF;
3586:
3587: --zbutt change bug#4772531 begin
3588: oe_order_util.clear_global_picture(l_return_status) ;
3589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3593: END IF;

Line 3590: RAISE FND_API.G_EXC_ERROR;

3586:
3587: --zbutt change bug#4772531 begin
3588: oe_order_util.clear_global_picture(l_return_status) ;
3589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3593: END IF;
3594: --zbutt change bug#4772531 end

Line 3591: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3587: --zbutt change bug#4772531 begin
3588: oe_order_util.clear_global_picture(l_return_status) ;
3589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3593: END IF;
3594: --zbutt change bug#4772531 end
3595:

Line 3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3588: oe_order_util.clear_global_picture(l_return_status) ;
3589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3593: END IF;
3594: --zbutt change bug#4772531 end
3595:
3596: END IF;

Line 3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3982: , 'Unrecognized attribute'
3983: );
3984: END IF;
3985:
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987:
3988: END IF;
3989: EXCEPTION
3990: WHEN OTHERS THEN

Line 3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3994: ( G_PKG_NAME
3995: , 'Copy_Attribute_To_Rec'
3996: );
3997: END IF;
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: END Copy_Attribute_To_Rec;
4000:
4001: PROCEDURE Validate_Phone_Number(
4002: p_area_code IN VARCHAR2 default Null,

Line 4310: x_return_status := FND_API.G_RET_STS_SUCCESS;

4306: END IF;
4307:
4308: IF p_column_name IS NOT NULL THEN
4309: -- Initializing return status to SUCCESS
4310: x_return_status := FND_API.G_RET_STS_SUCCESS;
4311:
4312: IF p_header_id IS NOT NULL THEN
4313: OE_Header_Util.Query_Row
4314: ( p_header_id => p_header_id,

Line 4340: x_return_status := FND_API.G_RET_STS_ERROR;

4336: ,x_on_operation_action => l_action
4337: );
4338: if l_result = OE_PC_GLOBALS.YES then
4339: x_constrained:=True;
4340: x_return_status := FND_API.G_RET_STS_ERROR;
4341: elsif l_result=OE_PC_GLOBALS.NO THEN
4342: x_constrained:=False;
4343: end if;
4344:

Line 4348: WHEN FND_API.G_EXC_ERROR THEN

4344:
4345: END IF; -- if column name is not null
4346:
4347: EXCEPTION
4348: WHEN FND_API.G_EXC_ERROR THEN
4349: x_constrained := TRUE;
4350: x_return_status := FND_API.G_RET_STS_ERROR;
4351: WHEN OTHERS THEN
4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4350: x_return_status := FND_API.G_RET_STS_ERROR;

4346:
4347: EXCEPTION
4348: WHEN FND_API.G_EXC_ERROR THEN
4349: x_constrained := TRUE;
4350: x_return_status := FND_API.G_RET_STS_ERROR;
4351: WHEN OTHERS THEN
4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4353:
4354: oe_msg_pub.count_and_get

Line 4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4348: WHEN FND_API.G_EXC_ERROR THEN
4349: x_constrained := TRUE;
4350: x_return_status := FND_API.G_RET_STS_ERROR;
4351: WHEN OTHERS THEN
4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4353:
4354: oe_msg_pub.count_and_get
4355: ( p_count => x_msg_count
4356: , p_data => x_msg_data);