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

Line 39: x_returnStatus := fnd_api.g_ret_sts_success;

35: from fnd_attached_documents fad
36: where fad.pk1_value = to_char(wo.operation_sequence_id)
37: and fad.entity_name = 'BOM_OPERATION_SEQUENCES');
38: begin
39: x_returnStatus := fnd_api.g_ret_sts_success;
40: if (l_logLevel <= wip_constants.trace_logging) then
41: l_params(1).paramName := 'p_orgID';
42: l_params(1).paramValue := p_orgID;
43: l_params(2).paramName := 'p_wipEntityID';

Line 62: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

58: l_params(9).paramValue := p_endDate;
59: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
60: p_params => l_params,
61: x_returnStatus => x_returnStatus);
62: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
63: raise fnd_api.g_exc_unexpected_error;
64: end if;
65: end if;
66:

Line 63: raise fnd_api.g_exc_unexpected_error;

59: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
60: p_params => l_params,
61: x_returnStatus => x_returnStatus);
62: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
63: raise fnd_api.g_exc_unexpected_error;
64: end if;
65: end if;
66:
67: begin

Line 579: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

575: p_procReturnStatus => x_returnStatus,
576: p_msg => 'unexp error:' || SQLERRM,
577: x_returnStatus => l_retStatus);
578: end if;
579: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
580: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
581: p_procedure_name => l_procName,
582: p_error_text => SQLERRM);
583: wip_utilities.get_message_stack(p_msg => l_msg);

Line 638: x_returnStatus := fnd_api.g_ret_sts_success;

634: and operation_seq_num < 0
635: and wip_supply_type = wip_constants.phantom;
636:
637: begin
638: x_returnStatus := fnd_api.g_ret_sts_success;
639: if (l_logLevel <= wip_constants.trace_logging) then
640: l_params(1).paramName := 'p_orgID';
641: l_params(1).paramValue := p_orgID;
642: l_params(2).paramName := 'p_wipEntityID';

Line 669: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

665: l_params(13).paramValue := p_taskID;
666: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
667: p_params => l_params,
668: x_returnStatus => x_returnStatus);
669: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
670: raise fnd_api.g_exc_unexpected_error;
671: end if;
672: end if;
673:

Line 670: raise fnd_api.g_exc_unexpected_error;

666: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
667: p_params => l_params,
668: x_returnStatus => x_returnStatus);
669: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
670: raise fnd_api.g_exc_unexpected_error;
671: end if;
672: end if;
673:
674: l_entityType := wip_constants.discrete;

Line 696: p_initMsgList => fnd_api.g_false,

692: p_bomRevDate => p_bomRevDate,
693: p_txnDate => null,
694: p_projectID => p_projectID,
695: p_taskID => p_taskID,
696: p_initMsgList => fnd_api.g_false,
697: p_endDebug => fnd_api.g_false,
698: x_compTbl => l_compTbl,
699: x_returnStatus => x_returnStatus);
700: */

Line 697: p_endDebug => fnd_api.g_false,

693: p_txnDate => null,
694: p_projectID => p_projectID,
695: p_taskID => p_taskID,
696: p_initMsgList => fnd_api.g_false,
697: p_endDebug => fnd_api.g_false,
698: x_compTbl => l_compTbl,
699: x_returnStatus => x_returnStatus);
700: */
701:

Line 719: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then

715: p_txnFlag => false, /* for bug4538135 */ /* ER 4369064 */
716: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
717: x_compTbl => l_compTbl,
718: x_returnStatus => x_returnStatus);
719: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
720: raise fnd_api.g_exc_unexpected_error;
721: end if;
722:
723: begin

Line 720: raise fnd_api.g_exc_unexpected_error;

716: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
717: x_compTbl => l_compTbl,
718: x_returnStatus => x_returnStatus);
719: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
720: raise fnd_api.g_exc_unexpected_error;
721: end if;
722:
723: begin
724: select nvl(min(operation_seq_num), 1)

Line 802: raise fnd_api.g_exc_unexpected_error;

798: and wro.wip_entity_id = p_wipEntityID
799: and wro.operation_seq_num = l_wro_op;
800:
801: if( l_diff_basis > 1 ) then
802: raise fnd_api.g_exc_unexpected_error;
803: elsif( l_diff_basis = 1 ) then
804: if( (l_compTbl(l_count).basis_type is null and l_basis = 1 )
805: or l_compTbl(l_count).basis_type = l_basis ) then
806: update wip_requirement_operations wro

Line 824: x_returnStatus := fnd_api.g_ret_sts_error;

