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.WSMPJUPD dependencies on FND_API

Line 30: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;

26: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
27: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
28: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
29:
30: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
32: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34:

Line 31: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;

27: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
28: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
29:
30: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
32: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34:
35: type t_number is table of number index by binary_integer;

Line 32: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

28: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
29:
30: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
32: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
33:
34:
35: type t_number is table of number index by binary_integer;
36: type t_job_name_tbl is table of number index by wip_entities.wip_entity_name%type;

Line 111: x_return_status := FND_API.G_RET_STS_SUCCESS;

107: BEGIN
108:
109: savepoint start_secondary_quantities;
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: IF FND_LOG.LEVEL_PROCEDURE >= l_log_level THEN
114: l_stmt_num := 5;
115: l_param_tbl.delete;

Line 641: raise FND_API.G_EXC_ERROR;

637: );
638: -- Once this call is over the data for the new operation would be copied...
639: if x_return_status <> G_RET_SUCCESS then
640: IF x_return_status = G_RET_ERROR THEN
641: raise FND_API.G_EXC_ERROR;
642: ELSE
643: raise FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645: end if;

Line 643: raise FND_API.G_EXC_UNEXPECTED_ERROR;

639: if x_return_status <> G_RET_SUCCESS then
640: IF x_return_status = G_RET_ERROR THEN
641: raise FND_API.G_EXC_ERROR;
642: ELSE
643: raise FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645: end if;
646: END IF;
647: l_counter := p_wltx_resulting_jobs_tbl.next(l_counter);

Line 718: x_return_status := FND_API.G_RET_STS_SUCCESS;

714: p_run_log_level => l_log_level
715: );
716: End if;
717:
718: x_return_status := FND_API.G_RET_STS_SUCCESS;
719:
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: ROLLBACK TO start_secondary_quantities;

Line 721: WHEN FND_API.G_EXC_ERROR THEN

717:
718: x_return_status := FND_API.G_RET_STS_SUCCESS;
719:
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: ROLLBACK TO start_secondary_quantities;
723: x_return_status := G_RET_ERROR;
724: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
725: p_count => x_msg_count ,

Line 729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

725: p_count => x_msg_count ,
726: p_data => x_error_msg
727: );
728:
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: ROLLBACK TO start_secondary_quantities;
731: x_return_status := G_RET_UNEXPECTED;
732: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
733: p_count => x_msg_count ,

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

781: BEGIN
782:
783: savepoint start_copy_wsm_op_reason_codes;
784:
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: l_stmt_num := 10;
788:
789: if p_sj_also_rj_index is null then

Line 896: x_return_status := FND_API.G_RET_STS_SUCCESS;

892: where sequence_num = p_wltx_resulting_jobs_tbl(l_counter).starting_operation_seq_num
893: and STANDARD_OPERATION_ID = p_wltx_resulting_jobs_tbl(l_counter).starting_std_op_id
894: );
895: end if;
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900:

Line 899: WHEN FND_API.G_EXC_ERROR THEN

895: end if;
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900:
901: ROLLBACK TO start_copy_wsm_op_reason_codes;
902:
903: x_return_status := G_RET_ERROR;

Line 909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

905: p_count => x_msg_count ,
906: p_data => x_error_msg
907: );
908:
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910:
911: ROLLBACK TO start_copy_wsm_op_reason_codes;
912:
913: x_return_status := G_RET_UNEXPECTED;

Line 967: x_return_status := FND_API.G_RET_STS_SUCCESS;

963:
964: BEGIN
965: savepoint start_copy_wsm_subst_comp;
966:
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968:
969: l_stmt_num := 10;
970:
971: If p_wltx_starting_jobs_tbl(p_rep_job_index).intraoperation_step = 1 then

Line 1086: x_return_status := FND_API.G_RET_STS_SUCCESS;

1082: end loop;
1083: end if;
1084: end if;
1085:
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088: EXCEPTION
1089: WHEN FND_API.G_EXC_ERROR THEN
1090:

Line 1089: WHEN FND_API.G_EXC_ERROR THEN

1085:
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088: EXCEPTION
1089: WHEN FND_API.G_EXC_ERROR THEN
1090:
1091: ROLLBACK TO start_copy_wsm_subst_comp;
1092:
1093: x_return_status := G_RET_ERROR;

Line 1099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1095: p_count => x_error_msg ,
1096: p_data => x_msg_count
1097: );
1098:
1099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1100:
1101: ROLLBACK TO start_copy_wsm_subst_comp;
1102:
1103: x_return_status := G_RET_UNEXPECTED;

Line 1221: RAISE FND_API.G_EXC_ERROR;

