DBA Data[Home] [Help]

APPS.PAY_PPR_SHD dependencies on FND_MESSAGE

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

29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then

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

30: Begin
31: --
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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

31: --
32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');

Line 36: fnd_message.raise_error;

32: If (p_constraint_name = 'PAY_SPR_PROCESSING_RULE_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;

Line 38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');

35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);

Line 40: fnd_message.raise_error;

36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_FK2') Then
38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');

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

38: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then

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

39: fnd_message.set_token('COLUMN_NAME', 'ASSIGNMENT_STATUS_TYPE_ID');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);

Line 45: fnd_message.raise_error;

41: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');

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

43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else

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

44: fnd_message.set_token('STEP','15');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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

45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);

Line 50: fnd_message.raise_error;

46: ElsIf (p_constraint_name = 'PAY_STATUS_PROCESSING_RULE_UK2') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','20');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

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

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

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

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

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

Line 55: fnd_message.raise_error;

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

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

121: Close C_Sel1;
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
126: fnd_message.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number

Line 126: fnd_message.raise_error;

122: --
123: -- The primary key is invalid therefore we must error
124: --
125: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
126: fnd_message.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> pay_ppr_shd.g_old_rec.object_version_number) Then

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

127: End If;
128: Close C_Sel1;
129: If (p_object_version_number
130: <> pay_ppr_shd.g_old_rec.object_version_number) Then
131: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
132: fnd_message.raise_error;
133: End If;
134: l_fct_ret := true;
135: End If;

Line 132: fnd_message.raise_error;

128: Close C_Sel1;
129: If (p_object_version_number
130: <> pay_ppr_shd.g_old_rec.object_version_number) Then
131: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
132: fnd_message.raise_error;
133: End If;
134: l_fct_ret := true;
135: End If;
136: End If;

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

342: Close C_Sel1;
343: --
344: -- The primary key is invalid therefore we must error
345: --
346: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
347: fnd_message.raise_error;
348: End If;
349: Close C_Sel1;
350: If (p_object_version_number

Line 347: fnd_message.raise_error;

343: --
344: -- The primary key is invalid therefore we must error
345: --
346: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
347: fnd_message.raise_error;
348: End If;
349: Close C_Sel1;
350: If (p_object_version_number
351: <> pay_ppr_shd.g_old_rec.object_version_number) Then

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

348: End If;
349: Close C_Sel1;
350: If (p_object_version_number
351: <> pay_ppr_shd.g_old_rec.object_version_number) Then
352: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
353: fnd_message.raise_error;
354: End If;
355: --
356: -- Providing we are doing an update and a comment_id exists then

Line 353: fnd_message.raise_error;

349: Close C_Sel1;
350: If (p_object_version_number
351: <> pay_ppr_shd.g_old_rec.object_version_number) Then
352: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
353: fnd_message.raise_error;
354: End If;
355: --
356: -- Providing we are doing an update and a comment_id exists then
357: -- we select the comment text.

Line 372: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');

368: -- The comments for the specified comment_id does not exist.
369: -- We must error due to data integrity problems.
370: --
371: Close C_Sel3;
372: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
373: fnd_message.raise_error;
374: End If;
375: Close C_Sel3;
376: End If;

Line 373: fnd_message.raise_error;

369: -- We must error due to data integrity problems.
370: --
371: Close C_Sel3;
372: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
373: fnd_message.raise_error;
374: End If;
375: Close C_Sel3;
376: End If;
377: --

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

394: -- We are doing a datetrack 'INSERT' which is illegal within this
395: -- procedure therefore we must error (note: to lck on insert the
396: -- private procedure ins_lck should be called).
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;

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

395: -- procedure therefore we must error (note: to lck on insert the
396: -- private procedure ins_lck should be called).
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
403: --

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

396: -- private procedure ins_lck should be called).
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
403: --
404: -- Set the validation start and end date OUT arguments

Line 401: fnd_message.raise_error;

397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','20');
401: fnd_message.raise_error;
402: End If;
403: --
404: -- Set the validation start and end date OUT arguments
405: --

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

415: --
416: -- The object is locked therefore we need to supply a meaningful
417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --

Line 420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');

416: -- The object is locked therefore we need to supply a meaningful
417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --
424: -- ----------------------------------------------------------------------------

Line 421: fnd_message.raise_error;

417: -- error message.
418: --
419: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
420: fnd_message.set_token('TABLE_NAME', 'pay_status_processing_rules_f');
421: fnd_message.raise_error;
422: End lck;
423: --
424: -- ----------------------------------------------------------------------------
425: -- |-----------------------------< convert_args >-----------------------------|