DBA Data[Home] [Help]

APPS.OKL_CSH_ORDER_SEQ_PVT dependencies on OKL_API

Line 256: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

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;

Line 258: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 265: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 464: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 743: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

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;

Line 745: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 752: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 918: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 1065: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

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;

Line 1067: ELSIF l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 1074: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 1143: l_overall_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 1160: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

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;

Line 1161: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 1187: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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: