APPS.GMD_ROUTINGS_PUB dependencies on GMD_STATUS

Line 528: Gmd_status_pub.modify_status ( p_api_version => 1

524: V_orgn_id => p_routings.owner_organization_id, --W.r.t. bug 4004501
525: X_entity_status => l_entity_status);
526: --Add this code after the call to gmd_routings_pkg.insert_row.
527: IF (l_entity_status.entity_status > 100) THEN
528: Gmd_status_pub.modify_status ( p_api_version => 1
529: , p_init_msg_list => TRUE
530: , p_entity_name =>'ROUTING'
531: , p_entity_id => l_routings_rec.routing_id
532: , p_entity_no => NULL

Line 633: l_cur_status gmd_status.status_code%TYPE;

629: /* Local variable section */
630: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING';
631: l_routing_id gmd_routings.routing_id%TYPE;
632: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
633: l_cur_status gmd_status.status_code%TYPE;
634: l_owner_id gmd_routings.owner_id%TYPE;
635: l_owner_orgn_id NUMBER;
636:
637: /* Define record type that hold the routing data */

Line 751: IF NOT GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS

747:
748: FOR a IN 1 .. p_update_table.count LOOP
749: /* Validation: status dependencies */
750: IF UPPER(p_update_table(a).p_col_to_update) = 'STATUS' THEN
751: IF NOT GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS
752: ( P_Entity_Type => 4,
753: P_Entity_id => l_routing_id,
754: P_Current_Status => l_cur_status,
755: P_To_Status => p_update_table(a).p_value) THEN

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

752: ( P_Entity_Type => 4,
753: P_Entity_id => l_routing_id,
754: P_Current_Status => l_cur_status,
755: P_To_Status => p_update_table(a).p_value) THEN
756: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');
757: FND_MSG_PUB.ADD;
758: RAISE routing_update_failure;
759: END IF;
760: /* Validation : Check if owner_orgn_id is valid */