50: -- GLOBAL MESSAGE CONSTANTS FOR ERROR HANDLING
51: ---------------------------------------------------------------------------
52:
53: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
54: G_APP2_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
55: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_UTIL_PVT';
56: G_API_VERSION CONSTANT NUMBER := 1;
57: G_API_NAME CONSTANT VARCHAR2(30) := 'OKL_AM_UTIL_PVT';
58: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
57: G_API_NAME CONSTANT VARCHAR2(30) := 'OKL_AM_UTIL_PVT';
58: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
60: G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
64: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
64: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
66: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_LEN_CHK CONSTANT VARCHAR2(200) := 'OKC_LENGTH_EXCEEDS';
69: G_NOTFOUND CONSTANT VARCHAR2(200) := 'OKC_VIEW_NOT_FOUND';
70: G_VIEW_TOKEN CONSTANT VARCHAR2(200) := 'G_VIEW_TOKEN';
71: G_EXCEPTION_HALT_PROCESS EXCEPTION;
68: G_LEN_CHK CONSTANT VARCHAR2(200) := 'OKC_LENGTH_EXCEEDS';
69: G_NOTFOUND CONSTANT VARCHAR2(200) := 'OKC_VIEW_NOT_FOUND';
70: G_VIEW_TOKEN CONSTANT VARCHAR2(200) := 'G_VIEW_TOKEN';
71: G_EXCEPTION_HALT_PROCESS EXCEPTION;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
73: ---------------------------------------------------------------------------
74: -- Procedures and Functions
75: ---------------------------------------------------------------------------
76:
247:
248: -- Execute a fulfillment request
249: PROCEDURE EXECUTE_FULFILLMENT_REQUEST(
250: p_api_version IN NUMBER
251: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
252: , x_return_status OUT NOCOPY VARCHAR2
253: , x_msg_count OUT NOCOPY NUMBER
254: , x_msg_data OUT NOCOPY VARCHAR2
255: , p_ptm_code IN VARCHAR2
254: , x_msg_data OUT NOCOPY VARCHAR2
255: , p_ptm_code IN VARCHAR2
256: , p_agent_id IN NUMBER
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
255: , p_ptm_code IN VARCHAR2
256: , p_agent_id IN NUMBER
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
256: , p_agent_id IN NUMBER
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
265: , p_pt_bind_values IN p_bind_val_tbl
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
265: , p_pt_bind_values IN p_bind_val_tbl
266: , p_pt_bind_types IN p_bind_type_tbl
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
265: , p_pt_bind_values IN p_bind_val_tbl
266: , p_pt_bind_types IN p_bind_type_tbl
267: ) ;