DBA Data[Home] [Help]

APPS.XNP_MSG_BUILDER dependencies on XDP_UTILITIES

Line 901: xdp_utilities.create_pkg( p_pkg_name => p_pkg_name

897:
898: x_error_code := 0 ;
899: x_error_message := NULL ;
900:
901: xdp_utilities.create_pkg( p_pkg_name => p_pkg_name
902: ,p_pkg_type => 'PACKAGE'
903: ,p_application_short_name => 'XNP'
904: ,x_error_code => x_error_code
905: ,x_error_message => x_error_message) ;

Line 928: xdp_utilities.create_pkg(

924:
925: x_error_code := 0 ;
926: x_error_message := NULL ;
927:
928: xdp_utilities.create_pkg(
929: p_pkg_name => p_pkg_name
930: ,p_pkg_type => 'PACKAGE BODY'
931: ,p_application_short_name => 'XNP'
932: ,x_error_code => x_error_code

Line 971: xdp_utilities.initialize_pkg;

967: x_error_code := 0 ;
968: x_error_message := NULL ;
969: x_package_body := NULL ;
970:
971: xdp_utilities.initialize_pkg;
972:
973: -- The following statement has been commented out, replaced with the one follows
974: -- l_pkg_name := g_pkg_prefix || g_message_code || g_pkg_suffix;
975: -- By Anping Wang, bug refer. 1650015

Line 980: xdp_utilities.build_pkg('CREATE OR REPLACE PACKAGE BODY ' || l_pkg_name || ' AS '

976: -- 02/19/2001
977:
978: l_pkg_name := XNP_MESSAGE.g_pkg_prefix || g_message_code || XNP_MESSAGE.g_pkg_suffix;
979:
980: xdp_utilities.build_pkg('CREATE OR REPLACE PACKAGE BODY ' || l_pkg_name || ' AS '
981: || g_new_line || g_new_line ) ;
982:
983: x_package_body := x_package_body
984: || '/**************************************************************'

Line 998: xdp_utilities.build_pkg(l_publish_body||g_new_line || g_new_line);

994: cr_create_body( l_create_body ) ;
995:
996: IF (g_event_indr <> 'TIMER') THEN
997: cr_publish_body( l_publish_body ) ;
998: xdp_utilities.build_pkg(l_publish_body||g_new_line || g_new_line);
999: cr_send_body( l_send_body ) ;
1000: xdp_utilities.build_pkg(l_send_body||g_new_line || g_new_line);
1001: END IF;
1002:

Line 1000: xdp_utilities.build_pkg(l_send_body||g_new_line || g_new_line);

996: IF (g_event_indr <> 'TIMER') THEN
997: cr_publish_body( l_publish_body ) ;
998: xdp_utilities.build_pkg(l_publish_body||g_new_line || g_new_line);
999: cr_send_body( l_send_body ) ;
1000: xdp_utilities.build_pkg(l_send_body||g_new_line || g_new_line);
1001: END IF;
1002:
1003: cr_process_body( l_process_body ) ;
1004: xdp_utilities.build_pkg(l_process_body||g_new_line || g_new_line);

Line 1004: xdp_utilities.build_pkg(l_process_body||g_new_line || g_new_line);

1000: xdp_utilities.build_pkg(l_send_body||g_new_line || g_new_line);
1001: END IF;
1002:
1003: cr_process_body( l_process_body ) ;
1004: xdp_utilities.build_pkg(l_process_body||g_new_line || g_new_line);
1005:
1006: cr_dflt_process_body( l_dflt_process_body ) ;
1007: xdp_utilities.build_pkg(l_dflt_process_body||g_new_line || g_new_line);
1008:

Line 1007: xdp_utilities.build_pkg(l_dflt_process_body||g_new_line || g_new_line);

1003: cr_process_body( l_process_body ) ;
1004: xdp_utilities.build_pkg(l_process_body||g_new_line || g_new_line);
1005:
1006: cr_dflt_process_body( l_dflt_process_body ) ;
1007: xdp_utilities.build_pkg(l_dflt_process_body||g_new_line || g_new_line);
1008:
1009: cr_validate_body( l_validate_body ) ;
1010: xdp_utilities.build_pkg(l_validate_body||g_new_line || g_new_line);
1011:

Line 1010: xdp_utilities.build_pkg(l_validate_body||g_new_line || g_new_line);

1006: cr_dflt_process_body( l_dflt_process_body ) ;
1007: xdp_utilities.build_pkg(l_dflt_process_body||g_new_line || g_new_line);
1008:
1009: cr_validate_body( l_validate_body ) ;
1010: xdp_utilities.build_pkg(l_validate_body||g_new_line || g_new_line);
1011:
1012: IF (g_event_indr = 'TIMER') THEN
1013: cr_start_body (l_start_body) ;
1014: xdp_utilities.build_pkg(l_start_body||g_new_line );

Line 1014: xdp_utilities.build_pkg(l_start_body||g_new_line );

1010: xdp_utilities.build_pkg(l_validate_body||g_new_line || g_new_line);
1011:
1012: IF (g_event_indr = 'TIMER') THEN
1013: cr_start_body (l_start_body) ;
1014: xdp_utilities.build_pkg(l_start_body||g_new_line );
1015: END IF ;
1016:
1017: xdp_utilities.build_pkg(' '||g_new_line || ' END ' ||l_pkg_name ||';');
1018:

Line 1017: xdp_utilities.build_pkg(' '||g_new_line || ' END ' ||l_pkg_name ||';');

1013: cr_start_body (l_start_body) ;
1014: xdp_utilities.build_pkg(l_start_body||g_new_line );
1015: END IF ;
1016:
1017: xdp_utilities.build_pkg(' '||g_new_line || ' END ' ||l_pkg_name ||';');
1018:
1019: FOR i IN 1..xdp_utilities.g_message_list.COUNT
1020: LOOP
1021: l_body_len := LENGTH(x_package_body);

Line 1019: FOR i IN 1..xdp_utilities.g_message_list.COUNT

1015: END IF ;
1016:
1017: xdp_utilities.build_pkg(' '||g_new_line || ' END ' ||l_pkg_name ||';');
1018:
1019: FOR i IN 1..xdp_utilities.g_message_list.COUNT
1020: LOOP
1021: l_body_len := LENGTH(x_package_body);
1022: l_msg_len := LENGTH(xdp_utilities.g_message_list(i));
1023:

Line 1022: l_msg_len := LENGTH(xdp_utilities.g_message_list(i));

1018:
1019: FOR i IN 1..xdp_utilities.g_message_list.COUNT
1020: LOOP
1021: l_body_len := LENGTH(x_package_body);
1022: l_msg_len := LENGTH(xdp_utilities.g_message_list(i));
1023:
1024: IF ( l_body_len + l_msg_len ) < 31800 THEN
1025: x_package_body := x_package_body||g_new_line||xdp_utilities.g_message_list(i) ;
1026: ELSE

Line 1025: x_package_body := x_package_body||g_new_line||xdp_utilities.g_message_list(i) ;

1021: l_body_len := LENGTH(x_package_body);
1022: l_msg_len := LENGTH(xdp_utilities.g_message_list(i));
1023:
1024: IF ( l_body_len + l_msg_len ) < 31800 THEN
1025: x_package_body := x_package_body||g_new_line||xdp_utilities.g_message_list(i) ;
1026: ELSE
1027: x_package_body := x_package_body||g_new_line||substr(xdp_utilities.g_message_list(i),1,(31800 - l_body_len)) ;
1028: fnd_message.set_name('XNP','XNP_INCOMPLETE_PKG_DEFINITION');
1029: fnd_message.set_token('MSG_CODE',g_message_code);

Line 1027: x_package_body := x_package_body||g_new_line||substr(xdp_utilities.g_message_list(i),1,(31800 - l_body_len)) ;

1023:
1024: IF ( l_body_len + l_msg_len ) < 31800 THEN
1025: x_package_body := x_package_body||g_new_line||xdp_utilities.g_message_list(i) ;
1026: ELSE
1027: x_package_body := x_package_body||g_new_line||substr(xdp_utilities.g_message_list(i),1,(31800 - l_body_len)) ;
1028: fnd_message.set_name('XNP','XNP_INCOMPLETE_PKG_DEFINITION');
1029: fnd_message.set_token('MSG_CODE',g_message_code);
1030: l_pkg_msg := fnd_message.get ;
1031:

Line 1083: xdp_utilities.initialize_pkg;

1079: -- l_pkg_name := g_pkg_prefix || g_message_code || g_pkg_suffix;
1080: -- By Anping Wang, bug refer. 1650015
1081: -- 02/19/2001
1082: --
1083: xdp_utilities.initialize_pkg;
1084:
1085: l_pkg_name := XNP_MESSAGE.g_pkg_prefix || g_message_code || XNP_MESSAGE.g_pkg_suffix ;
1086:
1087:

Line 1099: xdp_utilities.build_pkg('CREATE OR REPLACE PACKAGE ' || l_pkg_name || ' AUTHID CURRENT_USER AS '

1095: || ' BY: ' || 'Oracle MessageBuilder' || g_new_line
1096: || '****************************************************************/'
1097: || g_new_line || g_new_line ;
1098:
1099: xdp_utilities.build_pkg('CREATE OR REPLACE PACKAGE ' || l_pkg_name || ' AUTHID CURRENT_USER AS '
1100: || g_new_line || g_new_line ) ;
1101:
1102: cr_create_signature ( l_create_sig ) ;
1103:

Line 1129: /* Adding all individual signatures to the tabe of records - xdp_utilities.g_message_list */

1125: cr_start_signature (l_timer_start_sig) ;
1126: l_timer_start_sig := l_timer_start_sig || ';' || g_new_line ;
1127: END IF;
1128:
1129: /* Adding all individual signatures to the tabe of records - xdp_utilities.g_message_list */
1130:
1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);
1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);

Line 1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);

1127: END IF;
1128:
1129: /* Adding all individual signatures to the tabe of records - xdp_utilities.g_message_list */
1130:
1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);
1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);

Line 1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);

1128:
1129: /* Adding all individual signatures to the tabe of records - xdp_utilities.g_message_list */
1130:
1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);
1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);

Line 1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);

1129: /* Adding all individual signatures to the tabe of records - xdp_utilities.g_message_list */
1130:
1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);
1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);

Line 1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);

1130:
1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);
1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);
1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);

Line 1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);

1131: xdp_utilities.build_pkg(l_create_sig||g_new_line ||g_new_line);
1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);
1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);
1139:

Line 1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);

1132: xdp_utilities.build_pkg(l_publish_sig||g_new_line ||g_new_line);
1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);
1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);
1139:
1140: FOR j IN 1..xdp_utilities.g_message_list.COUNT

Line 1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);

1133: xdp_utilities.build_pkg(l_send_sig||g_new_line ||g_new_line);
1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);
1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);
1139:
1140: FOR j IN 1..xdp_utilities.g_message_list.COUNT
1141: LOOP

Line 1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);

1134: xdp_utilities.build_pkg(l_process_sig||g_new_line ||g_new_line);
1135: xdp_utilities.build_pkg(l_dflt_process_sig||g_new_line ||g_new_line);
1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);
1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);
1139:
1140: FOR j IN 1..xdp_utilities.g_message_list.COUNT
1141: LOOP
1142: l_spec_len := LENGTH(x_package_spec);

Line 1140: FOR j IN 1..xdp_utilities.g_message_list.COUNT

1136: xdp_utilities.build_pkg(l_validate_sig||g_new_line ||g_new_line);
1137: xdp_utilities.build_pkg(l_timer_start_sig||g_new_line ||g_new_line);
1138: xdp_utilities.build_pkg(' '||g_new_line ||g_new_line|| ' END ' ||l_pkg_name ||';'||g_new_line ||g_new_line);
1139:
1140: FOR j IN 1..xdp_utilities.g_message_list.COUNT
1141: LOOP
1142: l_spec_len := LENGTH(x_package_spec);
1143: l_msg_len := LENGTH(xdp_utilities.g_message_list(j));
1144:

Line 1143: l_msg_len := LENGTH(xdp_utilities.g_message_list(j));

1139:
1140: FOR j IN 1..xdp_utilities.g_message_list.COUNT
1141: LOOP
1142: l_spec_len := LENGTH(x_package_spec);
1143: l_msg_len := LENGTH(xdp_utilities.g_message_list(j));
1144:
1145: IF (l_spec_len + l_msg_len ) < 31800 THEN
1146: x_package_spec := x_package_spec||g_new_line||xdp_utilities.g_message_list(j) ;
1147: ELSE

Line 1146: x_package_spec := x_package_spec||g_new_line||xdp_utilities.g_message_list(j) ;

1142: l_spec_len := LENGTH(x_package_spec);
1143: l_msg_len := LENGTH(xdp_utilities.g_message_list(j));
1144:
1145: IF (l_spec_len + l_msg_len ) < 31800 THEN
1146: x_package_spec := x_package_spec||g_new_line||xdp_utilities.g_message_list(j) ;
1147: ELSE
1148: x_package_spec := x_package_spec||g_new_line||substr(xdp_utilities.g_message_list(j),1,(31800 - l_spec_len));
1149: fnd_message.set_name('XNP','XNP_INCOMPLETE_PKG_DEFINITION');
1150: fnd_message.set_token('MSG_CODE',g_message_code);

Line 1148: x_package_spec := x_package_spec||g_new_line||substr(xdp_utilities.g_message_list(j),1,(31800 - l_spec_len));

1144:
1145: IF (l_spec_len + l_msg_len ) < 31800 THEN
1146: x_package_spec := x_package_spec||g_new_line||xdp_utilities.g_message_list(j) ;
1147: ELSE
1148: x_package_spec := x_package_spec||g_new_line||substr(xdp_utilities.g_message_list(j),1,(31800 - l_spec_len));
1149: fnd_message.set_name('XNP','XNP_INCOMPLETE_PKG_DEFINITION');
1150: fnd_message.set_token('MSG_CODE',g_message_code);
1151: l_pkg_msg := fnd_message.get ;
1152: EXIT;

Line 2806: xdp_utilities.build_pkg(l_create_sig||g_new_line || g_new_line);

2802: g_excep_section := g_excep_section || 'END ;'||g_new_line || g_new_line ;
2803:
2804: /* Add create signature , excep section , decl section to the table of records */
2805:
2806: xdp_utilities.build_pkg(l_create_sig||g_new_line || g_new_line);
2807: xdp_utilities.build_pkg(g_decl_section||g_new_line || g_new_line);
2808:
2809: FOR i IN 1..g_temp_tab.COUNT
2810: LOOP

Line 2807: xdp_utilities.build_pkg(g_decl_section||g_new_line || g_new_line);

2803:
2804: /* Add create signature , excep section , decl section to the table of records */
2805:
2806: xdp_utilities.build_pkg(l_create_sig||g_new_line || g_new_line);
2807: xdp_utilities.build_pkg(g_decl_section||g_new_line || g_new_line);
2808:
2809: FOR i IN 1..g_temp_tab.COUNT
2810: LOOP
2811: xdp_utilities.build_pkg(g_temp_tab(i));

Line 2811: xdp_utilities.build_pkg(g_temp_tab(i));

2807: xdp_utilities.build_pkg(g_decl_section||g_new_line || g_new_line);
2808:
2809: FOR i IN 1..g_temp_tab.COUNT
2810: LOOP
2811: xdp_utilities.build_pkg(g_temp_tab(i));
2812: END LOOP;
2813:
2814: xdp_utilities.build_pkg(g_excep_section);
2815:

Line 2814: xdp_utilities.build_pkg(g_excep_section);

2810: LOOP
2811: xdp_utilities.build_pkg(g_temp_tab(i));
2812: END LOOP;
2813:
2814: xdp_utilities.build_pkg(g_excep_section);
2815:
2816: EXCEPTION
2817: WHEN e_INVALID_MSG_CODE THEN
2818: IF ( get_children%ISOPEN ) THEN