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.OTA_TPM_SHD dependencies on FND_MESSAGE

Line 23: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');

19: Begin
20: --
21: If (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK1') Then
22: If (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan()) THEN
23: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
24: Else
25: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
26: END IF;
27: fnd_message.set_token('PROCEDURE', l_proc);

Line 25: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');

21: If (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK1') Then
22: If (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan()) THEN
23: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
24: Else
25: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
26: END IF;
27: fnd_message.set_token('PROCEDURE', l_proc);
28: fnd_message.set_token('STEP','5');
29: fnd_message.raise_error;

Line 27: fnd_message.set_token('PROCEDURE', l_proc);

23: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
24: Else
25: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
26: END IF;
27: fnd_message.set_token('PROCEDURE', l_proc);
28: fnd_message.set_token('STEP','5');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');

Line 28: fnd_message.set_token('STEP','5');

24: Else
25: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
26: END IF;
27: fnd_message.set_token('PROCEDURE', l_proc);
28: fnd_message.set_token('STEP','5');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
32: fnd_message.set_token('PROCEDURE', l_proc);

Line 29: fnd_message.raise_error;

25: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
26: END IF;
27: fnd_message.set_token('PROCEDURE', l_proc);
28: fnd_message.set_token('STEP','5');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');

Line 31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');

27: fnd_message.set_token('PROCEDURE', l_proc);
28: fnd_message.set_token('STEP','5');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then

Line 32: fnd_message.set_token('PROCEDURE', l_proc);

28: fnd_message.set_token('STEP','5');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');

Line 33: fnd_message.set_token('STEP','10');

29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
37: fnd_message.set_token('PROCEDURE', l_proc);

Line 34: fnd_message.raise_error;

30: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK2') Then
31: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');

Line 36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');

32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then

Line 37: fnd_message.set_token('PROCEDURE', l_proc);

33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 38: fnd_message.set_token('STEP','15');

34: fnd_message.raise_error;
35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);

Line 39: fnd_message.raise_error;

35: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_FK3') Then
36: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');

Line 41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then

Line 42: fnd_message.set_token('PROCEDURE', l_proc);

38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');

Line 43: fnd_message.set_token('STEP','20');

39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
47: fnd_message.set_token('PROCEDURE', l_proc);

Line 44: fnd_message.raise_error;

40: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_PK') Then
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','25');

Line 46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');

42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','25');
49: fnd_message.raise_error;
50: Else

Line 47: fnd_message.set_token('PROCEDURE', l_proc);

43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','25');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 48: fnd_message.set_token('STEP','25');

44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','25');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);

Line 49: fnd_message.raise_error;

45: ElsIf (p_constraint_name = 'OTA_TRAINING_PLAN_MEMBERS_UK2') Then
46: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','25');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','25');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;

Line 52: fnd_message.set_token('PROCEDURE', l_proc);

48: fnd_message.set_token('STEP','25');
49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
56: --

Line 53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

49: fnd_message.raise_error;
50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
56: --
57: End constraint_error;

Line 54: fnd_message.raise_error;

50: Else
51: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
54: fnd_message.raise_error;
55: End If;
56: --
57: End constraint_error;
58: --

Line 155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

151: Close C_Sel1;
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number

Line 156: fnd_message.raise_error;

152: --
153: -- The primary key is invalid therefore we must error
154: --
155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
160: <> ota_tpm_shd.g_old_rec.object_version_number) Then

Line 161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
160: <> ota_tpm_shd.g_old_rec.object_version_number) Then
161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
162: fnd_message.raise_error;
163: End If;
164: l_fct_ret := true;
165: End If;

Line 162: fnd_message.raise_error;

158: Close C_Sel1;
159: If (p_object_version_number
160: <> ota_tpm_shd.g_old_rec.object_version_number) Then
161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
162: fnd_message.raise_error;
163: End If;
164: l_fct_ret := true;
165: End If;
166: End If;

Line 250: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

246: Close C_Sel1;
247: --
248: -- The primary key is invalid therefore we must error
249: --
250: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
251: fnd_message.raise_error;
252: End If;
253: Close C_Sel1;
254: If (p_object_version_number

Line 251: fnd_message.raise_error;

247: --
248: -- The primary key is invalid therefore we must error
249: --
250: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
251: fnd_message.raise_error;
252: End If;
253: Close C_Sel1;
254: If (p_object_version_number
255: <> ota_tpm_shd.g_old_rec.object_version_number) Then

Line 256: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

252: End If;
253: Close C_Sel1;
254: If (p_object_version_number
255: <> ota_tpm_shd.g_old_rec.object_version_number) Then
256: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
257: fnd_message.raise_error;
258: End If;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 257: fnd_message.raise_error;

253: Close C_Sel1;
254: If (p_object_version_number
255: <> ota_tpm_shd.g_old_rec.object_version_number) Then
256: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
257: fnd_message.raise_error;
258: End If;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: --

Line 270: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

266: --
267: -- The object is locked therefore we need to supply a meaningful
268: -- error message.
269: --
270: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
271: fnd_message.set_token('TABLE_NAME', 'ota_training_plan_members');
272: fnd_message.raise_error;
273: End lck;
274: --

Line 271: fnd_message.set_token('TABLE_NAME', 'ota_training_plan_members');

267: -- The object is locked therefore we need to supply a meaningful
268: -- error message.
269: --
270: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
271: fnd_message.set_token('TABLE_NAME', 'ota_training_plan_members');
272: fnd_message.raise_error;
273: End lck;
274: --
275: -- ----------------------------------------------------------------------------

Line 272: fnd_message.raise_error;

268: -- error message.
269: --
270: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
271: fnd_message.set_token('TABLE_NAME', 'ota_training_plan_members');
272: fnd_message.raise_error;
273: End lck;
274: --
275: -- ----------------------------------------------------------------------------
276: -- |-----------------------------< convert_args >-----------------------------|