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.GMI_PICK_RELEASE_PUB dependencies on GMI_PICK_RELEASE_PUB

Line 1: PACKAGE BODY GMI_Pick_Release_PUB AS

1: PACKAGE BODY GMI_Pick_Release_PUB AS
2: /* $Header: GMIPPKRB.pls 120.0 2005/05/25 16:21:25 appldev noship $
3: +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 22: API Name : GMI_Pick_Release_PUB

18: | HISTORY |
19: | 27-Apr-2000 odaboval Created |
20: | 09/10/01 HW BUG#:1941429 Added code to support cross_docking | |
21: +=========================================================================+
22: API Name : GMI_Pick_Release_PUB
23: Type : Global
24: -
25: Pre-reqs : N/A
26: Parameters: Per function

Line 31: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_Pick_Release_PUB';

27:
28: Current Vers : 1.0
29: */
30:
31: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_Pick_Release_PUB';
32: -- HW BUG#:2643440 -removed G_MISS_XXX from p_grouping_rule_id and
33: -- added DEFAULT NULL
34: PROCEDURE Auto_Detail
35: (

Line 114: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before Init status');

110: gmi_reservation_util.println('Value of p_grouping_rule_id in Auto_Detail is '||p_grouping_rule_id);
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: GMI_Reservation_Util.PrintLn('EXITING GMI_Pick_Release....');
113:
114: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before Init status');
115: /* Set a SavePoint */
116: SAVEPOINT Pick_Release_PUB;
117:
118: /* Standard Call to check for call compatibility */

Line 123: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Error in Compatible_API_Call');

119: IF NOT FND_API.Compatible_API_Call(l_api_version
120: , p_api_version
121: , l_api_name
122: , G_PKG_NAME) THEN
123: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Error in Compatible_API_Call');
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126:
127: /* Initialize message list if p_init_msg_list is set to true */

Line 137: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before Validation');

133: =====================================================================
134: First determine whether the table of move order lines in p_mo_line_tbl has
135: any records
136: */
137: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before Validation');
138:
139: IF ( p_mo_line_tbl.COUNT = 0 )
140: THEN
141: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Validation Error count=0');

Line 141: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Validation Error count=0');

137: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before Validation');
138:
139: IF ( p_mo_line_tbl.COUNT = 0 )
140: THEN
141: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Validation Error count=0');
142: ROLLBACK TO Pick_Release_PUB;
143: FND_MESSAGE.SET_NAME('INV','INV_NO_LINES_TO_PICK');
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 155: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before loop org_id='||l_organization_id);

151: */
152: l_line_index := p_mo_line_tbl.FIRST;
153: l_mo_line := p_mo_line_tbl(l_line_index);
154: l_organization_id := l_mo_line.organization_id;
155: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before loop org_id='||l_organization_id);
156: LOOP
157: /* Verify that the lines are all for the same organization */
158: IF l_mo_line.organization_id <> l_organization_id THEN
159: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop Error pick_different_org');

Line 159: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop Error pick_different_org');

155: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Before loop org_id='||l_organization_id);
156: LOOP
157: /* Verify that the lines are all for the same organization */
158: IF l_mo_line.organization_id <> l_organization_id THEN
159: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop Error pick_different_org');
160: FND_MESSAGE.SET_NAME('GMI','INV_PICK_DIFFERENT_ORG');
161: FND_MSG_PUB.Add;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;

Line 167: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop Error Pick_line_Status');

163: END IF;
164:
165: /* Verify that the line status is approved or pre-approved */
166: IF (l_mo_line.line_status <> 3 AND l_mo_line.line_status <> 7) THEN
167: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop Error Pick_line_Status');
168: FND_MESSAGE.SET_NAME('GMI','INV_PICK_LINE_STATUS');
169: FND_MSG_PUB.Add;
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;

Line 174: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop org_id='||l_organization_id||', index='||l_line_index);

170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173: /* Verify that the move order type is Pick Wave (3) */
174: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, In loop org_id='||l_organization_id||', index='||l_line_index);
175: EXIT WHEN l_line_index = p_mo_line_tbl.LAST;
176: l_line_index := p_mo_line_tbl.NEXT(l_line_index);
177: END LOOP;
178:

Line 196: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Validation complete');

192: l_get_header_rule := 1;
193:
194: END IF;
195:
196: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PUB, Validation complete');
197: /* =====================================================================
198: Validation complete; begin pick release processing row-by-row
199: =====================================================================
200: */

Line 341: GMI_Reservation_Util.PrintLn('Pick Short -back order in GMI_PICK_RELEASE_PUB.Auto_detail');

337:
338: gmi_reservation_util.println('In Auto_detail value of l_quantity '||l_quantity);
339:
340: IF ( l_transaction_quantity < l_quantity ) THEN
341: GMI_Reservation_Util.PrintLn('Pick Short -back order in GMI_PICK_RELEASE_PUB.Auto_detail');
342: BEGIN
343: select delivery_detail_id, source_header_id, source_line_id,
344: released_status
345: into l_delivery_detail_id, l_source_header_id, l_source_line_id,

Line 384: 'GMI_Pick_Release_Pub.Auto_Detail');

380: x_return_status => l_api_return_status
381: );
382: IF( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
383: GMI_Reservation_Util.Println('Retrun error from update shipping attributes',
384: 'GMI_Pick_Release_Pub.Auto_Detail');
385: raise FND_API.G_EXC_ERROR;
386: END IF;
387:
388: UPDATE IC_TXN_REQUEST_LINES

Line 448: END GMI_Pick_Release_PUB;

444:
445: END Auto_Detail;
446:
447:
448: END GMI_Pick_Release_PUB;