DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PUB dependencies on GMD_STATUS

Line 503: Gmd_status_pub.modify_status ( p_api_version => 1

499: V_orgn_id => p_routings.owner_organization_id, --W.r.t. bug 4004501
500: X_entity_status => l_entity_status);
501: --Add this code after the call to gmd_routings_pkg.insert_row.
502: IF (l_entity_status.entity_status > 100) THEN
503: Gmd_status_pub.modify_status ( p_api_version => 1
504: , p_init_msg_list => TRUE
505: , p_entity_name =>'ROUTING'
506: , p_entity_id => l_routings_rec.routing_id
507: , p_entity_no => NULL

Line 606: l_cur_status gmd_status.status_code%TYPE;

602: /* Local variable section */
603: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING';
604: l_routing_id gmd_routings.routing_id%TYPE;
605: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
606: l_cur_status gmd_status.status_code%TYPE;
607: l_owner_id gmd_routings.owner_id%TYPE;
608: l_owner_orgn_id NUMBER;
609:
610: /* Define record type that hold the routing data */

Line 715: IF NOT GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS

711:
712: FOR a IN 1 .. p_update_table.count LOOP
713: /* Validation: status dependencies */
714: IF UPPER(p_update_table(a).p_col_to_update) = 'STATUS' THEN
715: IF NOT GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS
716: ( P_Entity_Type => 4,
717: P_Entity_id => l_routing_id,
718: P_Current_Status => l_cur_status,
719: P_To_Status => p_update_table(a).p_value) THEN

Line 720: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');

716: ( P_Entity_Type => 4,
717: P_Entity_id => l_routing_id,
718: P_Current_Status => l_cur_status,
719: P_To_Status => p_update_table(a).p_value) THEN
720: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');
721: FND_MSG_PUB.ADD;
722: RAISE routing_update_failure;
723: END IF;
724: /* Validation : Check if owner_orgn_id is valid */