44: x_msg_count => l_msg_count,
45: x_msg_data => l_msg_data,
46: x_request_id => l_request_id);
47:
48: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
45: x_msg_data => l_msg_data,
46: x_request_id => l_request_id);
47:
48: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
53:
46: x_request_id => l_request_id);
47:
48: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
53:
54:
47:
48: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: END IF;
53:
54:
55: jtf_fm_request_grp.get_content_xml (p_api_version => G_API_VERSION,
75: p_bind_var_type => p_bind_var_type,
76: p_request_id => l_request_id,
77: x_content_xml => l_content_xml);
78:
79: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
80: RAISE OKL_API.G_EXCEPTION_ERROR;
81: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: END IF;
76: p_request_id => l_request_id,
77: x_content_xml => l_content_xml);
78:
79: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
80: RAISE OKL_API.G_EXCEPTION_ERROR;
81: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: END IF;
84:
77: x_content_xml => l_content_xml);
78:
79: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
80: RAISE OKL_API.G_EXCEPTION_ERROR;
81: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: END IF;
84:
85: l_extended_header :='
78:
79: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
80: RAISE OKL_API.G_EXCEPTION_ERROR;
81: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: END IF;
84:
85: l_extended_header :='
86: -- "FROM" (default FROM is Recipient of the Email!)
119: p_extended_header => l_extended_header,
120: p_content_xml => l_content_xml,
121: p_request_id => l_request_id);
122:
123: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
120: p_content_xml => l_content_xml,
121: p_request_id => l_request_id);
122:
123: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
128:
121: p_request_id => l_request_id);
122:
123: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
128:
129: x_request_id := l_request_id;
122:
123: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
128:
129: x_request_id := l_request_id;
130:
128:
129: x_request_id := l_request_id;
130:
131: EXCEPTION
132: WHEN OKL_API.G_EXCEPTION_ERROR THEN
133: x_return_status := OKL_API.G_RET_STS_ERROR;
134: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
135: p_data => x_msg_data);
136:
129: x_request_id := l_request_id;
130:
131: EXCEPTION
132: WHEN OKL_API.G_EXCEPTION_ERROR THEN
133: x_return_status := OKL_API.G_RET_STS_ERROR;
134: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
135: p_data => x_msg_data);
136:
137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: x_return_status := OKL_API.G_RET_STS_ERROR;
134: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
135: p_data => x_msg_data);
136:
137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
138: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
139: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
140: p_data => x_msg_data);
141:
134: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
135: p_data => x_msg_data);
136:
137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
138: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
139: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142: WHEN OTHERS THEN
139: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142: WHEN OTHERS THEN
143: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
144: FND_MSG_PUB.ADD_EXC_MSG('OKL_FULFILLMENT_PVT','create_fulfillment');
145: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
146: p_data => x_msg_data);
147: