DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on FND_MESSAGE

Line 325: x_error_message := FND_MESSAGE.get;

321:
322: IF l_return_status <> 'S' THEN
323:
324: x_result := -1;
325: x_error_message := FND_MESSAGE.get;
326: return;
327:
328: END IF;
329: */

Line 396: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');

392:
393: WHEN NO_DATA_FOUND then
394: /* The req line has been deleted since it was queried up. */
395: x_result:=-1;
396: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
397: /*
398: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
399: WHERE prh.requisition_header_id = prl.requisition_header_id
400: AND prl.requisition_line_id = t_req_lines(i);

Line 402: fnd_message.set_token('REQ_NUM', x_req_num);

398: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
399: WHERE prh.requisition_header_id = prl.requisition_header_id
400: AND prl.requisition_line_id = t_req_lines(i);
401:
402: fnd_message.set_token('REQ_NUM', x_req_num);
403: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
404: */
405: rollback to CHECK_LOCK;
406: x_error_message := fnd_message.get;

Line 403: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

399: WHERE prh.requisition_header_id = prl.requisition_header_id
400: AND prl.requisition_line_id = t_req_lines(i);
401:
402: fnd_message.set_token('REQ_NUM', x_req_num);
403: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
404: */
405: rollback to CHECK_LOCK;
406: x_error_message := fnd_message.get;
407: RETURN;

Line 406: x_error_message := fnd_message.get;

402: fnd_message.set_token('REQ_NUM', x_req_num);
403: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
404: */
405: rollback to CHECK_LOCK;
406: x_error_message := fnd_message.get;
407: RETURN;
408:
409: WHEN OTHERS THEN
410: /* This is to see if req line is locked */

Line 414: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');

410: /* This is to see if req line is locked */
411: if (SQLCODE=-54)
412: THEN
413: x_result:=-1;
414: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
415: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
416: WHERE prh.requisition_header_id = prl.requisition_header_id
417: AND prl.requisition_line_id = t_req_lines(i);
418:

Line 419: fnd_message.set_token('REQ_NUM', x_req_num);

415: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
416: WHERE prh.requisition_header_id = prl.requisition_header_id
417: AND prl.requisition_line_id = t_req_lines(i);
418:
419: fnd_message.set_token('REQ_NUM', x_req_num);
420: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
421:
422: x_error_message := fnd_message.get;
423: rollback to CHECK_LOCK;

Line 420: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

416: WHERE prh.requisition_header_id = prl.requisition_header_id
417: AND prl.requisition_line_id = t_req_lines(i);
418:
419: fnd_message.set_token('REQ_NUM', x_req_num);
420: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
421:
422: x_error_message := fnd_message.get;
423: rollback to CHECK_LOCK;
424: RETURN;

Line 422: x_error_message := fnd_message.get;

418:
419: fnd_message.set_token('REQ_NUM', x_req_num);
420: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
421:
422: x_error_message := fnd_message.get;
423: rollback to CHECK_LOCK;
424: RETURN;
425: else
426: x_result:=-1;

Line 436: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');

432: if (x_req_in_pool_flag='N')
433: then
434: /* The req line has been auto created already. */
435: x_result:=-1;
436: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
437: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
438: WHERE prh.requisition_header_id = prl.requisition_header_id
439: AND prl.requisition_line_id = t_req_lines(i);
440:

Line 441: fnd_message.set_token('REQ_NUM', x_req_num);

437: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
438: WHERE prh.requisition_header_id = prl.requisition_header_id
439: AND prl.requisition_line_id = t_req_lines(i);
440:
441: fnd_message.set_token('REQ_NUM', x_req_num);
442: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
443:
444:
445: x_error_message := fnd_message.get;

Line 442: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

438: WHERE prh.requisition_header_id = prl.requisition_header_id
439: AND prl.requisition_line_id = t_req_lines(i);
440:
441: fnd_message.set_token('REQ_NUM', x_req_num);
442: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
443:
444:
445: x_error_message := fnd_message.get;
446: ROLLBACK TO CHECK_LOCK;

Line 445: x_error_message := fnd_message.get;

441: fnd_message.set_token('REQ_NUM', x_req_num);
442: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
443:
444:
445: x_error_message := fnd_message.get;
446: ROLLBACK TO CHECK_LOCK;
447: RETURN;
448:
449: elsif (x_cancel_flag = 'Y') then

Line 452: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');

448:
449: elsif (x_cancel_flag = 'Y') then
450: /* The req line has been cancelled. */
451: x_result:=-1;
452: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
453: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
454: WHERE prh.requisition_header_id = prl.requisition_header_id
455: AND prl.requisition_line_id = t_req_lines(i);
456:

Line 457: fnd_message.set_token('REQ_NUM', x_req_num);

453: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
454: WHERE prh.requisition_header_id = prl.requisition_header_id
455: AND prl.requisition_line_id = t_req_lines(i);
456:
457: fnd_message.set_token('REQ_NUM', x_req_num);
458: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
459:
460:
461: x_error_message := fnd_message.get;

Line 458: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

454: WHERE prh.requisition_header_id = prl.requisition_header_id
455: AND prl.requisition_line_id = t_req_lines(i);
456:
457: fnd_message.set_token('REQ_NUM', x_req_num);
458: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
459:
460:
461: x_error_message := fnd_message.get;
462: ROLLBACK TO CHECK_LOCK;

Line 461: x_error_message := fnd_message.get;

457: fnd_message.set_token('REQ_NUM', x_req_num);
458: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
459:
460:
461: x_error_message := fnd_message.get;
462: ROLLBACK TO CHECK_LOCK;
463: RETURN;
464:
465: elsif (x_closed_code = 'FINALLY CLOSED') then

Line 468: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');

464:
465: elsif (x_closed_code = 'FINALLY CLOSED') then
466: /* The req line has been auto created already. */
467: x_result:=-1;
468: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
469: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
470: WHERE prh.requisition_header_id = prl.requisition_header_id
471: AND prl.requisition_line_id = t_req_lines(i);
472:

Line 473: fnd_message.set_token('REQ_NUM', x_req_num);

469: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
470: WHERE prh.requisition_header_id = prl.requisition_header_id
471: AND prl.requisition_line_id = t_req_lines(i);
472:
473: fnd_message.set_token('REQ_NUM', x_req_num);
474: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
475:
476:
477: x_error_message := fnd_message.get;

Line 474: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

470: WHERE prh.requisition_header_id = prl.requisition_header_id
471: AND prl.requisition_line_id = t_req_lines(i);
472:
473: fnd_message.set_token('REQ_NUM', x_req_num);
474: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
475:
476:
477: x_error_message := fnd_message.get;
478: ROLLBACK TO CHECK_LOCK;

Line 477: x_error_message := fnd_message.get;

473: fnd_message.set_token('REQ_NUM', x_req_num);
474: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
475:
476:
477: x_error_message := fnd_message.get;
478: ROLLBACK TO CHECK_LOCK;
479: RETURN;
480:
481: end if;

Line 856: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;

852: rollback;
853: x_result := -1;
854: --
855: IF (x_error_message IS NULL) THEN
856: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;
857: END IF;
858: --
859: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
860: END;