APPS.OKL_STREAM_BILLING_PUB dependencies on FND_API

Line 41: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

37: ------------------------------------------------------------
38: -- Start processing
39: ------------------------------------------------------------
40:
41: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
42:
43: SAVEPOINT sp_bill_streams;
44:
45: l_contract_number := p_contract_number;

Line 68: p_commit => FND_API.G_TRUE,

64: p_init_msg_list => p_init_msg_list,
65: x_return_status => l_return_status,
66: x_msg_count => x_msg_count,
67: x_msg_data => x_msg_data,
68: p_commit => FND_API.G_TRUE,
69: p_contract_number => l_contract_number,
70: p_from_bill_date => l_from_bill_date,
71: p_to_bill_date => l_to_bill_date,
72: p_cust_acct_id => p_cust_acct_id,

Line 76: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

72: p_cust_acct_id => p_cust_acct_id,
73: p_assigned_process => p_assigned_process);
74:
75:
76: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
77: --Added by jjuneja
78: x_return_status:=l_return_status;
79: --End of addition by jjuneja
80: NULL;

Line 81: --RAISE Fnd_Api.G_EXC_ERROR;

77: --Added by jjuneja
78: x_return_status:=l_return_status;
79: --End of addition by jjuneja
80: NULL;
81: --RAISE Fnd_Api.G_EXC_ERROR;
82: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
83: --Added by jjuneja
84: x_return_status:=l_return_status;
85: --End of addition by jjuneja

Line 82: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

78: x_return_status:=l_return_status;
79: --End of addition by jjuneja
80: NULL;
81: --RAISE Fnd_Api.G_EXC_ERROR;
82: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
83: --Added by jjuneja
84: x_return_status:=l_return_status;
85: --End of addition by jjuneja
86: NULL;

Line 87: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

83: --Added by jjuneja
84: x_return_status:=l_return_status;
85: --End of addition by jjuneja
86: NULL;
87: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: ------------------------------------------------------------
91: ------------------------------------------------------------

Line 105: WHEN Fnd_Api.G_EXC_ERROR THEN

101: ------------------------------------------------------------
102: -- Exception handling
103: ------------------------------------------------------------
104:
105: WHEN Fnd_Api.G_EXC_ERROR THEN
106:
107: IF p_assigned_process IS NOT NULL THEN
108: DELETE OKL_PARALLEL_PROCESSES
109: WHERE assigned_process = p_assigned_process;

Line 114: x_return_status := Fnd_Api.G_RET_STS_ERROR;

110: COMMIT;
111: END IF;
112:
113: ROLLBACK TO sp_bill_streams;
114: x_return_status := Fnd_Api.G_RET_STS_ERROR;
115: Fnd_Msg_Pub.Count_and_get (
116: p_encoded => Okc_Api.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data);

Line 120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

116: p_encoded => Okc_Api.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data);
119:
120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
121:
122: IF p_assigned_process IS NOT NULL THEN
123: DELETE OKL_PARALLEL_PROCESSES
124: WHERE assigned_process = p_assigned_process;

Line 129: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

125: COMMIT;
126: END IF;
127:
128: ROLLBACK TO sp_bill_streams;
129: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
130: Fnd_Msg_Pub.Count_and_get (
131: p_encoded => Okc_Api.G_FALSE,
132: p_count => x_msg_count,
133: p_data => x_msg_data);

Line 143: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

139: WHERE assigned_process = p_assigned_process;
140: COMMIT;
141: END IF;
142:
143: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
144: Fnd_Msg_Pub.ADD_EXC_MSG (
145: p_pkg_name => G_PKG_NAME,
146: p_procedure_name => l_api_name);
147: Fnd_Msg_Pub.Count_and_get (