APPS.CUG_VALIDATE_ADDRESS_PUB dependencies on CUG_VALIDATE_ADDRESS_PUB

Line 1: Package Body CUG_VALIDATE_ADDRESS_PUB AS

1: Package Body CUG_VALIDATE_ADDRESS_PUB AS
2: /* $Header: CUGVADRB.pls 120.0 2006/03/01 18:39:10 spusegao noship $ */
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 17: G_PKG_NAME CONSTANT VARCHAR2(25):= 'CUG_VALIDATE_ADDRESS_PUB';

13:
14:
15: -- Enter procedure, function bodies as shown below
16:
17: G_PKG_NAME CONSTANT VARCHAR2(25):= 'CUG_VALIDATE_ADDRESS_PUB';
18:
19: PROCEDURE Validate_Incident_Address (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

Line 24: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,

20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
22: p_commit IN VARCHAR2 default fnd_api.g_false,
23: p_incident_type_id IN NUMBER,
24: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
27: x_return_status OUT NOCOPY VARCHAR2,
28: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL)

Line 43: l_incident_address_rec CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL;

39: l_msg_data VARCHAR2(2000);
40: l_location_id NUMBER;
41: l_incident_id NUMBER;
42:
43: l_incident_address_rec CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL;
44: l_incident_address_index BINARY_INTEGER;
45:
46: Begin
47:

Line 57: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

53: l_incident_address_rec(l_incident_address_index).validation_status := 'S';
54:
55:
56: -- Pre Call to Customer Hook
57: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
58: 'Validate_Address',
59: 'B', 'C') THEN
60:
61:

Line 85: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

81:
82:
83: -- Pre call to the Vertical Type User Hook
84: --
85: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
86: 'Validate_Address',
87: 'B', 'V') THEN
88:
89: CUG_Validate_Address_VUHK.Validate_Incident_Address_Pre (

Line 136: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

132: -- End of changes by ANEEMUCH
133:
134:
135: -- Post Call to Customer Hook
136: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
137: 'Validate_Address',
138: 'A', 'C') THEN
139:
140: CUG_Validate_Address_CUHK.Validate_Incident_Address_Post (

Line 161: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

157: END IF;
158:
159: -- Post call to the Vertical Type User Hook
160: --
161: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
162: 'Validate_Address',
163: 'A', 'V') THEN
164:
165: CUG_Validate_Address_VUHK.Validate_Incident_Address_Post (

Line 193: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,

189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
191: p_commit IN VARCHAR2 default fnd_api.g_false,
192: p_incident_type_id IN NUMBER,
193: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: x_return_status OUT NOCOPY VARCHAR2,
197: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL)

Line 212: l_incident_address_rec CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL;

208: l_msg_data VARCHAR2(2000);
209: l_location_id NUMBER;
210: l_incident_id NUMBER;
211:
212: l_incident_address_rec CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL;
213: l_incident_address_index BINARY_INTEGER;
214:
215: Begin
216:

Line 227: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

223:
224:
225:
226: -- Pre Call to Customer Hook
227: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
228: 'Validate_Type',
229: 'B', 'C') THEN
230:
231: CUG_Validate_Address_CUHK.Validate_Incident_Type_Pre (

Line 253: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

249:
250:
251: -- Pre call to the Vertical Type User Hook
252: --
253: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
254: 'Validate_Type',
255: 'B', 'V') THEN
256:
257: CUG_Validate_Address_VUHK.Validate_Incident_Type_Pre (

Line 304: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

300: -- End of changes by ANEEMUCH
301:
302:
303: -- Post Call to Customer Hook
304: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
305: 'Validate_Type',
306: 'A', 'C') THEN
307:
308:

Line 330: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',

326: END IF;
327:
328: -- Post call to the Vertical Type User Hook
329: --
330: IF jtf_usr_hks.Ok_To_Execute('CUG_Validate_Address_Pub',
331: 'Validate_Type',
332: 'A', 'V') THEN
333:
334: CUG_Validate_Address_VUHK.Validate_Incident_Type_Post (

Line 357: END CUG_VALIDATE_ADDRESS_PUB;

353: END Validate_Incident_Type;
354:
355:
356:
357: END CUG_VALIDATE_ADDRESS_PUB;