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.PQP_ADDRESS_SYNCHRONIZATION dependencies on HR_UTILITY

Line 113: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

109: l_return_status Varchar2(5);
110: --
111:
112: BEGIN
113: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
114: OPEN csr_stu (c_person_id => p_person_id);
115: FETCH csr_stu INTO l_Stu_OSSData_Sync;
116: CLOSE csr_stu;
117: --

Line 231: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);

227: );
228: END IF;
229:
230: IF l_return_status IN ('E','U') THEN
231: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
232: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
233: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
235: Hr_Utility.raise_error;

Line 232: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

228: END IF;
229:
230: IF l_return_status IN ('E','U') THEN
231: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
232: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
233: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
235: Hr_Utility.raise_error;
236: END IF;

Line 233: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );

229:
230: IF l_return_status IN ('E','U') THEN
231: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
232: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
233: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
235: Hr_Utility.raise_error;
236: END IF;
237:

Line 234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

230: IF l_return_status IN ('E','U') THEN
231: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
232: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
233: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
235: Hr_Utility.raise_error;
236: END IF;
237:
238: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 235: Hr_Utility.raise_error;

231: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
232: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
233: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
235: Hr_Utility.raise_error;
236: END IF;
237:
238: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
239:

Line 238: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

234: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
235: Hr_Utility.raise_error;
236: END IF;
237:
238: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
239:
240: END Addr_DDF_Ins;
241: -- =============================================================================
242: -- ~ Addr_DDF_Upd:

Line 328: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

324: l_create_oss_addr Boolean;
325: l_update_oss_addr Boolean;
326: --
327: BEGIN
328: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
329: OPEN csr_stu (c_person_id => p_person_id);
330: FETCH csr_stu INTO l_Stu_OSSData_Sync;
331: CLOSE csr_stu;
332: --

Line 473: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

469: ,p_return_status => l_return_status
470: ,p_msg_data => l_msg_data
471: );
472: END IF;
473: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
474: IF l_return_status IN ('E','U') THEN
475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );

Line 475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);

471: );
472: END IF;
473: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
474: IF l_return_status IN ('E','U') THEN
475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
478: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
479: Hr_Utility.raise_error;

Line 476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

472: END IF;
473: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
474: IF l_return_status IN ('E','U') THEN
475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
478: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
479: Hr_Utility.raise_error;
480: END IF;

Line 477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );

473: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
474: IF l_return_status IN ('E','U') THEN
475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
478: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
479: Hr_Utility.raise_error;
480: END IF;
481:

Line 478: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

474: IF l_return_status IN ('E','U') THEN
475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
478: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
479: Hr_Utility.raise_error;
480: END IF;
481:
482: END Addr_DDF_Upd;

Line 479: Hr_Utility.raise_error;

475: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
476: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
477: Hr_Utility.set_message_token('GENERIC_TOKEN',l_msg_data );
478: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
479: Hr_Utility.raise_error;
480: END IF;
481:
482: END Addr_DDF_Upd;
483: -- =============================================================================

Line 518: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

514:
515: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Addr_DDF_Del';
516:
517: BEGIN
518: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
519: NULL;
520: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
521: END Addr_DDF_Del;
522:

Line 520: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

516:
517: BEGIN
518: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
519: NULL;
520: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
521: END Addr_DDF_Del;
522:
523: End PQP_Address_Synchronization;