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_TRANSACTION_PVT dependencies on FND_API

Line 14: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

10: PROCEDURE Process_OSP_Transaction
11: ( p_OSP_rec IN WIP_Transaction_PUB.Res_Rec_Type
12: , p_validation_level IN NUMBER DEFAULT COMPLETE
13: , p_return_status OUT NOCOPY VARCHAR2
14: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: , p_msg_count OUT NOCOPY NUMBER
16: , p_msg_data OUT NOCOPY VARCHAR2
17: )
18: IS

Line 55: IF FND_API.to_Boolean( p_init_msg_list ) THEN

51: p_params => l_params,
52: x_returnStatus => l_return_status);
53: END IF;
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Initialize API return status to success

Line 60: p_return_status := FND_API.G_RET_STS_SUCCESS;

56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Initialize API return status to success
60: p_return_status := FND_API.G_RET_STS_SUCCESS;
61: l_OSP_rec := p_OSP_rec;
62: l_process_phase := '2';
63: -- Check for direct items
64: CST_eamCost_PUB.check_if_direct_item (

Line 73: if (p_return_status <> fnd_api.g_ret_sts_success) then

69: x_return_status => p_return_status,
70: x_msg_count => p_msg_count,
71: x_msg_data => p_msg_data);
72:
73: if (p_return_status <> fnd_api.g_ret_sts_success) then
74: Raise fnd_api.g_exc_unexpected_error ;
75: end if;
76:
77: if (l_direct_item_flag = 1) then

Line 74: Raise fnd_api.g_exc_unexpected_error ;

70: x_msg_count => p_msg_count,
71: x_msg_data => p_msg_data);
72:
73: if (p_return_status <> fnd_api.g_ret_sts_success) then
74: Raise fnd_api.g_exc_unexpected_error ;
75: end if;
76:
77: if (l_direct_item_flag = 1) then
78: l_process_phase := '3';

Line 88: if (p_return_status <> fnd_api.g_ret_sts_success) then

84: x_return_status => p_return_status,
85: x_msg_count => p_msg_count,
86: x_msg_data => p_msg_data);
87:
88: if (p_return_status <> fnd_api.g_ret_sts_success) then
89: Raise fnd_api.g_exc_unexpected_error ;
90: end if;
91: else
92: l_process_phase := '4';

Line 89: Raise fnd_api.g_exc_unexpected_error ;

85: x_msg_count => p_msg_count,
86: x_msg_data => p_msg_data);
87:
88: if (p_return_status <> fnd_api.g_ret_sts_success) then
89: Raise fnd_api.g_exc_unexpected_error ;
90: end if;
91: else
92: l_process_phase := '4';
93: --Default the OSP Record

Line 108: if (l_return_status <> FND_API.G_RET_STS_ERROR) then

104: ,p_validation_level => p_validation_level
105: ,p_old_Res_rec => l_old_OSP_rec);
106:
107: l_process_phase := '7';
108: if (l_return_status <> FND_API.G_RET_STS_ERROR) then
109: WIP_Validate_Res.Entity(
110: x_return_status => l_return_status
111: ,p_Res_rec => l_OSP_rec
112: ,p_validation_level => p_validation_level

Line 117: if (l_return_status <> FND_API.G_RET_STS_ERROR) then

113: ,p_old_Res_rec => l_old_OSP_rec);
114: end if;
115: l_process_phase := '8';
116: --Create the OSP record (resource transaction)
117: if (l_return_status <> FND_API.G_RET_STS_ERROR) then
118: WIP_Res_Util.Insert_Row(p_Res_rec => l_OSP_rec);
119: end if;
120: l_process_phase := '9';
121: if (l_direct_item_flag <> 1) then

Line 124: if (l_return_status <> FND_API.G_RET_STS_ERROR) then

