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.ASO_CORE_CONTRACTS_PUB dependencies on FND_API

Line 17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

13: g_login_id NUMBER := fnd_global.conc_login_id;
14:
15: PROCEDURE create_contract (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_quote_id IN NUMBER,
20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,

Line 18: p_commit IN VARCHAR2 := fnd_api.g_false,

14:
15: PROCEDURE create_contract (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_quote_id IN NUMBER,
20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

Line 20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,

16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_quote_id IN NUMBER,
20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,

Line 21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,

17: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_quote_id IN NUMBER,
20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,

Line 22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

18: p_commit IN VARCHAR2 := fnd_api.g_false,
19: p_quote_id IN NUMBER,
20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,
26: p_template_id IN NUMBER := fnd_api.g_miss_num,

Line 23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,

19: p_quote_id IN NUMBER,
20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,
26: p_template_id IN NUMBER := fnd_api.g_miss_num,
27: p_template_major_version IN NUMBER := fnd_api.g_miss_num,

Line 24: p_party_id IN NUMBER := fnd_api.g_miss_num,

20: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,
26: p_template_id IN NUMBER := fnd_api.g_miss_num,
27: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
28: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 25: p_resource_id IN NUMBER := fnd_api.g_miss_num,

21: p_rel_type IN VARCHAR2 := fnd_api.g_miss_char,
22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,
26: p_template_id IN NUMBER := fnd_api.g_miss_num,
27: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
28: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
29: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 26: p_template_id IN NUMBER := fnd_api.g_miss_num,

22: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,
26: p_template_id IN NUMBER := fnd_api.g_miss_num,
27: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
28: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
29: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
30: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 27: p_template_major_version IN NUMBER := fnd_api.g_miss_num,

23: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
24: p_party_id IN NUMBER := fnd_api.g_miss_num,
25: p_resource_id IN NUMBER := fnd_api.g_miss_num,
26: p_template_id IN NUMBER := fnd_api.g_miss_num,
27: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
28: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
29: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
30: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

42: END create_contract;
43:
44: PROCEDURE update_contract (
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_quote_id IN NUMBER,
49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

Line 47: p_commit IN VARCHAR2 := fnd_api.g_false,

43:
44: PROCEDURE update_contract (
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_quote_id IN NUMBER,
49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,

Line 49: p_contract_id IN NUMBER := fnd_api.g_miss_num,

45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_quote_id IN NUMBER,
49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
52: p_party_id IN NUMBER := fnd_api.g_miss_num,
53: p_resource_id IN NUMBER := fnd_api.g_miss_num,

Line 50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_quote_id IN NUMBER,
49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
52: p_party_id IN NUMBER := fnd_api.g_miss_num,
53: p_resource_id IN NUMBER := fnd_api.g_miss_num,
54: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,

47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_quote_id IN NUMBER,
49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
52: p_party_id IN NUMBER := fnd_api.g_miss_num,
53: p_resource_id IN NUMBER := fnd_api.g_miss_num,
54: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 52: p_party_id IN NUMBER := fnd_api.g_miss_num,

48: p_quote_id IN NUMBER,
49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
52: p_party_id IN NUMBER := fnd_api.g_miss_num,
53: p_resource_id IN NUMBER := fnd_api.g_miss_num,
54: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
56: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 53: p_resource_id IN NUMBER := fnd_api.g_miss_num,

49: p_contract_id IN NUMBER := fnd_api.g_miss_num,
50: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
51: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
52: p_party_id IN NUMBER := fnd_api.g_miss_num,
53: p_resource_id IN NUMBER := fnd_api.g_miss_num,
54: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
56: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57: ) IS

Line 70: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

66: END update_contract;
67:
68: PROCEDURE notify_contract_change (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
71: p_commit IN VARCHAR2 := fnd_api.g_false,
72: p_quote_id IN NUMBER,
73: p_notification_type IN VARCHAR2,
74: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,

Line 71: p_commit IN VARCHAR2 := fnd_api.g_false,

67:
68: PROCEDURE notify_contract_change (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
71: p_commit IN VARCHAR2 := fnd_api.g_false,
72: p_quote_id IN NUMBER,
73: p_notification_type IN VARCHAR2,
74: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
75: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,

Line 74: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,

70: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
71: p_commit IN VARCHAR2 := fnd_api.g_false,
72: p_quote_id IN NUMBER,
73: p_notification_type IN VARCHAR2,
74: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
75: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
76: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
77: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
78: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 75: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,

71: p_commit IN VARCHAR2 := fnd_api.g_false,
72: p_quote_id IN NUMBER,
73: p_notification_type IN VARCHAR2,
74: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
75: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
76: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
77: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
78: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79: ) IS

Line 92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

88: END notify_contract_change;
89:
90: -- vtariker
91: PROCEDURE Check_Customer_Accounts(
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_qte_header_id IN NUMBER,
94: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
96: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 109: IF FND_API.to_Boolean( p_init_msg_list ) THEN

105: -- Standard Start of API savepoint
106: SAVEPOINT Check_Customer_Accounts_PUB;
107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: IF FND_API.to_Boolean( p_init_msg_list ) THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112:
113: -- initialize G_Debug_Flag

Line 117: x_return_status := FND_API.G_RET_STS_SUCCESS;

113: -- initialize G_Debug_Flag
114: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
115:
116: -- Initialize API return status to success
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
120: aso_debug_pub.add('Check_Customer_Accounts PUB - Begin', 1, 'Y');
121: END IF;

Line 140: IF x_return_status <> fnd_api.g_ret_sts_success THEN

136: 'Y'
137: );
138: END IF;
139:
140: IF x_return_status <> fnd_api.g_ret_sts_success THEN
141: RAISE fnd_api.g_exc_error;
142: END IF;
143:
144: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 141: RAISE fnd_api.g_exc_error;

137: );
138: END IF;
139:
140: IF x_return_status <> fnd_api.g_ret_sts_success THEN
141: RAISE fnd_api.g_exc_error;
142: END IF;
143:
144: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
145: aso_debug_pub.add('Check_Customer_Accounts PUB : End ', 1, 'N');

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: p_data => x_msg_data
151: );
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: ,X_MSG_COUNT => X_MSG_COUNT
163: ,X_MSG_DATA => X_MSG_DATA
164: ,X_RETURN_STATUS => X_RETURN_STATUS);
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
168: P_API_NAME => L_API_NAME
169: ,P_PKG_NAME => G_PKG_NAME
170: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR