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.CN_MULTI_RATE_SCHEDULES_PVT dependencies on FND_MSG_PUB

Line 31: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

27: AND org_id = p_org_id;
28: --R12 MOAC Changes--End
29: BEGIN
30: IF (p_name IS NULL) THEN
31: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
32: l_prompt := cn_api.get_lkup_meaning('RATE_TABLE_NAME', 'CN_PROMPTS');
33: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
34: fnd_message.set_token('OBJ_NAME', l_prompt);
35: fnd_msg_pub.ADD;

Line 35: fnd_msg_pub.ADD;

31: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
32: l_prompt := cn_api.get_lkup_meaning('RATE_TABLE_NAME', 'CN_PROMPTS');
33: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
34: fnd_message.set_token('OBJ_NAME', l_prompt);
35: fnd_msg_pub.ADD;
36: END IF;
37: RAISE fnd_api.g_exc_error;
38: END IF;
39:

Line 45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

41: FETCH name_exists INTO l_dummy;
42: CLOSE name_exists;
43:
44: IF (l_dummy = 1) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
47: fnd_msg_pub.ADD;
48: END IF;
49: RAISE fnd_api.g_exc_error;

Line 47: fnd_msg_pub.ADD;

43:
44: IF (l_dummy = 1) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
47: fnd_msg_pub.ADD;
48: END IF;
49: RAISE fnd_api.g_exc_error;
50: END IF;
51:

Line 54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

50: END IF;
51:
52: -- validate commission_unit_code
53: IF (p_commission_unit_code NOT IN ('AMOUNT', 'PERCENT')) THEN
54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
55: fnd_message.set_name('CN', 'CN_INVALID_CUC');
56: fnd_msg_pub.ADD;
57: END IF;
58: RAISE fnd_api.g_exc_error;

Line 56: fnd_msg_pub.ADD;

52: -- validate commission_unit_code
53: IF (p_commission_unit_code NOT IN ('AMOUNT', 'PERCENT')) THEN
54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
55: fnd_message.set_name('CN', 'CN_INVALID_CUC');
56: fnd_msg_pub.ADD;
57: END IF;
58: RAISE fnd_api.g_exc_error;
59: END IF;
60:

Line 64: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

60:
61: -- if p_dims_tbl is not empty, then p_number_dim should be equal to the number of
62: -- records in p_dims_tbl. also the sequence numbers should be unique
63: IF (p_number_dim <> p_dims_tbl.count) THEN
64: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
65: fnd_message.set_name('CN', 'CN_X_NUMBER_DIM');
66: fnd_msg_pub.ADD;
67: END IF;
68: RAISE fnd_api.g_exc_error;

Line 66: fnd_msg_pub.ADD;

62: -- records in p_dims_tbl. also the sequence numbers should be unique
63: IF (p_number_dim <> p_dims_tbl.count) THEN
64: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
65: fnd_message.set_name('CN', 'CN_X_NUMBER_DIM');
66: fnd_msg_pub.ADD;
67: END IF;
68: RAISE fnd_api.g_exc_error;
69: END IF;
70:

Line 77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

73: for j in i+1..p_dims_tbl.last loop
74: -- for i in 1..p_number_dim-1 loop
75: -- for j in i+1..p_number_dim loop
76: if p_dims_tbl(i).rate_dim_sequence = p_dims_tbl(j).rate_dim_sequence then
77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
78: fnd_message.set_name('CN', 'CN_SEQUENCE_NOT_UNIQUE');
79: fnd_msg_pub.ADD;
80: END IF;
81: RAISE fnd_api.g_exc_error;

Line 79: fnd_msg_pub.ADD;

75: -- for j in i+1..p_number_dim loop
76: if p_dims_tbl(i).rate_dim_sequence = p_dims_tbl(j).rate_dim_sequence then
77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
78: fnd_message.set_name('CN', 'CN_SEQUENCE_NOT_UNIQUE');
79: fnd_msg_pub.ADD;
80: END IF;
81: RAISE fnd_api.g_exc_error;
82: END IF;
83: if p_dims_tbl(i).rate_dimension_id = p_dims_tbl(j).rate_dimension_id then

Line 84: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

80: END IF;
81: RAISE fnd_api.g_exc_error;
82: END IF;
83: if p_dims_tbl(i).rate_dimension_id = p_dims_tbl(j).rate_dimension_id then
84: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
85: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
86: fnd_msg_pub.ADD;
87: END IF;
88: RAISE fnd_api.g_exc_error;

Line 86: fnd_msg_pub.ADD;

82: END IF;
83: if p_dims_tbl(i).rate_dimension_id = p_dims_tbl(j).rate_dimension_id then
84: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
85: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
86: fnd_msg_pub.ADD;
87: END IF;
88: RAISE fnd_api.g_exc_error;
89: END IF;
90: end loop;

Line 348: FND_MSG_PUB.initialize;

344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:

Line 433: FND_MSG_PUB.Count_And_Get

429: IF FND_API.To_Boolean( p_commit ) THEN
430: COMMIT WORK;
431: END IF;
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: (p_count => x_msg_count ,
435: p_data => x_msg_data ,
436: p_encoded => FND_API.G_FALSE );
437: EXCEPTION

Line 441: FND_MSG_PUB.count_and_get

437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO Create_Schedule;
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: FND_MSG_PUB.count_and_get
442: (p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE );
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 448: FND_MSG_PUB.count_and_get

444: p_encoded => FND_API.G_FALSE );
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO Create_Schedule;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: FND_MSG_PUB.count_and_get
449: (p_count => x_msg_count ,
450: p_data => x_msg_data ,
451: p_encoded => FND_API.G_FALSE );
452: WHEN OTHERS THEN

Line 455: IF FND_MSG_PUB.check_msg_level

451: p_encoded => FND_API.G_FALSE );
452: WHEN OTHERS THEN
453: ROLLBACK TO Create_Schedule;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: IF FND_MSG_PUB.check_msg_level
456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.add_exc_msg
459: (G_PKG_NAME ,

Line 456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

452: WHEN OTHERS THEN
453: ROLLBACK TO Create_Schedule;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: IF FND_MSG_PUB.check_msg_level
456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.add_exc_msg
459: (G_PKG_NAME ,
460: l_api_name );

Line 458: FND_MSG_PUB.add_exc_msg

454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: IF FND_MSG_PUB.check_msg_level
456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.add_exc_msg
459: (G_PKG_NAME ,
460: l_api_name );
461: END IF;
462: FND_MSG_PUB.count_and_get

Line 462: FND_MSG_PUB.count_and_get

458: FND_MSG_PUB.add_exc_msg
459: (G_PKG_NAME ,
460: l_api_name );
461: END IF;
462: FND_MSG_PUB.count_and_get
463: (p_count => x_msg_count ,
464: p_data => x_msg_data ,
465: p_encoded => FND_API.G_FALSE );
466: END Create_Schedule;

Line 565: FND_MSG_PUB.initialize;

561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563: -- Initialize message list if p_init_msg_list is set to TRUE.
564: IF FND_API.to_Boolean( p_init_msg_list ) THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567: -- Initialize API return status to success
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569:

Line 596: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

592: x_usage_code => l_usage_code);
593: IF (l_usage_code = 'USED' AND
594: (l_commission_unit_code_old <> p_commission_unit_code OR l_number_dim > 0))
595: THEN
596: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
597: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
598: fnd_msg_pub.ADD;
599: END IF;
600: RAISE fnd_api.g_exc_error;

Line 598: fnd_msg_pub.ADD;

594: (l_commission_unit_code_old <> p_commission_unit_code OR l_number_dim > 0))
595: THEN
596: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
597: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
598: fnd_msg_pub.ADD;
599: END IF;
600: RAISE fnd_api.g_exc_error;
601: END IF;
602:

Line 740: FND_MSG_PUB.count_and_get

736: IF FND_API.To_Boolean( p_commit ) THEN
737: COMMIT WORK;
738: END IF;
739: -- Standard call to get message count and if count is 1, get message info.
740: FND_MSG_PUB.count_and_get
741: (p_count => x_msg_count ,
742: p_data => x_msg_data ,
743: p_encoded => FND_API.G_FALSE );
744: EXCEPTION

Line 748: FND_MSG_PUB.count_and_get

744: EXCEPTION
745: WHEN FND_API.G_EXC_ERROR THEN
746: ROLLBACK TO Update_Schedule;
747: x_return_status := FND_API.G_RET_STS_ERROR ;
748: FND_MSG_PUB.count_and_get
749: (p_count => x_msg_count ,
750: p_data => x_msg_data ,
751: p_encoded => FND_API.G_FALSE );
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 755: FND_MSG_PUB.count_and_get

751: p_encoded => FND_API.G_FALSE );
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO Update_Schedule;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: FND_MSG_PUB.count_and_get
756: (p_count => x_msg_count ,
757: p_data => x_msg_data ,
758: p_encoded => FND_API.G_FALSE );
759: WHEN OTHERS THEN

Line 762: IF FND_MSG_PUB.check_msg_level

758: p_encoded => FND_API.G_FALSE );
759: WHEN OTHERS THEN
760: ROLLBACK TO Update_Schedule;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.check_msg_level
763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
764: THEN
765: FND_MSG_PUB.add_exc_msg
766: (G_PKG_NAME ,

Line 763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

759: WHEN OTHERS THEN
760: ROLLBACK TO Update_Schedule;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.check_msg_level
763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
764: THEN
765: FND_MSG_PUB.add_exc_msg
766: (G_PKG_NAME ,
767: l_api_name );

Line 765: FND_MSG_PUB.add_exc_msg

761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.check_msg_level
763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
764: THEN
765: FND_MSG_PUB.add_exc_msg
766: (G_PKG_NAME ,
767: l_api_name );
768: END IF;
769: FND_MSG_PUB.count_and_get

Line 769: FND_MSG_PUB.count_and_get

765: FND_MSG_PUB.add_exc_msg
766: (G_PKG_NAME ,
767: l_api_name );
768: END IF;
769: FND_MSG_PUB.count_and_get
770: (p_count => x_msg_count ,
771: p_data => x_msg_data ,
772: p_encoded => FND_API.G_FALSE );
773: END Update_Schedule;

Line 839: FND_MSG_PUB.initialize;

835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF FND_API.to_Boolean( p_init_msg_list ) THEN
839: FND_MSG_PUB.initialize;
840: END IF;
841: -- Initialize API return status to success
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:

Line 849: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

845:
846: usage_check(p_rate_schedule_id => p_rate_schedule_id,
847: x_usage_code => l_usage_code);
848: IF (l_usage_code = 'USED') THEN
849: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
850: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
851: fnd_msg_pub.ADD;
852: END IF;
853: RAISE fnd_api.g_exc_error;

Line 851: fnd_msg_pub.ADD;

847: x_usage_code => l_usage_code);
848: IF (l_usage_code = 'USED') THEN
849: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
850: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
851: fnd_msg_pub.ADD;
852: END IF;
853: RAISE fnd_api.g_exc_error;
854: END IF;
855:

Line 902: FND_MSG_PUB.count_and_get

898: IF FND_API.To_Boolean( p_commit ) THEN
899: COMMIT WORK;
900: END IF;
901: -- Standard call to get message count and if count is 1, get message info.
902: FND_MSG_PUB.count_and_get
903: (p_count => x_msg_count ,
904: p_data => x_msg_data ,
905: p_encoded => FND_API.G_FALSE );
906: EXCEPTION

Line 910: FND_MSG_PUB.count_and_get

906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: ROLLBACK TO Delete_Schedule;
909: x_return_status := FND_API.G_RET_STS_ERROR ;
910: FND_MSG_PUB.count_and_get
911: (p_count => x_msg_count ,
912: p_data => x_msg_data ,
913: p_encoded => FND_API.G_FALSE );
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 917: FND_MSG_PUB.count_and_get

913: p_encoded => FND_API.G_FALSE );
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: ROLLBACK TO Delete_Schedule;
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
917: FND_MSG_PUB.count_and_get
918: (p_count => x_msg_count ,
919: p_data => x_msg_data ,
920: p_encoded => FND_API.G_FALSE );
921: WHEN OTHERS THEN

Line 924: IF FND_MSG_PUB.check_msg_level

920: p_encoded => FND_API.G_FALSE );
921: WHEN OTHERS THEN
922: ROLLBACK TO Delete_Schedule;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: IF FND_MSG_PUB.check_msg_level
925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.add_exc_msg
928: (G_PKG_NAME ,

Line 925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

921: WHEN OTHERS THEN
922: ROLLBACK TO Delete_Schedule;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: IF FND_MSG_PUB.check_msg_level
925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.add_exc_msg
928: (G_PKG_NAME ,
929: l_api_name );

Line 927: FND_MSG_PUB.add_exc_msg

923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: IF FND_MSG_PUB.check_msg_level
925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.add_exc_msg
928: (G_PKG_NAME ,
929: l_api_name );
930: END IF;
931: FND_MSG_PUB.count_and_get

Line 931: FND_MSG_PUB.count_and_get

927: FND_MSG_PUB.add_exc_msg
928: (G_PKG_NAME ,
929: l_api_name );
930: END IF;
931: FND_MSG_PUB.count_and_get
932: (p_count => x_msg_count ,
933: p_data => x_msg_data ,
934: p_encoded => FND_API.G_FALSE );
935: END Delete_Schedule;

Line 1009: FND_MSG_PUB.initialize;

1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007: -- Initialize message list if p_init_msg_list is set to TRUE.
1008: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1009: FND_MSG_PUB.initialize;
1010: END IF;
1011: -- Initialize API return status to success
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013:

Line 1019: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

1015:
1016: usage_check(p_rate_schedule_id => p_rate_schedule_id,
1017: x_usage_code => l_usage_code);
1018: IF (l_usage_code = 'USED') THEN
1019: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1020: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1021: fnd_msg_pub.ADD;
1022: END IF;
1023: RAISE fnd_api.g_exc_error;

Line 1021: fnd_msg_pub.ADD;

1017: x_usage_code => l_usage_code);
1018: IF (l_usage_code = 'USED') THEN
1019: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1020: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1021: fnd_msg_pub.ADD;
1022: END IF;
1023: RAISE fnd_api.g_exc_error;
1024: END IF;
1025:

Line 1036: fnd_msg_pub.add;

1032: AND rate_sch_dim_id = p_rate_sch_dim_id;
1033: EXCEPTION
1034: when no_data_found then
1035: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
1036: fnd_msg_pub.add;
1037: raise fnd_api.g_exc_unexpected_error;
1038: END;
1039:
1040: delete_rate_tiers(p_rate_schedule_id => p_rate_schedule_id,

Line 1108: FND_MSG_PUB.Count_And_Get

1104: IF FND_API.To_Boolean( p_commit ) THEN
1105: COMMIT WORK;
1106: END IF;
1107: -- Standard call to get message count and if count is 1, get message info.
1108: FND_MSG_PUB.Count_And_Get
1109: (p_count => x_msg_count ,
1110: p_data => x_msg_data ,
1111: p_encoded => FND_API.G_FALSE );
1112: EXCEPTION

Line 1116: FND_MSG_PUB.count_and_get

1112: EXCEPTION
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: ROLLBACK TO Delete_Dimension_Assign;
1115: x_return_status := FND_API.G_RET_STS_ERROR ;
1116: FND_MSG_PUB.count_and_get
1117: (p_count => x_msg_count ,
1118: p_data => x_msg_data ,
1119: p_encoded => FND_API.G_FALSE );
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1123: FND_MSG_PUB.count_and_get

1119: p_encoded => FND_API.G_FALSE );
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO Delete_Dimension_Assign;
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1123: FND_MSG_PUB.count_and_get
1124: (p_count => x_msg_count ,
1125: p_data => x_msg_data ,
1126: p_encoded => FND_API.G_FALSE );
1127: WHEN OTHERS THEN

Line 1130: IF FND_MSG_PUB.check_msg_level

1126: p_encoded => FND_API.G_FALSE );
1127: WHEN OTHERS THEN
1128: ROLLBACK TO Delete_Dimension_Assign;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1130: IF FND_MSG_PUB.check_msg_level
1131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg
1134: (G_PKG_NAME ,

Line 1131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1127: WHEN OTHERS THEN
1128: ROLLBACK TO Delete_Dimension_Assign;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1130: IF FND_MSG_PUB.check_msg_level
1131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg
1134: (G_PKG_NAME ,
1135: l_api_name );

Line 1133: FND_MSG_PUB.add_exc_msg

1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1130: IF FND_MSG_PUB.check_msg_level
1131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg
1134: (G_PKG_NAME ,
1135: l_api_name );
1136: END IF;
1137: FND_MSG_PUB.count_and_get

Line 1137: FND_MSG_PUB.count_and_get

1133: FND_MSG_PUB.add_exc_msg
1134: (G_PKG_NAME ,
1135: l_api_name );
1136: END IF;
1137: FND_MSG_PUB.count_and_get
1138: (p_count => x_msg_count ,
1139: p_data => x_msg_data ,
1140: p_encoded => FND_API.G_FALSE );
1141: END Delete_Dimension_Assign;

Line 1233: FND_MSG_PUB.initialize;

1229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231: -- Initialize message list if p_init_msg_list is set to TRUE.
1232: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1233: FND_MSG_PUB.initialize;
1234: END IF;
1235: -- Initialize API return status to success
1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237:

Line 1243: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

1239:
1240: usage_check(p_rate_schedule_id,
1241: x_usage_code => l_usage_code);
1242: IF (l_usage_code = 'USED') THEN
1243: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1244: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1245: fnd_msg_pub.ADD;
1246: END IF;
1247: RAISE fnd_api.g_exc_error;

Line 1245: fnd_msg_pub.ADD;

1241: x_usage_code => l_usage_code);
1242: IF (l_usage_code = 'USED') THEN
1243: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1244: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1245: fnd_msg_pub.ADD;
1246: END IF;
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249:

Line 1270: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

1266: select count(*) into l_count from cn_rate_sch_dims
1267: where rate_schedule_id = p_rate_schedule_id
1268: and rate_dimension_id = p_rate_dimension_id;
1269: if l_count > 0 then
1270: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1271: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
1272: fnd_msg_pub.ADD;
1273: END IF;
1274: RAISE fnd_api.g_exc_error;

Line 1272: fnd_msg_pub.ADD;

1268: and rate_dimension_id = p_rate_dimension_id;
1269: if l_count > 0 then
1270: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1271: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
1272: fnd_msg_pub.ADD;
1273: END IF;
1274: RAISE fnd_api.g_exc_error;
1275: END IF;
1276: IF (l_number_tier_new > l_number_tier_old) THEN

Line 1356: FND_MSG_PUB.Count_And_Get

1352: IF FND_API.To_Boolean( p_commit ) THEN
1353: COMMIT WORK;
1354: END IF;
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: (p_count => x_msg_count ,
1358: p_data => x_msg_data ,
1359: p_encoded => FND_API.G_FALSE );
1360: EXCEPTION

Line 1364: FND_MSG_PUB.count_and_get

1360: EXCEPTION
1361: WHEN FND_API.G_EXC_ERROR THEN
1362: ROLLBACK TO Update_Dimension_Assign;
1363: x_return_status := FND_API.G_RET_STS_ERROR ;
1364: FND_MSG_PUB.count_and_get
1365: (p_count => x_msg_count ,
1366: p_data => x_msg_data ,
1367: p_encoded => FND_API.G_FALSE );
1368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1371: FND_MSG_PUB.count_and_get

1367: p_encoded => FND_API.G_FALSE );
1368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1369: ROLLBACK TO Update_Dimension_Assign;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1371: FND_MSG_PUB.count_and_get
1372: (p_count => x_msg_count ,
1373: p_data => x_msg_data ,
1374: p_encoded => FND_API.G_FALSE );
1375: WHEN OTHERS THEN

Line 1378: IF FND_MSG_PUB.check_msg_level

1374: p_encoded => FND_API.G_FALSE );
1375: WHEN OTHERS THEN
1376: ROLLBACK TO Update_Dimension_Assign;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.check_msg_level
1379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1380: THEN
1381: FND_MSG_PUB.add_exc_msg
1382: (G_PKG_NAME ,

Line 1379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1375: WHEN OTHERS THEN
1376: ROLLBACK TO Update_Dimension_Assign;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.check_msg_level
1379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1380: THEN
1381: FND_MSG_PUB.add_exc_msg
1382: (G_PKG_NAME ,
1383: l_api_name );

Line 1381: FND_MSG_PUB.add_exc_msg

1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.check_msg_level
1379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1380: THEN
1381: FND_MSG_PUB.add_exc_msg
1382: (G_PKG_NAME ,
1383: l_api_name );
1384: END IF;
1385: FND_MSG_PUB.count_and_get

Line 1385: FND_MSG_PUB.count_and_get

1381: FND_MSG_PUB.add_exc_msg
1382: (G_PKG_NAME ,
1383: l_api_name );
1384: END IF;
1385: FND_MSG_PUB.count_and_get
1386: (p_count => x_msg_count ,
1387: p_data => x_msg_data ,
1388: p_encoded => FND_API.G_FALSE );
1389: END Update_Dimension_Assign;

Line 1471: FND_MSG_PUB.initialize;

1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469: -- Initialize message list if p_init_msg_list is set to TRUE.
1470: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1471: FND_MSG_PUB.initialize;
1472: END IF;
1473: -- Initialize API return status to success
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475:

Line 1481: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

1477:
1478: usage_check(p_rate_schedule_id,
1479: x_usage_code => l_usage_code);
1480: IF (l_usage_code = 'USED') THEN
1481: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1482: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1483: fnd_msg_pub.ADD;
1484: END IF;
1485: RAISE fnd_api.g_exc_error;

Line 1483: fnd_msg_pub.ADD;

1479: x_usage_code => l_usage_code);
1480: IF (l_usage_code = 'USED') THEN
1481: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1482: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1483: fnd_msg_pub.ADD;
1484: END IF;
1485: RAISE fnd_api.g_exc_error;
1486: END IF;
1487:

Line 1493: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

1489: select count(*) into l_count from cn_rate_sch_dims
1490: where rate_schedule_id = p_rate_schedule_id
1491: and rate_dimension_id = p_rate_dimension_id;
1492: if l_count > 0 then
1493: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1494: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
1495: fnd_msg_pub.ADD;
1496: END IF;
1497: RAISE fnd_api.g_exc_error;

Line 1495: fnd_msg_pub.ADD;

1491: and rate_dimension_id = p_rate_dimension_id;
1492: if l_count > 0 then
1493: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1494: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
1495: fnd_msg_pub.ADD;
1496: END IF;
1497: RAISE fnd_api.g_exc_error;
1498: END IF;
1499:

Line 1590: FND_MSG_PUB.Count_And_Get

1586: IF FND_API.To_Boolean( p_commit ) THEN
1587: COMMIT WORK;
1588: END IF;
1589: -- Standard call to get message count and if count is 1, get message info.
1590: FND_MSG_PUB.Count_And_Get
1591: (p_count => x_msg_count ,
1592: p_data => x_msg_data ,
1593: p_encoded => FND_API.G_FALSE );
1594: EXCEPTION

Line 1598: FND_MSG_PUB.count_and_get

1594: EXCEPTION
1595: WHEN FND_API.G_EXC_ERROR THEN
1596: ROLLBACK TO Create_Dimension_Assign;
1597: x_return_status := FND_API.G_RET_STS_ERROR ;
1598: FND_MSG_PUB.count_and_get
1599: (p_count => x_msg_count ,
1600: p_data => x_msg_data ,
1601: p_encoded => FND_API.G_FALSE );
1602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1605: FND_MSG_PUB.count_and_get

1601: p_encoded => FND_API.G_FALSE );
1602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1603: ROLLBACK TO Create_Dimension_Assign;
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1605: FND_MSG_PUB.count_and_get
1606: (p_count => x_msg_count ,
1607: p_data => x_msg_data ,
1608: p_encoded => FND_API.G_FALSE );
1609: WHEN OTHERS THEN

Line 1612: IF FND_MSG_PUB.check_msg_level

1608: p_encoded => FND_API.G_FALSE );
1609: WHEN OTHERS THEN
1610: ROLLBACK TO Create_Dimension_Assign;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: IF FND_MSG_PUB.check_msg_level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: FND_MSG_PUB.add_exc_msg
1616: (G_PKG_NAME ,

Line 1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1609: WHEN OTHERS THEN
1610: ROLLBACK TO Create_Dimension_Assign;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: IF FND_MSG_PUB.check_msg_level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: FND_MSG_PUB.add_exc_msg
1616: (G_PKG_NAME ,
1617: l_api_name );

Line 1615: FND_MSG_PUB.add_exc_msg

1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612: IF FND_MSG_PUB.check_msg_level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: FND_MSG_PUB.add_exc_msg
1616: (G_PKG_NAME ,
1617: l_api_name );
1618: END IF;
1619: FND_MSG_PUB.count_and_get

Line 1619: FND_MSG_PUB.count_and_get

1615: FND_MSG_PUB.add_exc_msg
1616: (G_PKG_NAME ,
1617: l_api_name );
1618: END IF;
1619: FND_MSG_PUB.count_and_get
1620: (p_count => x_msg_count ,
1621: p_data => x_msg_data ,
1622: p_encoded => FND_API.G_FALSE );
1623: END Create_Dimension_Assign;

Line 1887: FND_MSG_PUB.initialize;

1883:
1884: BEGIN
1885:
1886: SAVEPOINT Update_rate;
1887: FND_MSG_PUB.initialize;
1888:
1889: OPEN rate_tier_info;
1890: FETCH rate_tier_info INTO l_rate_tier_id, l_commission_amount;
1891: IF (rate_tier_info%notfound) THEN

Line 1958: FND_MSG_PUB.count_and_get

1954: EXCEPTION
1955: WHEN FND_API.G_EXC_ERROR THEN
1956: ROLLBACK TO Update_rate;
1957: x_return_status := FND_API.G_RET_STS_ERROR ;
1958: FND_MSG_PUB.count_and_get
1959: (p_count => x_msg_count ,
1960: p_data => x_msg_data ,
1961: p_encoded => FND_API.G_FALSE );
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1965: FND_MSG_PUB.count_and_get

1961: p_encoded => FND_API.G_FALSE );
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963: ROLLBACK TO Update_rate;
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1965: FND_MSG_PUB.count_and_get
1966: (p_count => x_msg_count ,
1967: p_data => x_msg_data ,
1968: p_encoded => FND_API.G_FALSE );
1969: WHEN OTHERS THEN

Line 1972: IF FND_MSG_PUB.check_msg_level

1968: p_encoded => FND_API.G_FALSE );
1969: WHEN OTHERS THEN
1970: ROLLBACK TO Update_rate;
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1972: IF FND_MSG_PUB.check_msg_level
1973: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1974: THEN
1975: FND_MSG_PUB.add_exc_msg
1976: (G_PKG_NAME ,

Line 1973: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1969: WHEN OTHERS THEN
1970: ROLLBACK TO Update_rate;
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1972: IF FND_MSG_PUB.check_msg_level
1973: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1974: THEN
1975: FND_MSG_PUB.add_exc_msg
1976: (G_PKG_NAME ,
1977: l_api_name );

Line 1975: FND_MSG_PUB.add_exc_msg

1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1972: IF FND_MSG_PUB.check_msg_level
1973: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1974: THEN
1975: FND_MSG_PUB.add_exc_msg
1976: (G_PKG_NAME ,
1977: l_api_name );
1978: END IF;
1979: FND_MSG_PUB.count_and_get

Line 1979: FND_MSG_PUB.count_and_get

1975: FND_MSG_PUB.add_exc_msg
1976: (G_PKG_NAME ,
1977: l_api_name );
1978: END IF;
1979: FND_MSG_PUB.count_and_get
1980: (p_count => x_msg_count ,
1981: p_data => x_msg_data ,
1982: p_encoded => FND_API.G_FALSE );
1983:

Line 2033: FND_MSG_PUB.initialize;

2029:
2030: BEGIN
2031: -- this should only be called if rates are customized
2032: SAVEPOINT update_srp_rate;
2033: FND_MSG_PUB.initialize;
2034:
2035: x_return_status := fnd_api.g_ret_sts_success;
2036: x_loading_status := 'CN_INSERTED';
2037:

Line 2127: fnd_msg_pub.add;

2123: close rate_tier_info;
2124:
2125: if (l_object_version_number <> p_object_version_number) then
2126: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2127: fnd_msg_pub.add;
2128: x_loading_status := 'CN_RECORD_CHANGED';
2129: raise fnd_api.g_exc_error;
2130: end if;
2131:

Line 2172: FND_MSG_PUB.count_and_get

2168: EXCEPTION
2169: WHEN FND_API.G_EXC_ERROR THEN
2170: ROLLBACK TO update_srp_rate;
2171: x_return_status := FND_API.G_RET_STS_ERROR ;
2172: FND_MSG_PUB.count_and_get
2173: (p_count => x_msg_count ,
2174: p_data => x_msg_data ,
2175: p_encoded => FND_API.G_FALSE );
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2179: FND_MSG_PUB.count_and_get

2175: p_encoded => FND_API.G_FALSE );
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: ROLLBACK TO update_srp_rate;
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2179: FND_MSG_PUB.count_and_get
2180: (p_count => x_msg_count ,
2181: p_data => x_msg_data ,
2182: p_encoded => FND_API.G_FALSE );
2183: WHEN OTHERS THEN

Line 2186: IF FND_MSG_PUB.check_msg_level

2182: p_encoded => FND_API.G_FALSE );
2183: WHEN OTHERS THEN
2184: ROLLBACK TO update_srp_rate;
2185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2186: IF FND_MSG_PUB.check_msg_level
2187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2188: THEN
2189: FND_MSG_PUB.add_exc_msg
2190: (G_PKG_NAME ,

Line 2187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2183: WHEN OTHERS THEN
2184: ROLLBACK TO update_srp_rate;
2185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2186: IF FND_MSG_PUB.check_msg_level
2187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2188: THEN
2189: FND_MSG_PUB.add_exc_msg
2190: (G_PKG_NAME ,
2191: l_api_name );

Line 2189: FND_MSG_PUB.add_exc_msg

2185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2186: IF FND_MSG_PUB.check_msg_level
2187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2188: THEN
2189: FND_MSG_PUB.add_exc_msg
2190: (G_PKG_NAME ,
2191: l_api_name );
2192: END IF;
2193: FND_MSG_PUB.count_and_get

Line 2193: FND_MSG_PUB.count_and_get

2189: FND_MSG_PUB.add_exc_msg
2190: (G_PKG_NAME ,
2191: l_api_name );
2192: END IF;
2193: FND_MSG_PUB.count_and_get
2194: (p_count => x_msg_count ,
2195: p_data => x_msg_data ,
2196: p_encoded => FND_API.G_FALSE );
2197: