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 555: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

551: p_procReturnStatus => x_returnStatus,
552: p_msg => 'unexp error:' || SQLERRM,
553: x_returnStatus => l_retStatus);
554: end if;
555: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
556: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
557: p_procedure_name => l_procName,
558: p_error_text => SQLERRM);
559: wip_utilities.get_message_stack(p_msg => l_msg);

Line 612: x_returnStatus := fnd_api.g_ret_sts_success;

608: and operation_seq_num < 0
609: and wip_supply_type = wip_constants.phantom;
610:
611: begin
612: x_returnStatus := fnd_api.g_ret_sts_success;
613: if (l_logLevel <= wip_constants.trace_logging) then
614: l_params(1).paramName := 'p_orgID';
615: l_params(1).paramValue := p_orgID;
616: l_params(2).paramName := 'p_wipEntityID';

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

639: l_params(13).paramValue := p_taskID;
640: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
641: p_params => l_params,
642: x_returnStatus => x_returnStatus);
643: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
644: raise fnd_api.g_exc_unexpected_error;
645: end if;
646: end if;
647:

Line 644: raise fnd_api.g_exc_unexpected_error;

640: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
641: p_params => l_params,
642: x_returnStatus => x_returnStatus);
643: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
644: raise fnd_api.g_exc_unexpected_error;
645: end if;
646: end if;
647:
648: l_entityType := wip_constants.discrete;

Line 669: p_initMsgList => fnd_api.g_false,

665: p_bomRevDate => p_bomRevDate,
666: p_txnDate => null,
667: p_projectID => p_projectID,
668: p_taskID => p_taskID,
669: p_initMsgList => fnd_api.g_false,
670: p_endDebug => fnd_api.g_false,
671: x_compTbl => l_compTbl,
672: x_returnStatus => x_returnStatus);
673: */

Line 670: p_endDebug => fnd_api.g_false,

666: p_txnDate => null,
667: p_projectID => p_projectID,
668: p_taskID => p_taskID,
669: p_initMsgList => fnd_api.g_false,
670: p_endDebug => fnd_api.g_false,
671: x_compTbl => l_compTbl,
672: x_returnStatus => x_returnStatus);
673: */
674:

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

688: p_txnFlag => false, /* for bug4538135 */ /* ER 4369064 */
689: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
690: x_compTbl => l_compTbl,
691: x_returnStatus => x_returnStatus);
692: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
693: raise fnd_api.g_exc_unexpected_error;
694: end if;
695:
696: begin

Line 693: raise fnd_api.g_exc_unexpected_error;

689: p_unitNumber => p_unitNumber, /* added for bug 5332615 */
690: x_compTbl => l_compTbl,
691: x_returnStatus => x_returnStatus);
692: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
693: raise fnd_api.g_exc_unexpected_error;
694: end if;
695:
696: begin
697: select nvl(min(operation_seq_num), 1)

Line 751: raise fnd_api.g_exc_unexpected_error;

747: and wro.wip_entity_id = p_wipEntityID
748: and wro.operation_seq_num = l_wro_op;
749:
750: if( l_diff_basis > 1 ) then
751: raise fnd_api.g_exc_unexpected_error;
752: elsif( l_diff_basis = 1 ) then
753: if( (l_compTbl(l_count).basis_type is null and l_basis = 1 )
754: or l_compTbl(l_count).basis_type = l_basis ) then
755: update wip_requirement_operations wro

Line 776: x_returnStatus := fnd_api.g_ret_sts_error;

772: and wro.organization_id = p_orgID
773: and wro.wip_entity_id = p_wipEntityID
774: and wro.operation_seq_num = l_wro_op;
775: else
776: x_returnStatus := fnd_api.g_ret_sts_error;
777: fnd_message.set_name('WIP', 'WIP_COMP_DUP_OP_ONE');
778: fnd_msg_pub.add;
779: if (l_logLevel <= wip_constants.full_logging) then
780: wip_logger.log(p_msg => 'Item ' || l_compTbl(l_count).inventory_item_id ||

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

872: p_org_id => p_orgID,
873: x_return_status => x_returnStatus,
874: x_msg_data => x_errorMsg );
875:
876: if (x_returnStatus <> fnd_api.g_ret_sts_success) then
877: if (l_logLevel <= wip_constants.full_logging) then
878: wip_logger.log(p_msg => 'Post_Explosion_Cleanup failed for wip_entity_id '||p_wipEntityID,
879: x_returnStatus => x_returnStatus);
880: end if;

Line 992: when fnd_api.g_exc_unexpected_error then

988: p_msg => 'success',
989: x_returnStatus => l_retStatus);
990: end if;
991: exception
992: when fnd_api.g_exc_unexpected_error then
993: if (l_logLevel <= wip_constants.trace_logging) then
994: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
995: p_procReturnStatus => x_returnStatus,
996: p_msg => 'failed at exploding requirements',

Line 1006: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1002: p_procReturnStatus => x_returnStatus,
1003: p_msg => 'unexp error:' || SQLERRM,
1004: x_returnStatus => l_retStatus);
1005: end if;
1006: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
1008: p_procedure_name => l_procName,
1009: p_error_text => SQLERRM);
1010: wip_utilities.get_message_stack(p_msg => l_msg);

Line 1031: x_returnStatus := fnd_api.g_ret_sts_success;

1027: l_jobStatus number;
1028: l_minOp number;
1029: begin
1030:
1031: x_returnStatus := fnd_api.g_ret_sts_success;
1032: if (l_logLevel <= wip_constants.trace_logging) then
1033: l_params(1).paramName := 'p_orgID';
1034: l_params(1).paramValue := p_orgID;
1035: l_params(2).paramName := 'p_wipEntityID';

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

1038: l_params(3).paramValue := p_qty;
1039: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
1040: p_params => l_params,
1041: x_returnStatus => x_returnStatus);
1042: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1043: raise fnd_api.g_exc_unexpected_error;
1044: end if;
1045: end if;
1046:

Line 1043: raise fnd_api.g_exc_unexpected_error;

1039: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,
1040: p_params => l_params,
1041: x_returnStatus => x_returnStatus);
1042: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
1043: raise fnd_api.g_exc_unexpected_error;
1044: end if;
1045: end if;
1046:
1047:

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

1068: end if;
1069:
1070:
1071: if ( l_jobStatus <> wip_constants.unreleased ) then
1072: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
1073: into l_minOp
1074: from wip_operations
1075: where organization_id = p_orgID
1076: and wip_entity_id = p_wipEntityID;

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

1074: from wip_operations
1075: where organization_id = p_orgID
1076: and wip_entity_id = p_wipEntityID;
1077:
1078: if ( l_minOp = fnd_api.g_miss_num ) then
1079: if(l_logLevel <= wip_constants.trace_logging) then
1080: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1081: p_procReturnStatus => x_returnStatus,
1082: p_msg => 'no operation exist',

Line 1134: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1130: p_procReturnStatus => x_returnStatus,
1131: p_msg => 'unexp error:' || SQLERRM,
1132: x_returnStatus => l_retStatus);
1133: end if;
1134: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1135: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkgName,
1136: p_procedure_name => l_procName,
1137: p_error_text => SQLERRM);
1138: wip_utilities.get_message_stack(p_msg => l_msg);