DBA Data[Home] [Help]

APPS.WMA_FLOW dependencies on WMA_FLOW

Line 1: PACKAGE BODY wma_flow AS

1: PACKAGE BODY wma_flow AS
2: /* $Header: wmapflwb.pls 120.10 2007/10/12 18:31:26 vjambhek ship $ */
3:
4: Function putIntoMMTT(flowRec FlowRecord, errMsg OUT NOCOPY VARCHAR2) return boolean;
5:

Line 26: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecord',

22: status := 0;
23: if (l_logLevel <= wip_constants.trace_logging) then
24: l_params(1).paramName := 'not printing params';
25: l_params(1).paramValue := ' ';
26: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecord',
27: p_params => l_params,
28: x_returnStatus => l_returnStatus);
29: end if;
30:

Line 35: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

31: if ( derive(param, flowRec, errMsg) = false ) then
32: status := -1;
33: errMessage := errMsg;
34: if (l_logLevel <= wip_constants.trace_logging) then
35: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
36: p_procReturnStatus => status,
37: p_msg => errMessage,
38: x_returnStatus => l_returnStatus);
39: end if;

Line 47: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

43: if ( put(flowRec, errMsg) = false ) then
44: status := -1;
45: errMessage := errMsg;
46: if (l_logLevel <= wip_constants.trace_logging) then
47: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
48: p_procReturnStatus => status,
49: p_msg => errMessage,
50: x_returnStatus => l_returnStatus);
51: end if;

Line 56: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

52: return;
53: end if;
54:
55: if (l_logLevel <= wip_constants.trace_logging) then
56: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
57: p_procReturnStatus => status,
58: p_msg => 'success',
59: x_returnStatus => l_returnStatus);
60: end if;

Line 66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');

62: EXCEPTION
63: when others then
64: status := -1;
65: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

Line 70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',

66: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecord');
67: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
68: errMessage := fnd_message.get;
69: if (l_logLevel <= wip_constants.trace_logging) then
70: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecord',
71: p_procReturnStatus => status,
72: p_msg => errMessage,
73: x_returnStatus => l_returnStatus);
74: end if;

Line 97: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

93:
94: if (l_logLevel <= wip_constants.trace_logging) then
95: l_params(1).paramName := 'not printing params';
96: l_params(1).paramValue := ' ';
97: wip_logger.entryPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
98: p_params => l_params,
99: x_returnStatus => l_returnStatus);
100: end if;
101:

Line 106: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

102: if ( derive(param, flowRec, errMsg) = false ) then
103: status := -1;
104: errMessage := errMsg;
105: if (l_logLevel <= wip_constants.trace_logging) then
106: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
107: p_procReturnStatus => status,
108: p_msg => errMessage,
109: x_returnStatus => l_returnStatus);
110: end if;

Line 118: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

114: if ( putIntoMMTT(flowRec, errMsg) = false ) then
115: status := -1;
116: errMessage := errMsg;
117: if (l_logLevel <= wip_constants.trace_logging) then
118: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
119: p_procReturnStatus => status,
120: p_msg => errMessage,
121: x_returnStatus => l_returnStatus);
122: end if;

Line 127: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

123: return;
124: end if;
125:
126: if (l_logLevel <= wip_constants.trace_logging) then
127: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
128: p_procReturnStatus => status,
129: p_msg => 'success',
130: x_returnStatus => l_returnStatus);
131: end if;

Line 137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');

133: EXCEPTION
134: when others then
135: status := -1;
136: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

Line 141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',

137: fnd_message.set_token ('FUNCTION', 'wma_flow.insertParentRecordintoMMTT');
138: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
139: errMessage := fnd_message.get;
140: if (l_logLevel <= wip_constants.trace_logging) then
141: wip_logger.exitPoint(p_procName => 'wma_flow.insertParentRecordintoMMTT',
142: p_procReturnStatus => status,
143: p_msg => errMessage,
144: x_returnStatus => l_returnStatus);
145: end if;

Line 500: fnd_message.set_token ('FUNCTION', 'wma_flow.put');

496:
497: EXCEPTION
498: when others then
499: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
500: fnd_message.set_token ('FUNCTION', 'wma_flow.put');
501: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
502: errMsg := fnd_message.get;
503: return false;
504: End put;

Line 975: fnd_message.set_token ('FUNCTION', 'wma_flow.putIntoMMTT');

971:
972: EXCEPTION
973: when others then
974: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
975: fnd_message.set_token ('FUNCTION', 'wma_flow.putIntoMMTT');
976: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
977: errMsg := fnd_message.get;
978: return false;
979: End putIntoMMTT;

Line 1022: wip_logger.entryPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1018:
1019: if (l_logLevel <= wip_constants.trace_logging) then
1020: l_params(1).paramName := 'not printing params';
1021: l_params(1).paramValue := ' ';
1022: wip_logger.entryPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1023: p_params => l_params,
1024: x_returnStatus => l_returnStatus);
1025: end if;
1026:

Line 1159: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1155: x_compInfo => x_compInfo,
1156: x_returnStatus => x_returnStatus);
1157:
1158: if (l_logLevel <= wip_constants.trace_logging) then
1159: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1160: p_procReturnStatus => x_returnStatus,
1161: p_msg => 'success',
1162: x_returnStatus => l_returnStatus);
1163: end if;

Line 1170: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1166: when fnd_api.g_exc_unexpected_error then
1167: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1168: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
1169: if (l_logLevel <= wip_constants.trace_logging) then
1170: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1171: p_procReturnStatus => x_returnStatus,
1172: p_msg => x_errMessage,
1173: x_returnStatus => l_returnStatus);
1174: end if;

Line 1182: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',

1178: when others then
1179: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1180: x_errMessage := SQLERRM;
1181: if (l_logLevel <= wip_constants.trace_logging) then
1182: wip_logger.exitPoint(p_procName => 'wma_flow.explodeBOMAndDerive',
1183: p_procReturnStatus => x_returnStatus,
1184: p_msg => x_errMessage,
1185: x_returnStatus => l_returnStatus);
1186: end if;

Line 1190: END wma_flow;

1186: end if;
1187: rollback;
1188: end explodeBOMAndDerive;
1189:
1190: END wma_flow;