1217: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1218: p_run_log_level => l_log_level
1219: );
1220: END IF;
1221: RAISE FND_API.G_EXC_ERROR;
1222:
1223: ELSIF (l_qty_Q = 0) AND (l_qty_RUN = 0) AND (l_qty_TM = 0) THEN
1224: p_intra_op := 5;
1225: ELSE

Line 1241: RAISE FND_API.G_EXC_ERROR;

1237: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
1238: p_run_log_level => l_log_level
1239: );
1240: END IF;
1241: RAISE FND_API.G_EXC_ERROR;
1242:
1243: END IF;
1244:
1245: l_stmt_num := 30;

Line 1250: WHEN FND_API.G_EXC_ERROR THEN

1246: x_err_code := 0;
1247: x_err_buf := NULL;
1248:
1249: EXCEPTION
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: x_err_code := -1;
1252: x_err_buf := 'WSMPJUPD.GET_JOB_CURR_OP_INFO('||to_char(l_stmt_num)||'): Incorrect job status for this transaction';
1253:
1254: WHEN OTHERS THEN

Line 2501: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then

2497: p_Kanban_Card_Id => p_kanban_card_id,
2498: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
2499: );
2500:
2501: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
2502: x_err_code := -1;
2503: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
2504:
2505: fnd_message.set_token('STATUS',g_translated_meaning);

Line 3045: RAISE FND_API.G_EXC_ERROR;

3041: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3042: p_run_log_level => l_log_level
3043: );
3044: END IF;
3045: RAISE FND_API.G_EXC_ERROR;
3046:
3047: END IF;
3048:
3049: l_stmt_num := 30;

Line 3085: RAISE FND_API.G_EXC_ERROR;

3081: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3082: p_run_log_level => l_log_level
3083: );
3084: END IF;
3085: RAISE FND_API.G_EXC_ERROR;
3086: END IF;
3087:
3088: IF (l_charges_exist = 1) THEN
3089: IF ((l_manually_added_resource = 1) OR (l_issued_resource = 1)) THEN

Line 3306: RAISE FND_API.G_EXC_ERROR;

3302: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3303: p_run_log_level => l_log_level
3304: );
3305: END IF;
3306: RAISE FND_API.G_EXC_ERROR;
3307: END IF;
3308:
3309: -- Start : Additions to fix bug 3452913 --
3310: UPDATE wip_operations

Line 3357: RAISE FND_API.G_EXC_ERROR;

3353: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3354: p_run_log_level => l_log_level
3355: );
3356: END IF;
3357: RAISE FND_API.G_EXC_ERROR;
3358: ELSE
3359:
3360: if( g_log_level_statement >= l_log_level ) then
3361: l_msg_tokens.delete;

Line 3408: WHEN FND_API.G_EXC_ERROR THEN

3404: EXCEPTION
3405: WHEN e_upd_txn THEN
3406: x_err_code := -100;
3407: x_err_buf := l_fnd_err_msg;
3408: WHEN FND_API.G_EXC_ERROR THEN
3409: x_err_code := SQLCODE;
3410: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3411: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3412: p_count => x_msg_count ,

Line 3415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3411: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3412: p_count => x_msg_count ,
3413: p_data => x_err_buf
3414: );
3415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3416: x_err_code := SQLCODE;
3417: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3418: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3419: p_count => x_msg_count ,

Line 3522: RAISE FND_API.G_EXC_ERROR;

3518: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3519: p_run_log_level => l_log_level
3520: );
3521: END IF;
3522: RAISE FND_API.G_EXC_ERROR;
3523:
3524: END IF;
3525:
3526: -- indicates that the compl. subinv has changed hence remove the link to the kanban card id...

Line 3571: if ( l_return_status <> fnd_api.g_ret_sts_success ) then

3567: p_Kanban_Card_Id => l_job_kanban_card_id,
3568: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
3569: );
3570:
3571: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
3572: x_err_code := -1;
3573: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
3574:
3575: fnd_message.set_token('STATUS',g_translated_meaning);

Line 3592: RAISE FND_API.G_EXC_ERROR;

3588: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3589: p_run_log_level => l_log_level
3590: );
3591: END IF;
3592: RAISE FND_API.G_EXC_ERROR;
3593:
3594: end if;
3595:
3596: l_job_kanban_card_id := null;

Line 3655: RAISE FND_API.G_EXC_ERROR;

3651: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3652: p_run_log_level => l_log_level
3653: );
3654: END IF;
3655: RAISE FND_API.G_EXC_ERROR;
3656: ELSE
3657:
3658: IF (l_new_op_added IS NOT NULL) THEN -- Added condition check for APS-WLT --
3659: if( g_log_level_statement >= l_log_level ) then

Line 3733: WHEN FND_API.G_EXC_ERROR THEN

3729: x_err_code := 0;
3730: x_err_buf := null;
3731:
3732: EXCEPTION
3733: WHEN FND_API.G_EXC_ERROR THEN
3734: x_err_code := -1;
3735: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3736: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3737: p_count => x_msg_count ,

Line 3741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3737: p_count => x_msg_count ,
3738: p_data => x_err_buf
3739: );
3740:
3741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3742: x_err_code := -1;
3743: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3744: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3745: p_count => x_msg_count ,

Line 3833: RAISE FND_API.G_EXC_ERROR;

3829: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3830: p_run_log_level => l_log_level
3831: );
3832: END IF;
3833: RAISE FND_API.G_EXC_ERROR;
3834: END IF;
3835:
3836: l_stmt_num := 30;
3837:

Line 3938: x_return_status := fnd_api.g_ret_sts_success;

3934:
3935: end if;
3936:
3937: /* set the return status to succes... */
3938: x_return_status := fnd_api.g_ret_sts_success;
3939:
3940: exception
3941: WHEN FND_API.G_EXC_ERROR THEN
3942:

Line 3941: WHEN FND_API.G_EXC_ERROR THEN

3937: /* set the return status to succes... */
3938: x_return_status := fnd_api.g_ret_sts_success;
3939:
3940: exception
3941: WHEN FND_API.G_EXC_ERROR THEN
3942:
3943: x_return_status := G_RET_ERROR;
3944: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3945: p_count => x_msg_count ,

Line 3949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3945: p_count => x_msg_count ,
3946: p_data => x_msg_data
3947: );
3948:
3949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3950:
3951: x_return_status := G_RET_UNEXPECTED;
3952:
3953: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',

Line 3959: x_return_status := fnd_api.g_ret_sts_error;

3955: p_data => x_msg_data
3956: );
3957: when others then
3958: /* handle it... */
3959: x_return_status := fnd_api.g_ret_sts_error;
3960: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
3961:
3962: l_msg_tokens.delete;
3963: WSM_log_PVT.logMessage (p_module_name => l_module ,

Line 4128: RAISE FND_API.G_EXC_ERROR;

4124: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4125: p_run_log_level => l_log_level
4126: );
4127: END IF;
4128: RAISE FND_API.G_EXC_ERROR;
4129: END IF;
4130:
4131: if( g_log_level_statement >= l_log_level ) then
4132: l_msg_tokens.delete;

Line 4246: RAISE FND_API.G_EXC_ERROR;

4242: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4243: p_run_log_level => l_log_level
4244: );
4245: END IF;
4246: RAISE FND_API.G_EXC_ERROR;
4247: END IF;
4248:
4249: l_stmt_num := 70;
4250:

Line 4391: RAISE FND_API.G_EXC_ERROR;

4387: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4388: p_run_log_level => l_log_level
4389: );
4390: END IF;
4391: RAISE FND_API.G_EXC_ERROR;
4392: END IF;
4393:
4394: if( g_log_level_statement >= l_log_level ) then
4395: l_msg_tokens.delete;

Line 4523: RAISE FND_API.G_EXC_ERROR;

4519: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4520: p_run_log_level => l_log_level
4521: );
4522: END IF;
4523: RAISE FND_API.G_EXC_ERROR;
4524: END IF;
4525:
4526: if( g_log_level_statement >= l_log_level ) then
4527: l_msg_tokens.delete;

Line 4569: WHEN FND_API.G_EXC_ERROR THEN

4565: l_stmt_num := 160;
4566: x_err_code := 0;
4567:
4568: EXCEPTION
4569: WHEN FND_API.G_EXC_ERROR THEN
4570: x_err_code := SQLCODE;
4571: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4572:
4573: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',

Line 4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4574: p_count => x_msg_count ,
4575: p_data => x_err_buf
4576: );
4577:
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579:
4580: x_err_code := SQLCODE;
4581: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4582:

Line 4679: RAISE FND_API.G_EXC_ERROR;

4675: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4676: p_run_log_level => l_log_level
4677: );
4678: END IF;
4679: RAISE FND_API.G_EXC_ERROR;
4680: END IF;
4681:
4682: l_stmt_num := 40;
4683:

Line 4690: p_initMsgList => FND_API.g_true,

4686: l_stmt_num := 50;
4687:
4688: WSM_infinite_scheduler_PVT.schedule
4689: (
4690: p_initMsgList => FND_API.g_true,
4691: p_endDebug => FND_API.g_true,
4692: p_orgID => p_org_id,
4693: p_wipEntityID => p_par_we_id,
4694: p_scheduleMode => l_schedule_mode,

Line 4691: p_endDebug => FND_API.g_true,

4687:
4688: WSM_infinite_scheduler_PVT.schedule
4689: (
4690: p_initMsgList => FND_API.g_true,
4691: p_endDebug => FND_API.g_true,
4692: p_orgID => p_org_id,
4693: p_wipEntityID => p_par_we_id,
4694: p_scheduleMode => l_schedule_mode,
4695: p_startDate => l_job_op_start_dt,

Line 4703: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN

4699: x_returnStatus => l_returnStatus,
4700: x_errorMsg => x_err_buf
4701: );
4702:
4703: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4704: x_err_code := -1;
4705: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4706: l_msg_tokens.delete;
4707: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 4716: RAISE FND_API.G_EXC_ERROR;

4712: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4713: p_run_log_level => l_log_level
4714: );
4715: END IF;
4716: RAISE FND_API.G_EXC_ERROR;
4717: ELSE
4718: x_err_code := 0;
4719: END IF;
4720:

Line 4734: WHEN FND_API.G_EXC_ERROR THEN

4730:
4731: l_stmt_num := 70;
4732:
4733: EXCEPTION
4734: WHEN FND_API.G_EXC_ERROR THEN
4735:
4736: x_err_code := SQLCODE;
4737: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4738: /*

Line 4744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4740: p_count => x_msg_count ,
4741: p_data => x_err_buf
4742: );
4743: */
4744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4745:
4746: x_err_code := SQLCODE;
4747: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4748: /*

Line 4892: raise FND_API.G_EXC_ERROR;

4888: );
4889:
4890: if x_return_status <> G_RET_SUCCESS then
4891: IF x_return_status = G_RET_ERROR THEN
4892: raise FND_API.G_EXC_ERROR;
4893: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4894: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4895: END IF;
4896: end if;

Line 4894: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4890: if x_return_status <> G_RET_SUCCESS then
4891: IF x_return_status = G_RET_ERROR THEN
4892: raise FND_API.G_EXC_ERROR;
4893: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4894: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4895: END IF;
4896: end if;
4897: End if;
4898:

Line 5136: RAISE FND_API.G_EXC_ERROR;

5132: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5133: p_run_log_level => l_log_level
5134: );
5135: END IF;
5136: RAISE FND_API.G_EXC_ERROR;
5137: ELSE
5138: -- success... now the program would have returned the id ....
5139: if( g_log_level_statement >= l_log_level ) then
5140: l_msg_tokens.delete;

Line 5267: RAISE FND_API.G_EXC_ERROR;

5263: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5264: p_run_log_level => l_log_level
5265: );
5266: END IF;
5267: RAISE FND_API.G_EXC_ERROR;
5268:
5269: ELSE
5270: -- success... now the program would have returned the id ....
5271: if( g_log_level_statement >= l_log_level ) then

Line 5336: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then

5332: p_Document_detail_Id => '',
5333: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity
5334: );
5335:
5336: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5337: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5338:
5339: l_msg_tokens.delete;
5340: l_msg_tokens(1).TokenName := 'STATUS';

Line 5352: RAISE FND_API.G_EXC_ERROR;

5348: p_run_log_level => l_log_level
5349: );
5350: END IF;
5351:
5352: RAISE FND_API.G_EXC_ERROR;
5353:
5354: end if;
5355:
5356: p_wltx_resulting_jobs_tbl(l_job_counter).kanban_card_id := l_kanban_card_id;

Line 5423: RAISE FND_API.G_EXC_ERROR;

5419: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5420: p_run_log_level => l_log_level
5421: );
5422: END IF;
5423: RAISE FND_API.G_EXC_ERROR;
5424: END IF;
5425:
5426:
5427: l_stmt_num := 230;

Line 5462: RAISE FND_API.G_EXC_ERROR;

5458: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5459: p_run_log_level => l_log_level
5460: );
5461: END IF;
5462: RAISE FND_API.G_EXC_ERROR;
5463: END IF;
5464:
5465:
5466: -- Related bugs : 3142153

Line 5509: RAISE FND_API.G_EXC_ERROR;

5505: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5506: p_run_log_level => l_log_level
5507: );
5508: END IF;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END IF;
5511: END IF;
5512:
5513: --End: Additions for APS-WLT--

Line 5540: RAISE FND_API.G_EXC_ERROR;

5536: p_fnd_log_level => G_LOG_LEVEL_ERROR,
5537: p_run_log_level => l_log_level
5538: );
5539: END IF;
5540: RAISE FND_API.G_EXC_ERROR;
5541: END IF;
5542: /* ST : Detailed Scheduling end */
5543:
5544: l_stmt_num := 250;

Line 5583: RAISE FND_API.G_EXC_ERROR;

5579: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5580: p_run_log_level => l_log_level
5581: );
5582: END IF;
5583: RAISE FND_API.G_EXC_ERROR;
5584: END IF;
5585:
5586:
5587: l_stmt_num := 260;

Line 5622: RAISE FND_API.G_EXC_ERROR;

5618: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5619: p_run_log_level => l_log_level
5620: );
5621: END IF;
5622: RAISE FND_API.G_EXC_ERROR;
5623: END IF;
5624:
5625: -- ok now process the starting jobs...
5626: if( g_log_level_statement >= l_log_level ) then

Line 5708: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then

5704: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id,
5705: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5706: );
5707:
5708: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5709:
5710: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5711:
5712: l_msg_tokens.delete;

Line 5724: RAISE FND_API.G_EXC_ERROR;

5720: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5721: p_run_log_level => l_log_level
5722: );
5723: END IF;
5724: RAISE FND_API.G_EXC_ERROR;
5725:
5726: end if;
5727:
5728: l_stmt_num := 125;

Line 5769: RAISE FND_API.G_EXC_ERROR;

5765: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5766: p_run_log_level => l_log_level
5767: );
5768: END IF;
5769: RAISE FND_API.G_EXC_ERROR;
5770: END IF;
5771:
5772: -- indicates that the compl. subinv has changed hence remove the link to the kanban card id...
5773: if l_sub_loc_change <> 0 then

Line 5801: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then

5797: p_Document_detail_Id => '',
5798: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity
5799: );
5800:
5801: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5802: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5803:
5804: l_msg_tokens.delete;
5805: l_msg_tokens(1).TokenName := 'STATUS';

Line 5816: RAISE FND_API.G_EXC_ERROR;

5812: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5813: p_run_log_level => l_log_level
5814: );
5815: END IF;
5816: RAISE FND_API.G_EXC_ERROR;
5817:
5818: end if;
5819:
5820: l_stmt_num := 150;

Line 5907: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then

5903: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_job_counter).kanban_card_id,
5904: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5905: );
5906:
5907: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5908: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5909:
5910: l_msg_tokens.delete;
5911: l_msg_tokens(1).TokenName := 'STATUS';

Line 5922: RAISE FND_API.G_EXC_ERROR;

5918: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5919: p_run_log_level => l_log_level
5920: );
5921: END IF;
5922: RAISE FND_API.G_EXC_ERROR;
5923: end if;
5924:
5925: l_stmt_num := 137;
5926: --Bug 5344676:Commented out the following line

Line 5979: RAISE FND_API.G_EXC_ERROR;

5975: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5976: p_run_log_level => l_log_level
5977: );
5978: END IF;
5979: RAISE FND_API.G_EXC_ERROR;
5980: else
5981: -- success.. got the new name for the job ...
5982: if( g_log_level_statement >= l_log_level ) then
5983: l_msg_tokens.delete;

Line 6047: RAISE FND_API.G_EXC_ERROR;

6043: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6044: p_run_log_level => l_log_level
6045: );
6046: END IF;
6047: RAISE FND_API.G_EXC_ERROR;
6048: END IF;
6049:
6050: l_stmt_num := 270;
6051: if( g_log_level_statement >= l_log_level ) then

Line 6092: RAISE FND_API.G_EXC_ERROR;

6088: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6089: p_run_log_level => l_log_level
6090: );
6091: END IF;
6092: RAISE FND_API.G_EXC_ERROR;
6093: end if;
6094:
6095: l_stmt_num := 280;
6096:

Line 6149: RAISE FND_API.G_EXC_ERROR;

6145: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6146: p_run_log_level => l_log_level
6147: );
6148: END IF;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: end if;
6152:
6153: l_job_counter := p_wltx_resulting_jobs_tbl.next(l_job_counter);

Line 6223: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message

6219: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6220: p_run_log_level => l_log_level
6221: );
6222: END IF;
6223: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
6224: END IF;
6225:
6226: -- New Jobs in Split/Merge, jobs undergoing SPUA and jobs involved in Upd Rtg/Assly
6227: -- have already been either Infinite Scheduled or the data has been set for them

Line 6264: RAISE FND_API.G_EXC_ERROR;

6260: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6261: p_run_log_level => l_log_level
6262: );
6263: END IF;
6264: RAISE FND_API.G_EXC_ERROR;
6265: END IF;
6266:
6267: END IF;
6268:

Line 6285: raise FND_API.G_EXC_ERROR;

6281: x_error_msg => x_error_msg
6282: );
6283: if x_return_status <> G_RET_SUCCESS then
6284: IF x_return_status = G_RET_ERROR THEN
6285: raise FND_API.G_EXC_ERROR;
6286: ELSE
6287: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6288: END IF;
6289: end if;

Line 6287: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6283: if x_return_status <> G_RET_SUCCESS then
6284: IF x_return_status = G_RET_ERROR THEN
6285: raise FND_API.G_EXC_ERROR;
6286: ELSE
6287: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6288: END IF;
6289: end if;
6290:
6291: l_stmt_num := 330;

Line 6389: RAISE FND_API.G_EXC_ERROR;

6385:
6386: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6387:
6388: END IF;
6389: RAISE FND_API.G_EXC_ERROR;
6390: END IF;
6391:
6392: end loop;
6393: else

Line 6490: RAISE FND_API.G_EXC_ERROR;

6486:
6487: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6488:
6489: END IF;
6490: RAISE FND_API.G_EXC_ERROR;
6491: END IF;
6492:
6493: end loop;
6494:

Line 6518: if l_ret_status <> fnd_api.g_ret_sts_success then

6514: );
6515:
6516: l_stmt_num := 390;
6517:
6518: if l_ret_status <> fnd_api.g_ret_sts_success then
6519: -- error out...
6520: l_stmt_num := 395;
6521: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6522: l_msg_tokens.delete;

Line 6532: RAISE FND_API.G_EXC_ERROR;

6528: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6529: p_run_log_level => l_log_level
6530: );
6531: END IF;
6532: RAISE FND_API.G_EXC_ERROR;
6533: end if;
6534:
6535: l_stmt_num := 400;
6536:

Line 6573: RAISE FND_API.G_EXC_ERROR;

6569: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6570: p_run_log_level => l_log_level
6571: );
6572: END IF;
6573: RAISE FND_API.G_EXC_ERROR;
6574: END IF;
6575:
6576: l_stmt_num := 510;
6577: l_err_code := 0;

Line 6604: RAISE FND_API.G_EXC_ERROR;

6600: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6601: p_run_log_level => l_log_level
6602: );
6603: END IF;
6604: RAISE FND_API.G_EXC_ERROR;
6605: END IF;
6606:
6607: process_mes_info ( p_secondary_qty_tbl => p_secondary_qty_tbl,
6608: p_wltx_header => p_wltx_header,

Line 6620: raise FND_API.G_EXC_ERROR;

6616: );
6617:
6618: if x_return_status <> G_RET_SUCCESS then
6619: IF x_return_status = G_RET_ERROR THEN
6620: raise FND_API.G_EXC_ERROR;
6621: ELSE
6622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6623: END IF;
6624: end if;

Line 6622: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6618: if x_return_status <> G_RET_SUCCESS then
6619: IF x_return_status = G_RET_ERROR THEN
6620: raise FND_API.G_EXC_ERROR;
6621: ELSE
6622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6623: END IF;
6624: end if;
6625:
6626: l_txn_status := WIP_CONSTANTS.COMPLETED;

Line 6679: RAISE FND_API.G_EXC_ERROR;

6675: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6676: p_run_log_level => l_log_level
6677: );
6678: END IF;
6679: RAISE FND_API.G_EXC_ERROR;
6680: END IF;
6681:
6682: -- end processing the starting jobs....
6683: l_stmt_num := 530;

Line 6719: RAISE FND_API.G_EXC_ERROR;

6715: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6716: p_run_log_level => l_log_level
6717: );
6718: END IF;
6719: RAISE FND_API.G_EXC_ERROR;
6720: end if;
6721:
6722: l_kanban_card_id := p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id;
6723:

Line 6757: RAISE FND_API.G_EXC_ERROR;

6753: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6754: p_run_log_level => l_log_level
6755: );
6756: END IF;
6757: RAISE FND_API.G_EXC_ERROR;
6758: END IF;
6759:
6760: -- indicates that the compl. subinv has changed hence remove the link to the kanban card id...
6761: if l_sub_loc_change <> 0 then

Line 6778: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then

6774: p_Document_detail_Id => '',
6775: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_rj_index).start_quantity
6776: );
6777:
6778: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
6779:
6780: --x_err_code := -1;
6781: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
6782: fnd_message.set_token('STATUS',g_translated_meaning);

Line 6799: RAISE FND_API.G_EXC_ERROR;

6795: p_run_log_level => l_log_level
6796: );
6797: END IF;
6798:
6799: RAISE FND_API.G_EXC_ERROR;
6800:
6801: end if;
6802:
6803: l_stmt_num := 150;

Line 6892: RAISE FND_API.G_EXC_ERROR;

6888: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6889: p_run_log_level => l_log_level
6890: );
6891: END IF;
6892: RAISE FND_API.G_EXC_ERROR;
6893: END IF;
6894: end if;
6895:
6896: l_stmt_num := 590;

Line 6911: raise FND_API.G_EXC_ERROR;

6907: );
6908:
6909: if x_return_status <> G_RET_SUCCESS then
6910: IF x_return_status = G_RET_ERROR THEN
6911: raise FND_API.G_EXC_ERROR;
6912: ELSE
6913: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6914: END IF;
6915: end if;

Line 6913: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6909: if x_return_status <> G_RET_SUCCESS then
6910: IF x_return_status = G_RET_ERROR THEN
6911: raise FND_API.G_EXC_ERROR;
6912: ELSE
6913: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6914: END IF;
6915: end if;
6916:
6917: -- p_txn_id should be known here....

Line 6919: l_ret_status := FND_API.G_RET_STS_SUCCESS;

6915: end if;
6916:
6917: -- p_txn_id should be known here....
6918: -- call to insert MMT....
6919: l_ret_status := FND_API.G_RET_STS_SUCCESS;
6920: l_msg_data := null;
6921:
6922: Insert_MMT_record ( p_txn_id => p_wltx_header.transaction_id,
6923: p_txn_org_id => p_txn_org_id,

Line 6941: if l_ret_status <> fnd_api.g_ret_sts_success then

6937: );
6938:
6939: l_stmt_num := 390;
6940:
6941: if l_ret_status <> fnd_api.g_ret_sts_success then
6942: -- error out...
6943: l_stmt_num := 395;
6944: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6945:

Line 6956: RAISE FND_API.G_EXC_ERROR;

6952: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6953: p_run_log_level => l_log_level
6954: );
6955: END IF;
6956: RAISE FND_API.G_EXC_ERROR;
6957: end if;
6958:
6959: l_stmt_num := 400;
6960:

Line 7032: RAISE FND_API.G_EXC_ERROR;

7028: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7029: p_run_log_level => l_log_level
7030: );
7031: END IF;
7032: RAISE FND_API.G_EXC_ERROR;
7033:
7034: end if;
7035:
7036: l_bonus_rtg_st_op_seq := p_wltx_resulting_jobs_tbl(l_rj_index).starting_operation_seq_num;

Line 7149: RAISE FND_API.G_EXC_ERROR;

7145: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7146: p_run_log_level => l_log_level
7147: );
7148: END IF;
7149: RAISE FND_API.G_EXC_ERROR;
7150: ELSE
7151: -- success... now the program would have returned the id ....
7152: if( g_log_level_statement >= l_log_level ) then
7153: l_msg_tokens.delete;

Line 7201: RAISE FND_API.G_EXC_ERROR;

7197: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7198: p_run_log_level => l_log_level
7199: );
7200: END IF;
7201: RAISE FND_API.G_EXC_ERROR;
7202: ELSE
7203: if( g_log_level_statement >= l_log_level ) then
7204: l_msg_tokens.delete;
7205: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 7330: RAISE FND_API.G_EXC_ERROR;

7326: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7327: p_run_log_level => l_log_level
7328: );
7329: END IF;
7330: RAISE FND_API.G_EXC_ERROR;
7331: END IF;
7332:
7333: l_stmt_num := 130;
7334: l_ret_status := FND_API.G_RET_STS_SUCCESS;

Line 7334: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7330: RAISE FND_API.G_EXC_ERROR;
7331: END IF;
7332:
7333: l_stmt_num := 130;
7334: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7335: l_msg_count := 0;
7336: l_msg_data := null;
7337:
7338: if( g_log_level_statement >= l_log_level ) then

Line 7365: if l_ret_status <> fnd_api.g_ret_sts_success then

7361: x_return_status => l_ret_status,
7362: x_msg_count => l_msg_count,
7363: x_msg_data => l_msg_data
7364: );
7365: if l_ret_status <> fnd_api.g_ret_sts_success then
7366: -- error out...
7367: l_stmt_num := 395;
7368: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7369:

Line 7380: RAISE FND_API.G_EXC_ERROR;

7376: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7377: p_run_log_level => l_log_level
7378: );
7379: END IF;
7380: RAISE FND_API.G_EXC_ERROR;
7381: end if;
7382:
7383: l_stmt_num := 140;
7384: l_err_code := 0;

Line 7412: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message

7408: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7409: p_run_log_level => l_log_level
7410: );
7411: END IF;
7412: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
7413: END IF;
7414:
7415: -- Begin MES changes
7416: -- Commented out due to insufficient data in sec qty table due to which txns r failing-to be uncommented

Line 7432: raise FND_API.G_EXC_ERROR;

7428: x_error_msg => x_error_msg
7429: );
7430: if x_return_status <> G_RET_SUCCESS then
7431: IF x_return_status = G_RET_ERROR THEN
7432: raise FND_API.G_EXC_ERROR;
7433: ELSE
7434: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7435: END IF;
7436: end if;

Line 7434: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7430: if x_return_status <> G_RET_SUCCESS then
7431: IF x_return_status = G_RET_ERROR THEN
7432: raise FND_API.G_EXC_ERROR;
7433: ELSE
7434: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7435: END IF;
7436: end if;
7437:
7438: -- End MES changes--

Line 7458: raise FND_API.G_EXC_ERROR;

7454: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7455: p_run_log_level => l_log_level
7456: );
7457: END IF;
7458: raise FND_API.G_EXC_ERROR;
7459: end if;
7460:
7461:
7462: l_stmt_num := 500;

Line 7476: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7472: l_stmt_num := 510;
7473: If p_wltx_header.transaction_type_id in (WSMPCNST.UPDATE_QUANTITY,WSMPCNST.UPDATE_ROUTING,WSMPCNST.UPDATE_LOT_NAME) then
7474: l_rj_index := p_wltx_resulting_jobs_tbl.first;
7475: l_stmt_num := 520;
7476: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7477: l_msg_count := 0;
7478: l_msg_data := null;
7479: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
7480: P_old_net_qty => p_wltx_starting_jobs_tbl(l_rep_sj_index).net_quantity,

Line 7490: if l_ret_status <> fnd_api.g_ret_sts_success then

7486: x_msg_count => l_msg_count,
7487: x_msg_data => l_msg_data
7488: ); --this is to handle the change in net qty if any.
7489:
7490: if l_ret_status <> fnd_api.g_ret_sts_success then
7491: -- error out...
7492:
7493: if( g_log_level_statement >= l_log_level ) then
7494:

Line 7505: RAISE FND_API.G_EXC_ERROR;

7501: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7502: p_run_log_level => l_log_level
7503: );
7504: END IF;
7505: RAISE FND_API.G_EXC_ERROR;
7506: END IF;
7507: Else
7508: --Split,SpUA and Update Assembly transaction
7509: l_stmt_num := 530;

Line 7510: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7506: END IF;
7507: Else
7508: --Split,SpUA and Update Assembly transaction
7509: l_stmt_num := 530;
7510: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7511: l_msg_count := 0;
7512: l_msg_data := null;
7513: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7514: p_txn_header => p_wltx_header,

Line 7522: if l_ret_status <> fnd_api.g_ret_sts_success then

7518: p_sj_also_rj_index => l_sj_also_rj_index,
7519: x_return_status => l_ret_status,
7520: x_msg_count => l_msg_count,
7521: x_msg_data => l_msg_data) ;
7522: if l_ret_status <> fnd_api.g_ret_sts_success then
7523: -- error out...
7524: if( g_log_level_statement >= l_log_level ) then
7525:
7526: l_msg_tokens.delete;

Line 7537: RAISE FND_API.G_EXC_ERROR;

7533: p_run_log_level => l_log_level
7534: );
7535: END IF;
7536: --To be reverted
7537: RAISE FND_API.G_EXC_ERROR;
7538: end if;
7539: End if;
7540: End if;
7541: elsif p_wltx_header.transaction_type_id in (WSMPCNST.MERGE) then

Line 7543: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7539: End if;
7540: End if;
7541: elsif p_wltx_header.transaction_type_id in (WSMPCNST.MERGE) then
7542: l_stmt_num := 540;
7543: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7544: l_msg_count := 0;
7545: l_msg_data := null;
7546: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7547: p_txn_header => p_wltx_header,

Line 7555: if l_ret_status <> fnd_api.g_ret_sts_success then

7551: p_sj_also_rj_index => l_sj_also_rj_index,
7552: x_return_status => l_ret_status,
7553: x_msg_count => l_msg_count,
7554: x_msg_data => l_msg_data) ;
7555: if l_ret_status <> fnd_api.g_ret_sts_success then
7556: -- error out...
7557: l_stmt_num := 200;
7558: if( g_log_level_statement >= l_log_level ) then
7559:

Line 7571: --RAISE FND_API.G_EXC_ERROR;

7567: p_run_log_level => l_log_level
7568: );
7569: END IF;
7570: --To be reverted
7571: --RAISE FND_API.G_EXC_ERROR;
7572: end if;
7573: End if;
7574: --End Sales Order LBJ Reservation Changes--
7575:

Line 7586: WHEN FND_API.G_EXC_ERROR THEN

7582: -- end to take care of phantoms--
7583:
7584: EXCEPTION
7585:
7586: WHEN FND_API.G_EXC_ERROR THEN
7587: x_return_status := FND_API.G_RET_STS_ERROR ;
7588:
7589: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7590: p_count => x_msg_count ,

Line 7587: x_return_status := FND_API.G_RET_STS_ERROR ;

7583:
7584: EXCEPTION
7585:
7586: WHEN FND_API.G_EXC_ERROR THEN
7587: x_return_status := FND_API.G_RET_STS_ERROR ;
7588:
7589: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7590: p_count => x_msg_count ,
7591: p_data => x_error_msg

Line 7594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7590: p_count => x_msg_count ,
7591: p_data => x_error_msg
7592: );
7593:
7594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7595:
7596: x_return_status := G_RET_UNEXPECTED;
7597:
7598: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR