[Home] [Help]
46: l_api_name CONSTANT VARCHAR2(30) := 'Get_OrgId' ;
47: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
48: l_api_version CONSTANT NUMBER := 1.0 ;
49:
50: l_debug number := ASO_DEBUG_PUB.G_DEBUG_LEVEL ;
51:
52: l_rel_type_code csi_i_org_assignments.relationship_type_code%TYPE := 'SERVICED_BY';
53: l_rule_code cs_multi_org_rules.multi_org_rule_code%TYPE;
54: l_rule_order cs_multi_org_rules.multi_org_rule_order%TYPE;
124: FND_MSG_PUB.initialize;
125: END IF;
126:
127: if (l_debug > 0) then
128: aso_debug_pub.add ('Private API: ' || l_api_name_full || ' start', 1, 'Y');
129: end if;
130:
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
135: -- API body
136: --
137: -- Local Procedure
138: if (l_debug > 0) then
139: aso_debug_pub.add(l_api_name_full || ': Incident Id =' || p_incident_id, 1, 'Y');
140: end if;
141:
142: -- Validate parameters
143: IF (p_incident_id is null) THEN
140: end if;
141:
142: -- Validate parameters
143: IF (p_incident_id is null) THEN
144: aso_debug_pub.add(l_api_name_full || ': invalid input parameter: p_incident_id', 1, 'Y');
145: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
146: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
147: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
148: FND_MSG_PUB.Add;
257: COMMIT WORK;
258: END IF;
259:
260: if (l_debug > 0) then
261: aso_debug_pub.add ('Private API: ' || l_api_name_full || ' end', 1, 'Y');
262: end if;
263:
264: -- Standard call to get message count and if count is 1, get message info.
265: FND_MSG_PUB.Count_And_Get