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 67: p_commit => FND_API.G_TRUE,

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

Line 75: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

71: p_cust_acct_id => p_cust_acct_id,
72: p_assigned_process => p_assigned_process);
73:
74:
75: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
76: NULL;
77: --RAISE Fnd_Api.G_EXC_ERROR;
78: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
79: NULL;

Line 77: --RAISE Fnd_Api.G_EXC_ERROR;

73:
74:
75: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
76: NULL;
77: --RAISE Fnd_Api.G_EXC_ERROR;
78: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
79: NULL;
80: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
81: END IF;

Line 78: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

74:
75: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
76: NULL;
77: --RAISE Fnd_Api.G_EXC_ERROR;
78: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
79: NULL;
80: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82:

Line 80: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

76: NULL;
77: --RAISE Fnd_Api.G_EXC_ERROR;
78: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
79: NULL;
80: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82:
83: ------------------------------------------------------------
84: ------------------------------------------------------------

Line 98: WHEN Fnd_Api.G_EXC_ERROR THEN

94: ------------------------------------------------------------
95: -- Exception handling
96: ------------------------------------------------------------
97:
98: WHEN Fnd_Api.G_EXC_ERROR THEN
99:
100: IF p_assigned_process IS NOT NULL THEN
101: DELETE OKL_PARALLEL_PROCESSES
102: WHERE assigned_process = p_assigned_process;

Line 107: x_return_status := Fnd_Api.G_RET_STS_ERROR;

103: COMMIT;
104: END IF;
105:
106: ROLLBACK TO sp_bill_streams;
107: x_return_status := Fnd_Api.G_RET_STS_ERROR;
108: Fnd_Msg_Pub.Count_and_get (
109: p_encoded => Okc_Api.G_FALSE,
110: p_count => x_msg_count,
111: p_data => x_msg_data);

Line 113: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

109: p_encoded => Okc_Api.G_FALSE,
110: p_count => x_msg_count,
111: p_data => x_msg_data);
112:
113: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
114:
115: IF p_assigned_process IS NOT NULL THEN
116: DELETE OKL_PARALLEL_PROCESSES
117: WHERE assigned_process = p_assigned_process;

Line 122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

118: COMMIT;
119: END IF;
120:
121: ROLLBACK TO sp_bill_streams;
122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
123: Fnd_Msg_Pub.Count_and_get (
124: p_encoded => Okc_Api.G_FALSE,
125: p_count => x_msg_count,
126: p_data => x_msg_data);

Line 136: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

132: WHERE assigned_process = p_assigned_process;
133: COMMIT;
134: END IF;
135:
136: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
137: Fnd_Msg_Pub.ADD_EXC_MSG (
138: p_pkg_name => G_PKG_NAME,
139: p_procedure_name => l_api_name);
140: Fnd_Msg_Pub.Count_and_get (