[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;
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: if (l_debug > 0) then
127: aso_debug_pub.add ('Private API: ' || l_api_name_full || ' start', 1, 'Y');
128: end if;
129:
130: -- Initialize API return status to success
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: -- API body
135: --
136: -- Local Procedure
137: if (l_debug > 0) then
138: aso_debug_pub.add(l_api_name_full || ': Incident Id =' || p_incident_id, 1, 'Y');
139: end if;
140:
141: -- Validate parameters
142: IF (p_incident_id is null) THEN
139: end if;
140:
141: -- Validate parameters
142: IF (p_incident_id is null) THEN
143: aso_debug_pub.add(l_api_name_full || ': invalid input parameter: p_incident_id', 1, 'Y');
144: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
145: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
146: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
147: FND_MSG_PUB.Add;
240: COMMIT WORK;
241: END IF;
242:
243: if (l_debug > 0) then
244: aso_debug_pub.add ('Private API: ' || l_api_name_full || ' end', 1, 'Y');
245: end if;
246:
247: -- Standard call to get message count and if count is 1, get message info.
248: FND_MSG_PUB.Count_And_Get