DBA Data[Home] [Help]

APPS.GMI_PR_PICK_SLIP_NUMBER dependencies on FND_API

Line 119: | x_api_status => FND_API.G_RET_STS_SUCESSS or

115: | p_pick_slip_number => pick slip number
116: | p_report_set_id => report set
117: |
118: | Output Parameters
119: | x_api_status => FND_API.G_RET_STS_SUCESSS or
120: | FND_API.G_RET_STS_ERROR or
121: | FND_API.G_RET_STS_UNEXP_ERROR
122: | x_error_message => Error message
123: =========================================================================*/

Line 120: | FND_API.G_RET_STS_ERROR or

116: | p_report_set_id => report set
117: |
118: | Output Parameters
119: | x_api_status => FND_API.G_RET_STS_SUCESSS or
120: | FND_API.G_RET_STS_ERROR or
121: | FND_API.G_RET_STS_UNEXP_ERROR
122: | x_error_message => Error message
123: =========================================================================*/
124:

Line 121: | FND_API.G_RET_STS_UNEXP_ERROR

117: |
118: | Output Parameters
119: | x_api_status => FND_API.G_RET_STS_SUCESSS or
120: | FND_API.G_RET_STS_ERROR or
121: | FND_API.G_RET_STS_UNEXP_ERROR
122: | x_error_message => Error message
123: =========================================================================*/
124:
125: -- HW BUG#:2643440 - Replaced FND_API.G_MISS_NUM for p_pick_slip_number

Line 125: -- HW BUG#:2643440 - Replaced FND_API.G_MISS_NUM for p_pick_slip_number

121: | FND_API.G_RET_STS_UNEXP_ERROR
122: | x_error_message => Error message
123: =========================================================================*/
124:
125: -- HW BUG#:2643440 - Replaced FND_API.G_MISS_NUM for p_pick_slip_number
126: -- with DEFAULT NULL
127: PROCEDURE Print_Pick_Slip (
128: p_pick_slip_number IN NUMBER DEFAULT NULL,
129: p_report_set_id IN NUMBER,

Line 142: x_api_status := FND_API.G_RET_STS_SUCCESS;

138: l_index := g_pskey_table.first;
139:
140: /* If report set id is NULL, there is no report to print */
141: IF (p_report_set_id IS NULL) THEN
142: x_api_status := FND_API.G_RET_STS_SUCCESS;
143: RETURN;
144: END IF;
145:
146: /* If key table is empty, there is nothing to print */

Line 148: x_api_status := FND_API.G_RET_STS_SUCCESS;

144: END IF;
145:
146: /* If key table is empty, there is nothing to print */
147: IF (l_index IS NULL) THEN
148: x_api_status := FND_API.G_RET_STS_SUCCESS;
149: RETURN;
150: END IF;
151:
152: -- HW BUG#:2643440 - Replaced comparison with FND_API.G_MISS_NUM for p_pick_slip_number

Line 152: -- HW BUG#:2643440 - Replaced comparison with FND_API.G_MISS_NUM for p_pick_slip_number

148: x_api_status := FND_API.G_RET_STS_SUCCESS;
149: RETURN;
150: END IF;
151:
152: -- HW BUG#:2643440 - Replaced comparison with FND_API.G_MISS_NUM for p_pick_slip_number
153: -- with NULL
154:
155: IF p_pick_slip_number = NULL THEN
156: /* Loop through key table and print all remaining pick slips */

Line 185: IF x_api_status <> FND_API.G_RET_STS_SUCCESS THEN

181: l_index := g_pskey_table.next(l_index);
182: END LOOP;
183: END IF;
184:
185: IF x_api_status <> FND_API.G_RET_STS_SUCCESS THEN
186: x_error_message := 'Error occurred in call to ' ||
187: 'WSH_UTIL_CORE.Print_Document_Sets in ' ||
188: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
189: END IF;

Line 194: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

190:
191: EXCEPTION
192: WHEN OTHERS THEN
193: x_error_message := 'Exception occurred in WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
194: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: WSH_UTIL_CORE.Println('SQL error: ' || SQLERRM(SQLCODE));
196: END Print_Pick_Slip;
197:
198: /* =======================================================================

Line 224: | x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE

220: | p_revision => revision
221: |
222: | Output Parameters
223: | x_pick_slip_number => pick_slip_number
224: | x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
225: | x_api_status => FND_API.G_RET_STS_SUCESSS or
226: | FND_API.G_RET_STS_ERROR or
227: | FND_API.G_RET_STS_UNEXP_ERROR
228: | x_error_message => Error message

Line 225: | x_api_status => FND_API.G_RET_STS_SUCESSS or

221: |
222: | Output Parameters
223: | x_pick_slip_number => pick_slip_number
224: | x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
225: | x_api_status => FND_API.G_RET_STS_SUCESSS or
226: | FND_API.G_RET_STS_ERROR or
227: | FND_API.G_RET_STS_UNEXP_ERROR
228: | x_error_message => Error message
229: ===============================================================*/

Line 226: | FND_API.G_RET_STS_ERROR or

222: | Output Parameters
223: | x_pick_slip_number => pick_slip_number
224: | x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
225: | x_api_status => FND_API.G_RET_STS_SUCESSS or
226: | FND_API.G_RET_STS_ERROR or
227: | FND_API.G_RET_STS_UNEXP_ERROR
228: | x_error_message => Error message
229: ===============================================================*/
230: PROCEDURE Get_Pick_Slip_Number (

Line 227: | FND_API.G_RET_STS_UNEXP_ERROR

223: | x_pick_slip_number => pick_slip_number
224: | x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
225: | x_api_status => FND_API.G_RET_STS_SUCESSS or
226: | FND_API.G_RET_STS_ERROR or
227: | FND_API.G_RET_STS_UNEXP_ERROR
228: | x_error_message => Error message
229: ===============================================================*/
230: PROCEDURE Get_Pick_Slip_Number (
231: p_ps_mode IN VARCHAR2,

Line 289: x_api_status := FND_API.G_RET_STS_ERROR;

285: IF get_limit%NOTFOUND THEN
286: x_error_message := 'Organization ' ||
287: to_char(p_org_id) ||
288: ' does not exist. ';
289: x_api_status := FND_API.G_RET_STS_ERROR;
290: RETURN;
291: END IF;
292: END IF;
293:

Line 296: x_ready_to_print := FND_API.G_FALSE;

292: END IF;
293:
294:
295: /* Set ready to print flag to FALSE initially */
296: x_ready_to_print := FND_API.G_FALSE;
297:
298: /* find grouping rule in table */
299: l_found := FALSE;
300: FOR i IN 1..g_rule_table.count LOOP

Line 329: x_api_status := FND_API.G_RET_STS_ERROR;

325: IF ps_rule%NOTFOUND THEN
326: x_error_message := 'Pick grouping rule '
327: || to_char(p_pick_grouping_rule_id) ||
328: ' does not exist';
329: x_api_status := FND_API.G_RET_STS_ERROR;
330: RETURN;
331: END IF;
332:
333: g_rule_table(i).grouping_rule_id := p_pick_grouping_rule_id;

Line 352: x_api_status := FND_API.G_RET_STS_SUCCESS;

348: p_revision => p_revision,
349: p_org_id => p_org_id,
350: x_pick_slip_number => x_pick_slip_number );
351:
352: x_api_status := FND_API.G_RET_STS_SUCCESS;
353: RETURN;
354:
355: END IF;
356:

Line 519: x_ready_to_print := FND_API.G_TRUE;

515: IF l_found THEN
516: /* Print is immediate so check if limit has been reached */
517: IF (p_ps_mode = 'I' AND l_limit <> -1) THEN
518: IF (g_pskey_table(i).counter >= l_limit) THEN
519: x_ready_to_print := FND_API.G_TRUE;
520: END IF;
521: END IF;
522: ELSE
523: /* Insert new key */

Line 541: x_api_status := FND_API.G_RET_STS_SUCCESS;

537: p_org_id => p_org_id,
538: x_pick_slip_number => x_pick_slip_number );
539: END IF;
540:
541: x_api_status := FND_API.G_RET_STS_SUCCESS;
542: EXCEPTION
543: WHEN OTHERS THEN
544: x_error_message := 'Error occurred in WSH_PR_PICK_NUMBER.Get_Pick_Slip_Number';
545: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 545: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

541: x_api_status := FND_API.G_RET_STS_SUCCESS;
542: EXCEPTION
543: WHEN OTHERS THEN
544: x_error_message := 'Error occurred in WSH_PR_PICK_NUMBER.Get_Pick_Slip_Number';
545: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
546:
547: END Get_Pick_Slip_Number;
548:
549: /* ==================================================================

Line 562: | x_api_status => FND_API.G_RET_STS_SUCESSS or

558: | p_report_set_id => report set
559: | p_pick_slip_number => pick slip number
560: |
561: | Output Parameters
562: | x_api_status => FND_API.G_RET_STS_SUCESSS or
563: | FND_API.G_RET_STS_ERROR or
564: | FND_API.G_RET_STS_UNEXP_ERROR
565: ==================================================================*/
566: PROCEDURE Print_Pvt (

Line 563: | FND_API.G_RET_STS_ERROR or

559: | p_pick_slip_number => pick slip number
560: |
561: | Output Parameters
562: | x_api_status => FND_API.G_RET_STS_SUCESSS or
563: | FND_API.G_RET_STS_ERROR or
564: | FND_API.G_RET_STS_UNEXP_ERROR
565: ==================================================================*/
566: PROCEDURE Print_Pvt (
567: p_report_set_id IN NUMBER,

Line 564: | FND_API.G_RET_STS_UNEXP_ERROR

560: |
561: | Output Parameters
562: | x_api_status => FND_API.G_RET_STS_SUCESSS or
563: | FND_API.G_RET_STS_ERROR or
564: | FND_API.G_RET_STS_UNEXP_ERROR
565: ==================================================================*/
566: PROCEDURE Print_Pvt (
567: p_report_set_id IN NUMBER,
568: p_organization_id IN NUMBER,