DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE dependencies on FND_MSG_PUB

Line 122: FND_MSG_PUB.Initialize ;

118: pa_debug.debug('Fetching the projects ');
119: LOOP
120:
121:
122: FND_MSG_PUB.Initialize ;
123:
124: -- Fetch the next project from the cursor
125:
126: Fetch GetProjectsInBatch into l_GetProjectsInBatch_csr ;

Line 161: fnd_msg_pub.add;

157: IF (l_project_status_code <> 'PENDING_PURGE') AND /* Added for Bug 2715317 */
158: (l_project_status_code <>
159: l_GetProjectsInBatch_csr.last_project_status_code) THEN
160: fnd_message.set_name('PA','PA_ARPR_PROJ_STATUS_CHANGED');
161: fnd_msg_pub.add;
162: l_err_code := 10;
163: l_err_stage := 'This project status has been changed.';
164: l_err_stack := l_err_stack||'->Project status changed';
165: pa_debug.debug(' This project status changed after selecting a batch '||to_char(l_GetProjectsInBatch_csr.project_id));

Line 281: FND_MSG_PUB.Initialize;

277:
278: g_delete_errors := 'N';
279: pa_purge_validate_icip.g_insert_errors_no_duplicate := 'N'; /* Bug# 2431705 */
280:
281: FND_MSG_PUB.Initialize;
282:
283: if c_prj_in_batch.last_project_status_code <> 'PARTIALLY_PURGED' then
284:
285: if pa_purge_validate_icip.Is_InterPrj_Receiver_Project(c_prj_in_batch.project_id) = 'Y' then

Line 395: l_MesgCount := FND_MSG_PUB.Count_Msg ;

391: 'WE8ISO8859P1') ;
392: l_err_stack := X_err_stack ;
393: l_err_stack_old := X_err_stack ;
394: l_err_stack := X_err_stack || '-> Inserting errors to the error table ' ;
395: l_MesgCount := FND_MSG_PUB.Count_Msg ;
396:
397: if g_delete_errors = 'Y' then /* Bug#2416385 Added for Phase -III Archive and Purge */
398:
399: pa_debug.debug('Deleting errors for the project '||to_char(p_project_id)||' in batch '||to_char(p_purge_batch_id));

Line 450: FND_MSG_PUB.Get(p_encoded => l_encoded,

446: X_err_stage := 'Inserting validation errors for project '||to_char(p_project_id) ;
447:
448: for i in 1..l_MesgCount
449: LOOP
450: FND_MSG_PUB.Get(p_encoded => l_encoded,
451: p_data => l_message_code,
452: p_msg_index => 1,
453: p_msg_index_out => l_msg_index_out) ;
454: pa_debug.debug('Message is '||replace(replace(l_message_code,'PA'||l_chr), l_chr));

Line 463: FND_MSG_PUB.DELETE_MSG(p_msg_index => 1);

459: FND_MESSAGE.PARSE_ENCODED(ENCODED_MESSAGE => l_message_code,
460: APP_SHORT_NAME => l_app_name,
461: MESSAGE_NAME => l_msg_data);
462:
463: FND_MSG_PUB.DELETE_MSG(p_msg_index => 1);
464:
465: pa_debug.debug('l_msg_data:'||l_msg_data);
466:
467: end if;