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 3303: RAISE FND_API.G_EXC_ERROR;

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

Line 3354: RAISE FND_API.G_EXC_ERROR;

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

Line 3402: WHEN FND_API.G_EXC_ERROR THEN

3398: x_err_buf := NULL;
3399:
3400:
3401: EXCEPTION
3402: WHEN FND_API.G_EXC_ERROR THEN
3403: x_err_code := SQLCODE;
3404: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3405: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3406: p_count => x_msg_count ,

Line 3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3405: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3406: p_count => x_msg_count ,
3407: p_data => x_err_buf
3408: );
3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3410: x_err_code := SQLCODE;
3411: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3412: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3413: p_count => x_msg_count ,

Line 3516: RAISE FND_API.G_EXC_ERROR;

3512: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3513: p_run_log_level => l_log_level
3514: );
3515: END IF;
3516: RAISE FND_API.G_EXC_ERROR;
3517:
3518: END IF;
3519:
3520: -- indicates that the compl. subinv has changed hence remove the link to the kanban card id...

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

3561: p_Kanban_Card_Id => l_job_kanban_card_id,
3562: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
3563: );
3564:
3565: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
3566: x_err_code := -1;
3567: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
3568:
3569: fnd_message.set_token('STATUS',g_translated_meaning);

Line 3586: RAISE FND_API.G_EXC_ERROR;

3582: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3583: p_run_log_level => l_log_level
3584: );
3585: END IF;
3586: RAISE FND_API.G_EXC_ERROR;
3587:
3588: end if;
3589:
3590: l_job_kanban_card_id := null;

Line 3649: RAISE FND_API.G_EXC_ERROR;

3645: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3646: p_run_log_level => l_log_level
3647: );
3648: END IF;
3649: RAISE FND_API.G_EXC_ERROR;
3650: ELSE
3651:
3652: IF (l_new_op_added IS NOT NULL) THEN -- Added condition check for APS-WLT --
3653: if( g_log_level_statement >= l_log_level ) then

Line 3727: WHEN FND_API.G_EXC_ERROR THEN

3723: x_err_code := 0;
3724: x_err_buf := null;
3725:
3726: EXCEPTION
3727: WHEN FND_API.G_EXC_ERROR THEN
3728: x_err_code := -1;
3729: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3730: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3731: p_count => x_msg_count ,

Line 3735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3731: p_count => x_msg_count ,
3732: p_data => x_err_buf
3733: );
3734:
3735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3736: x_err_code := -1;
3737: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3738: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3739: p_count => x_msg_count ,

Line 3827: RAISE FND_API.G_EXC_ERROR;

3823: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
3824: p_run_log_level => l_log_level
3825: );
3826: END IF;
3827: RAISE FND_API.G_EXC_ERROR;
3828: END IF;
3829:
3830: l_stmt_num := 30;
3831:

Line 3932: x_return_status := fnd_api.g_ret_sts_success;

3928:
3929: end if;
3930:
3931: /* set the return status to succes... */
3932: x_return_status := fnd_api.g_ret_sts_success;
3933:
3934: exception
3935: WHEN FND_API.G_EXC_ERROR THEN
3936:

Line 3935: WHEN FND_API.G_EXC_ERROR THEN

3931: /* set the return status to succes... */
3932: x_return_status := fnd_api.g_ret_sts_success;
3933:
3934: exception
3935: WHEN FND_API.G_EXC_ERROR THEN
3936:
3937: x_return_status := G_RET_ERROR;
3938: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3939: p_count => x_msg_count ,

Line 3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3939: p_count => x_msg_count ,
3940: p_data => x_msg_data
3941: );
3942:
3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944:
3945: x_return_status := G_RET_UNEXPECTED;
3946:
3947: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',

Line 3953: x_return_status := fnd_api.g_ret_sts_error;

3949: p_data => x_msg_data
3950: );
3951: when others then
3952: /* handle it... */
3953: x_return_status := fnd_api.g_ret_sts_error;
3954: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) THEN
3955:
3956: l_msg_tokens.delete;
3957: WSM_log_PVT.logMessage (p_module_name => l_module ,

Line 4122: RAISE FND_API.G_EXC_ERROR;

4118: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4119: p_run_log_level => l_log_level
4120: );
4121: END IF;
4122: RAISE FND_API.G_EXC_ERROR;
4123: END IF;
4124:
4125: if( g_log_level_statement >= l_log_level ) then
4126: l_msg_tokens.delete;

Line 4238: RAISE FND_API.G_EXC_ERROR;

4234: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4235: p_run_log_level => l_log_level
4236: );
4237: END IF;
4238: RAISE FND_API.G_EXC_ERROR;
4239: END IF;
4240:
4241: l_stmt_num := 70;
4242:

Line 4383: RAISE FND_API.G_EXC_ERROR;

4379: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4380: p_run_log_level => l_log_level
4381: );
4382: END IF;
4383: RAISE FND_API.G_EXC_ERROR;
4384: END IF;
4385:
4386: if( g_log_level_statement >= l_log_level ) then
4387: l_msg_tokens.delete;

Line 4515: RAISE FND_API.G_EXC_ERROR;

4511: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4512: p_run_log_level => l_log_level
4513: );
4514: END IF;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;
4517:
4518: if( g_log_level_statement >= l_log_level ) then
4519: l_msg_tokens.delete;

Line 4561: WHEN FND_API.G_EXC_ERROR THEN

4557: l_stmt_num := 160;
4558: x_err_code := 0;
4559:
4560: EXCEPTION
4561: WHEN FND_API.G_EXC_ERROR THEN
4562: x_err_code := SQLCODE;
4563: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4564:
4565: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',

Line 4570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4566: p_count => x_msg_count ,
4567: p_data => x_err_buf
4568: );
4569:
4570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4571:
4572: x_err_code := SQLCODE;
4573: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4574:

Line 4671: RAISE FND_API.G_EXC_ERROR;

4667: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4668: p_run_log_level => l_log_level
4669: );
4670: END IF;
4671: RAISE FND_API.G_EXC_ERROR;
4672: END IF;
4673:
4674: l_stmt_num := 40;
4675:

Line 4682: p_initMsgList => FND_API.g_true,

4678: l_stmt_num := 50;
4679:
4680: WSM_infinite_scheduler_PVT.schedule
4681: (
4682: p_initMsgList => FND_API.g_true,
4683: p_endDebug => FND_API.g_true,
4684: p_orgID => p_org_id,
4685: p_wipEntityID => p_par_we_id,
4686: p_scheduleMode => l_schedule_mode,

Line 4683: p_endDebug => FND_API.g_true,

4679:
4680: WSM_infinite_scheduler_PVT.schedule
4681: (
4682: p_initMsgList => FND_API.g_true,
4683: p_endDebug => FND_API.g_true,
4684: p_orgID => p_org_id,
4685: p_wipEntityID => p_par_we_id,
4686: p_scheduleMode => l_schedule_mode,
4687: p_startDate => l_job_op_start_dt,

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

4691: x_returnStatus => l_returnStatus,
4692: x_errorMsg => x_err_buf
4693: );
4694:
4695: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4696: x_err_code := -1;
4697: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4698: l_msg_tokens.delete;
4699: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 4708: RAISE FND_API.G_EXC_ERROR;

4704: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
4705: p_run_log_level => l_log_level
4706: );
4707: END IF;
4708: RAISE FND_API.G_EXC_ERROR;
4709: ELSE
4710: x_err_code := 0;
4711: END IF;
4712:

Line 4726: WHEN FND_API.G_EXC_ERROR THEN

4722:
4723: l_stmt_num := 70;
4724:
4725: EXCEPTION
4726: WHEN FND_API.G_EXC_ERROR THEN
4727:
4728: x_err_code := SQLCODE;
4729: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4730: /*

Line 4736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4732: p_count => x_msg_count ,
4733: p_data => x_err_buf
4734: );
4735: */
4736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4737:
4738: x_err_code := SQLCODE;
4739: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4740: /*

Line 4867: raise FND_API.G_EXC_ERROR;

4863: );
4864:
4865: if x_return_status <> G_RET_SUCCESS then
4866: IF x_return_status = G_RET_ERROR THEN
4867: raise FND_API.G_EXC_ERROR;
4868: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4869: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4870: END IF;
4871: end if;

Line 4869: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4865: if x_return_status <> G_RET_SUCCESS then
4866: IF x_return_status = G_RET_ERROR THEN
4867: raise FND_API.G_EXC_ERROR;
4868: ELSIF x_return_status = G_RET_UNEXPECTED THEN
4869: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4870: END IF;
4871: end if;
4872: End if;
4873:

Line 5072: RAISE FND_API.G_EXC_ERROR;

5068: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5069: p_run_log_level => l_log_level
5070: );
5071: END IF;
5072: RAISE FND_API.G_EXC_ERROR;
5073: ELSE
5074: -- success... now the program would have returned the id ....
5075: if( g_log_level_statement >= l_log_level ) then
5076: l_msg_tokens.delete;

Line 5203: RAISE FND_API.G_EXC_ERROR;

5199: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5200: p_run_log_level => l_log_level
5201: );
5202: END IF;
5203: RAISE FND_API.G_EXC_ERROR;
5204:
5205: ELSE
5206: -- success... now the program would have returned the id ....
5207: if( g_log_level_statement >= l_log_level ) then

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

5268: p_Document_detail_Id => '',
5269: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity
5270: );
5271:
5272: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5273: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5274:
5275: l_msg_tokens.delete;
5276: l_msg_tokens(1).TokenName := 'STATUS';

Line 5288: RAISE FND_API.G_EXC_ERROR;

5284: p_run_log_level => l_log_level
5285: );
5286: END IF;
5287:
5288: RAISE FND_API.G_EXC_ERROR;
5289:
5290: end if;
5291:
5292: p_wltx_resulting_jobs_tbl(l_job_counter).kanban_card_id := l_kanban_card_id;

Line 5359: RAISE FND_API.G_EXC_ERROR;

5355: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5356: p_run_log_level => l_log_level
5357: );
5358: END IF;
5359: RAISE FND_API.G_EXC_ERROR;
5360: END IF;
5361:
5362:
5363: l_stmt_num := 230;

Line 5398: RAISE FND_API.G_EXC_ERROR;

5394: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5395: p_run_log_level => l_log_level
5396: );
5397: END IF;
5398: RAISE FND_API.G_EXC_ERROR;
5399: END IF;
5400:
5401:
5402: -- Related bugs : 3142153

Line 5445: RAISE FND_API.G_EXC_ERROR;

5441: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5442: p_run_log_level => l_log_level
5443: );
5444: END IF;
5445: RAISE FND_API.G_EXC_ERROR;
5446: END IF;
5447: END IF;
5448:
5449: --End: Additions for APS-WLT--

Line 5476: RAISE FND_API.G_EXC_ERROR;

5472: p_fnd_log_level => G_LOG_LEVEL_ERROR,
5473: p_run_log_level => l_log_level
5474: );
5475: END IF;
5476: RAISE FND_API.G_EXC_ERROR;
5477: END IF;
5478: /* ST : Detailed Scheduling end */
5479:
5480: l_stmt_num := 250;

Line 5519: RAISE FND_API.G_EXC_ERROR;

5515: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5516: p_run_log_level => l_log_level
5517: );
5518: END IF;
5519: RAISE FND_API.G_EXC_ERROR;
5520: END IF;
5521:
5522:
5523: l_stmt_num := 260;

Line 5558: RAISE FND_API.G_EXC_ERROR;

5554: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5555: p_run_log_level => l_log_level
5556: );
5557: END IF;
5558: RAISE FND_API.G_EXC_ERROR;
5559: END IF;
5560:
5561: -- ok now process the starting jobs...
5562: if( g_log_level_statement >= l_log_level ) then

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

5640: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id,
5641: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5642: );
5643:
5644: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5645:
5646: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5647:
5648: l_msg_tokens.delete;

Line 5660: RAISE FND_API.G_EXC_ERROR;

5656: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5657: p_run_log_level => l_log_level
5658: );
5659: END IF;
5660: RAISE FND_API.G_EXC_ERROR;
5661:
5662: end if;
5663:
5664: l_stmt_num := 125;

Line 5705: RAISE FND_API.G_EXC_ERROR;

5701: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5702: p_run_log_level => l_log_level
5703: );
5704: END IF;
5705: RAISE FND_API.G_EXC_ERROR;
5706: END IF;
5707:
5708: -- indicates that the compl. subinv has changed hence remove the link to the kanban card id...
5709: if l_sub_loc_change <> 0 then

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

5733: p_Document_detail_Id => '',
5734: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity
5735: );
5736:
5737: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5738: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5739:
5740: l_msg_tokens.delete;
5741: l_msg_tokens(1).TokenName := 'STATUS';

Line 5752: RAISE FND_API.G_EXC_ERROR;

5748: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5749: p_run_log_level => l_log_level
5750: );
5751: END IF;
5752: RAISE FND_API.G_EXC_ERROR;
5753:
5754: end if;
5755:
5756: l_stmt_num := 150;

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

5839: p_Kanban_Card_Id => p_wltx_starting_jobs_tbl(l_job_counter).kanban_card_id,
5840: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5841: );
5842:
5843: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5844: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5845:
5846: l_msg_tokens.delete;
5847: l_msg_tokens(1).TokenName := 'STATUS';

Line 5858: RAISE FND_API.G_EXC_ERROR;

5854: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5855: p_run_log_level => l_log_level
5856: );
5857: END IF;
5858: RAISE FND_API.G_EXC_ERROR;
5859: end if;
5860:
5861: l_stmt_num := 137;
5862: --Bug 5344676:Commented out the following line

Line 5915: RAISE FND_API.G_EXC_ERROR;

5911: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5912: p_run_log_level => l_log_level
5913: );
5914: END IF;
5915: RAISE FND_API.G_EXC_ERROR;
5916: else
5917: -- success.. got the new name for the job ...
5918: if( g_log_level_statement >= l_log_level ) then
5919: l_msg_tokens.delete;

Line 5983: RAISE FND_API.G_EXC_ERROR;

5979: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
5980: p_run_log_level => l_log_level
5981: );
5982: END IF;
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;
5985:
5986: l_stmt_num := 270;
5987: if( g_log_level_statement >= l_log_level ) then

Line 6028: RAISE FND_API.G_EXC_ERROR;

6024: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6025: p_run_log_level => l_log_level
6026: );
6027: END IF;
6028: RAISE FND_API.G_EXC_ERROR;
6029: end if;
6030:
6031: l_stmt_num := 280;
6032:

Line 6085: RAISE FND_API.G_EXC_ERROR;

6081: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6082: p_run_log_level => l_log_level
6083: );
6084: END IF;
6085: RAISE FND_API.G_EXC_ERROR;
6086: END IF;
6087: end if;
6088:
6089: l_job_counter := p_wltx_resulting_jobs_tbl.next(l_job_counter);

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

6155: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6156: p_run_log_level => l_log_level
6157: );
6158: END IF;
6159: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
6160: END IF;
6161:
6162: -- New Jobs in Split/Merge, jobs undergoing SPUA and jobs involved in Upd Rtg/Assly
6163: -- have already been either Infinite Scheduled or the data has been set for them

Line 6200: RAISE FND_API.G_EXC_ERROR;

6196: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6197: p_run_log_level => l_log_level
6198: );
6199: END IF;
6200: RAISE FND_API.G_EXC_ERROR;
6201: END IF;
6202:
6203: END IF;
6204:

Line 6221: raise FND_API.G_EXC_ERROR;

6217: x_error_msg => x_error_msg
6218: );
6219: if x_return_status <> G_RET_SUCCESS then
6220: IF x_return_status = G_RET_ERROR THEN
6221: raise FND_API.G_EXC_ERROR;
6222: ELSE
6223: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6224: END IF;
6225: end if;

Line 6223: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6219: if x_return_status <> G_RET_SUCCESS then
6220: IF x_return_status = G_RET_ERROR THEN
6221: raise FND_API.G_EXC_ERROR;
6222: ELSE
6223: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6224: END IF;
6225: end if;
6226:
6227: l_stmt_num := 330;

Line 6325: RAISE FND_API.G_EXC_ERROR;

6321:
6322: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6323:
6324: END IF;
6325: RAISE FND_API.G_EXC_ERROR;
6326: END IF;
6327:
6328: end loop;
6329: else

Line 6426: RAISE FND_API.G_EXC_ERROR;

6422:
6423: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6424:
6425: END IF;
6426: RAISE FND_API.G_EXC_ERROR;
6427: END IF;
6428:
6429: end loop;
6430:

Line 6454: if l_ret_status <> fnd_api.g_ret_sts_success then

6450: );
6451:
6452: l_stmt_num := 390;
6453:
6454: if l_ret_status <> fnd_api.g_ret_sts_success then
6455: -- error out...
6456: l_stmt_num := 395;
6457: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6458: l_msg_tokens.delete;

Line 6468: RAISE FND_API.G_EXC_ERROR;

6464: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6465: p_run_log_level => l_log_level
6466: );
6467: END IF;
6468: RAISE FND_API.G_EXC_ERROR;
6469: end if;
6470:
6471: l_stmt_num := 400;
6472:

Line 6509: RAISE FND_API.G_EXC_ERROR;

6505: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6506: p_run_log_level => l_log_level
6507: );
6508: END IF;
6509: RAISE FND_API.G_EXC_ERROR;
6510: END IF;
6511:
6512: l_stmt_num := 510;
6513: l_err_code := 0;

Line 6540: RAISE FND_API.G_EXC_ERROR;

6536: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6537: p_run_log_level => l_log_level
6538: );
6539: END IF;
6540: RAISE FND_API.G_EXC_ERROR;
6541: END IF;
6542:
6543: process_mes_info ( p_secondary_qty_tbl => p_secondary_qty_tbl,
6544: p_wltx_header => p_wltx_header,

Line 6556: raise FND_API.G_EXC_ERROR;

6552: );
6553:
6554: if x_return_status <> G_RET_SUCCESS then
6555: IF x_return_status = G_RET_ERROR THEN
6556: raise FND_API.G_EXC_ERROR;
6557: ELSE
6558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6559: END IF;
6560: end if;

Line 6558: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6554: if x_return_status <> G_RET_SUCCESS then
6555: IF x_return_status = G_RET_ERROR THEN
6556: raise FND_API.G_EXC_ERROR;
6557: ELSE
6558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6559: END IF;
6560: end if;
6561:
6562: l_txn_status := WIP_CONSTANTS.COMPLETED;

Line 6615: RAISE FND_API.G_EXC_ERROR;

6611: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6612: p_run_log_level => l_log_level
6613: );
6614: END IF;
6615: RAISE FND_API.G_EXC_ERROR;
6616: END IF;
6617:
6618: -- end processing the starting jobs....
6619: l_stmt_num := 530;

Line 6655: RAISE FND_API.G_EXC_ERROR;

6651: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6652: p_run_log_level => l_log_level
6653: );
6654: END IF;
6655: RAISE FND_API.G_EXC_ERROR;
6656: end if;
6657:
6658: l_kanban_card_id := p_wltx_starting_jobs_tbl(l_rep_sj_index).kanban_card_id;
6659:

Line 6693: RAISE FND_API.G_EXC_ERROR;

6689: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6690: p_run_log_level => l_log_level
6691: );
6692: END IF;
6693: RAISE FND_API.G_EXC_ERROR;
6694: END IF;
6695:
6696: -- indicates that the compl. subinv has changed hence remove the link to the kanban card id...
6697: if l_sub_loc_change <> 0 then

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

6710: p_Document_detail_Id => '',
6711: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_rj_index).start_quantity
6712: );
6713:
6714: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
6715:
6716: --x_err_code := -1;
6717: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
6718: fnd_message.set_token('STATUS',g_translated_meaning);

Line 6735: RAISE FND_API.G_EXC_ERROR;

6731: p_run_log_level => l_log_level
6732: );
6733: END IF;
6734:
6735: RAISE FND_API.G_EXC_ERROR;
6736:
6737: end if;
6738:
6739: l_stmt_num := 150;

Line 6828: RAISE FND_API.G_EXC_ERROR;

6824: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6825: p_run_log_level => l_log_level
6826: );
6827: END IF;
6828: RAISE FND_API.G_EXC_ERROR;
6829: END IF;
6830: end if;
6831:
6832: l_stmt_num := 590;

Line 6847: raise FND_API.G_EXC_ERROR;

6843: );
6844:
6845: if x_return_status <> G_RET_SUCCESS then
6846: IF x_return_status = G_RET_ERROR THEN
6847: raise FND_API.G_EXC_ERROR;
6848: ELSE
6849: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6850: END IF;
6851: end if;

Line 6849: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6845: if x_return_status <> G_RET_SUCCESS then
6846: IF x_return_status = G_RET_ERROR THEN
6847: raise FND_API.G_EXC_ERROR;
6848: ELSE
6849: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6850: END IF;
6851: end if;
6852:
6853: -- p_txn_id should be known here....

Line 6855: l_ret_status := FND_API.G_RET_STS_SUCCESS;

6851: end if;
6852:
6853: -- p_txn_id should be known here....
6854: -- call to insert MMT....
6855: l_ret_status := FND_API.G_RET_STS_SUCCESS;
6856: l_msg_data := null;
6857:
6858: Insert_MMT_record ( p_txn_id => p_wltx_header.transaction_id,
6859: p_txn_org_id => p_txn_org_id,

Line 6877: if l_ret_status <> fnd_api.g_ret_sts_success then

6873: );
6874:
6875: l_stmt_num := 390;
6876:
6877: if l_ret_status <> fnd_api.g_ret_sts_success then
6878: -- error out...
6879: l_stmt_num := 395;
6880: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6881:

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:
6895: l_stmt_num := 400;
6896:

Line 6968: RAISE FND_API.G_EXC_ERROR;

6964: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
6965: p_run_log_level => l_log_level
6966: );
6967: END IF;
6968: RAISE FND_API.G_EXC_ERROR;
6969:
6970: end if;
6971:
6972: l_bonus_rtg_st_op_seq := p_wltx_resulting_jobs_tbl(l_rj_index).starting_operation_seq_num;

Line 7085: RAISE FND_API.G_EXC_ERROR;

7081: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7082: p_run_log_level => l_log_level
7083: );
7084: END IF;
7085: RAISE FND_API.G_EXC_ERROR;
7086: ELSE
7087: -- success... now the program would have returned the id ....
7088: if( g_log_level_statement >= l_log_level ) then
7089: l_msg_tokens.delete;

Line 7137: RAISE FND_API.G_EXC_ERROR;

7133: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7134: p_run_log_level => l_log_level
7135: );
7136: END IF;
7137: RAISE FND_API.G_EXC_ERROR;
7138: ELSE
7139: if( g_log_level_statement >= l_log_level ) then
7140: l_msg_tokens.delete;
7141: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 7266: RAISE FND_API.G_EXC_ERROR;

7262: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7263: p_run_log_level => l_log_level
7264: );
7265: END IF;
7266: RAISE FND_API.G_EXC_ERROR;
7267: END IF;
7268:
7269: l_stmt_num := 130;
7270: l_ret_status := FND_API.G_RET_STS_SUCCESS;

Line 7270: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7266: RAISE FND_API.G_EXC_ERROR;
7267: END IF;
7268:
7269: l_stmt_num := 130;
7270: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7271: l_msg_count := 0;
7272: l_msg_data := null;
7273:
7274: if( g_log_level_statement >= l_log_level ) then

Line 7301: if l_ret_status <> fnd_api.g_ret_sts_success then

7297: x_return_status => l_ret_status,
7298: x_msg_count => l_msg_count,
7299: x_msg_data => l_msg_data
7300: );
7301: if l_ret_status <> fnd_api.g_ret_sts_success then
7302: -- error out...
7303: l_stmt_num := 395;
7304: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7305:

Line 7316: RAISE FND_API.G_EXC_ERROR;

7312: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7313: p_run_log_level => l_log_level
7314: );
7315: END IF;
7316: RAISE FND_API.G_EXC_ERROR;
7317: end if;
7318:
7319: l_stmt_num := 140;
7320: l_err_code := 0;

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

7344: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7345: p_run_log_level => l_log_level
7346: );
7347: END IF;
7348: RAISE FND_API.G_EXC_ERROR; --x_err_code has errcode, x_err_buf has the error message
7349: END IF;
7350:
7351: -- Begin MES changes
7352: -- Commented out due to insufficient data in sec qty table due to which txns r failing-to be uncommented

Line 7368: raise FND_API.G_EXC_ERROR;

7364: x_error_msg => x_error_msg
7365: );
7366: if x_return_status <> G_RET_SUCCESS then
7367: IF x_return_status = G_RET_ERROR THEN
7368: raise FND_API.G_EXC_ERROR;
7369: ELSE
7370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7371: END IF;
7372: end if;

Line 7370: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7366: if x_return_status <> G_RET_SUCCESS then
7367: IF x_return_status = G_RET_ERROR THEN
7368: raise FND_API.G_EXC_ERROR;
7369: ELSE
7370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7371: END IF;
7372: end if;
7373:
7374: -- End MES changes--

Line 7394: raise FND_API.G_EXC_ERROR;

7390: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7391: p_run_log_level => l_log_level
7392: );
7393: END IF;
7394: raise FND_API.G_EXC_ERROR;
7395: end if;
7396:
7397:
7398: l_stmt_num := 500;

Line 7412: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7408: l_stmt_num := 510;
7409: If p_wltx_header.transaction_type_id in (WSMPCNST.UPDATE_QUANTITY,WSMPCNST.UPDATE_ROUTING,WSMPCNST.UPDATE_LOT_NAME) then
7410: l_rj_index := p_wltx_resulting_jobs_tbl.first;
7411: l_stmt_num := 520;
7412: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7413: l_msg_count := 0;
7414: l_msg_data := null;
7415: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(p_wip_entity_id => p_wltx_starting_jobs_tbl(l_rep_sj_index).wip_entity_id,
7416: P_old_net_qty => p_wltx_starting_jobs_tbl(l_rep_sj_index).net_quantity,

Line 7426: if l_ret_status <> fnd_api.g_ret_sts_success then

7422: x_msg_count => l_msg_count,
7423: x_msg_data => l_msg_data
7424: ); --this is to handle the change in net qty if any.
7425:
7426: if l_ret_status <> fnd_api.g_ret_sts_success then
7427: -- error out...
7428:
7429: if( g_log_level_statement >= l_log_level ) then
7430:

Line 7441: RAISE FND_API.G_EXC_ERROR;

7437: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
7438: p_run_log_level => l_log_level
7439: );
7440: END IF;
7441: RAISE FND_API.G_EXC_ERROR;
7442: END IF;
7443: Else
7444: --Split,SpUA and Update Assembly transaction
7445: l_stmt_num := 530;

Line 7446: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7442: END IF;
7443: Else
7444: --Split,SpUA and Update Assembly transaction
7445: l_stmt_num := 530;
7446: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7447: l_msg_count := 0;
7448: l_msg_data := null;
7449: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7450: p_txn_header => p_wltx_header,

Line 7458: if l_ret_status <> fnd_api.g_ret_sts_success then

7454: p_sj_also_rj_index => l_sj_also_rj_index,
7455: x_return_status => l_ret_status,
7456: x_msg_count => l_msg_count,
7457: x_msg_data => l_msg_data) ;
7458: if l_ret_status <> fnd_api.g_ret_sts_success then
7459: -- error out...
7460: if( g_log_level_statement >= l_log_level ) then
7461:
7462: l_msg_tokens.delete;

Line 7473: RAISE FND_API.G_EXC_ERROR;

7469: p_run_log_level => l_log_level
7470: );
7471: END IF;
7472: --To be reverted
7473: RAISE FND_API.G_EXC_ERROR;
7474: end if;
7475: End if;
7476: End if;
7477: elsif p_wltx_header.transaction_type_id in (WSMPCNST.MERGE) then

Line 7479: l_ret_status := FND_API.G_RET_STS_SUCCESS;

7475: End if;
7476: End if;
7477: elsif p_wltx_header.transaction_type_id in (WSMPCNST.MERGE) then
7478: l_stmt_num := 540;
7479: l_ret_status := FND_API.G_RET_STS_SUCCESS;
7480: l_msg_count := 0;
7481: l_msg_data := null;
7482: WSM_RESERVATIONS_PVT.modify_reservations_wlt (
7483: p_txn_header => p_wltx_header,

Line 7491: if l_ret_status <> fnd_api.g_ret_sts_success then

7487: p_sj_also_rj_index => l_sj_also_rj_index,
7488: x_return_status => l_ret_status,
7489: x_msg_count => l_msg_count,
7490: x_msg_data => l_msg_data) ;
7491: if l_ret_status <> fnd_api.g_ret_sts_success then
7492: -- error out...
7493: l_stmt_num := 200;
7494: if( g_log_level_statement >= l_log_level ) then
7495:

Line 7507: --RAISE FND_API.G_EXC_ERROR;

7503: p_run_log_level => l_log_level
7504: );
7505: END IF;
7506: --To be reverted
7507: --RAISE FND_API.G_EXC_ERROR;
7508: end if;
7509: End if;
7510: --End Sales Order LBJ Reservation Changes--
7511:

Line 7522: WHEN FND_API.G_EXC_ERROR THEN

7518: -- end to take care of phantoms--
7519:
7520: EXCEPTION
7521:
7522: WHEN FND_API.G_EXC_ERROR THEN
7523: x_return_status := FND_API.G_RET_STS_ERROR ;
7524:
7525: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7526: p_count => x_msg_count ,

Line 7523: x_return_status := FND_API.G_RET_STS_ERROR ;

7519:
7520: EXCEPTION
7521:
7522: WHEN FND_API.G_EXC_ERROR THEN
7523: x_return_status := FND_API.G_RET_STS_ERROR ;
7524:
7525: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7526: p_count => x_msg_count ,
7527: p_data => x_error_msg

Line 7530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7526: p_count => x_msg_count ,
7527: p_data => x_error_msg
7528: );
7529:
7530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7531:
7532: x_return_status := G_RET_UNEXPECTED;
7533:
7534: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR