APPS.PA_PAGE_CONTENTS_PUB dependencies on PA_PAGE_CONTENTS

Line 1: PACKAGE BODY PA_PAGE_CONTENTS_PUB AS

1: PACKAGE BODY PA_PAGE_CONTENTS_PUB AS
2: --$Header: PAPGCTPB.pls 120.1 2006/02/24 02:33:46 appldev noship $
3:
4: --Bug 5020365.When this API is called from paxstcvb.Generate_Error_Page, some messages
5: --added in publish flow might already be there in fnd_msg_pub. In this case, this API

Line 38: FROM PA_PAGE_CONTENTS

34:
35:
36: CURSOR existing_record IS
37: SELECT PAGE_CONTENT_ID
38: FROM PA_PAGE_CONTENTS
39: WHERE OBJECT_TYPE = P_OBJECT_TYPE
40: AND NVL(PK1_VALUE,0) = NVL(P_PK1_VALUE,0)
41: AND NVL(PK2_VALUE,0) = NVL(P_PK2_VALUE,0)
42: AND NVL(PK3_VALUE,0) = NVL(P_PK3_VALUE,0)

Line 50: PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Save_Page_Contents');

46:
47:
48: BEGIN
49: -- Initialize the Error Stack
50: PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Save_Page_Contents');
51:
52: -- Initialize the return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:

Line 68: PA_PAGE_CONTENTS_PVT.ADD_PAGE_CONTENTS (

64: OPEN existing_record;
65: FETCH existing_record INTO l_content_id;
66:
67: IF existing_record%NOTFOUND THEN
68: PA_PAGE_CONTENTS_PVT.ADD_PAGE_CONTENTS (
69: p_api_version
70: ,p_init_msg_list
71: ,p_commit
72: ,p_validate_only

Line 90: PA_PAGE_CONTENTS_PVT.CLEAR_PAGE_CONTENTS (

86: ELSE
87: x_page_content_id := l_content_id;
88: CLOSE existing_record;
89:
90: PA_PAGE_CONTENTS_PVT.CLEAR_PAGE_CONTENTS (
91: p_api_version
92: ,p_init_msg_list
93: ,p_commit
94: ,p_validate_only

Line 124: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.SAVE_PAGE_CONTENTS'

120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: -- Set the excetption Message and the stack
124: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.SAVE_PAGE_CONTENTS'
125: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
126:
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: RAISE;

Line 159: FROM PA_PAGE_CONTENTS

155:
156:
157: CURSOR existing_record IS
158: SELECT PAGE_CONTENT_ID
159: FROM PA_PAGE_CONTENTS
160: WHERE OBJECT_TYPE = P_OBJECT_TYPE
161: AND NVL(PK1_VALUE,0) = NVL(P_PK1_VALUE,0)
162: AND NVL(PK2_VALUE,0) = NVL(P_PK2_VALUE,0)
163: AND NVL(PK3_VALUE,0) = NVL(P_PK3_VALUE,0)

Line 169: PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Delete_Page_Contents');

165: AND NVL(PK5_VALUE,0) = NVL(P_PK5_VALUE,0);
166:
167: begin
168: -- Initialize the Error Stack
169: PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Delete_Page_Contents');
170:
171: -- Initialize the return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:

Line 196: PA_PAGE_CONTENTS_PVT.DELETE_PAGE_CONTENTS (

192: return;
193: END IF;
194: END IF;
195:
196: PA_PAGE_CONTENTS_PVT.DELETE_PAGE_CONTENTS (
197: p_api_version
198: ,p_init_msg_list
199: ,p_commit
200: ,p_validate_only

Line 228: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.DELETE_PAGE_CONTENTS'

224: EXCEPTION
225: WHEN OTHERS THEN
226: rollback;
227: -- Set the excetption Message and the stack
228: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.DELETE_PAGE_CONTENTS'
229: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
230:
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
232: RAISE;

Line 235: END PA_PAGE_CONTENTS_PUB;

231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
232: RAISE;
233: end DELETE_PAGE_CONTENTS;
234:
235: END PA_PAGE_CONTENTS_PUB;