DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_HEADER_UTIL dependencies on GMI_RESERVATION_UTIL

Line 451: gmi_reservation_util.println('In insert_row in GMIUMOHB.pls');

447: )
448: IS
449: BEGIN
450:
451: gmi_reservation_util.println('In insert_row in GMIUMOHB.pls');
452: gmi_reservation_util.println('value of l_mo_hdr_rec.organization_id: '||p_mo_hdr_rec.organization_id);
453: gmi_reservation_util.println('Value of l_mo_hdr_rec.operation is '||p_mo_hdr_rec.request_number);
454:
455: INSERT INTO IC_TXN_REQUEST_HEADERS

Line 452: gmi_reservation_util.println('value of l_mo_hdr_rec.organization_id: '||p_mo_hdr_rec.organization_id);

448: IS
449: BEGIN
450:
451: gmi_reservation_util.println('In insert_row in GMIUMOHB.pls');
452: gmi_reservation_util.println('value of l_mo_hdr_rec.organization_id: '||p_mo_hdr_rec.organization_id);
453: gmi_reservation_util.println('Value of l_mo_hdr_rec.operation is '||p_mo_hdr_rec.request_number);
454:
455: INSERT INTO IC_TXN_REQUEST_HEADERS
456: ( ATTRIBUTE1

Line 453: gmi_reservation_util.println('Value of l_mo_hdr_rec.operation is '||p_mo_hdr_rec.request_number);

449: BEGIN
450:
451: gmi_reservation_util.println('In insert_row in GMIUMOHB.pls');
452: gmi_reservation_util.println('value of l_mo_hdr_rec.organization_id: '||p_mo_hdr_rec.organization_id);
453: gmi_reservation_util.println('Value of l_mo_hdr_rec.operation is '||p_mo_hdr_rec.request_number);
454:
455: INSERT INTO IC_TXN_REQUEST_HEADERS
456: ( ATTRIBUTE1
457: , ATTRIBUTE10

Line 538: gmi_reservation_util.println('End of isnert row');

534: , p_mo_hdr_rec.grouping_rule_id
535: , p_mo_hdr_rec.ship_to_location_id
536: );
537:
538: gmi_reservation_util.println('End of isnert row');
539:
540: EXCEPTION
541:
542: WHEN OTHERS THEN

Line 544: gmi_reservation_util.println('ERROR in INSERT');

540: EXCEPTION
541:
542: WHEN OTHERS THEN
543: WSH_Util_Core.PrintLn('Error In Insert');
544: gmi_reservation_util.println('ERROR in INSERT');
545: gmi_reservation_util.println(' ERR NUM => ' || SQLERRM);
546: gmi_reservation_util.println(' ERR MSG => ' || SQLCODE);
547:
548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 545: gmi_reservation_util.println(' ERR NUM => ' || SQLERRM);

541:
542: WHEN OTHERS THEN
543: WSH_Util_Core.PrintLn('Error In Insert');
544: gmi_reservation_util.println('ERROR in INSERT');
545: gmi_reservation_util.println(' ERR NUM => ' || SQLERRM);
546: gmi_reservation_util.println(' ERR MSG => ' || SQLCODE);
547:
548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN

Line 546: gmi_reservation_util.println(' ERR MSG => ' || SQLCODE);

542: WHEN OTHERS THEN
543: WSH_Util_Core.PrintLn('Error In Insert');
544: gmi_reservation_util.println('ERROR in INSERT');
545: gmi_reservation_util.println(' ERR NUM => ' || SQLERRM);
546: gmi_reservation_util.println(' ERR MSG => ' || SQLCODE);
547:
548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg