DBA Data[Home] [Help]

APPS.EAM_MATERIAL_REQUEST_PVT dependencies on FND_MESSAGE

Line 76: fnd_message.set_name('EAM','EAM_MR_NEGATIVE_REQ_QTY');

72: return;
73: end if;
74: if (p_requested_quantity < 0) then
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_message.set_name('EAM','EAM_MR_NEGATIVE_REQ_QTY');
77: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity) );
78: fnd_msg_pub.add;
79: FND_MSG_PUB.Count_And_Get(
80: p_count => x_msg_count,

Line 77: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity) );

73: end if;
74: if (p_requested_quantity < 0) then
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_message.set_name('EAM','EAM_MR_NEGATIVE_REQ_QTY');
77: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity) );
78: fnd_msg_pub.add;
79: FND_MSG_PUB.Count_And_Get(
80: p_count => x_msg_count,
81: p_data => x_msg_data);

Line 157: fnd_message.set_name('EAM','EAM_GENERIC_ERROR');

153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data);
156: if (x_msg_count = 0 ) then --means not on stack, add it.
157: fnd_message.set_name('EAM','EAM_GENERIC_ERROR');
158: fnd_message.set_token('EAM_ERROR', l_msg_data );
159: fnd_msg_pub.add;
160: end if;
161: end if;

Line 158: fnd_message.set_token('EAM_ERROR', l_msg_data );

154: p_count => x_msg_count,
155: p_data => x_msg_data);
156: if (x_msg_count = 0 ) then --means not on stack, add it.
157: fnd_message.set_name('EAM','EAM_GENERIC_ERROR');
158: fnd_message.set_token('EAM_ERROR', l_msg_data );
159: fnd_msg_pub.add;
160: end if;
161: end if;
162:

Line 170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');

166: where header_id = (select header_id from mtl_txn_request_headers
167: where request_number = x_request_number
168: and organization_id = p_organization_id);
169: if (l_partial_qty = 0) then
170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );

Line 173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');

169: if (l_partial_qty = 0) then
170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));
176: fnd_msg_pub.add;
177: end if;

Line 174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );

170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');
171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));
176: fnd_msg_pub.add;
177: end if;
178: end if;

Line 175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));

171: fnd_msg_pub.add;
172: else
173: fnd_message.set_name('EAM','EAM_MR_PARTIAL_ALLOCATION');
174: fnd_message.set_token('PARTIAL', to_char(l_partial_qty) );
175: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity));
176: fnd_msg_pub.add;
177: end if;
178: end if;
179:

Line 182: fnd_message.set_name('EAM','EAM_MR_ALLOCATION_FAILED');

178: end if;
179:
180: if (x_return_status = FND_API.G_RET_STS_ERROR) then
181: if l_msg_data is null then --should not happen, just a safeguard
182: fnd_message.set_name('EAM','EAM_MR_ALLOCATION_FAILED');
183: fnd_msg_pub.add;
184: end if;
185: RAISE FND_API.G_EXC_ERROR;
186: end if;

Line 377: fnd_message.set_name('FND', 'CONC-PARAMETERS');

373: else
374: l_plan_tasks:= FALSE;
375: end if;
376:
377: fnd_message.set_name('FND', 'CONC-PARAMETERS');
378: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
379:
380: select meaning
381: into l_outBuffer

Line 378: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

374: l_plan_tasks:= FALSE;
375: end if;
376:
377: fnd_message.set_name('FND', 'CONC-PARAMETERS');
378: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
379:
380: select meaning
381: into l_outBuffer
382: from mfg_lookups

Line 386: fnd_message.set_name('WIP', 'WIP_PICKING_USE_PICKSETS');

382: from mfg_lookups
383: where lookup_type = 'SYS_YES_NO'
384: and lookup_code = p_use_pickset_indicator;
385:
386: fnd_message.set_name('WIP', 'WIP_PICKING_USE_PICKSETS');
387: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
388: /* Added as part of Enhancement#2578514*/
389: select meaning
390: into l_outBuffer

Line 387: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

383: where lookup_type = 'SYS_YES_NO'
384: and lookup_code = p_use_pickset_indicator;
385:
386: fnd_message.set_name('WIP', 'WIP_PICKING_USE_PICKSETS');
387: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
388: /* Added as part of Enhancement#2578514*/
389: select meaning
390: into l_outBuffer
391: from mfg_lookups

Line 395: fnd_message.set_name('WIP', 'WIP_PICKING_PRINT_PICKSLIPS');

391: from mfg_lookups
392: where lookup_type = 'SYS_YES_NO'
393: and lookup_code = p_print_pickslips;
394:
395: fnd_message.set_name('WIP', 'WIP_PICKING_PRINT_PICKSLIPS');
396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
397: /* Added as part of Enhancement#2578514*/
398: if(p_pick_grouping_rule_id IS NOT NULL) then
399: select name

Line 396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

392: where lookup_type = 'SYS_YES_NO'
393: and lookup_code = p_print_pickslips;
394:
395: fnd_message.set_name('WIP', 'WIP_PICKING_PRINT_PICKSLIPS');
396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
397: /* Added as part of Enhancement#2578514*/
398: if(p_pick_grouping_rule_id IS NOT NULL) then
399: select name
400: into l_outBuffer

Line 404: fnd_message.set_name('WIP', 'WIP_PICKING_PICK_GROUPING_RULE');

400: into l_outBuffer
401: from wsh_pick_grouping_rules
402: where pick_grouping_rule_id = p_pick_grouping_rule_id;
403:
404: fnd_message.set_name('WIP', 'WIP_PICKING_PICK_GROUPING_RULE');
405: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
406: end if;
407:
408: /* Added as part of Enhancement#2578514*/

Line 405: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

401: from wsh_pick_grouping_rules
402: where pick_grouping_rule_id = p_pick_grouping_rule_id;
403:
404: fnd_message.set_name('WIP', 'WIP_PICKING_PICK_GROUPING_RULE');
405: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
406: end if;
407:
408: /* Added as part of Enhancement#2578514*/
409: select meaning

Line 415: fnd_message.set_name('WIP', 'WIP_PICKING_PLAN_TASKS');

411: from mfg_lookups
412: where lookup_type = 'SYS_YES_NO'
413: and lookup_code = p_plan_tasks;
414:
415: fnd_message.set_name('WIP', 'WIP_PICKING_PLAN_TASKS');
416: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
417:
418: select organization_code
419: into l_outBuffer

Line 416: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

412: where lookup_type = 'SYS_YES_NO'
413: and lookup_code = p_plan_tasks;
414:
415: fnd_message.set_name('WIP', 'WIP_PICKING_PLAN_TASKS');
416: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
417:
418: select organization_code
419: into l_outBuffer
420: from MTL_PARAMETERS

Line 423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');

419: into l_outBuffer
420: from MTL_PARAMETERS
421: where organization_id = p_organization_id;
422:
423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
425:
426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);

Line 424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

420: from MTL_PARAMETERS
421: where organization_id = p_organization_id;
422:
423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
425:
426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
428:

Line 426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');

422:
423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
425:
426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
428:
429: select meaning
430: into l_outBuffer

Line 427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);

423: fnd_message.set_name('WIP', 'WIP_PICKING_ORG');
424: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
425:
426: fnd_message.set_name('WIP', 'WIP_PICKING_DAYS_FORWARD');
427: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || p_days_forward);
428:
429: select meaning
430: into l_outBuffer
431: from mfg_lookups

Line 435: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');

431: from mfg_lookups
432: where lookup_type = 'WIP_ENTITY'
433: and lookup_code = p_wip_entity_type;
434:
435: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
436: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
437:
438:
439: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/

Line 436: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

432: where lookup_type = 'WIP_ENTITY'
433: and lookup_code = p_wip_entity_type;
434:
435: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
436: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
437:
438:
439: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/
440:

Line 449: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');

445: from mfg_lookups
446: where lookup_type = 'WIP_ENTITIES'
447: and lookup_code = p_job_type ;
448:
449: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
451: --End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type
452: end if;
453:

Line 450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);

446: where lookup_type = 'WIP_ENTITIES'
447: and lookup_code = p_job_type ;
448:
449: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
451: --End - Bug 5932126 (FP of 5880558): Added code to print new parameter for job type
452: end if;
453:
454: fnd_file.put_line(which => fnd_file.output, buff => '');

Line 505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');

501: x_msg_data => errbuf);
502: END IF;
503:
504: if(l_returnStatus = 'P') then
505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);

502: END IF;
503:
504: if(l_returnStatus = 'P') then
505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then

Line 507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

503:
504: if(l_returnStatus = 'P') then
505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

Line 508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');

504: if(l_returnStatus = 'P') then
505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);

Line 509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

505: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
506: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

507: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
514: end if;
515:

Line 512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);

508: fnd_message.set_name('WIP', 'WIP_PICKING_PARTIAL_ALLOC_CONC');
509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
514: end if;
515:
516: elsif(l_returnStatus = 'S') then

Line 513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

509: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
510: if(l_print_pickslips = 'T') then
511: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
512: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
514: end if;
515:
516: elsif(l_returnStatus = 'S') then
517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');

Line 517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');

513: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
514: end if;
515:
516: elsif(l_returnStatus = 'S') then
517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

Line 518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);

514: end if;
515:
516: elsif(l_returnStatus = 'S') then
517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);

Line 519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

515:
516: elsif(l_returnStatus = 'S') then
517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');

517: fnd_message.set_name('WIP','WIP_PICKING_MO_NUMBER');
518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');

Line 522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);

518: fnd_message.set_token('MO_NUMBER',l_mo_req_number);
519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

519: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
520: if(l_print_pickslips = 'T') then
521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:

Line 525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');

521: fnd_message.set_name('WIP','WIP_PICKING_PRINT_SLIP');
522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:
528: elsif(l_returnStatus = 'N') then
529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');

Line 526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

522: fnd_message.set_token('REQ_NUMBER',l_conc_req_id);
523: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
524: end if;
525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:
528: elsif(l_returnStatus = 'N') then
529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

Line 529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');

525: fnd_message.set_name('WIP', 'WIP_TXN_COMPLETED');
526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:
528: elsif(l_returnStatus = 'N') then
529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');

Line 530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

526: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
527:
528: elsif(l_returnStatus = 'N') then
529: fnd_message.set_name('WIP','WIP_PICKING_NO_ALLOCATION_CONC');
530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');

Line 534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');

530: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);
538: fnd_file.put_line(which => fnd_file.output,

Line 535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

531:
532: else
533: fnd_file.put_line(which => fnd_file.output, buff => '');
534: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
535: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
536: fnd_file.put_line(which => fnd_file.output,
537: buff => 'Returned status: ' || l_returnStatus);
538: fnd_file.put_line(which => fnd_file.output,
539: buff => 'Returned message: ' || errbuf);

Line 560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');

556: errbuf := SQLERRM;
557: retcode := 2;
558: fnd_file.put_line(which => fnd_file.output, buff => '');
559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop
563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));
564: end loop;

Line 561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);

557: retcode := 2;
558: fnd_file.put_line(which => fnd_file.output, buff => '');
559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop
563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));
564: end loop;
565: rollback to eam_allocate_concurrent;