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.PN_CC_SYNC_PKG dependencies on PNP_DEBUG_PKG

Line 116: pnp_debug_pkg.debug(l_desc||' (+)');

112:
113: BEGIN
114:
115:
116: pnp_debug_pkg.debug(l_desc||' (+)');
117:
118:
119: --Print all input parameters
120:

Line 127: pnp_debug_pkg.put_log_msg(fnd_message.get);

123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
128:
129: l_log_context := ' Getting as of Date..';
130: l_as_of_date := trunc(fnd_date.canonical_to_date(p_as_of_date));
131:

Line 259: /pnp_debug_pkg.log('l_query is : '|| l_query);/

255: l_where_clause := l_where_clause || ' ORDER BY person_id ';
256: l_query := l_query || l_where_clause ;
257:
258: /* uncomment for debugging purposes */
259: /*pnp_debug_pkg.log('l_query is : '|| l_query);*/
260:
261: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
262:
263: dbms_sql.bind_variable

Line 401: pnp_debug_pkg.log('Processing data for person: '|| l_person_id || ' HR Cost Center : ' || l_cost_center);

397: CLOSE get_emp_name;
398: END IF;
399:
400: l_person_id := asg_rec.person_id;
401: pnp_debug_pkg.log('Processing data for person: '|| l_person_id || ' HR Cost Center : ' || l_cost_center);
402:
403: END IF;
404:
405: /* Comapre cost centers and make changes if necessary */

Line 424: pnp_debug_pkg.log(l_log_context);

420:
421: ELSIF asg_rec.cost_center_code <> l_cost_center THEN
422:
423: l_log_context := ' inserting/updating data for assignment_id : ' || asg_rec.emp_space_assign_id ;
424: pnp_debug_pkg.log(l_log_context);
425:
426:
427: BEGIN
428:

Line 539: pnp_debug_pkg.log(l_log_context);

535: IF l_commit_count > l_batch_size then
536: l_log_context := ' doing batch commit...';
537: commit;
538: l_log_context := ' done batch commit...current person_id : ' || asg_rec.person_id;
539: pnp_debug_pkg.log(l_log_context);
540: l_commit_count := 0;
541: l_last_person_processed := asg_rec.person_id;
542: l_log_context := ' Cursor closing and opening again...' ;
543: pnp_debug_pkg.log(l_log_context);

Line 543: pnp_debug_pkg.log(l_log_context);

539: pnp_debug_pkg.log(l_log_context);
540: l_commit_count := 0;
541: l_last_person_processed := asg_rec.person_id;
542: l_log_context := ' Cursor closing and opening again...' ;
543: pnp_debug_pkg.log(l_log_context);
544:
545: END IF;
546:
547: EXCEPTION

Line 573: pnp_debug_pkg.log(l_log_context);

569:
570: l_log_context := ' commiting last batch...';
571: commit;
572: l_log_context := ' commited last batch...';
573: pnp_debug_pkg.log(l_log_context);
574:
575: l_log_context := ' printing summary ...';
576:
577: pnp_debug_pkg.put_log_msg('===============================================================================');

Line 577: pnp_debug_pkg.put_log_msg('===============================================================================');

573: pnp_debug_pkg.log(l_log_context);
574:
575: l_log_context := ' printing summary ...';
576:
577: pnp_debug_pkg.put_log_msg('===============================================================================');
578:
579:
580: fnd_message.set_name ('PN','PN_CAFM_LOCATION_TOTAL');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));

Line 582: pnp_debug_pkg.put_log_msg(fnd_message.get);

578:
579:
580: fnd_message.set_name ('PN','PN_CAFM_LOCATION_TOTAL');
581: fnd_message.set_token ('TOTAL', TO_CHAR(l_count_total));
582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 586: pnp_debug_pkg.put_log_msg(fnd_message.get);

582: pnp_debug_pkg.put_log_msg(fnd_message.get);
583:
584: fnd_message.set_name ('PN','PN_CAFM_LOCATION_SUCCESS');
585: fnd_message.set_token ('SUCCESS', TO_CHAR(l_count_success));
586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 590: pnp_debug_pkg.put_log_msg(fnd_message.get);

586: pnp_debug_pkg.put_log_msg(fnd_message.get);
587:
588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);
591:
592: pnp_debug_pkg.put_log_msg('===============================================================================');
593:
594:

Line 592: pnp_debug_pkg.put_log_msg('===============================================================================');

588: fnd_message.set_name ('PN','PN_CAFM_LOCATION_FAILURE');
589: fnd_message.set_token ('FAILURE', TO_CHAR(l_count_failure));
590: pnp_debug_pkg.put_log_msg(fnd_message.get);
591:
592: pnp_debug_pkg.put_log_msg('===============================================================================');
593:
594:
595: -- Print failed records
596:

Line 599: pnp_debug_pkg.put_log_msg(' ');

595: -- Print failed records
596:
597: IF failure_table.COUNT > 0 THEN
598: l_log_context := ' printing failure table...';
599: pnp_debug_pkg.put_log_msg(' ');
600: pnp_debug_pkg.put_log_msg(' ');
601:
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 600: pnp_debug_pkg.put_log_msg(' ');

596:
597: IF failure_table.COUNT > 0 THEN
598: l_log_context := ' printing failure table...';
599: pnp_debug_pkg.put_log_msg(' ');
600: pnp_debug_pkg.put_log_msg(' ');
601:
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);
604:

Line 603: pnp_debug_pkg.put_log_msg(fnd_message.get);

599: pnp_debug_pkg.put_log_msg(' ');
600: pnp_debug_pkg.put_log_msg(' ');
601:
602: fnd_message.set_name ('PN','PN_HRSYNC_FAIL_DTLS');
603: pnp_debug_pkg.put_log_msg(fnd_message.get);
604:
605: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
606: l_message := fnd_message.get;
607: l_message := l_message||' ';

Line 624: pnp_debug_pkg.put_log_msg(l_message);

620:
621: fnd_message.set_name ('PN','PN_ERR');
622: l_message := l_message||fnd_message.get||' ';
623:
624: pnp_debug_pkg.put_log_msg(l_message);
625: pnp_debug_pkg.put_log_msg(' ');
626:
627:
628: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');

Line 625: pnp_debug_pkg.put_log_msg(' ');

621: fnd_message.set_name ('PN','PN_ERR');
622: l_message := l_message||fnd_message.get||' ';
623:
624: pnp_debug_pkg.put_log_msg(l_message);
625: pnp_debug_pkg.put_log_msg(' ');
626:
627:
628: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
629:

Line 628: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');

624: pnp_debug_pkg.put_log_msg(l_message);
625: pnp_debug_pkg.put_log_msg(' ');
626:
627:
628: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
629:
630: i := 0;
631: FOR i IN 0 .. (failure_table.COUNT - 1) LOOP
632: pnp_debug_pkg.put_log_msg(failure_table(i));

Line 632: pnp_debug_pkg.put_log_msg(failure_table(i));

628: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
629:
630: i := 0;
631: FOR i IN 0 .. (failure_table.COUNT - 1) LOOP
632: pnp_debug_pkg.put_log_msg(failure_table(i));
633: END LOOP;
634:
635: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
636:

Line 635: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');

631: FOR i IN 0 .. (failure_table.COUNT - 1) LOOP
632: pnp_debug_pkg.put_log_msg(failure_table(i));
633: END LOOP;
634:
635: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
636:
637:
638: END IF;
639:

Line 645: pnp_debug_pkg.put_log_msg(' ');

641: l_message := NULL;
642:
643: IF success_table.COUNT > 0 THEN
644: l_log_context := ' printing success table...';
645: pnp_debug_pkg.put_log_msg(' ');
646: pnp_debug_pkg.put_log_msg(' ');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:

Line 646: pnp_debug_pkg.put_log_msg(' ');

642:
643: IF success_table.COUNT > 0 THEN
644: l_log_context := ' printing success table...';
645: pnp_debug_pkg.put_log_msg(' ');
646: pnp_debug_pkg.put_log_msg(' ');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');

Line 648: pnp_debug_pkg.put_log_msg(fnd_message.get);

644: l_log_context := ' printing success table...';
645: pnp_debug_pkg.put_log_msg(' ');
646: pnp_debug_pkg.put_log_msg(' ');
647: fnd_message.set_name ('PN','PN_HRSYNC_SUC_DTLS');
648: pnp_debug_pkg.put_log_msg(fnd_message.get);
649:
650: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NAME');
651: l_message := fnd_message.get;
652: l_message := l_message||' ';

Line 669: pnp_debug_pkg.put_log_msg(l_message);

665:
666: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NEW_CC');
667: l_message := l_message||fnd_message.get||' ';
668:
669: pnp_debug_pkg.put_log_msg(l_message);
670: pnp_debug_pkg.put_log_msg(' ');
671:
672:
673: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');

Line 670: pnp_debug_pkg.put_log_msg(' ');

666: fnd_message.set_name ('PN','PN_HRSYNC_REC_DTLS_NEW_CC');
667: l_message := l_message||fnd_message.get||' ';
668:
669: pnp_debug_pkg.put_log_msg(l_message);
670: pnp_debug_pkg.put_log_msg(' ');
671:
672:
673: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
674:

Line 673: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');

669: pnp_debug_pkg.put_log_msg(l_message);
670: pnp_debug_pkg.put_log_msg(' ');
671:
672:
673: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
674:
675:
676:
677: i := 0;

Line 679: pnp_debug_pkg.put_log_msg(success_table(i));

675:
676:
677: i := 0;
678: FOR i IN 0 .. (success_table.COUNT - 1) LOOP
679: pnp_debug_pkg.put_log_msg(success_table(i));
680: END LOOP;
681:
682: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
683:

Line 682: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');

678: FOR i IN 0 .. (success_table.COUNT - 1) LOOP
679: pnp_debug_pkg.put_log_msg(success_table(i));
680: END LOOP;
681:
682: pnp_debug_pkg.put_log_msg('==============================================================================================================================================================');
683:
684:
685: END IF;
686:

Line 687: pnp_debug_pkg.debug(l_desc||' (-)');

683:
684:
685: END IF;
686:
687: pnp_debug_pkg.debug(l_desc||' (-)');
688:
689: EXCEPTION
690: WHEN OTHERS THEN
691:

Line 692: pnp_debug_pkg.log(l_desc || ': Error while ' || l_log_context);

688:
689: EXCEPTION
690: WHEN OTHERS THEN
691:
692: pnp_debug_pkg.log(l_desc || ': Error while ' || l_log_context);
693: Errbuf := SQLERRM || ' : ' || SQLCODE ;
694: raise;
695: END cc_sync_with_hr;
696:

Line 801: /*pnp_debug_pkg.log(' l_statement_4:'||l_statement);

797:
798: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
799:
800: /* uncomment for debugging purposes */
801: /*pnp_debug_pkg.log(' l_statement_4:'||l_statement);
802: pnp_debug_pkg.log(' l_code_comb_id:'||l_code_comb_id);
803: pnp_debug_pkg.log(' l_column_name:'||l_column_name);*/
804:
805: dbms_sql.bind_variable

Line 802: pnp_debug_pkg.log(' l_code_comb_id:'||l_code_comb_id);

798: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
799:
800: /* uncomment for debugging purposes */
801: /*pnp_debug_pkg.log(' l_statement_4:'||l_statement);
802: pnp_debug_pkg.log(' l_code_comb_id:'||l_code_comb_id);
803: pnp_debug_pkg.log(' l_column_name:'||l_column_name);*/
804:
805: dbms_sql.bind_variable
806: (l_cursor,'x_code_comb_id',l_code_comb_id );

Line 803: pnp_debug_pkg.log(' l_column_name:'||l_column_name);*/

799:
800: /* uncomment for debugging purposes */
801: /*pnp_debug_pkg.log(' l_statement_4:'||l_statement);
802: pnp_debug_pkg.log(' l_code_comb_id:'||l_code_comb_id);
803: pnp_debug_pkg.log(' l_column_name:'||l_column_name);*/
804:
805: dbms_sql.bind_variable
806: (l_cursor,'x_code_comb_id',l_code_comb_id );
807: