eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_PUB dependencies on PA_PURGE_PUB

Line 1: PACKAGE BODY PA_PURGE_PUB AS

1: PACKAGE BODY PA_PURGE_PUB AS
2: -- $Header: PAXPURGB.pls 120.5 2008/02/27 18:00:34 bifernan noship $
3: Invalid_Arg_Exc_Pjr EXCEPTION;
4:
5: --

Line 58: pa_debug.set_err_stack('PA_PURGE_PUB.START_PROCESS');

54:
55: errbuf := NULL ;
56: retcode := 0;
57: l_return_status := FND_API.G_RET_STS_SUCCESS;
58: pa_debug.set_err_stack('PA_PURGE_PUB.START_PROCESS');
59: FND_MSG_PUB.initialize;
60:
61: pa_debug.set_process('PLSQL','LOG',p_debug_mode);
62:

Line 67: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

63: IF p_debug_mode = 'Y' THEN
64: pa_debug.set_curr_function( p_function => 'START_PROCESS', p_debug_mode => p_debug_mode );
65: pa_debug.g_err_stage:= 'Entering START_PROCESS - Request Id : ' || l_request_id;
66: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
67: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
68: pa_debug.g_err_stage:= 'Purge Type is ' || p_purge_type ;
69: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
70: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
71: pa_debug.g_err_stage:= 'Commit Size is ' || p_commit_size ;

Line 70: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

66: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
67: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
68: pa_debug.g_err_stage:= 'Purge Type is ' || p_purge_type ;
69: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
70: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
71: pa_debug.g_err_stage:= 'Commit Size is ' || p_commit_size ;
72: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
73: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
74: END IF;

Line 73: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

69: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
70: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
71: pa_debug.g_err_stage:= 'Commit Size is ' || p_commit_size ;
72: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
73: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
74: END IF;
75:
76: IF p_purge_type IS NULL THEN
77: IF p_debug_mode = 'Y' THEN

Line 80: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

76: IF p_purge_type IS NULL THEN
77: IF p_debug_mode = 'Y' THEN
78: pa_debug.g_err_stage:= 'Mandatory parameter to this API : Purge Type is NULL';
79: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
80: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
81: END IF;
82:
83: l_return_status := FND_API.G_RET_STS_ERROR;
84: PA_UTILS.ADD_MESSAGE

Line 93: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_FORECAST_ITEMS';

89:
90:
91: IF p_purge_type in ('ALL', 'DAILY_FCST_INFO') THEN
92: IF p_debug_mode = 'Y' THEN
93: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_FORECAST_ITEMS';
94: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
95: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
96: END IF;
97:

Line 95: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

91: IF p_purge_type in ('ALL', 'DAILY_FCST_INFO') THEN
92: IF p_debug_mode = 'Y' THEN
93: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_FORECAST_ITEMS';
94: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
95: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
96: END IF;
97:
98: PA_PURGE_PUB.PURGE_FORECAST_ITEMS
99: (

Line 98: PA_PURGE_PUB.PURGE_FORECAST_ITEMS

94: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
95: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
96: END IF;
97:
98: PA_PURGE_PUB.PURGE_FORECAST_ITEMS
99: (
100: p_debug_mode => p_debug_mode ,
101: p_commit_size => p_commit_size ,
102: p_request_id => l_request_id ,

Line 109: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned status ' || l_return_status;

105: x_msg_data => l_msg_data
106: );
107:
108: IF p_debug_mode = 'Y' THEN
109: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned status ' || l_return_status;
110: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
111: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
112: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_count as '||l_msg_count;
113: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 111: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

107:
108: IF p_debug_mode = 'Y' THEN
109: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned status ' || l_return_status;
110: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
111: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
112: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_count as '||l_msg_count;
113: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
114: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
115: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_data as ' || substrb(l_msg_data,1,240);

Line 112: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_count as '||l_msg_count;

108: IF p_debug_mode = 'Y' THEN
109: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned status ' || l_return_status;
110: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
111: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
112: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_count as '||l_msg_count;
113: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
114: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
115: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_data as ' || substrb(l_msg_data,1,240);
116: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 114: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

110: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
111: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
112: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_count as '||l_msg_count;
113: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
114: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
115: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_data as ' || substrb(l_msg_data,1,240);
116: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
117: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
118: END IF;

Line 115: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_data as ' || substrb(l_msg_data,1,240);

111: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
112: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_count as '||l_msg_count;
113: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
114: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
115: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_data as ' || substrb(l_msg_data,1,240);
116: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
117: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
118: END IF;
119:

Line 117: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

113: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
114: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
115: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_FORECAST_ITEMS returned l_msg_data as ' || substrb(l_msg_data,1,240);
116: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
117: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
118: END IF;
119:
120: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
121: l_local_error_flag := 'Y'; -- 5201806

Line 127: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_PROJ_WORKFLOW';

123: END IF; -- 5171235
124:
125: IF p_purge_type in ('ALL','PROJECTS_WORKFLOWS') THEN -- 5171235
126: IF p_debug_mode = 'Y' THEN
127: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_PROJ_WORKFLOW';
128: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
129: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
130: END IF;
131:

Line 129: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

125: IF p_purge_type in ('ALL','PROJECTS_WORKFLOWS') THEN -- 5171235
126: IF p_debug_mode = 'Y' THEN
127: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_PROJ_WORKFLOW';
128: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
129: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
130: END IF;
131:
132: PA_PURGE_PUB.PURGE_PROJ_WORKFLOW
133: (

Line 132: PA_PURGE_PUB.PURGE_PROJ_WORKFLOW

128: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
129: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
130: END IF;
131:
132: PA_PURGE_PUB.PURGE_PROJ_WORKFLOW
133: (
134: p_debug_mode => p_debug_mode ,
135: p_commit_size => p_commit_size ,
136: p_request_id => l_request_id ,

Line 143: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned status ' || l_return_status;

139: x_msg_data => l_msg_data
140: );
141:
142: IF p_debug_mode = 'Y' THEN
143: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned status ' || l_return_status;
144: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
145: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
146: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_count as '||l_msg_count;
147: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 145: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

141:
142: IF p_debug_mode = 'Y' THEN
143: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned status ' || l_return_status;
144: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
145: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
146: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_count as '||l_msg_count;
147: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
148: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
149: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_data as ' || substrb(l_msg_data,1,240);

Line 146: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_count as '||l_msg_count;

142: IF p_debug_mode = 'Y' THEN
143: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned status ' || l_return_status;
144: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
145: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
146: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_count as '||l_msg_count;
147: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
148: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
149: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_data as ' || substrb(l_msg_data,1,240);
150: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 148: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

144: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
145: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
146: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_count as '||l_msg_count;
147: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
148: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
149: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_data as ' || substrb(l_msg_data,1,240);
150: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
151: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
152: END IF;

Line 149: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_data as ' || substrb(l_msg_data,1,240);

145: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
146: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_count as '||l_msg_count;
147: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
148: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
149: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_data as ' || substrb(l_msg_data,1,240);
150: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
151: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
152: END IF;
153:

Line 151: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

147: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
148: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
149: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PROJ_WORKFLOW returned l_msg_data as ' || substrb(l_msg_data,1,240);
150: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
151: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
152: END IF;
153:
154: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: l_local_error_flag := 'Y'; -- 5201806

Line 162: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS';

158:
159: IF p_purge_type in ('ALL', 'REPORTING_EXCEPTIONS') THEN -- 5171235
160:
161: IF p_debug_mode = 'Y' THEN
162: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS';
163: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
164: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
165: END IF;
166:

Line 164: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

160:
161: IF p_debug_mode = 'Y' THEN
162: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS';
163: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
164: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
165: END IF;
166:
167:
168: PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS

Line 168: PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS

164: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
165: END IF;
166:
167:
168: PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS
169: (
170: p_debug_mode => p_debug_mode ,
171: p_commit_size => p_commit_size ,
172: p_request_id => l_request_id ,

Line 179: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned status ' || l_return_status;

175: x_msg_data => l_msg_data
176: );
177:
178: IF p_debug_mode = 'Y' THEN
179: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned status ' || l_return_status;
180: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
181: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
182: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_count as '||l_msg_count;
183: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 181: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

177:
178: IF p_debug_mode = 'Y' THEN
179: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned status ' || l_return_status;
180: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
181: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
182: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_count as '||l_msg_count;
183: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
184: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
185: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_data as ' || substrb(l_msg_data,1,240);

Line 182: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_count as '||l_msg_count;

178: IF p_debug_mode = 'Y' THEN
179: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned status ' || l_return_status;
180: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
181: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
182: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_count as '||l_msg_count;
183: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
184: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
185: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_data as ' || substrb(l_msg_data,1,240);
186: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 184: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

180: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
181: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
182: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_count as '||l_msg_count;
183: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
184: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
185: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_data as ' || substrb(l_msg_data,1,240);
186: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
187: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
188: END IF;

Line 185: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_data as ' || substrb(l_msg_data,1,240);

181: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
182: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_count as '||l_msg_count;
183: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
184: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
185: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_data as ' || substrb(l_msg_data,1,240);
186: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
187: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
188: END IF;
189:

Line 187: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

183: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
184: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
185: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_REPORTING_EXCEPTIONS returned l_msg_data as ' || substrb(l_msg_data,1,240);
186: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
187: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
188: END IF;
189:
190: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
191: l_local_error_flag := 'Y'; -- 5201806

Line 199: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_ORG_AUTHORITY';

195:
196: IF p_purge_type in ('ALL', 'ORG_AUTH') THEN
197:
198: IF p_debug_mode = 'Y' THEN
199: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_ORG_AUTHORITY';
200: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
201: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
202: END IF;
203:

Line 201: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

197:
198: IF p_debug_mode = 'Y' THEN
199: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_ORG_AUTHORITY';
200: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
201: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
202: END IF;
203:
204:
205: PA_PURGE_PUB.PURGE_ORG_AUTHORITY

Line 205: PA_PURGE_PUB.PURGE_ORG_AUTHORITY

201: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
202: END IF;
203:
204:
205: PA_PURGE_PUB.PURGE_ORG_AUTHORITY
206: (
207: p_debug_mode => p_debug_mode ,
208: p_commit_size => p_commit_size ,
209: p_request_id => l_request_id ,

Line 216: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned status ' || l_return_status;

212: x_msg_data => l_msg_data
213: );
214:
215: IF p_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned status ' || l_return_status;
217: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
218: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
219: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_count as '||l_msg_count;
220: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 218: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

214:
215: IF p_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned status ' || l_return_status;
217: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
218: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
219: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_count as '||l_msg_count;
220: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
221: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
222: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_data as ' || substrb(l_msg_data,1,240);

Line 219: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_count as '||l_msg_count;

215: IF p_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned status ' || l_return_status;
217: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
218: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
219: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_count as '||l_msg_count;
220: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
221: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
222: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_data as ' || substrb(l_msg_data,1,240);
223: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 221: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

217: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
218: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
219: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_count as '||l_msg_count;
220: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
221: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
222: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_data as ' || substrb(l_msg_data,1,240);
223: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
224: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
225: END IF;

Line 222: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_data as ' || substrb(l_msg_data,1,240);

218: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
219: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_count as '||l_msg_count;
220: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
221: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
222: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_data as ' || substrb(l_msg_data,1,240);
223: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
224: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
225: END IF;
226:

Line 224: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

220: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
221: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
222: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_ORG_AUTHORITY returned l_msg_data as ' || substrb(l_msg_data,1,240);
223: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
224: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
225: END IF;
226:
227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
228: l_local_error_flag := 'Y';

Line 235: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_PJI_DEBUG';

231:
232: IF p_purge_type in ('ALL', 'PJI_DEBUG') THEN
233:
234: IF p_debug_mode = 'Y' THEN
235: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_PJI_DEBUG';
236: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
237: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
238: END IF;
239:

Line 237: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

233:
234: IF p_debug_mode = 'Y' THEN
235: pa_debug.g_err_stage:= 'Before Calling PA_PURGE_PUB.PURGE_PJI_DEBUG';
236: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
237: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
238: END IF;
239:
240:
241: PA_PURGE_PUB.PURGE_PJI_DEBUG

Line 241: PA_PURGE_PUB.PURGE_PJI_DEBUG

237: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
238: END IF;
239:
240:
241: PA_PURGE_PUB.PURGE_PJI_DEBUG
242: (
243: p_debug_mode => p_debug_mode ,
244: p_commit_size => p_commit_size ,
245: p_request_id => l_request_id ,

Line 252: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned status ' || l_return_status;

248: x_msg_data => l_msg_data
249: );
250:
251: IF p_debug_mode = 'Y' THEN
252: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned status ' || l_return_status;
253: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
254: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
255: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_count as '||l_msg_count;
256: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 254: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

250:
251: IF p_debug_mode = 'Y' THEN
252: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned status ' || l_return_status;
253: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
254: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
255: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_count as '||l_msg_count;
256: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
257: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
258: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_data as ' || substrb(l_msg_data,1,240);

Line 255: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_count as '||l_msg_count;

251: IF p_debug_mode = 'Y' THEN
252: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned status ' || l_return_status;
253: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
254: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
255: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_count as '||l_msg_count;
256: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
257: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
258: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_data as ' || substrb(l_msg_data,1,240);
259: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);

Line 257: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

253: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
254: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
255: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_count as '||l_msg_count;
256: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
257: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
258: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_data as ' || substrb(l_msg_data,1,240);
259: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
260: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
261: END IF;

Line 258: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_data as ' || substrb(l_msg_data,1,240);

254: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
255: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_count as '||l_msg_count;
256: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
257: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
258: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_data as ' || substrb(l_msg_data,1,240);
259: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
260: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
261: END IF;
262:

Line 260: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

256: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
257: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
258: pa_debug.g_err_stage:= 'PA_PURGE_PUB.PURGE_PJI_DEBUG returned l_msg_data as ' || substrb(l_msg_data,1,240);
259: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
260: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
261: END IF;
262:
263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: l_local_error_flag := 'Y';

Line 268: PA_PURGE_PUB.PRINT_OUTPUT_REPORT

264: l_local_error_flag := 'Y';
265: END IF ;
266: END IF;
267:
268: PA_PURGE_PUB.PRINT_OUTPUT_REPORT
269: (
270: p_request_id => l_request_id
271: ,x_return_status => l_return_status
272: ,x_msg_count => l_msg_count

Line 290: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

286:
287: IF p_debug_mode = 'Y' THEN
288: pa_debug.g_err_stage:= 'Successfully Exiting START_PROCESS ';
289: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
290: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
291:
292: pa_debug.reset_err_stack;
293: pa_debug.reset_curr_function;
294: END IF;

Line 305: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

301:
302: IF p_debug_mode = 'Y' THEN
303: pa_debug.g_err_stage := 'Inside Invalid Argument exception of START_PROCESS API';
304: pa_debug.write_file('START_PROCESS : '|| pa_debug.g_err_stage);
305: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
306: END IF;
307:
308: -- 5201806 : Commented not needed
309: --IF l_msg_count >= 1 THEN

Line 338: pa_debug.write('PA_PURGE_PUB.START_PROCESS',l_data,l_debug_level3);

334: END LOOP;
335:
336: IF p_debug_mode = 'Y' THEN
337: pa_debug.write_file('START_PROCESS :' || l_data);
338: pa_debug.write('PA_PURGE_PUB.START_PROCESS',l_data,l_debug_level3);
339: pa_debug.reset_err_stack;
340: pa_debug.reset_curr_function;
341: END IF ;
342: -- No raise as per FD

Line 352: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

348:
349: IF p_debug_mode = 'Y' THEN
350: pa_debug.g_err_stage := 'Inside Expected Error block of START_PROCESS API';
351: pa_debug.write_file('START_PROCESS : '|| pa_debug.g_err_stage);
352: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
353: END IF;
354:
355: -- 5201806 : Commented not needed
356: --IF l_msg_count >= 1 THEN

Line 386: pa_debug.write('PA_PURGE_PUB.START_PROCESS',l_data,l_debug_level3);

382:
383:
384: IF p_debug_mode = 'Y' THEN
385: pa_debug.write_file('START_PROCESS :' || l_data);
386: pa_debug.write('PA_PURGE_PUB.START_PROCESS',l_data,l_debug_level3);
387: pa_debug.reset_err_stack;
388: pa_debug.reset_curr_function;
389: END IF ;
390: -- No raise as per FD

Line 397: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_PURGE_PUB'

393: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: retcode := '-1';
395: errbuf := SUBSTRB(SQLERRM,1,240);
396:
397: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_PURGE_PUB'
398: ,p_procedure_name => 'START_PROCESS'
399: ,p_error_text => errbuf);
400:
401: FOR i in 1..FND_MSG_PUB.count_msg LOOP -- 5201806

Line 420: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);

416:
417: IF p_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:='Unexpected Error'||errbuf;
419: pa_debug.write_file('START_PROCESS :' || pa_debug.g_err_stage);
420: pa_debug.write('PA_PURGE_PUB.START_PROCESS',pa_debug.g_err_stage,l_debug_level3);
421: pa_debug.reset_err_stack;
422: pa_debug.reset_curr_function;
423: END IF;
424:

Line 504: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

500: IF p_debug_mode = 'Y' THEN
501: PA_DEBUG.set_curr_function( p_function => 'PURGE_FORECAST_ITEMS',
502: p_debug_mode => p_debug_mode);
503: pa_debug.g_err_stage:= 'Inside PURGE_FORECAST_ITEMS API' ;
504: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
505: END IF;
506:
507: sql_command := 'SELECT 1 from dual where exists(SELECT NAME FROM PJI_SYSTEM_PARAMETERS)' ;
508:

Line 640: ( p_pkg_name => 'PA_PURGE_PUB'

636: -- successfully deleted so far.
637: l_rows2 := l_rows2 + nvl(sql%rowcount,0);
638: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
639: Fnd_Msg_Pub.add_exc_msg
640: ( p_pkg_name => 'PA_PURGE_PUB'
641: , p_procedure_name => 'PURGE_FORECAST_ITEMS'
642: , p_error_text => SUBSTRB(SQLERRM,1,240));
643: EXIT; -- 5201806 : exit the loop after discussion with Anders.
644: END;

Line 673: ( p_pkg_name => 'PA_PURGE_PUB'

669: -- successfully deleted so far.
670: l_rows3 := l_rows3 + nvl(sql%rowcount,0);
671: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
672: Fnd_Msg_Pub.add_exc_msg
673: ( p_pkg_name => 'PA_PURGE_PUB'
674: , p_procedure_name => 'PURGE_FORECAST_ITEMS'
675: , p_error_text => SUBSTRB(SQLERRM,1,240));
676: EXIT; -- 5201806 : exit the loop after discussion with Anders.
677: END;

Line 708: ( p_pkg_name => 'PA_PURGE_PUB'

704: -- successfully deleted so far.
705: l_rows1 := l_rows1 + nvl(sql%rowcount,0);
706: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
707: Fnd_Msg_Pub.add_exc_msg
708: ( p_pkg_name => 'PA_PURGE_PUB'
709: , p_procedure_name => 'PURGE_FORECAST_ITEMS'
710: , p_error_text => SUBSTRB(SQLERRM,1,240));
711: EXIT; -- 5201806 : exit the loop after discussion with Anders.
712: END;

Line 718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

714: CLOSE c_get_forecast_item_ids;
715:
716: IF p_debug_mode = 'Y' THEN
717: pa_debug.g_err_stage:= 'No. of rows deleted from pa_forecast_items - ' || l_rows1 ;
718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
719: pa_debug.g_err_stage:= 'No. of rows deleted from pa_forecast_item_details - ' || l_rows2;
720: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
721: pa_debug.g_err_stage:= 'No. of rows deleted from pa_fi_amount_details - ' ||l_rows3;
722: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

Line 720: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

716: IF p_debug_mode = 'Y' THEN
717: pa_debug.g_err_stage:= 'No. of rows deleted from pa_forecast_items - ' || l_rows1 ;
718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
719: pa_debug.g_err_stage:= 'No. of rows deleted from pa_forecast_item_details - ' || l_rows2;
720: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
721: pa_debug.g_err_stage:= 'No. of rows deleted from pa_fi_amount_details - ' ||l_rows3;
722: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
723: END IF;
724:

Line 722: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
719: pa_debug.g_err_stage:= 'No. of rows deleted from pa_forecast_item_details - ' || l_rows2;
720: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
721: pa_debug.g_err_stage:= 'No. of rows deleted from pa_fi_amount_details - ' ||l_rows3;
722: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
723: END IF;
724:
725: -- Write this info into log table
726: PA_PURGE_PUB.INSERT_PURGE_LOG

Line 726: PA_PURGE_PUB.INSERT_PURGE_LOG

722: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
723: END IF;
724:
725: -- Write this info into log table
726: PA_PURGE_PUB.INSERT_PURGE_LOG
727: (
728: p_request_id => p_request_id ,
729: p_table_name => 'PA_FORECAST_ITEMS' ,
730: p_rows_deleted => l_rows1 ,

Line 742: PA_PURGE_PUB.INSERT_PURGE_LOG

738: l_local_error_flag := 'Y'; -- 5201806
739: END IF;
740:
741:
742: PA_PURGE_PUB.INSERT_PURGE_LOG
743: (
744: p_request_id => p_request_id ,
745: p_table_name => 'PA_FORECAST_ITEM_DETAILS',
746: p_rows_deleted => l_rows2,

Line 757: PA_PURGE_PUB.INSERT_PURGE_LOG

753: --RAISE FND_API.G_EXC_ERROR;
754: l_local_error_flag := 'Y'; -- 5201806
755: END IF;
756:
757: PA_PURGE_PUB.INSERT_PURGE_LOG
758: (
759: p_request_id => p_request_id ,
760: p_table_name => 'PA_FI_AMOUNT_DETAILS',
761: p_rows_deleted => l_rows3,

Line 778: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

774: END IF;
775:
776: IF p_debug_mode = 'Y' THEN
777: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_FI_AMOUNT_DETAILS';
778: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
779: pa_debug.g_err_stage:= 'Exiting PURGE_FORECAST_ITEMS';
780: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_FORECAST_ITEMS :' || pa_debug.g_err_stage,l_debug_level3);
781: pa_debug.reset_curr_function;
782: END IF;

Line 780: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_FORECAST_ITEMS :' || pa_debug.g_err_stage,l_debug_level3);

776: IF p_debug_mode = 'Y' THEN
777: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_FI_AMOUNT_DETAILS';
778: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
779: pa_debug.g_err_stage:= 'Exiting PURGE_FORECAST_ITEMS';
780: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_FORECAST_ITEMS :' || pa_debug.g_err_stage,l_debug_level3);
781: pa_debug.reset_curr_function;
782: END IF;
783:
784: EXCEPTION

Line 822: ( p_pkg_name => 'PA_PURGE_PUB'

818: CLOSE c_get_forecast_item_ids;
819: END IF;
820:
821: Fnd_Msg_Pub.add_exc_msg
822: ( p_pkg_name => 'PA_PURGE_PUB'
823: , p_procedure_name => 'PURGE_FORECAST_ITEMS'
824: , p_error_text => x_msg_data);
825:
826: x_msg_count := FND_MSG_PUB.count_msg; --5201806

Line 830: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

826: x_msg_count := FND_MSG_PUB.count_msg; --5201806
827:
828: IF p_debug_mode = 'Y' THEN
829: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
830: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
831: Pa_Debug.reset_curr_function;
832: END IF;
833: -- RAISE; 5201806 Do not raise in internal APIs
834: END PURGE_FORECAST_ITEMS ;

Line 904: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

900:
901: IF p_debug_mode = 'Y' THEN
902: PA_DEBUG.set_curr_function( p_function => 'PURGE_PROJ_WORKFLOW', p_debug_mode => p_debug_mode);
903: pa_debug.g_err_stage:= 'Inside PURGE_PROJ_WORKFLOW API' ;
904: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
905: END IF;
906:
907: OPEN c_purge_wf_details ;
908: LOOP

Line 937: ( p_pkg_name => 'PA_PURGE_PUB'

933: -- successfully deleted so far.
934: l_rows3 := l_rows3 + nvl(sql%rowcount,0);
935: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
936: Fnd_Msg_Pub.add_exc_msg
937: ( p_pkg_name => 'PA_PURGE_PUB'
938: , p_procedure_name => 'PURGE_PROJ_WORKFLOW'
939: , p_error_text => SUBSTRB(SQLERRM,1,240));
940: EXIT; -- 5201806 : exit the loop after discussion with Anders.
941: END;

Line 964: ( p_pkg_name => 'PA_PURGE_PUB'

960: -- successfully deleted so far.
961: l_rows2 := l_rows2 + nvl(sql%rowcount,0);
962: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
963: Fnd_Msg_Pub.add_exc_msg
964: ( p_pkg_name => 'PA_PURGE_PUB'
965: , p_procedure_name => 'PURGE_PROJ_WORKFLOW'
966: , p_error_text => SUBSTRB(SQLERRM,1,240));
967: EXIT; -- 5201806 : exit the loop after discussion with Anders.
968: END;

Line 990: ( p_pkg_name => 'PA_PURGE_PUB'

986: -- successfully deleted so far.
987: l_rows1 := l_rows1 + nvl(sql%rowcount,0);
988: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
989: Fnd_Msg_Pub.add_exc_msg
990: ( p_pkg_name => 'PA_PURGE_PUB'
991: , p_procedure_name => 'PURGE_PROJ_WORKFLOW'
992: , p_error_text => SUBSTRB(SQLERRM,1,240));
993: EXIT; -- 5201806 : exit the loop after discussion with Anders.
994: END;

Line 1000: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

996: CLOSE c_purge_wf_details;
997:
998: IF p_debug_mode = 'Y' THEN
999: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_processes ' || l_rows1 ;
1000: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1001: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_process_details ' || l_rows2 ;
1002: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1003: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_ntf_performers ' || l_rows3 ;
1004: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

Line 1002: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

998: IF p_debug_mode = 'Y' THEN
999: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_processes ' || l_rows1 ;
1000: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1001: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_process_details ' || l_rows2 ;
1002: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1003: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_ntf_performers ' || l_rows3 ;
1004: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1005: END IF;
1006:

Line 1004: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1000: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1001: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_process_details ' || l_rows2 ;
1002: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1003: pa_debug.g_err_stage:= 'No. of rows deleted from pa_wf_ntf_performers ' || l_rows3 ;
1004: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1005: END IF;
1006:
1007:
1008: PA_PURGE_PUB.INSERT_PURGE_LOG

Line 1008: PA_PURGE_PUB.INSERT_PURGE_LOG

1004: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1005: END IF;
1006:
1007:
1008: PA_PURGE_PUB.INSERT_PURGE_LOG
1009: (
1010: p_request_id => p_request_id ,
1011: p_table_name => 'PA_WF_PROCESSES' ,
1012: p_rows_deleted => l_rows1 ,

Line 1024: PA_PURGE_PUB.INSERT_PURGE_LOG

1020: l_local_error_flag := 'Y'; -- 5201806
1021: END IF;
1022:
1023:
1024: PA_PURGE_PUB.INSERT_PURGE_LOG
1025: (
1026: p_request_id => p_request_id ,
1027: p_table_name => 'PA_WF_PROCESS_DETAILS',
1028: p_rows_deleted => l_rows2,

Line 1039: PA_PURGE_PUB.INSERT_PURGE_LOG

1035: --RAISE FND_API.G_EXC_ERROR;
1036: l_local_error_flag := 'Y'; -- 5201806
1037: END IF;
1038:
1039: PA_PURGE_PUB.INSERT_PURGE_LOG
1040: (
1041: p_request_id => p_request_id ,
1042: p_table_name => 'PA_WF_NTF_PERFORMERS',
1043: p_rows_deleted => l_rows3,

Line 1061: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1057:
1058:
1059: IF p_debug_mode = 'Y' THEN
1060: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_WF_NTF_PERFORMERS';
1061: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1062: pa_debug.g_err_stage:= 'Exiting PURGE_PROJ_WORKFLOW';
1063: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PROJ_WORKFLOW :' || pa_debug.g_err_stage,l_debug_level3);
1064: pa_debug.reset_curr_function;
1065: END IF;

Line 1063: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PROJ_WORKFLOW :' || pa_debug.g_err_stage,l_debug_level3);

1059: IF p_debug_mode = 'Y' THEN
1060: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PA_WF_NTF_PERFORMERS';
1061: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1062: pa_debug.g_err_stage:= 'Exiting PURGE_PROJ_WORKFLOW';
1063: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PROJ_WORKFLOW :' || pa_debug.g_err_stage,l_debug_level3);
1064: pa_debug.reset_curr_function;
1065: END IF;
1066:
1067: EXCEPTION

Line 1106: ( p_pkg_name => 'PA_PURGE_PUB'

1102: Close c_purge_wf_details;
1103: END IF;
1104:
1105: Fnd_Msg_Pub.add_exc_msg
1106: ( p_pkg_name => 'PA_PURGE_PUB'
1107: , p_procedure_name => 'PURGE_PROJ_WORKFLOW'
1108: , p_error_text => x_msg_data);
1109:
1110: x_msg_count := FND_MSG_PUB.count_msg;--5201806

Line 1114: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

1110: x_msg_count := FND_MSG_PUB.count_msg;--5201806
1111:
1112: IF p_debug_mode = 'Y' THEN
1113: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1114: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
1115: Pa_Debug.reset_curr_function;
1116: END IF;
1117: -- RAISE; 5201806 Do not raise in internal APIs
1118: END PURGE_PROJ_WORKFLOW;

Line 1184: Pa_Debug.WRITE('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1180:
1181: IF p_debug_mode = 'Y' THEN
1182: PA_DEBUG.set_curr_function( p_function => 'PURGE_REPORTING_EXCEPTIONS', p_debug_mode => p_debug_mode);
1183: pa_debug.g_err_stage:= 'Entering PURGE_REPORTING_EXCEPTIONS API';
1184: Pa_Debug.WRITE('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1185: END IF;
1186:
1187: OPEN c_get_request_id;
1188: LOOP

Line 1210: ( p_pkg_name => 'PA_PURGE_PUB'

1206: -- successfully deleted so far.
1207: l_rows1 :=l_rows1+nvl(sql%rowcount,0);
1208: l_local_error_flag := 'Y'; -- 5201806 : Populate the error in stack
1209: Fnd_Msg_Pub.add_exc_msg
1210: ( p_pkg_name => 'PA_PURGE_PUB'
1211: , p_procedure_name => 'PURGE_REPORTING_EXCEPTIONS'
1212: , p_error_text => SUBSTRB(SQLERRM,1,240));
1213: EXIT; -- 5201806 : exit the loop after discussion with Anders.
1214: END;

Line 1220: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1216: CLOSE c_get_request_id;
1217:
1218: IF p_debug_mode = 'Y' THEN
1219: pa_debug.g_err_stage:= 'No. of rows deleted from pa_reporting_exceptions ' || l_rows1 ;
1220: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1221: END IF;
1222:
1223:
1224: PA_PURGE_PUB.INSERT_PURGE_LOG

Line 1224: PA_PURGE_PUB.INSERT_PURGE_LOG

1220: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1221: END IF;
1222:
1223:
1224: PA_PURGE_PUB.INSERT_PURGE_LOG
1225: (
1226: p_request_id => p_request_id ,
1227: p_table_name => 'PA_REPORTING_EXCEPTIONS' ,
1228: p_rows_deleted => l_rows1 ,

Line 1245: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1241: END IF;
1242:
1243: IF p_debug_mode = 'Y' THEN
1244: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to pa_reporting_exceptions';
1245: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1246: pa_debug.g_err_stage:= 'Exiting PURGE_REPORTING_EXCEPTIONS';
1247: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1248: Pa_Debug.reset_curr_function;
1249: END IF;

Line 1247: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1243: IF p_debug_mode = 'Y' THEN
1244: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to pa_reporting_exceptions';
1245: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1246: pa_debug.g_err_stage:= 'Exiting PURGE_REPORTING_EXCEPTIONS';
1247: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1248: Pa_Debug.reset_curr_function;
1249: END IF;
1250: EXCEPTION
1251: WHEN FND_API.G_EXC_ERROR THEN

Line 1289: ( p_pkg_name => 'PA_PURGE_PUB'

1285: CLOSE c_get_request_id;
1286: END IF;
1287:
1288: Fnd_Msg_Pub.add_exc_msg
1289: ( p_pkg_name => 'PA_PURGE_PUB'
1290: , p_procedure_name => 'PURGE_REPORTING_EXCEPTIONS'
1291: , p_error_text => x_msg_data);
1292:
1293: x_msg_count := FND_MSG_PUB.count_msg; --5201806

Line 1297: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

1293: x_msg_count := FND_MSG_PUB.count_msg; --5201806
1294:
1295: IF p_debug_mode = 'Y' THEN
1296: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1297: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
1298: Pa_Debug.reset_curr_function;
1299: END IF;
1300: -- RAISE; 5201806 Do not raise in internal APIs
1301: END PURGE_REPORTING_EXCEPTIONS;

Line 1401: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1397:
1398: IF p_debug_mode = 'Y' THEN
1399: PA_DEBUG.set_curr_function( p_function => 'PURGE_ORG_AUTHORITY', p_debug_mode => p_debug_mode);
1400: pa_debug.g_err_stage:= 'Inside PURGE_ORG_AUTHORITY API' ;
1401: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1402: END IF;
1403:
1404: OPEN c_purge_org_authority;
1405: LOOP

Line 1449: ( p_pkg_name => 'PA_PURGE_PUB'

1445: NULL ; -- Do nothing
1446: WHEN OTHERS THEN
1447: l_local_error_flag := 'Y';
1448: Fnd_Msg_Pub.add_exc_msg
1449: ( p_pkg_name => 'PA_PURGE_PUB'
1450: , p_procedure_name => 'PURGE_ORG_AUTHORITY'
1451: , p_error_text => SUBSTRB(SQLERRM,1,240));
1452: EXIT;
1453: END;

Line 1460: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1456: CLOSE c_purge_org_authority;
1457:
1458: IF p_debug_mode = 'Y' THEN
1459: pa_debug.g_err_stage:= 'No. of grants deleted ' || l_grants_deleted;
1460: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1461: END IF;
1462:
1463: PA_PURGE_PUB.INSERT_PURGE_LOG
1464: (

Line 1463: PA_PURGE_PUB.INSERT_PURGE_LOG

1459: pa_debug.g_err_stage:= 'No. of grants deleted ' || l_grants_deleted;
1460: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1461: END IF;
1462:
1463: PA_PURGE_PUB.INSERT_PURGE_LOG
1464: (
1465: p_request_id => p_request_id ,
1466: p_table_name => 'FND_GRANTS' ,
1467: p_rows_deleted => l_grants_deleted ,

Line 1483: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1479: END IF;
1480:
1481: IF p_debug_mode = 'Y' THEN
1482: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PURGE_ORG_AUTHORITY';
1483: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1484: pa_debug.g_err_stage:= 'Exiting PURGE_ORG_AUTHORITY';
1485: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1486: Pa_Debug.reset_curr_function;
1487: END IF;

Line 1485: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1481: IF p_debug_mode = 'Y' THEN
1482: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PURGE_ORG_AUTHORITY';
1483: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1484: pa_debug.g_err_stage:= 'Exiting PURGE_ORG_AUTHORITY';
1485: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1486: Pa_Debug.reset_curr_function;
1487: END IF;
1488:
1489: EXCEPTION

Line 1514: ( p_pkg_name => 'PA_PURGE_PUB'

1510: CLOSE c_purge_org_authority;
1511: END IF;
1512:
1513: Fnd_Msg_Pub.add_exc_msg
1514: ( p_pkg_name => 'PA_PURGE_PUB'
1515: , p_procedure_name => 'PURGE_ORG_AUTHORITY'
1516: , p_error_text => x_msg_data);
1517:
1518: x_msg_count := FND_MSG_PUB.count_msg;

Line 1522: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

1518: x_msg_count := FND_MSG_PUB.count_msg;
1519:
1520: IF p_debug_mode = 'Y' THEN
1521: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1522: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
1523: Pa_Debug.reset_curr_function;
1524: END IF;
1525:
1526: END PURGE_ORG_AUTHORITY;

Line 1585: Pa_Debug.WRITE('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1581:
1582: IF p_debug_mode = 'Y' THEN
1583: PA_DEBUG.set_curr_function( p_function => 'PURGE_PJI_DEBUG', p_debug_mode => p_debug_mode);
1584: pa_debug.g_err_stage:= 'Entering PURGE_PJI_DEBUG API';
1585: Pa_Debug.WRITE('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1586: END IF;
1587:
1588: -- PJI_FM_EXTR_PLAN_LINES_DEBUG
1589: BEGIN

Line 1607: ( p_pkg_name => 'PA_PURGE_PUB'

1603: WHEN OTHERS THEN
1604: l_rows1 := l_rows1 + nvl(sql%rowcount,0);
1605: l_local_error_flag := 'Y';
1606: Fnd_Msg_Pub.add_exc_msg
1607: ( p_pkg_name => 'PA_PURGE_PUB'
1608: , p_procedure_name => 'PURGE_PJI_DEBUG'
1609: , p_error_text => SUBSTRB(SQLERRM,1,240));
1610: END;
1611:

Line 1631: ( p_pkg_name => 'PA_PURGE_PUB'

1627: WHEN OTHERS THEN
1628: l_rows2 := l_rows2 + nvl(sql%rowcount,0);
1629: l_local_error_flag := 'Y';
1630: Fnd_Msg_Pub.add_exc_msg
1631: ( p_pkg_name => 'PA_PURGE_PUB'
1632: , p_procedure_name => 'PURGE_PJI_DEBUG'
1633: , p_error_text => SUBSTRB(SQLERRM,1,240));
1634: END;
1635:

Line 1655: ( p_pkg_name => 'PA_PURGE_PUB'

1651: WHEN OTHERS THEN
1652: l_rows3 := l_rows3 + nvl(sql%rowcount,0);
1653: l_local_error_flag := 'Y';
1654: Fnd_Msg_Pub.add_exc_msg
1655: ( p_pkg_name => 'PA_PURGE_PUB'
1656: , p_procedure_name => 'PURGE_PJI_DEBUG'
1657: , p_error_text => SUBSTRB(SQLERRM,1,240));
1658: END;
1659:

Line 1662: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1658: END;
1659:
1660: IF p_debug_mode = 'Y' THEN
1661: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_EXTR_PLAN_LINES_DEBUG ' || l_rows1 ;
1662: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1663: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;
1664: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1665: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1666: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

Line 1664: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1660: IF p_debug_mode = 'Y' THEN
1661: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_EXTR_PLAN_LINES_DEBUG ' || l_rows1 ;
1662: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1663: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;
1664: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1665: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1666: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1667: END IF;
1668:

Line 1666: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1662: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1663: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_FM_XBS_ACCUM_TMP1_DEBUG ' || l_rows2 ;
1664: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1665: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1666: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1667: END IF;
1668:
1669: PA_PURGE_PUB.INSERT_PURGE_LOG
1670: (

Line 1669: PA_PURGE_PUB.INSERT_PURGE_LOG

1665: pa_debug.g_err_stage:= 'No. of rows deleted from PJI_SYSTEM_DEBUG_MSG ' || l_rows3 ;
1666: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1667: END IF;
1668:
1669: PA_PURGE_PUB.INSERT_PURGE_LOG
1670: (
1671: p_request_id => p_request_id ,
1672: p_table_name => 'PJI_FM_EXTR_PLAN_LINES_DEBUG' ,
1673: p_rows_deleted => l_rows1 ,

Line 1683: PA_PURGE_PUB.INSERT_PURGE_LOG

1679: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1680: l_local_error_flag := 'Y';
1681: END IF;
1682:
1683: PA_PURGE_PUB.INSERT_PURGE_LOG
1684: (
1685: p_request_id => p_request_id ,
1686: p_table_name => 'PJI_FM_XBS_ACCUM_TMP1_DEBUG',
1687: p_rows_deleted => l_rows2,

Line 1697: PA_PURGE_PUB.INSERT_PURGE_LOG

1693: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1694: l_local_error_flag := 'Y';
1695: END IF;
1696:
1697: PA_PURGE_PUB.INSERT_PURGE_LOG
1698: (
1699: p_request_id => p_request_id ,
1700: p_table_name => 'PJI_SYSTEM_DEBUG_MSG',
1701: p_rows_deleted => l_rows3,

Line 1718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);

1714:
1715:
1716: IF p_debug_mode = 'Y' THEN
1717: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PURGE_PJI_DEBUG';
1718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1719: pa_debug.g_err_stage:= 'Exiting PURGE_PJI_DEBUG';
1720: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PJI_DEBUG :' || pa_debug.g_err_stage,l_debug_level3);
1721: pa_debug.reset_curr_function;
1722: END IF;

Line 1720: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PJI_DEBUG :' || pa_debug.g_err_stage,l_debug_level3);

1716: IF p_debug_mode = 'Y' THEN
1717: pa_debug.g_err_stage:= 'Successfully inserted Log details pertaining to PURGE_PJI_DEBUG';
1718: pa_debug.write('PA_PURGE_PUB',pa_debug.g_err_stage,l_debug_level3);
1719: pa_debug.g_err_stage:= 'Exiting PURGE_PJI_DEBUG';
1720: pa_debug.write('PA_PURGE_PUB','PA_PURGE_PUB.PURGE_PJI_DEBUG :' || pa_debug.g_err_stage,l_debug_level3);
1721: pa_debug.reset_curr_function;
1722: END IF;
1723:
1724: EXCEPTION

Line 1739: ( p_pkg_name => 'PA_PURGE_PUB'

1735: x_msg_count := 1;
1736: x_msg_data := SUBSTRB(SQLERRM,1,240);
1737:
1738: Fnd_Msg_Pub.add_exc_msg
1739: ( p_pkg_name => 'PA_PURGE_PUB'
1740: , p_procedure_name => 'PURGE_PJI_DEBUG'
1741: , p_error_text => x_msg_data);
1742:
1743: x_msg_count := FND_MSG_PUB.count_msg;

Line 1747: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

1743: x_msg_count := FND_MSG_PUB.count_msg;
1744:
1745: IF p_debug_mode = 'Y' THEN
1746: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1747: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
1748: Pa_Debug.reset_curr_function;
1749: END IF;
1750:
1751: END PURGE_PJI_DEBUG;

Line 1844: ( p_pkg_name => 'PA_PURGE_PUB'

1840: CLOSE c_purge_details ;
1841: END IF;
1842:
1843: Fnd_Msg_Pub.add_exc_msg
1844: ( p_pkg_name => 'PA_PURGE_PUB'
1845: , p_procedure_name => 'PRINT_OUTPUT_REPORT'
1846: , p_error_text => x_msg_data);
1847:
1848: x_msg_count := FND_MSG_PUB.count_msg; --5201806

Line 1852: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

1848: x_msg_count := FND_MSG_PUB.count_msg; --5201806
1849:
1850: IF l_debug_mode = 'Y' THEN -- 5201806
1851: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1852: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
1853: Pa_Debug.reset_curr_function;
1854: END IF;
1855: -- RAISE; 5201806 Do not raise in internal APIs
1856: END PRINT_OUTPUT_REPORT;

Line 1903: Pa_Debug.WRITE('PA_PURGE_PUB','Before inserting into PA_PURGE_PRJ_DETAILS',l_debug_level3);

1899: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1900:
1901: IF l_debug_mode = 'Y' THEN
1902: pa_debug.set_curr_function( p_function => 'INSERT_PURGE_LOG', p_debug_mode => 'Y');
1903: Pa_Debug.WRITE('PA_PURGE_PUB','Before inserting into PA_PURGE_PRJ_DETAILS',l_debug_level3);
1904: END IF;
1905:
1906: INSERT INTO PA_PURGE_PRJ_DETAILS
1907: (

Line 1939: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage,l_debug_level3);

1935: );
1936:
1937: IF l_debug_mode = 'Y' THEN
1938: Pa_Debug.g_err_stage:='Successfully Inserted Purge Log';
1939: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage,l_debug_level3);
1940: pa_debug.reset_curr_function;
1941: END IF;
1942:
1943: EXCEPTION

Line 1950: ( p_pkg_name => 'PA_PURGE_PUB'

1946: x_msg_count := 1;
1947: x_msg_data := SUBSTRB(SQLERRM,1,240);
1948:
1949: Fnd_Msg_Pub.add_exc_msg
1950: ( p_pkg_name => 'PA_PURGE_PUB'
1951: , p_procedure_name => 'INSERT_PURGE_LOG'
1952: , p_error_text => x_msg_data);
1953:
1954: x_msg_count := FND_MSG_PUB.count_msg; --5201806

Line 1958: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);

1954: x_msg_count := FND_MSG_PUB.count_msg; --5201806
1955:
1956: IF l_debug_mode = 'Y' THEN
1957: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1958: Pa_Debug.WRITE('PA_PURGE_PUB',Pa_Debug.g_err_stage, 5);
1959: Pa_Debug.reset_curr_function;
1960: END IF;
1961: -- RAISE; 5201806 Do not raise in internal APIs
1962: END INSERT_PURGE_LOG;

Line 1964: END PA_PURGE_PUB;

1960: END IF;
1961: -- RAISE; 5201806 Do not raise in internal APIs
1962: END INSERT_PURGE_LOG;
1963:
1964: END PA_PURGE_PUB;