DBA Data[Home] [Help]

APPS.PJM_UNIT_EFF_CONC dependencies on PJM_CONC

Line 61: PJM_CONC.new_line(1);

57:
58: if ( PJM_UNIT_EFF.Enabled = 'N' ) then
59: fnd_message.set_name('PJM','UEFF-Function Not Available');
60: ERRBUF := fnd_message.get;
61: PJM_CONC.new_line(1);
62: PJM_CONC.put_line(ERRBUF);
63: PJM_CONC.new_line(1);
64: RETCODE := PJM_CONC.G_conc_failure;
65: return;

Line 62: PJM_CONC.put_line(ERRBUF);

58: if ( PJM_UNIT_EFF.Enabled = 'N' ) then
59: fnd_message.set_name('PJM','UEFF-Function Not Available');
60: ERRBUF := fnd_message.get;
61: PJM_CONC.new_line(1);
62: PJM_CONC.put_line(ERRBUF);
63: PJM_CONC.new_line(1);
64: RETCODE := PJM_CONC.G_conc_failure;
65: return;
66: end if;

Line 63: PJM_CONC.new_line(1);

59: fnd_message.set_name('PJM','UEFF-Function Not Available');
60: ERRBUF := fnd_message.get;
61: PJM_CONC.new_line(1);
62: PJM_CONC.put_line(ERRBUF);
63: PJM_CONC.new_line(1);
64: RETCODE := PJM_CONC.G_conc_failure;
65: return;
66: end if;
67:

Line 64: RETCODE := PJM_CONC.G_conc_failure;

60: ERRBUF := fnd_message.get;
61: PJM_CONC.new_line(1);
62: PJM_CONC.put_line(ERRBUF);
63: PJM_CONC.new_line(1);
64: RETCODE := PJM_CONC.G_conc_failure;
65: return;
66: end if;
67:
68: PJM_CONC.new_line(1);

Line 68: PJM_CONC.new_line(1);

64: RETCODE := PJM_CONC.G_conc_failure;
65: return;
66: end if;
67:
68: PJM_CONC.new_line(1);
69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);
70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);

Line 69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);

65: return;
66: end if;
67:
68: PJM_CONC.new_line(1);
69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);
70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);

Line 70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);

66: end if;
67:
68: PJM_CONC.new_line(1);
69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);
70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);
74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);

Line 71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);

67:
68: PJM_CONC.new_line(1);
69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);
70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);
74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);
75: PJM_CONC.new_line(1);

Line 72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);

68: PJM_CONC.new_line(1);
69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);
70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);
74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);
75: PJM_CONC.new_line(1);
76:

Line 73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);

69: PJM_CONC.put_line('[MASTER_ORG_ID] = ' || X_master_org_id);
70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);
74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);
75: PJM_CONC.new_line(1);
76:
77: --

Line 74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);

70: PJM_CONC.put_line('[END_ITEM_ID] = ' || X_end_item_id);
71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);
74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);
75: PJM_CONC.new_line(1);
76:
77: --
78: -- Calculate End_Num based on X_Start_Num and X_Counts

Line 75: PJM_CONC.new_line(1);

71: PJM_CONC.put_line('[PREFIX] = ' || X_prefix);
72: PJM_CONC.put_line('[START_NUM] = ' || X_start_num);
73: PJM_CONC.put_line('[COUNTS] = ' || X_counts);
74: PJM_CONC.put_line('[NUMERIC_WIDTH] = ' || X_numeric_width);
75: PJM_CONC.new_line(1);
76:
77: --
78: -- Calculate End_Num based on X_Start_Num and X_Counts
79: --

Line 86: PJM_CONC.new_line(1);

82: if ( length(to_char(L_end_num)) > X_numeric_width ) then
83: fnd_message.set_name('PJM','UEFF-Exc Unit Num Length');
84: fnd_message.set_token('LEN1', to_char(L_end_num));
85: fnd_message.set_token('LEN2', X_numeric_width);
86: PJM_CONC.new_line(1);
87: PJM_CONC.put_line(fnd_message.get);
88: PJM_CONC.new_line(1);
89: L_pad_width := length(to_char(L_end_num));
90: else

Line 87: PJM_CONC.put_line(fnd_message.get);

83: fnd_message.set_name('PJM','UEFF-Exc Unit Num Length');
84: fnd_message.set_token('LEN1', to_char(L_end_num));
85: fnd_message.set_token('LEN2', X_numeric_width);
86: PJM_CONC.new_line(1);
87: PJM_CONC.put_line(fnd_message.get);
88: PJM_CONC.new_line(1);
89: L_pad_width := length(to_char(L_end_num));
90: else
91: L_pad_width := X_numeric_width;

Line 88: PJM_CONC.new_line(1);

84: fnd_message.set_token('LEN1', to_char(L_end_num));
85: fnd_message.set_token('LEN2', X_numeric_width);
86: PJM_CONC.new_line(1);
87: PJM_CONC.put_line(fnd_message.get);
88: PJM_CONC.new_line(1);
89: L_pad_width := length(to_char(L_end_num));
90: else
91: L_pad_width := X_numeric_width;
92: end if;

Line 97: PJM_CONC.new_line(1);

93:
94: if nvl(length(X_prefix),0) + L_pad_width > 30 then
95: fnd_message.set_name('PJM','UEFF-Max Unit Num Length');
96: errbuf := fnd_message.get;
97: PJM_CONC.new_line(1);
98: PJM_CONC.put_line(errbuf);
99: PJM_CONC.new_line(1);
100: retcode := PJM_CONC.G_conc_failure;
101: return;

Line 98: PJM_CONC.put_line(errbuf);

94: if nvl(length(X_prefix),0) + L_pad_width > 30 then
95: fnd_message.set_name('PJM','UEFF-Max Unit Num Length');
96: errbuf := fnd_message.get;
97: PJM_CONC.new_line(1);
98: PJM_CONC.put_line(errbuf);
99: PJM_CONC.new_line(1);
100: retcode := PJM_CONC.G_conc_failure;
101: return;
102: end if;

Line 99: PJM_CONC.new_line(1);

95: fnd_message.set_name('PJM','UEFF-Max Unit Num Length');
96: errbuf := fnd_message.get;
97: PJM_CONC.new_line(1);
98: PJM_CONC.put_line(errbuf);
99: PJM_CONC.new_line(1);
100: retcode := PJM_CONC.G_conc_failure;
101: return;
102: end if;
103:

Line 100: retcode := PJM_CONC.G_conc_failure;

96: errbuf := fnd_message.get;
97: PJM_CONC.new_line(1);
98: PJM_CONC.put_line(errbuf);
99: PJM_CONC.new_line(1);
100: retcode := PJM_CONC.G_conc_failure;
101: return;
102: end if;
103:
104: L_user_id := fnd_global.user_id;

Line 110: PJM_CONC.new_line(1);

106: L_request_id := fnd_global.conc_request_id;
107: L_prog_appl_id := fnd_global.prog_appl_id;
108: L_prog_id := fnd_global.conc_program_id;
109:
110: PJM_CONC.new_line(1);
111: PJM_CONC.put_line(fnd_message.get_string('PJM','CONC-UEFGN BEGIN'));
112: PJM_CONC.new_line(1);
113:
114: n := 0;

Line 111: PJM_CONC.put_line(fnd_message.get_string('PJM','CONC-UEFGN BEGIN'));

107: L_prog_appl_id := fnd_global.prog_appl_id;
108: L_prog_id := fnd_global.conc_program_id;
109:
110: PJM_CONC.new_line(1);
111: PJM_CONC.put_line(fnd_message.get_string('PJM','CONC-UEFGN BEGIN'));
112: PJM_CONC.new_line(1);
113:
114: n := 0;
115:

Line 112: PJM_CONC.new_line(1);

108: L_prog_id := fnd_global.conc_program_id;
109:
110: PJM_CONC.new_line(1);
111: PJM_CONC.put_line(fnd_message.get_string('PJM','CONC-UEFGN BEGIN'));
112: PJM_CONC.new_line(1);
113:
114: n := 0;
115:
116: FOR i in X_start_num..L_end_num

Line 157: PJM_CONC.put_line(fnd_message.get);

153: n := n + 1;
154:
155: fnd_message.set_name('PJM','CONC-UEFGN UNITNUM CREATED');
156: fnd_message.set_token('UNIT', L_current_unit_number);
157: PJM_CONC.put_line(fnd_message.get);
158:
159: EXCEPTION
160: WHEN dup_val_on_index THEN
161: fnd_message.set_name('PJM','CONC-UEFGN UNITNUM EXISTS');

Line 163: PJM_CONC.put_line(fnd_message.get);

159: EXCEPTION
160: WHEN dup_val_on_index THEN
161: fnd_message.set_name('PJM','CONC-UEFGN UNITNUM EXISTS');
162: fnd_message.set_token('UNIT', L_current_unit_number);
163: PJM_CONC.put_line(fnd_message.get);
164: WHEN others THEN
165: errbuf := sqlerrm;
166: retcode := PJM_CONC.G_conc_failure;
167: return;

Line 166: retcode := PJM_CONC.G_conc_failure;

162: fnd_message.set_token('UNIT', L_current_unit_number);
163: PJM_CONC.put_line(fnd_message.get);
164: WHEN others THEN
165: errbuf := sqlerrm;
166: retcode := PJM_CONC.G_conc_failure;
167: return;
168: END;
169:
170: END LOOP;

Line 172: PJM_CONC.new_line(1);

168: END;
169:
170: END LOOP;
171:
172: PJM_CONC.new_line(1);
173: fnd_message.set_name('PJM','CONC-UEFGN DONE');
174: fnd_message.set_token('NUM', n);
175: PJM_CONC.put_line(fnd_message.get);
176: PJM_CONC.new_line(1);

Line 175: PJM_CONC.put_line(fnd_message.get);

171:
172: PJM_CONC.new_line(1);
173: fnd_message.set_name('PJM','CONC-UEFGN DONE');
174: fnd_message.set_token('NUM', n);
175: PJM_CONC.put_line(fnd_message.get);
176: PJM_CONC.new_line(1);
177:
178: retcode := PJM_CONC.G_conc_success;
179:

Line 176: PJM_CONC.new_line(1);

172: PJM_CONC.new_line(1);
173: fnd_message.set_name('PJM','CONC-UEFGN DONE');
174: fnd_message.set_token('NUM', n);
175: PJM_CONC.put_line(fnd_message.get);
176: PJM_CONC.new_line(1);
177:
178: retcode := PJM_CONC.G_conc_success;
179:
180: END Generate;

Line 178: retcode := PJM_CONC.G_conc_success;

174: fnd_message.set_token('NUM', n);
175: PJM_CONC.put_line(fnd_message.get);
176: PJM_CONC.new_line(1);
177:
178: retcode := PJM_CONC.G_conc_success;
179:
180: END Generate;
181:
182: