eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_EXT_CONTACTS_PKG dependencies on FND_API

Line 23: P_customer_product_id IN NUMBER := FND_API.G_MISS_NUM,

19: RETURN l_Txn_Type_Id;
20: END Get_Txn_Type;
21: -- Procedure to convert Contacts parameters to RecordType
22: PROCEDURE Convert_Contact_Param_To_Rec(
23: P_customer_product_id IN NUMBER := FND_API.G_MISS_NUM,
24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,

Line 24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,

20: END Get_Txn_Type;
21: -- Procedure to convert Contacts parameters to RecordType
22: PROCEDURE Convert_Contact_Param_To_Rec(
23: P_customer_product_id IN NUMBER := FND_API.G_MISS_NUM,
24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

21: -- Procedure to convert Contacts parameters to RecordType
22: PROCEDURE Convert_Contact_Param_To_Rec(
23: P_customer_product_id IN NUMBER := FND_API.G_MISS_NUM,
24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

22: PROCEDURE Convert_Contact_Param_To_Rec(
23: P_customer_product_id IN NUMBER := FND_API.G_MISS_NUM,
24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,

23: P_customer_product_id IN NUMBER := FND_API.G_MISS_NUM,
24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

24: P_CS_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

25: P_contact_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: P_contact_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,

27: P_contact_id IN NUMBER := FND_API.G_MISS_NUM,
28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,

28: P_primary_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,

29: P_preferred_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

30: P_svc_provider_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

31: P_start_date_active IN DATE := FND_API.G_MISS_DATE,
32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

32: P_end_date_active IN DATE := FND_API.G_MISS_DATE,
33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

33: P_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: P_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: P_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: P_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: P_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: P_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: P_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: P_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

41: P_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl) IS

Line 46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: P_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl) IS
50: CURSOR CONTACT_IP(P_INSTANCE_ID NUMBER ) IS

Line 47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: P_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl) IS
50: CURSOR CONTACT_IP(P_INSTANCE_ID NUMBER ) IS
51: select instance_party_id

Line 48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: P_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl) IS
50: CURSOR CONTACT_IP(P_INSTANCE_ID NUMBER ) IS
51: select instance_party_id
52: from csi_i_parties

Line 62: X_party_tbl(1).instance_id := NVL(P_customer_product_Id,FND_API.G_MISS_NUM);

58: LOOP
59: x_party_tbl(1).contact_ip_id:=contact_ip_rec.instance_party_id;
60: END LOOP;
61:
62: X_party_tbl(1).instance_id := NVL(P_customer_product_Id,FND_API.G_MISS_NUM);
63: X_party_tbl(1).party_source_table := NVL(P_Contact_Category,FND_API.G_MISS_CHAR);
64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);
65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';

Line 63: X_party_tbl(1).party_source_table := NVL(P_Contact_Category,FND_API.G_MISS_CHAR);

59: x_party_tbl(1).contact_ip_id:=contact_ip_rec.instance_party_id;
60: END LOOP;
61:
62: X_party_tbl(1).instance_id := NVL(P_customer_product_Id,FND_API.G_MISS_NUM);
63: X_party_tbl(1).party_source_table := NVL(P_Contact_Category,FND_API.G_MISS_CHAR);
64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);
65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);

Line 64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);

60: END LOOP;
61:
62: X_party_tbl(1).instance_id := NVL(P_customer_product_Id,FND_API.G_MISS_NUM);
63: X_party_tbl(1).party_source_table := NVL(P_Contact_Category,FND_API.G_MISS_CHAR);
64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);
65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);

Line 65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);

61:
62: X_party_tbl(1).instance_id := NVL(P_customer_product_Id,FND_API.G_MISS_NUM);
63: X_party_tbl(1).party_source_table := NVL(P_Contact_Category,FND_API.G_MISS_CHAR);
64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);
65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);

Line 67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);

63: X_party_tbl(1).party_source_table := NVL(P_Contact_Category,FND_API.G_MISS_CHAR);
64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);
65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);

Line 68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);

64: X_party_tbl(1).party_id := NVL(P_Contact_Id,FND_API.G_MISS_NUM);
65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);

Line 69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);

65: X_party_tbl(1).relationship_type_code := NVL(P_Contact_Type,FND_API.G_MISS_CHAR);
66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);

Line 70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);

66: X_party_tbl(1).contact_flag := 'Y';
67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);

Line 71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);

67: X_party_tbl(1).Instance_Party_Id := NVL(P_cs_Contact_Id,FND_API.G_MISS_NUM);
68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);

Line 72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);

68: X_party_tbl(1).active_start_date :=NVL(P_Start_Date_Active,FND_API.G_MISS_DATE);
69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);

Line 73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);

69: X_Party_tbl(1).primary_flag := NVL(P_primary_flag,FND_API.G_MISS_CHAR);
70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);

Line 74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);

70: X_Party_tbl(1).preferred_flag := NVL(P_preferred_flag,FND_API.G_MISS_CHAR);
71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);

Line 75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);

71: X_Party_tbl(1).context := NVL(P_context,FND_API.G_MISS_CHAR);
72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);

Line 76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);

72: X_Party_tbl(1).Attribute1 := NVL(P_Attribute1,FND_API.G_MISS_CHAR);
73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);

Line 77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);

73: X_Party_tbl(1).Attribute2 := NVL(P_Attribute2,FND_API.G_MISS_CHAR);
74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);

Line 78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);

74: X_Party_tbl(1).Attribute3 := NVL(P_Attribute3,FND_API.G_MISS_CHAR);
75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);

Line 79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);

75: X_Party_tbl(1).Attribute4 := NVL(P_Attribute4,FND_API.G_MISS_CHAR);
76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);

Line 80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);

76: X_Party_tbl(1).Attribute5 := NVL(P_Attribute5,FND_API.G_MISS_CHAR);
77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);

Line 81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);

77: X_Party_tbl(1).Attribute6 := NVL(P_Attribute6,FND_API.G_MISS_CHAR);
78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);
85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);

Line 82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);

78: X_Party_tbl(1).Attribute7 := NVL(P_Attribute7,FND_API.G_MISS_CHAR);
79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);
85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);
86: X_Party_tbl(1).Attribute15 := NVL(P_Attribute15,FND_API.G_MISS_CHAR);

Line 83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);

79: X_Party_tbl(1).Attribute8 := NVL(P_Attribute8,FND_API.G_MISS_CHAR);
80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);
85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);
86: X_Party_tbl(1).Attribute15 := NVL(P_Attribute15,FND_API.G_MISS_CHAR);
87: END Convert_Contact_Param_To_Rec;

Line 84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);

80: X_Party_tbl(1).Attribute9 := NVL(P_Attribute9,FND_API.G_MISS_CHAR);
81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);
85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);
86: X_Party_tbl(1).Attribute15 := NVL(P_Attribute15,FND_API.G_MISS_CHAR);
87: END Convert_Contact_Param_To_Rec;
88:

Line 85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);

81: X_Party_tbl(1).Attribute10 := NVL(P_Attribute10,FND_API.G_MISS_CHAR);
82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);
85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);
86: X_Party_tbl(1).Attribute15 := NVL(P_Attribute15,FND_API.G_MISS_CHAR);
87: END Convert_Contact_Param_To_Rec;
88:
89: PROCEDURE Insert_Row(

Line 86: X_Party_tbl(1).Attribute15 := NVL(P_Attribute15,FND_API.G_MISS_CHAR);

82: X_Party_tbl(1).Attribute11 := NVL(P_Attribute11,FND_API.G_MISS_CHAR);
83: X_Party_tbl(1).Attribute12 := NVL(P_Attribute12,FND_API.G_MISS_CHAR);
84: X_Party_tbl(1).Attribute13 := NVL(P_Attribute13,FND_API.G_MISS_CHAR);
85: X_Party_tbl(1).Attribute14 := NVL(P_Attribute14,FND_API.G_MISS_CHAR);
86: X_Party_tbl(1).Attribute15 := NVL(P_Attribute15,FND_API.G_MISS_CHAR);
87: END Convert_Contact_Param_To_Rec;
88:
89: PROCEDURE Insert_Row(
90: p_customer_product_id IN NUMBER,

Line 127: l_Commit VARCHAR2(1) := FND_API.G_FALSE;

123: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
124: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
125: l_Api_Version NUMBER DEFAULT 1;
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
127: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
128: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
129: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
130: l_Return_Status VARCHAR2(1);
131: l_Msg_Index NUMBER;

Line 128: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;

124: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
125: l_Api_Version NUMBER DEFAULT 1;
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
127: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
128: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
129: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
130: l_Return_Status VARCHAR2(1);
131: l_Msg_Index NUMBER;
132:

Line 129: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;

125: l_Api_Version NUMBER DEFAULT 1;
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
127: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
128: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
129: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
130: l_Return_Status VARCHAR2(1);
131: l_Msg_Index NUMBER;
132:
133: -- added as part of fix for Bug 2733128

Line 192: p_commit => fnd_api.g_false,

188: */
189:
190: csi_item_instance_pub.update_item_instance(
191: p_api_version => 1.0,
192: p_commit => fnd_api.g_false,
193: p_init_msg_list => fnd_api.g_true,
194: p_validation_level => fnd_api.g_valid_level_full,
195: p_instance_rec => l_chg_instance_rec,
196: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,

Line 193: p_init_msg_list => fnd_api.g_true,

189:
190: csi_item_instance_pub.update_item_instance(
191: p_api_version => 1.0,
192: p_commit => fnd_api.g_false,
193: p_init_msg_list => fnd_api.g_true,
194: p_validation_level => fnd_api.g_valid_level_full,
195: p_instance_rec => l_chg_instance_rec,
196: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
197: p_party_tbl => l_Party_Tbl,

Line 194: p_validation_level => fnd_api.g_valid_level_full,

190: csi_item_instance_pub.update_item_instance(
191: p_api_version => 1.0,
192: p_commit => fnd_api.g_false,
193: p_init_msg_list => fnd_api.g_true,
194: p_validation_level => fnd_api.g_valid_level_full,
195: p_instance_rec => l_chg_instance_rec,
196: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
197: p_party_tbl => l_Party_Tbl,
198: p_account_tbl => l_Party_Account_Tbl,

Line 208: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success

204: x_return_status => x_Return_Status,
205: x_msg_count => x_Msg_Count,
206: x_msg_data => x_Msg_Data);
207:
208: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success
209: THEN
210: l_msg_index := 1;
211: WHILE x_msg_count > 0
212: LOOP

Line 214: FND_API.G_FALSE);

210: l_msg_index := 1;
211: WHILE x_msg_count > 0
212: LOOP
213: x_Msg_Data:= x_Msg_Data||FND_MSG_PUB.GET(l_msg_index,
214: FND_API.G_FALSE);
215: l_msg_index := l_msg_index + 1;
216: x_Msg_Count := x_Msg_Count - 1;
217: END LOOP;
218: RAISE fnd_api.g_Exc_Error;

Line 218: RAISE fnd_api.g_Exc_Error;

214: FND_API.G_FALSE);
215: l_msg_index := l_msg_index + 1;
216: x_Msg_Count := x_Msg_Count - 1;
217: END LOOP;
218: RAISE fnd_api.g_Exc_Error;
219: END IF;
220: x_Cs_Contact_Id := l_Party_Tbl(1).Instance_Party_Id;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218: RAISE fnd_api.g_Exc_Error;
219: END IF;
220: x_Cs_Contact_Id := l_Party_Tbl(1).Instance_Party_Id;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR ;
224: FND_MSG_PUB.Count_And_Get
225: (p_count => x_msg_count ,
226: p_data => x_msg_data

Line 223: x_return_status := FND_API.G_RET_STS_ERROR ;

219: END IF;
220: x_Cs_Contact_Id := l_Party_Tbl(1).Instance_Party_Id;
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_ERROR ;
224: FND_MSG_PUB.Count_And_Get
225: (p_count => x_msg_count ,
226: p_data => x_msg_data
227: );

Line 228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

224: FND_MSG_PUB.Count_And_Get
225: (p_count => x_msg_count ,
226: p_data => x_msg_data
227: );
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count ,
232: p_data => x_msg_data

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225: (p_count => x_msg_count ,
226: p_data => x_msg_data
227: );
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count ,
232: p_data => x_msg_data
233: );

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

231: (p_count => x_msg_count ,
232: p_data => x_msg_data
233: );
234: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
238: END IF;
239: FND_MSG_PUB.Count_And_Get

Line 258: l_Commit VARCHAR2(1) := FND_API.G_FALSE;

254: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
255: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
256: l_Api_Version NUMBER DEFAULT 1;
257: l_Api_Name VARCHAR2(30) := 'Delete_Row';
258: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
259: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
260: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
261: l_Msg_Index NUMBER;
262: begin

Line 259: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;

255: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
256: l_Api_Version NUMBER DEFAULT 1;
257: l_Api_Name VARCHAR2(30) := 'Delete_Row';
258: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
259: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
260: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
261: l_Msg_Index NUMBER;
262: begin
263: l_Party_Tbl(1).Instance_Party_Id := p_CS_Contact_ID;

Line 260: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;

256: l_Api_Version NUMBER DEFAULT 1;
257: l_Api_Name VARCHAR2(30) := 'Delete_Row';
258: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
259: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
260: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
261: l_Msg_Index NUMBER;
262: begin
263: l_Party_Tbl(1).Instance_Party_Id := p_CS_Contact_ID;
264: l_Party_Tbl(1).Object_Version_Number := p_Object_Version_Number;

Line 280: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success

276: x_return_status => x_Return_Status,
277: x_msg_count => x_Msg_Count,
278: x_msg_data => x_Msg_Data );
279:
280: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success
281: THEN
282: l_msg_index := 1;
283: WHILE x_msg_count > 0
284: LOOP

Line 286: FND_API.G_FALSE);

282: l_msg_index := 1;
283: WHILE x_msg_count > 0
284: LOOP
285: x_Msg_Data := x_Msg_Data||FND_MSG_PUB.GET(l_msg_index,
286: FND_API.G_FALSE);
287: l_msg_index := l_msg_index + 1;
288: x_Msg_Count := x_Msg_Count - 1;
289: END LOOP;
290: RAISE fnd_api.g_Exc_Error;

Line 290: RAISE fnd_api.g_Exc_Error;

286: FND_API.G_FALSE);
287: l_msg_index := l_msg_index + 1;
288: x_Msg_Count := x_Msg_Count - 1;
289: END LOOP;
290: RAISE fnd_api.g_Exc_Error;
291: END IF;
292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN

Line 294: WHEN FND_API.G_EXC_ERROR THEN

290: RAISE fnd_api.g_Exc_Error;
291: END IF;
292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: (p_count => x_msg_count ,
298: p_data => x_msg_data

Line 295: x_return_status := FND_API.G_RET_STS_ERROR ;

291: END IF;
292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: (p_count => x_msg_count ,
298: p_data => x_msg_data
299: );

Line 300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

296: FND_MSG_PUB.Count_And_Get
297: (p_count => x_msg_count ,
298: p_data => x_msg_data
299: );
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count ,
304: p_data => x_msg_data

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

297: (p_count => x_msg_count ,
298: p_data => x_msg_data
299: );
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count ,
304: p_data => x_msg_data
305: );

Line 307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

303: (p_count => x_msg_count ,
304: p_data => x_msg_data
305: );
306: WHEN OTHERS THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
310: END IF;
311: FND_MSG_PUB.Count_And_Get

Line 508: l_Commit VARCHAR2(1) := FND_API.G_FALSE;

504: )
505: IS
506: l_api_name CONSTANT VARCHAR2(30) := 'Update_Contact';
507: l_api_version CONSTANT NUMBER := 1.0;
508: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
509: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
511: l_Msg_Index NUMBER;
512: l_Party_Tbl csi_datastructures_pub.party_tbl;

Line 509: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;

505: IS
506: l_api_name CONSTANT VARCHAR2(30) := 'Update_Contact';
507: l_api_version CONSTANT NUMBER := 1.0;
508: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
509: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
511: l_Msg_Index NUMBER;
512: l_Party_Tbl csi_datastructures_pub.party_tbl;
513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;

Line 510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;

506: l_api_name CONSTANT VARCHAR2(30) := 'Update_Contact';
507: l_api_version CONSTANT NUMBER := 1.0;
508: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
509: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
511: l_Msg_Index NUMBER;
512: l_Party_Tbl csi_datastructures_pub.party_tbl;
513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;
514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;

Line 578: p_commit => fnd_api.g_false,

574: */
575:
576: csi_item_instance_pub.update_item_instance(
577: p_api_version => 1.0,
578: p_commit => fnd_api.g_false,
579: p_init_msg_list => fnd_api.g_true,
580: p_validation_level => fnd_api.g_valid_level_full,
581: p_instance_rec => l_chg_instance_rec,
582: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,

Line 579: p_init_msg_list => fnd_api.g_true,

575:
576: csi_item_instance_pub.update_item_instance(
577: p_api_version => 1.0,
578: p_commit => fnd_api.g_false,
579: p_init_msg_list => fnd_api.g_true,
580: p_validation_level => fnd_api.g_valid_level_full,
581: p_instance_rec => l_chg_instance_rec,
582: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
583: p_party_tbl => l_party_tbl,

Line 580: p_validation_level => fnd_api.g_valid_level_full,

576: csi_item_instance_pub.update_item_instance(
577: p_api_version => 1.0,
578: p_commit => fnd_api.g_false,
579: p_init_msg_list => fnd_api.g_true,
580: p_validation_level => fnd_api.g_valid_level_full,
581: p_instance_rec => l_chg_instance_rec,
582: p_ext_attrib_values_tbl => l_chg_ext_attrib_val_tbl,
583: p_party_tbl => l_party_tbl,
584: p_account_tbl => l_account_tbl,

Line 594: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success

590: x_return_status => x_return_status,
591: x_msg_count => x_msg_count,
592: x_msg_data => x_msg_data);
593:
594: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success
595: THEN
596: l_msg_index := 1;
597: WHILE x_msg_count > 0
598: LOOP

Line 600: FND_API.G_FALSE);

596: l_msg_index := 1;
597: WHILE x_msg_count > 0
598: LOOP
599: x_Msg_Data := x_Msg_Data||FND_MSG_PUB.GET(l_msg_index,
600: FND_API.G_FALSE);
601: l_msg_index := l_msg_index + 1;
602: x_Msg_Count := x_Msg_Count - 1;
603: END LOOP;
604: RAISE fnd_api.g_Exc_Error;

Line 604: RAISE fnd_api.g_Exc_Error;

600: FND_API.G_FALSE);
601: l_msg_index := l_msg_index + 1;
602: x_Msg_Count := x_Msg_Count - 1;
603: END LOOP;
604: RAISE fnd_api.g_Exc_Error;
605: END IF;
606:
607: EXCEPTION
608: WHEN FND_API.G_EXC_ERROR THEN

Line 608: WHEN FND_API.G_EXC_ERROR THEN

604: RAISE fnd_api.g_Exc_Error;
605: END IF;
606:
607: EXCEPTION
608: WHEN FND_API.G_EXC_ERROR THEN
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count ,
612: p_data => x_msg_data

Line 609: x_return_status := FND_API.G_RET_STS_ERROR ;

605: END IF;
606:
607: EXCEPTION
608: WHEN FND_API.G_EXC_ERROR THEN
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count ,
612: p_data => x_msg_data
613: );

Line 614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count ,
612: p_data => x_msg_data
613: );
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
616: FND_MSG_PUB.Count_And_Get
617: (p_count => x_msg_count ,
618: p_data => x_msg_data

Line 615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

611: (p_count => x_msg_count ,
612: p_data => x_msg_data
613: );
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
616: FND_MSG_PUB.Count_And_Get
617: (p_count => x_msg_count ,
618: p_data => x_msg_data
619: );

Line 621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

617: (p_count => x_msg_count ,
618: p_data => x_msg_data
619: );
620: WHEN OTHERS THEN
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
623: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
624: END IF;
625: FND_MSG_PUB.Count_And_Get