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:
1061: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;

Line 1063: x_return_status := FND_API.G_RET_STS_ERROR;

1059: OE_GLOBALS.G_UI_FLAG := FALSE;
1060:
1061: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
1062:
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064:
1065: -- Get message count and data
1066:
1067: OE_MSG_PUB.Count_And_Get

Line 1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1165: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 1166: , p_init_msg_list => FND_API.G_TRUE

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

Line 1173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1176: RAISE FND_API.G_EXC_ERROR;

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

Line 1189: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1202: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1206: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1275: , p_init_msg_list => FND_API.G_TRUE

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

Line 1281: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1283: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1284: RAISE FND_API.G_EXC_ERROR;

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

Line 1292: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1305: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1309: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1417: , p_init_msg_list => FND_API.G_FALSE

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

Line 1423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1426: RAISE FND_API.G_EXC_ERROR;

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

Line 1435: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1451: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1455: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1533: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 1549: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1552: RAISE FND_API.G_EXC_ERROR;

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

Line 1566: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1570: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 1705: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1722: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1746: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1762: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1780: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1808: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1817: RAISE FND_API.G_EXC_ERROR;

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

Line 1830: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1831: RAISE FND_API.G_EXC_ERROR;

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

Line 1832: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1833: RAISE FND_API.G_EXC_ERROR;

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

Line 1840: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1842: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1869: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 3266: l_init_msg_list := FND_API.G_FALSE;

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

Line 3304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3306: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3302:
3303:
3304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3306: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3307: RAISE FND_API.G_EXC_ERROR;
3308: END IF;
3309:
3310:

Line 3307: RAISE FND_API.G_EXC_ERROR;

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

Line 3316: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3329: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3333: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

Line 3484: , p_init_msg_list => FND_API.G_TRUE

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

Line 3485: , p_return_values => FND_API.G_FALSE

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

Line 3486: , p_commit => FND_API.G_FALSE

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

Line 3504: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3506: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3507: RAISE FND_API.G_EXC_ERROR;

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

Line 3517: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3519: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3525: );
3526:
3527:
3528:
3529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3530: ROLLBACK;
3531:
3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3533: OE_MSG_PUB.Count_And_Get

Line 3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

Line 3578: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3579: RAISE FND_API.G_EXC_ERROR;

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

Line 3580: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3586: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3587: RAISE FND_API.G_EXC_ERROR;

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

Line 3588: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3979: , 'Unrecognized attribute'
3980: );
3981: END IF;
3982:
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984:
3985: END IF;
3986: EXCEPTION
3987: WHEN OTHERS THEN

Line 3995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4307: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4337: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4345: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4347: x_return_status := FND_API.G_RET_STS_ERROR;

4343:
4344: EXCEPTION
4345: WHEN FND_API.G_EXC_ERROR THEN
4346: x_constrained := TRUE;
4347: x_return_status := FND_API.G_RET_STS_ERROR;
4348: WHEN OTHERS THEN
4349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4350:
4351: oe_msg_pub.count_and_get

Line 4349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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