820: and wro.organization_id = p_orgID
821: and wro.wip_entity_id = p_wipEntityID
822: and wro.operation_seq_num = l_wro_op;
823: else
824: x_returnStatus := fnd_api.g_ret_sts_error;
825: fnd_message.set_name('WIP', 'WIP_COMP_DUP_OP_ONE');
826: fnd_msg_pub.add;
827: if (l_logLevel <= wip_constants.full_logging) then
828: wip_logger.log(p_msg => 'Item ' || l_compTbl(l_count).inventory_item_id ||

Line 924: if (x_returnStatus <> fnd_api.g_ret_sts_success) then

920: p_org_id => p_orgID,
921: x_return_status => x_returnStatus,
922: x_msg_data => x_errorMsg );
923:
924: if (x_returnStatus <> fnd_api.g_ret_sts_success) then
925: if (l_logLevel <= wip_constants.full_logging) then
926: wip_logger.log(p_msg => 'Post_Explosion_Cleanup failed for wip_entity_id '||p_wipEntityID,
927: x_returnStatus => x_returnStatus);
928: end if;

Line 1040: when fnd_api.g_exc_unexpected_error then

1036: p_msg => 'success',
1037: x_returnStatus => l_retStatus);
1038: end if;
1039: exception
1040: when fnd_api.g_exc_unexpected_error then
1041: if (l_logLevel <= wip_constants.trace_logging) then
1042: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1043: p_procReturnStatus => x_returnStatus,
1044: p_msg => 'failed at exploding requirements',

Line 1054: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1050: p_procReturnStatus => x_returnStatus,
1051: p_msg => 'unexp error:' || SQLERRM,
1052: x_returnStatus => l_retStatus);
1053: end if;
1054: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
1056: p_procedure_name => l_procName,
1057: p_error_text => SQLERRM);
1058: wip_utilities.get_message_stack(p_msg => l_msg);

Line 1080: x_returnStatus := fnd_api.g_ret_sts_success;

1076: l_minOp number;
1077: l_updateFlag number :=0;/* add for Bug 8413228 (FP of 8392916).*/
1078: begin
1079:
1080: x_returnStatus := fnd_api.g_ret_sts_success;
1081: if (l_logLevel <= wip_constants.trace_logging) then
1082: l_params(1).paramName := 'p_orgID';
1083: l_params(1).paramValue := p_orgID;
1084: l_params(2).paramName := 'p_wipEntityID';

Line 1091: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

1087: l_params(3).paramValue := p_qty;
1088: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
1089: p_params => l_params,
1090: x_returnStatus => x_returnStatus);
1091: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1092: raise fnd_api.g_exc_unexpected_error;
1093: end if;
1094: end if;
1095:

Line 1092: raise fnd_api.g_exc_unexpected_error;

1088: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
1089: p_params => l_params,
1090: x_returnStatus => x_returnStatus);
1091: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1092: raise fnd_api.g_exc_unexpected_error;
1093: end if;
1094: end if;
1095:
1096:

Line 1121: select nvl(min(operation_seq_num), fnd_api.g_miss_num)

1117: end if;
1118:
1119:
1120: if ( l_jobStatus <> wip_constants.unreleased ) then
1121: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
1122: into l_minOp
1123: from wip_operations
1124: where organization_id = p_orgID
1125: and wip_entity_id = p_wipEntityID;

Line 1127: if ( l_minOp = fnd_api.g_miss_num ) then

1123: from wip_operations
1124: where organization_id = p_orgID
1125: and wip_entity_id = p_wipEntityID;
1126:
1127: if ( l_minOp = fnd_api.g_miss_num ) then
1128: /* Fix bug 9540544 */
1129: update wip_requirement_operations
1130: set required_quantity = decode(basis_type,
1131: 2, /* basis is lot */

Line 1197: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1193: that the quantity was lowered below what was already past queue of the first op.
1194: This is an error. */
1195: if (SQL%NOTFOUND and l_updateFlag = 0) then
1196: fnd_message.set_name('WIP', 'WIP_LOWER_JOB_QTY');
1197: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1198: x_errorMsg := fnd_message.get;
1199: return;
1200: end if;
1201:

Line 1232: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1228: p_procReturnStatus => x_returnStatus,
1229: p_msg => 'unexp error:' || SQLERRM,
1230: x_returnStatus => l_retStatus);
1231: end if;
1232: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1233: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
1234: p_procedure_name => l_procName,
1235: p_error_text => SQLERRM);
1236: wip_utilities.get_message_stack(p_msg => l_msg);