120: l_process_phase := '9';
121: if (l_direct_item_flag <> 1) then
122: --Perform the Move transaction if the autocharge is PO Move
123: -- do not do this if direct item
124: if (l_return_status <> FND_API.G_RET_STS_ERROR) then
125: IF l_OSP_rec.autocharge_type = WIP_CONSTANTS.PO_MOVE THEN
126: l_process_phase := '10';
127: --Default the ShopFloorMove record
128: WIP_Default_ShopFloorMove.Attributes(

Line 143: if (l_return_status <> FND_API.G_RET_STS_ERROR) then

139: p_ShopFloorMove_rec => l_ShopFloorMove_rec,
140: p_validation_level => p_validation_level
141: ,p_old_ShopFloorMove_rec => l_old_ShopFloorMove_rec);
142: l_process_phase := '13';
143: if (l_return_status <> FND_API.G_RET_STS_ERROR) then
144: l_process_phase := '14';
145: WIP_Validate_ShopFloorMove.Entity(
146: x_return_status => l_return_status,
147: p_ShopFloorMove_rec => l_ShopFloorMove_rec,

Line 153: if (l_return_status <> FND_API.G_RET_STS_ERROR) then

149: ,p_old_ShopFloorMove_rec => l_old_ShopFloorMove_rec);
150: end if;
151: l_process_phase := '15';
152: --Create the ShopFloorMove record
153: if (l_return_status <> FND_API.G_RET_STS_ERROR) then
154: WIP_ShopFloorMove_Util.Insert_Row(
155: p_ShopFloorMove_rec => l_ShopFloorMove_rec);
156: end if;
157: l_process_phase := '16';

Line 163: ( p_encoded => FND_API.G_FALSE ,

159: END IF;
160: END IF; -- end of check for direct items
161:
162: FND_MSG_PUB.Count_And_Get
163: ( p_encoded => FND_API.G_FALSE ,
164: p_count => p_msg_count ,
165: p_data => p_msg_data
166: );
167: p_return_status := l_return_status;

Line 177: WHEN FND_API.G_EXC_ERROR THEN

173: x_returnStatus => l_return_status);
174: END IF;
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: l_OSP_rec.return_status := FND_API.G_RET_STS_ERROR;
179:
180: p_return_status := l_OSP_rec.return_status ;
181:

Line 178: l_OSP_rec.return_status := FND_API.G_RET_STS_ERROR;

174: END IF;
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: l_OSP_rec.return_status := FND_API.G_RET_STS_ERROR;
179:
180: p_return_status := l_OSP_rec.return_status ;
181:
182: FND_MSG_PUB.Count_And_Get

Line 195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

191: p_procReturnStatus => p_return_status,
192: p_msg => l_error_msg,
193: x_returnStatus => l_return_status);
194: END IF;
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
196:
197: l_OSP_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: p_return_status := l_OSP_rec.return_status ;
199:

Line 197: l_OSP_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

193: x_returnStatus => l_return_status);
194: END IF;
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
196:
197: l_OSP_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: p_return_status := l_OSP_rec.return_status ;
199:
200: FND_MSG_PUB.Count_And_Get
201: ( p_count => p_msg_count

Line 216: l_OSP_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: END IF;
213:
214: WHEN OTHERS THEN
215:
216: l_OSP_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217:
218: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg

Line 261: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

257: -- End of Comments
258:
259: PROCEDURE Get_Transaction
260: ( p_api_version_number IN NUMBER
261: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262: , x_return_status OUT NOCOPY VARCHAR2
263: , x_msg_count OUT NOCOPY NUMBER
264: , x_msg_data OUT NOCOPY VARCHAR2
265: , p_dummy IN VARCHAR2

Line 282: IF NOT FND_API.Compatible_API_Call

278: BEGIN
279:
280: -- Standard call to check for call compatibility
281:
282: IF NOT FND_API.Compatible_API_Call
283: ( l_api_version_number
284: , p_api_version_number
285: , l_api_name
286: , G_PKG_NAME

Line 294: IF FND_API.to_Boolean(p_init_msg_list) THEN

290: END IF;
291:
292: -- Initialize message list.
293:
294: IF FND_API.to_Boolean(p_init_msg_list) THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:
298: -- Get WIPTransaction ( parent = WIPTransaction )

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: x_ShopFloorMove_tbl := l_x_ShopFloorMove_tbl;
342:
343: -- Set return status
344:
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: -- Get message count and data
348:
349: FND_MSG_PUB.Count_And_Get

Line 357: WHEN FND_API.G_EXC_ERROR THEN

353:
354:
355: EXCEPTION
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358:
359: x_return_status := FND_API.G_RET_STS_ERROR;
360:
361: -- Get message count and data

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: EXCEPTION
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358:
359: x_return_status := FND_API.G_RET_STS_ERROR;
360:
361: -- Get message count and data
362:
363: FND_MSG_PUB.Count_And_Get

Line 368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

364: ( p_count => x_msg_count
365: , p_data => x_msg_data
366: );
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371:
372: -- Get message count and data

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

366: );
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371:
372: -- Get message count and data
373:
374: FND_MSG_PUB.Count_And_Get

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: );
378:
379: WHEN OTHERS THEN
380:
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382:
383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
384: THEN
385: FND_MSG_PUB.Add_Exc_Msg

Line 409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

405: PROCEDURE Process_Resource_Transaction
406: ( p_res_txn_rec IN WIP_Transaction_PUB.Res_Rec_Type
407: , p_validation_level IN NUMBER DEFAULT COMPLETE
408: , p_return_status OUT NOCOPY VARCHAR2
409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
410: , p_msg_count OUT NOCOPY NUMBER
411: , p_msg_data OUT NOCOPY VARCHAR2
412: )
413: IS

Line 442: IF FND_API.to_Boolean( p_init_msg_list ) THEN

438: p_params => l_params,
439: x_returnStatus => l_return_status);
440: END IF;
441: -- Initialize message list if p_init_msg_list is set to TRUE.
442: IF FND_API.to_Boolean( p_init_msg_list ) THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446: -- Initialize API return status to success

Line 447: l_return_status := FND_API.G_RET_STS_SUCCESS;

443: FND_MSG_PUB.initialize;
444: END IF;
445:
446: -- Initialize API return status to success
447: l_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: l_res_txn_rec := p_res_txn_rec;
450: l_process_phase := '2';
451: --Default the Resource Record

Line 483: ( p_encoded => FND_API.G_FALSE ,

479: --Create the Resource record (resource transaction)
480: WIP_Res_Util.Insert_Row(p_Res_rec => l_res_txn_rec);
481: l_process_phase := '8';
482: FND_MSG_PUB.Count_And_Get
483: ( p_encoded => FND_API.G_FALSE ,
484: p_count => p_msg_count ,
485: p_data => p_msg_data
486: );
487:

Line 498: WHEN FND_API.G_EXC_ERROR THEN

494: x_returnStatus => l_return_status);
495: END IF;
496: EXCEPTION
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: l_res_txn_rec.return_status := FND_API.G_RET_STS_ERROR;
500: l_error_msg := 'process_phase = ' || l_process_phase || ';';
501: IF (l_log_level <= wip_constants.trace_logging) THEN
502: wip_logger.exitPoint(

Line 499: l_res_txn_rec.return_status := FND_API.G_RET_STS_ERROR;

495: END IF;
496: EXCEPTION
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: l_res_txn_rec.return_status := FND_API.G_RET_STS_ERROR;
500: l_error_msg := 'process_phase = ' || l_process_phase || ';';
501: IF (l_log_level <= wip_constants.trace_logging) THEN
502: wip_logger.exitPoint(
503: p_procName => 'WIP_Transaction_PVT.Process_Resource_Transaction',

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: p_procReturnStatus => p_return_status,
505: p_msg => l_error_msg,
506: x_returnStatus => l_return_status);
507: END IF;
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: l_res_txn_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: l_error_msg := 'process_phase = ' || l_process_phase || ';';
511: IF (l_log_level <= wip_constants.trace_logging) THEN
512: wip_logger.exitPoint(

Line 509: l_res_txn_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: p_msg => l_error_msg,
506: x_returnStatus => l_return_status);
507: END IF;
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: l_res_txn_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: l_error_msg := 'process_phase = ' || l_process_phase || ';';
511: IF (l_log_level <= wip_constants.trace_logging) THEN
512: wip_logger.exitPoint(
513: p_procName => 'WIP_Transaction_PVT.Process_Resource_Transaction',

Line 519: l_res_txn_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: p_msg => l_error_msg,
516: x_returnStatus => l_return_status);
517: END IF;
518: WHEN OTHERS THEN
519: l_res_txn_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520:
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg