DBA Data[Home] [Help]

APPS.IBE_COPY_LOGICALCONTENT_GRP dependencies on FND_API

Line 17: l_true VARCHAR2(1) := FND_API.G_TRUE;

13: | |
14: | |
15: | Dec 15, 2009 YTIAN - Created |
16: |___________________________________________________________________________|*/
17: l_true VARCHAR2(1) := FND_API.G_TRUE;
18: --- Generate primary key for the table
19: CURSOR obj_lgl_ctnt_id_seq IS
20: SELECT ibe_dsp_obj_lgl_ctnt_s1.NEXTVAL
21: FROM DUAL;

Line 25: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

21: FROM DUAL;
22:
23: PROCEDURE copy_lgl_ctnt(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_object_type_code IN VARCHAR2,
28: p_from_Product_id IN NUMBER,
29: p_from_Context_ids IN Ids_List,

Line 26: p_commit IN VARCHAR2 := FND_API.g_false,

22:
23: PROCEDURE copy_lgl_ctnt(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_object_type_code IN VARCHAR2,
28: p_from_Product_id IN NUMBER,
29: p_from_Context_ids IN Ids_List,
30: p_to_product_ids IN Ids_List,

Line 107: x_return_status := FND_API.g_ret_sts_unexp_error ;

103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: --ROLLBACK TO copy_logical_content;
107: x_return_status := FND_API.g_ret_sts_unexp_error ;
108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
109: THEN
110: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
111: END IF;

Line 113: p_encoded => FND_API.g_false,

109: THEN
110: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
111: END IF;
112: FND_MSG_PUB.count_and_get(
113: p_encoded => FND_API.g_false,
114: p_count => x_msg_count,
115: p_data => x_msg_data );
116:
117:

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

118: END copy_lgl_ctnt;
119:
120: PROCEDURE copy_lgl_ctnt(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124: p_object_type_code IN VARCHAR2,
125: p_from_Product_id IN NUMBER,
126: p_from_Context_ids IN Ids_List,

Line 123: p_commit IN VARCHAR2 := FND_API.g_false,

119:
120: PROCEDURE copy_lgl_ctnt(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124: p_object_type_code IN VARCHAR2,
125: p_from_Product_id IN NUMBER,
126: p_from_Context_ids IN Ids_List,
127: p_from_deliverable_ids IN Ids_List,

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

300:
301:
302:
303: end if;
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,

Line 307: p_encoded => FND_API.g_false,

303: end if;
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data );
310:
311: EXCEPTION

Line 314: x_return_status := FND_API.g_ret_sts_unexp_error ;

310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: ROLLBACK TO copy_logical_content2;
314: x_return_status := FND_API.g_ret_sts_unexp_error ;
315: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
316: THEN
317: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
318: END IF;

Line 320: p_encoded => FND_API.g_false,

316: THEN
317: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
318: END IF;
319: FND_MSG_PUB.count_and_get(
320: p_encoded => FND_API.g_false,
321: p_count => x_msg_count,
322: p_data => x_msg_data );
323:
324: