252: x_return_status := l_return_status ;
253: x_msg_count := l_msg_count ;
254: x_msg_data := l_msg_data ;
255:
256: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
257: RAISE l_ins_ext;
258: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
259: RAISE l_ins_ext;
260: END IF;
254: x_msg_data := l_msg_data ;
255:
256: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
257: RAISE l_ins_ext;
258: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
259: RAISE l_ins_ext;
260: END IF;
261:
262: EXCEPTION
261:
262: EXCEPTION
263:
264: WHEN l_ins_ext THEN
265: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
266: x_msg_count := l_msg_count ;
267: l_msg_data := 'Problems with External Delete';
268: x_msg_data := l_msg_data ;
269:
460:
461: EXCEPTION
462:
463: WHEN l_ins_ext THEN
464: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
465: x_msg_count := l_msg_count ;
466: l_msg_data := 'Problems with External Delete';
467: x_msg_data := l_msg_data ;
468:
739: x_return_status := l_return_status ;
740: x_msg_count := l_msg_count ;
741: x_msg_data := l_msg_data ;
742:
743: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
744: RAISE l_upd_ext;
745: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
746: RAISE l_upd_ext;
747: END IF;
741: x_msg_data := l_msg_data ;
742:
743: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
744: RAISE l_upd_ext;
745: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
746: RAISE l_upd_ext;
747: END IF;
748:
749: EXCEPTION
748:
749: EXCEPTION
750:
751: WHEN l_upd_ext THEN
752: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
753: x_msg_count := l_msg_count ;
754: l_msg_data := 'Problems with External Insert';
755: x_msg_data := l_msg_data ;
756:
914: END IF;
915:
916: EXCEPTION
917: WHEN l_upd_ext THEN
918: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
919: x_msg_count := l_msg_count ;
920: l_msg_data := 'Problems with External Delete';
921: x_msg_data := l_msg_data ;
922:
1061: x_msg_data := l_msg_data ;
1062:
1063: END IF;
1064:
1065: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1066: RAISE l_del_ext;
1067: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1068: RAISE l_del_ext;
1069: END IF;
1063: END IF;
1064:
1065: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1066: RAISE l_del_ext;
1067: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1068: RAISE l_del_ext;
1069: END IF;
1070:
1071: EXCEPTION
1070:
1071: EXCEPTION
1072:
1073: WHEN l_del_ext THEN
1074: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1075: x_msg_count := l_msg_count ;
1076: l_msg_data := 'Problems with External Insert';
1077: x_msg_data := l_msg_data ;
1078:
1139: l_return_status := Okc_Api.G_RET_STS_SUCCESS;
1140:
1141: -- Begin Post-Generation Change
1142: -- overall error status
1143: l_overall_status := Okl_Api.G_RET_STS_SUCCESS;
1144: -- End Post-Generation Change
1145:
1146: IF (lp_okl_csh_order_tbl.COUNT > 0) THEN
1147: i := lp_okl_csh_order_tbl.FIRST;
1156: ,lp_okl_csh_order_tbl(i));
1157:
1158: -- Begin Post-Generation Change
1159: -- store the highest degree of error
1160: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1161: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1162: l_overall_status := x_return_status;
1163: END IF;
1164: END IF;
1157:
1158: -- Begin Post-Generation Change
1159: -- store the highest degree of error
1160: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1161: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1162: l_overall_status := x_return_status;
1163: END IF;
1164: END IF;
1165: -- End Post-Generation Change
1183:
1184: EXCEPTION
1185:
1186: WHEN l_del_ext THEN
1187: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1188: x_msg_count := l_msg_count ;
1189: l_msg_data := 'Problems with External Delete';
1190: x_msg_data := l_msg_data ;
1191: