DBA Data[Home] [Help]

APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on FND_MESSAGE

Line 157: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');

153:
154: IF l_count = 0 THEN
155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
156: THEN
157: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');
158: FND_MSG_PUB.Add;
159: END IF;
160: x_loading_status := 'CN_PAYEE_DATE_INVALID';
161: RAISE FND_API.G_EXC_ERROR ;

Line 178: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');

174:
175: IF l_count = 0 THEN
176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
177: THEN
178: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_INVALID');
179: FND_MSG_PUB.Add;
180: END IF;
181: x_loading_status := 'CN_PAYEE_DATE_INVALID';
182: RAISE FND_API.G_EXC_ERROR ;

Line 201: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_OVERLAP');

197: IF l_count > 0 then
198: --payee dates overlap
199: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
200: THEN
201: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_DATE_OVERLAP');
202: FND_MSG_PUB.Add;
203: END IF;
204: x_loading_status := 'CN_PAYEE_DATE_OVERLAP';
205: RAISE FND_API.G_EXC_ERROR ;

Line 282: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_NOT_ACTIVE' );

278:
279: IF l_count = 0 THEN
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_NOT_ACTIVE' );
283: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
284: FND_MESSAGE.SET_TOKEN('PAYEE_NUMBER',l_emp_num);
285: FND_MSG_PUB.Add;
286: END IF;

Line 283: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);

279: IF l_count = 0 THEN
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_NOT_ACTIVE' );
283: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
284: FND_MESSAGE.SET_TOKEN('PAYEE_NUMBER',l_emp_num);
285: FND_MSG_PUB.Add;
286: END IF;
287: x_loading_status := 'CN_PAYEE_NOT_ACTIVE';

Line 284: FND_MESSAGE.SET_TOKEN('PAYEE_NUMBER',l_emp_num);

280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_NOT_ACTIVE' );
283: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
284: FND_MESSAGE.SET_TOKEN('PAYEE_NUMBER',l_emp_num);
285: FND_MSG_PUB.Add;
286: END IF;
287: x_loading_status := 'CN_PAYEE_NOT_ACTIVE';
288: RAISE FND_API.G_EXC_ERROR ;

Line 298: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAYEE_CANNOT_BE_SAME' );

294: IF p_payee_id = p_salesrep_id THEN
295:
296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
297: THEN
298: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAYEE_CANNOT_BE_SAME' );
299: FND_MSG_PUB.Add;
300: END IF;
301: x_loading_status := 'CN_SRP_PAYEE_CANNOT_BE_SAME';
302: RAISE FND_API.G_EXC_ERROR ;

Line 311: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');

307: --+
308: IF p_end_date IS NOT NULL AND p_end_date < p_start_date THEN
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
310: THEN
311: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATE_RANGE');
312: FND_MSG_PUB.Add;
313: END IF;
314: x_loading_status := 'CN_INVALID_DATE_RANGE';
315: RAISE FND_API.G_EXC_ERROR ;

Line 334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');

330: INTO l_srp_name
331: FROM cn_salesreps
332: WHERE salesrep_id = p_salesrep_id
333: AND org_id = p_org_id;
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');
335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);
336: FND_MESSAGE.SET_TOKEN('SALESREP_NAME', l_srp_name);
337: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
338: FND_MSG_PUB.Add;

Line 335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);

331: FROM cn_salesreps
332: WHERE salesrep_id = p_salesrep_id
333: AND org_id = p_org_id;
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');
335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);
336: FND_MESSAGE.SET_TOKEN('SALESREP_NAME', l_srp_name);
337: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
338: FND_MSG_PUB.Add;
339: END IF;

Line 336: FND_MESSAGE.SET_TOKEN('SALESREP_NAME', l_srp_name);

332: WHERE salesrep_id = p_salesrep_id
333: AND org_id = p_org_id;
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');
335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);
336: FND_MESSAGE.SET_TOKEN('SALESREP_NAME', l_srp_name);
337: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
338: FND_MSG_PUB.Add;
339: END IF;
340: x_loading_status := 'CN_CANNOT_HAVE_PAYEE';

Line 337: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);

333: AND org_id = p_org_id;
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_HAVE_PAYEE');
335: FND_MESSAGE.SET_TOKEN('PLAN_NAME', l_pe_name);
336: FND_MESSAGE.SET_TOKEN('SALESREP_NAME', l_srp_name);
337: FND_MESSAGE.SET_TOKEN('PAYEE_NAME', l_payee_name);
338: FND_MSG_PUB.Add;
339: END IF;
340: x_loading_status := 'CN_CANNOT_HAVE_PAYEE';
341: RAISE FND_API.G_EXC_ERROR ;

Line 358: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_PG_NOT_FOUND');

354:
355: if l_daycount <> (l_end_date - p_start_date + 1) then
356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
357: THEN
358: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_PG_NOT_FOUND');
359: FND_MSG_PUB.Add;
360: END IF;
361: x_loading_status := 'CN_PAYEE_PG_NOT_FOUND';
362: RAISE FND_API.G_EXC_ERROR ;

Line 379: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_ROLE_NOT_FOUND');

375:
376: if l_daycount <> (l_end_date - p_start_date + 1) then
377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_ROLE_NOT_FOUND');
380: FND_MSG_PUB.Add;
381: END IF;
382: x_loading_status := 'CN_PAYEE_ROLE_NOT_FOUND';
383: RAISE FND_API.G_EXC_ERROR ;

Line 417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');

413: x_msg IN OUT nocopy VARCHAR2) IS
414:
415: l_note_msg VARCHAR2(240);
416: BEGIN
417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');
418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
419: fnd_message.set_token('OLD', p_old_value);
420: fnd_message.set_token('NEW', p_new_value);
421: l_note_msg := fnd_message.get;

Line 418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));

414:
415: l_note_msg VARCHAR2(240);
416: BEGIN
417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');
418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
419: fnd_message.set_token('OLD', p_old_value);
420: fnd_message.set_token('NEW', p_new_value);
421: l_note_msg := fnd_message.get;
422:

Line 419: fnd_message.set_token('OLD', p_old_value);

415: l_note_msg VARCHAR2(240);
416: BEGIN
417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');
418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
419: fnd_message.set_token('OLD', p_old_value);
420: fnd_message.set_token('NEW', p_new_value);
421: l_note_msg := fnd_message.get;
422:
423: IF x_msg IS NOT NULL THEN

Line 420: fnd_message.set_token('NEW', p_new_value);

416: BEGIN
417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');
418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
419: fnd_message.set_token('OLD', p_old_value);
420: fnd_message.set_token('NEW', p_new_value);
421: l_note_msg := fnd_message.get;
422:
423: IF x_msg IS NOT NULL THEN
424: x_msg := x_msg || fnd_global.local_chr(10);

Line 421: l_note_msg := fnd_message.get;

417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');
418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
419: fnd_message.set_token('OLD', p_old_value);
420: fnd_message.set_token('NEW', p_new_value);
421: l_note_msg := fnd_message.get;
422:
423: IF x_msg IS NOT NULL THEN
424: x_msg := x_msg || fnd_global.local_chr(10);
425: END IF;

Line 584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');

580: FROM cn_salesreps
581: WHERE salesrep_id = p_payee_id
582: AND org_id = l_org_id;
583:
584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');
585: fnd_message.set_token('PAYEE', l_payee_name);
586: fnd_message.set_token('START_DATE', p_start_date);
587: fnd_message.set_token('END_DATE', p_end_date);
588: l_note_msg := fnd_message.get;

Line 585: fnd_message.set_token('PAYEE', l_payee_name);

581: WHERE salesrep_id = p_payee_id
582: AND org_id = l_org_id;
583:
584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');
585: fnd_message.set_token('PAYEE', l_payee_name);
586: fnd_message.set_token('START_DATE', p_start_date);
587: fnd_message.set_token('END_DATE', p_end_date);
588: l_note_msg := fnd_message.get;
589:

Line 586: fnd_message.set_token('START_DATE', p_start_date);

582: AND org_id = l_org_id;
583:
584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');
585: fnd_message.set_token('PAYEE', l_payee_name);
586: fnd_message.set_token('START_DATE', p_start_date);
587: fnd_message.set_token('END_DATE', p_end_date);
588: l_note_msg := fnd_message.get;
589:
590: jtf_notes_pub.create_note

Line 587: fnd_message.set_token('END_DATE', p_end_date);

583:
584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');
585: fnd_message.set_token('PAYEE', l_payee_name);
586: fnd_message.set_token('START_DATE', p_start_date);
587: fnd_message.set_token('END_DATE', p_end_date);
588: l_note_msg := fnd_message.get;
589:
590: jtf_notes_pub.create_note
591: ( p_api_version => 1.0,

Line 588: l_note_msg := fnd_message.get;

584: fnd_message.set_name('CN', 'CN_PAYEE_CRE_NOTE');
585: fnd_message.set_token('PAYEE', l_payee_name);
586: fnd_message.set_token('START_DATE', p_start_date);
587: fnd_message.set_token('END_DATE', p_end_date);
588: l_note_msg := fnd_message.get;
589:
590: jtf_notes_pub.create_note
591: ( p_api_version => 1.0,
592: x_return_status => x_return_status,

Line 758: fnd_message.set_name('CN', 'CN_RECORD_UPDATED');

754: --Raise an error if the object_version numbers don't match
755: --
756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
757: THEN
758: fnd_message.set_name('CN', 'CN_RECORD_UPDATED');
759: fnd_msg_pub.add;
760: END IF;
761: x_loading_status := 'CN_RECORD_UPDATED';
762: RAISE FND_API.G_EXC_ERROR;

Line 809: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');

805: w.start_date,
806: w.end_date) = true then
807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
808: THEN
809: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');
810: FND_MSG_PUB.Add;
811: END IF;
812: x_loading_status := 'CN_PAYEE_HAS_WKSHT';
813: RAISE FND_API.G_EXC_ERROR ;

Line 1022: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');

1018: w.start_date,
1019: w.end_date) = true THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1021: THEN
1022: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAYEE_HAS_WKSHT');
1023: FND_MSG_PUB.Add;
1024: END IF;
1025: x_loading_status := 'CN_PAYEE_HAS_WKSHT';
1026: RAISE FND_API.G_EXC_ERROR ;

Line 1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');

1153: FROM cn_salesreps
1154: WHERE salesrep_id = l_payee_id
1155: AND org_id = l_org_id;
1156:
1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');
1158: fnd_message.set_token('PAYEE', l_payee_name);
1159: fnd_message.set_token('START_DATE', l_start_date);
1160: fnd_message.set_token('END_DATE', l_end_date);
1161: l_note_msg := fnd_message.get;

Line 1158: fnd_message.set_token('PAYEE', l_payee_name);

1154: WHERE salesrep_id = l_payee_id
1155: AND org_id = l_org_id;
1156:
1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');
1158: fnd_message.set_token('PAYEE', l_payee_name);
1159: fnd_message.set_token('START_DATE', l_start_date);
1160: fnd_message.set_token('END_DATE', l_end_date);
1161: l_note_msg := fnd_message.get;
1162:

Line 1159: fnd_message.set_token('START_DATE', l_start_date);

1155: AND org_id = l_org_id;
1156:
1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');
1158: fnd_message.set_token('PAYEE', l_payee_name);
1159: fnd_message.set_token('START_DATE', l_start_date);
1160: fnd_message.set_token('END_DATE', l_end_date);
1161: l_note_msg := fnd_message.get;
1162:
1163: jtf_notes_pub.create_note

Line 1160: fnd_message.set_token('END_DATE', l_end_date);

1156:
1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');
1158: fnd_message.set_token('PAYEE', l_payee_name);
1159: fnd_message.set_token('START_DATE', l_start_date);
1160: fnd_message.set_token('END_DATE', l_end_date);
1161: l_note_msg := fnd_message.get;
1162:
1163: jtf_notes_pub.create_note
1164: ( p_api_version => 1.0,

Line 1161: l_note_msg := fnd_message.get;

1157: fnd_message.set_name('CN', 'CN_PAYEE_DEL_NOTE');
1158: fnd_message.set_token('PAYEE', l_payee_name);
1159: fnd_message.set_token('START_DATE', l_start_date);
1160: fnd_message.set_token('END_DATE', l_end_date);
1161: l_note_msg := fnd_message.get;
1162:
1163: jtf_notes_pub.create_note
1164: ( p_api_version => 1.0,
1165: x_return_status => x_return_status,