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.ECX_DOCUMENT_STANDARDS_API dependencies on STANDARD

Line 1: PACKAGE BODY ECX_DOCUMENT_STANDARDS_API AS

1: PACKAGE BODY ECX_DOCUMENT_STANDARDS_API AS
2: -- $Header: ECXSTDAB.pls 120.2 2005/06/30 11:17:57 appldev ship $
3:
4: /**
5: This Retrieve_XML_Standard API is used to retrieve an existing XML standard definition from the ECX_Standards table.

Line 5: This Retrieve_XML_Standard API is used to retrieve an existing XML standard definition from the ECX_Standards table.

1: PACKAGE BODY ECX_DOCUMENT_STANDARDS_API AS
2: -- $Header: ECXSTDAB.pls 120.2 2005/06/30 11:17:57 appldev ship $
3:
4: /**
5: This Retrieve_XML_Standard API is used to retrieve an existing XML standard definition from the ECX_Standards table.
6: **/
7: procedure retrieve_standard
8: (
9: x_return_status Out nocopy pls_integer,

Line 7: procedure retrieve_standard

3:
4: /**
5: This Retrieve_XML_Standard API is used to retrieve an existing XML standard definition from the ECX_Standards table.
6: **/
7: procedure retrieve_standard
8: (
9: x_return_status Out nocopy pls_integer,
10: x_msg Out nocopy Varchar2,
11: x_standard_id Out nocopy pls_integer,

Line 11: x_standard_id Out nocopy pls_integer,

7: procedure retrieve_standard
8: (
9: x_return_status Out nocopy pls_integer,
10: x_msg Out nocopy Varchar2,
11: x_standard_id Out nocopy pls_integer,
12: p_standard_code In Varchar2,
13: x_standard_type In Out nocopy Varchar2,
14: x_standard_desc Out nocopy Varchar2,
15: x_data_seeded Out nocopy Varchar2

Line 12: p_standard_code In Varchar2,

8: (
9: x_return_status Out nocopy pls_integer,
10: x_msg Out nocopy Varchar2,
11: x_standard_id Out nocopy pls_integer,
12: p_standard_code In Varchar2,
13: x_standard_type In Out nocopy Varchar2,
14: x_standard_desc Out nocopy Varchar2,
15: x_data_seeded Out nocopy Varchar2
16: )

Line 13: x_standard_type In Out nocopy Varchar2,

9: x_return_status Out nocopy pls_integer,
10: x_msg Out nocopy Varchar2,
11: x_standard_id Out nocopy pls_integer,
12: p_standard_code In Varchar2,
13: x_standard_type In Out nocopy Varchar2,
14: x_standard_desc Out nocopy Varchar2,
15: x_data_seeded Out nocopy Varchar2
16: )
17: is

Line 14: x_standard_desc Out nocopy Varchar2,

10: x_msg Out nocopy Varchar2,
11: x_standard_id Out nocopy pls_integer,
12: p_standard_code In Varchar2,
13: x_standard_type In Out nocopy Varchar2,
14: x_standard_desc Out nocopy Varchar2,
15: x_data_seeded Out nocopy Varchar2
16: )
17: is
18: x_last_update_date date;

Line 22: l_standard_type varchar2(80);

18: x_last_update_date date;
19: x_last_updated_by pls_integer;
20: x_created_by pls_integer;
21: x_creation_date date;
22: l_standard_type varchar2(80);
23: begin
24: x_return_status := ECX_UTIL_API.G_NO_ERROR;
25: x_msg := null;
26: l_standard_type := x_standard_type;

Line 26: l_standard_type := x_standard_type;

22: l_standard_type varchar2(80);
23: begin
24: x_return_status := ECX_UTIL_API.G_NO_ERROR;
25: x_msg := null;
26: l_standard_type := x_standard_type;
27:
28: -- make sure p_standard_code is not null.
29: If (p_standard_code is null)
30: then

Line 28: -- make sure p_standard_code is not null.

24: x_return_status := ECX_UTIL_API.G_NO_ERROR;
25: x_msg := null;
26: l_standard_type := x_standard_type;
27:
28: -- make sure p_standard_code is not null.
29: If (p_standard_code is null)
30: then
31: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');

Line 29: If (p_standard_code is null)

25: x_msg := null;
26: l_standard_type := x_standard_type;
27:
28: -- make sure p_standard_code is not null.
29: If (p_standard_code is null)
30: then
31: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
33: return;

Line 32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');

28: -- make sure p_standard_code is not null.
29: If (p_standard_code is null)
30: then
31: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
33: return;
34: elsif (l_standard_type is null)
35: then
36: l_standard_type := 'XML';

Line 34: elsif (l_standard_type is null)

30: then
31: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
33: return;
34: elsif (l_standard_type is null)
35: then
36: l_standard_type := 'XML';
37: end if;
38:

Line 36: l_standard_type := 'XML';

32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
33: return;
34: elsif (l_standard_type is null)
35: then
36: l_standard_type := 'XML';
37: end if;
38:
39:
40: select STANDARD_ID,

Line 40: select STANDARD_ID,

36: l_standard_type := 'XML';
37: end if;
38:
39:
40: select STANDARD_ID,
41: STANDARD_TYPE,
42: STANDARD_DESC,
43: DATA_SEEDED,
44: LAST_UPDATE_DATE,

Line 41: STANDARD_TYPE,

37: end if;
38:
39:
40: select STANDARD_ID,
41: STANDARD_TYPE,
42: STANDARD_DESC,
43: DATA_SEEDED,
44: LAST_UPDATE_DATE,
45: LAST_UPDATED_BY,

Line 42: STANDARD_DESC,

38:
39:
40: select STANDARD_ID,
41: STANDARD_TYPE,
42: STANDARD_DESC,
43: DATA_SEEDED,
44: LAST_UPDATE_DATE,
45: LAST_UPDATED_BY,
46: CREATED_BY,

Line 48: into x_standard_id,

44: LAST_UPDATE_DATE,
45: LAST_UPDATED_BY,
46: CREATED_BY,
47: CREATION_DATE
48: into x_standard_id,
49: x_standard_type,
50: x_standard_desc,
51: x_data_seeded,
52: x_last_update_date,

Line 49: x_standard_type,

45: LAST_UPDATED_BY,
46: CREATED_BY,
47: CREATION_DATE
48: into x_standard_id,
49: x_standard_type,
50: x_standard_desc,
51: x_data_seeded,
52: x_last_update_date,
53: x_last_updated_by,

Line 50: x_standard_desc,

46: CREATED_BY,
47: CREATION_DATE
48: into x_standard_id,
49: x_standard_type,
50: x_standard_desc,
51: x_data_seeded,
52: x_last_update_date,
53: x_last_updated_by,
54: x_created_by,

Line 56: from ecx_standards_vl

52: x_last_update_date,
53: x_last_updated_by,
54: x_created_by,
55: x_creation_date
56: from ecx_standards_vl
57: where standard_code = p_standard_code
58: and standard_type = l_standard_type;
59: exception
60: when no_data_found then

Line 57: where standard_code = p_standard_code

53: x_last_updated_by,
54: x_created_by,
55: x_creation_date
56: from ecx_standards_vl
57: where standard_code = p_standard_code
58: and standard_type = l_standard_type;
59: exception
60: when no_data_found then
61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 58: and standard_type = l_standard_type;

54: x_created_by,
55: x_creation_date
56: from ecx_standards_vl
57: where standard_code = p_standard_code
58: and standard_type = l_standard_type;
59: exception
60: when no_data_found then
61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',

Line 62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',

58: and standard_type = l_standard_type;
59: exception
60: when no_data_found then
61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
63: 'p_standard_code',
64: p_standard_code,
65: 'p_standard_type',
66: l_standard_type);

Line 63: 'p_standard_code',

59: exception
60: when no_data_found then
61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
63: 'p_standard_code',
64: p_standard_code,
65: 'p_standard_type',
66: l_standard_type);
67: when too_many_rows then

Line 64: p_standard_code,

60: when no_data_found then
61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
63: 'p_standard_code',
64: p_standard_code,
65: 'p_standard_type',
66: l_standard_type);
67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;

Line 65: 'p_standard_type',

61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
63: 'p_standard_code',
64: p_standard_code,
65: 'p_standard_type',
66: l_standard_type);
67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',

Line 66: l_standard_type);

62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
63: 'p_standard_code',
64: p_standard_code,
65: 'p_standard_type',
66: l_standard_type);
67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',

Line 69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',

65: 'p_standard_type',
66: l_standard_type);
67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',
71: p_standard_code,
72: 'p_standard_type',
73: l_standard_type);

Line 70: 'p_standard_code',

66: l_standard_type);
67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',
71: p_standard_code,
72: 'p_standard_type',
73: l_standard_type);
74:

Line 71: p_standard_code,

67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',
71: p_standard_code,
72: 'p_standard_type',
73: l_standard_type);
74:
75: when others then

Line 72: 'p_standard_type',

68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',
71: p_standard_code,
72: 'p_standard_type',
73: l_standard_type);
74:
75: when others then
76: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

Line 73: l_standard_type);

69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',
71: p_standard_code,
72: 'p_standard_type',
73: l_standard_type);
74:
75: when others then
76: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
77: x_msg := substr(SQLERRM,1,200);

Line 78: end retrieve_standard;

74:
75: when others then
76: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
77: x_msg := substr(SQLERRM,1,200);
78: end retrieve_standard;
79:
80: /**
81: This Create_XML_Standard API is used to create a new XML standard definition in the ECX_Standards table.
82: **/

Line 81: This Create_XML_Standard API is used to create a new XML standard definition in the ECX_Standards table.

77: x_msg := substr(SQLERRM,1,200);
78: end retrieve_standard;
79:
80: /**
81: This Create_XML_Standard API is used to create a new XML standard definition in the ECX_Standards table.
82: **/
83: procedure create_standard
84: (
85: x_return_status Out nocopy pls_integer,

Line 83: procedure create_standard

79:
80: /**
81: This Create_XML_Standard API is used to create a new XML standard definition in the ECX_Standards table.
82: **/
83: procedure create_standard
84: (
85: x_return_status Out nocopy pls_integer,
86: x_msg Out nocopy Varchar2,
87: x_standard_id Out nocopy pls_integer,

Line 87: x_standard_id Out nocopy pls_integer,

83: procedure create_standard
84: (
85: x_return_status Out nocopy pls_integer,
86: x_msg Out nocopy Varchar2,
87: x_standard_id Out nocopy pls_integer,
88: p_standard_code In Varchar2,
89: p_standard_type In Varchar2,
90: p_standard_desc In Varchar2,
91: p_data_seeded In Varchar2,

Line 88: p_standard_code In Varchar2,

84: (
85: x_return_status Out nocopy pls_integer,
86: x_msg Out nocopy Varchar2,
87: x_standard_id Out nocopy pls_integer,
88: p_standard_code In Varchar2,
89: p_standard_type In Varchar2,
90: p_standard_desc In Varchar2,
91: p_data_seeded In Varchar2,
92: p_owner In varchar2

Line 89: p_standard_type In Varchar2,

85: x_return_status Out nocopy pls_integer,
86: x_msg Out nocopy Varchar2,
87: x_standard_id Out nocopy pls_integer,
88: p_standard_code In Varchar2,
89: p_standard_type In Varchar2,
90: p_standard_desc In Varchar2,
91: p_data_seeded In Varchar2,
92: p_owner In varchar2
93: )

Line 90: p_standard_desc In Varchar2,

86: x_msg Out nocopy Varchar2,
87: x_standard_id Out nocopy pls_integer,
88: p_standard_code In Varchar2,
89: p_standard_type In Varchar2,
90: p_standard_desc In Varchar2,
91: p_data_seeded In Varchar2,
92: p_owner In varchar2
93: )
94: is

Line 97: l_standard_type varchar2(80);

93: )
94: is
95: i_last_updated_by pls_integer;
96: i_rowid varchar2(2000);
97: l_standard_type varchar2(80);
98: begin
99:
100: x_return_status := ECX_UTIL_API.G_NO_ERROR;
101: x_standard_id :=-1;

Line 101: x_standard_id :=-1;

97: l_standard_type varchar2(80);
98: begin
99:
100: x_return_status := ECX_UTIL_API.G_NO_ERROR;
101: x_standard_id :=-1;
102: x_msg := null;
103: l_standard_type := p_standard_type;
104:
105: -- make sure p_standard_code is not null.

Line 103: l_standard_type := p_standard_type;

99:
100: x_return_status := ECX_UTIL_API.G_NO_ERROR;
101: x_standard_id :=-1;
102: x_msg := null;
103: l_standard_type := p_standard_type;
104:
105: -- make sure p_standard_code is not null.
106: If (p_standard_code is null)
107: then

Line 105: -- make sure p_standard_code is not null.

101: x_standard_id :=-1;
102: x_msg := null;
103: l_standard_type := p_standard_type;
104:
105: -- make sure p_standard_code is not null.
106: If (p_standard_code is null)
107: then
108: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');

Line 106: If (p_standard_code is null)

102: x_msg := null;
103: l_standard_type := p_standard_type;
104:
105: -- make sure p_standard_code is not null.
106: If (p_standard_code is null)
107: then
108: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
110: return;

Line 109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');

105: -- make sure p_standard_code is not null.
106: If (p_standard_code is null)
107: then
108: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
110: return;
111: elsIf (l_standard_type is null)
112: then
113: l_standard_type := 'XML';

Line 111: elsIf (l_standard_type is null)

107: then
108: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
110: return;
111: elsIf (l_standard_type is null)
112: then
113: l_standard_type := 'XML';
114: end If;
115:

Line 113: l_standard_type := 'XML';

109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
110: return;
111: elsIf (l_standard_type is null)
112: then
113: l_standard_type := 'XML';
114: end If;
115:
116: -- validate data seeded flag
117: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)

Line 125: select ecx_standards_s.nextval

121: 'p_data_seeded', p_data_seeded);
122: return;
123: end If;
124:
125: select ecx_standards_s.nextval
126: into x_standard_id
127: from dual;
128:
129: if p_owner = 'SEED'

Line 126: into x_standard_id

122: return;
123: end If;
124:
125: select ecx_standards_s.nextval
126: into x_standard_id
127: from dual;
128:
129: if p_owner = 'SEED'
130: then

Line 163: ecx_standards_b , ecx_standards_tl table */

159:
160: end if;
161:
162: /* Call the table handler APIS to insert data into
163: ecx_standards_b , ecx_standards_tl table */
164:
165: ECX_STANDARDS_PKG.INSERT_ROW(
166: X_ROWID => i_rowid,
167: X_STANDARD_ID => x_standard_id,

Line 165: ECX_STANDARDS_PKG.INSERT_ROW(

161:
162: /* Call the table handler APIS to insert data into
163: ecx_standards_b , ecx_standards_tl table */
164:
165: ECX_STANDARDS_PKG.INSERT_ROW(
166: X_ROWID => i_rowid,
167: X_STANDARD_ID => x_standard_id,
168: X_STANDARD_CODE => p_standard_code,
169: X_STANDARD_TYPE => l_standard_type,

Line 167: X_STANDARD_ID => x_standard_id,

163: ecx_standards_b , ecx_standards_tl table */
164:
165: ECX_STANDARDS_PKG.INSERT_ROW(
166: X_ROWID => i_rowid,
167: X_STANDARD_ID => x_standard_id,
168: X_STANDARD_CODE => p_standard_code,
169: X_STANDARD_TYPE => l_standard_type,
170: X_DATA_SEEDED => p_data_seeded,
171: X_STANDARD_DESC => p_standard_desc,

Line 168: X_STANDARD_CODE => p_standard_code,

164:
165: ECX_STANDARDS_PKG.INSERT_ROW(
166: X_ROWID => i_rowid,
167: X_STANDARD_ID => x_standard_id,
168: X_STANDARD_CODE => p_standard_code,
169: X_STANDARD_TYPE => l_standard_type,
170: X_DATA_SEEDED => p_data_seeded,
171: X_STANDARD_DESC => p_standard_desc,
172: X_CREATION_DATE => sysdate,

Line 169: X_STANDARD_TYPE => l_standard_type,

165: ECX_STANDARDS_PKG.INSERT_ROW(
166: X_ROWID => i_rowid,
167: X_STANDARD_ID => x_standard_id,
168: X_STANDARD_CODE => p_standard_code,
169: X_STANDARD_TYPE => l_standard_type,
170: X_DATA_SEEDED => p_data_seeded,
171: X_STANDARD_DESC => p_standard_desc,
172: X_CREATION_DATE => sysdate,
173: X_CREATED_BY => i_last_updated_by,

Line 171: X_STANDARD_DESC => p_standard_desc,

167: X_STANDARD_ID => x_standard_id,
168: X_STANDARD_CODE => p_standard_code,
169: X_STANDARD_TYPE => l_standard_type,
170: X_DATA_SEEDED => p_data_seeded,
171: X_STANDARD_DESC => p_standard_desc,
172: X_CREATION_DATE => sysdate,
173: X_CREATED_BY => i_last_updated_by,
174: X_LAST_UPDATE_DATE => sysdate,
175: X_LAST_UPDATED_BY => i_last_updated_by,

Line 182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',

178:
179: exception
180: when dup_val_on_index then
181: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',
183: 'p_standard_code',
184: p_standard_code,
185: 'p_standard_type',
186: l_standard_type);

Line 183: 'p_standard_code',

179: exception
180: when dup_val_on_index then
181: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',
183: 'p_standard_code',
184: p_standard_code,
185: 'p_standard_type',
186: l_standard_type);
187:

Line 184: p_standard_code,

180: when dup_val_on_index then
181: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',
183: 'p_standard_code',
184: p_standard_code,
185: 'p_standard_type',
186: l_standard_type);
187:
188: when no_data_found then

Line 185: 'p_standard_type',

181: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',
183: 'p_standard_code',
184: p_standard_code,
185: 'p_standard_type',
186: l_standard_type);
187:
188: when no_data_found then
189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 186: l_standard_type);

182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',
183: 'p_standard_code',
184: p_standard_code,
185: 'p_standard_type',
186: l_standard_type);
187:
188: when no_data_found then
189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',

Line 190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',

186: l_standard_type);
187:
188: when no_data_found then
189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
191: 'p_standard_code',
192: p_standard_code,
193: 'p_standard_type',
194: l_standard_type);

Line 191: 'p_standard_code',

187:
188: when no_data_found then
189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
191: 'p_standard_code',
192: p_standard_code,
193: 'p_standard_type',
194: l_standard_type);
195:

Line 192: p_standard_code,

188: when no_data_found then
189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
191: 'p_standard_code',
192: p_standard_code,
193: 'p_standard_type',
194: l_standard_type);
195:
196: when others then

Line 193: 'p_standard_type',

189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
191: 'p_standard_code',
192: p_standard_code,
193: 'p_standard_type',
194: l_standard_type);
195:
196: when others then
197: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

Line 194: l_standard_type);

190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
191: 'p_standard_code',
192: p_standard_code,
193: 'p_standard_type',
194: l_standard_type);
195:
196: when others then
197: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
198: x_msg := substr(SQLERRM,1,200);

Line 200: end create_standard;

196: when others then
197: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
198: x_msg := substr(SQLERRM,1,200);
199:
200: end create_standard;
201:
202: /**
203: Update_Standards API is used to update an existing XML Standard definition in the ECX_Standards table.
204: This API allows users to update the description and data seeded fields by specifying standard id

Line 203: Update_Standards API is used to update an existing XML Standard definition in the ECX_Standards table.

199:
200: end create_standard;
201:
202: /**
203: Update_Standards API is used to update an existing XML Standard definition in the ECX_Standards table.
204: This API allows users to update the description and data seeded fields by specifying standard id
205: **/
206:
207: procedure update_standard

Line 204: This API allows users to update the description and data seeded fields by specifying standard id

200: end create_standard;
201:
202: /**
203: Update_Standards API is used to update an existing XML Standard definition in the ECX_Standards table.
204: This API allows users to update the description and data seeded fields by specifying standard id
205: **/
206:
207: procedure update_standard
208: (

Line 207: procedure update_standard

203: Update_Standards API is used to update an existing XML Standard definition in the ECX_Standards table.
204: This API allows users to update the description and data seeded fields by specifying standard id
205: **/
206:
207: procedure update_standard
208: (
209: x_return_status Out nocopy pls_integer,
210: x_msg Out nocopy Varchar2,
211: p_standard_id In pls_integer,

Line 211: p_standard_id In pls_integer,

207: procedure update_standard
208: (
209: x_return_status Out nocopy pls_integer,
210: x_msg Out nocopy Varchar2,
211: p_standard_id In pls_integer,
212: p_standard_desc In Varchar2,
213: p_data_seeded In Varchar2,
214: p_owner In varchar2
215: )

Line 212: p_standard_desc In Varchar2,

208: (
209: x_return_status Out nocopy pls_integer,
210: x_msg Out nocopy Varchar2,
211: p_standard_id In pls_integer,
212: p_standard_desc In Varchar2,
213: p_data_seeded In Varchar2,
214: p_owner In varchar2
215: )
216: is

Line 224: -- make sure standard_id is not null.

220:
221: x_return_status := ECX_UTIL_API.G_NO_ERROR;
222: x_msg := null;
223:
224: -- make sure standard_id is not null.
225: If (p_standard_id is null)
226: then
227: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
228: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');

Line 225: If (p_standard_id is null)

221: x_return_status := ECX_UTIL_API.G_NO_ERROR;
222: x_msg := null;
223:
224: -- make sure standard_id is not null.
225: If (p_standard_id is null)
226: then
227: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
228: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
229: return;

Line 228: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');

224: -- make sure standard_id is not null.
225: If (p_standard_id is null)
226: then
227: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
228: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
229: return;
230: end if;
231:
232: -- validate data seeded flag

Line 276: update ECX_STANDARDS_B

272: return;
273:
274: end if;
275:
276: update ECX_STANDARDS_B
277: set DATA_SEEDED = p_data_seeded,
278: LAST_UPDATED_BY = i_last_updated_by,
279: LAST_UPDATE_DATE = sysdate
280: where standard_id = p_standard_id;

Line 280: where standard_id = p_standard_id;

276: update ECX_STANDARDS_B
277: set DATA_SEEDED = p_data_seeded,
278: LAST_UPDATED_BY = i_last_updated_by,
279: LAST_UPDATE_DATE = sysdate
280: where standard_id = p_standard_id;
281:
282: if (sql%rowcount = 0)
283: then
284: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 286: 'p_table', 'ECX_STANDARDS_B', 'p_param_name', 'Document Standard ID','p_param_id',p_standard_id);

282: if (sql%rowcount = 0)
283: then
284: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
285: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
286: 'p_table', 'ECX_STANDARDS_B', 'p_param_name', 'Document Standard ID','p_param_id',p_standard_id);
287: return;
288: end if;
289:
290: update ECX_STANDARDS_TL

Line 290: update ECX_STANDARDS_TL

286: 'p_table', 'ECX_STANDARDS_B', 'p_param_name', 'Document Standard ID','p_param_id',p_standard_id);
287: return;
288: end if;
289:
290: update ECX_STANDARDS_TL
291: set STANDARD_DESC = p_standard_desc,
292: LAST_UPDATED_BY = i_last_updated_by,
293: LAST_UPDATE_DATE = sysdate,
294: source_lang = userenv('LANG')

Line 291: set STANDARD_DESC = p_standard_desc,

287: return;
288: end if;
289:
290: update ECX_STANDARDS_TL
291: set STANDARD_DESC = p_standard_desc,
292: LAST_UPDATED_BY = i_last_updated_by,
293: LAST_UPDATE_DATE = sysdate,
294: source_lang = userenv('LANG')
295: where standard_id = p_standard_id and

Line 295: where standard_id = p_standard_id and

291: set STANDARD_DESC = p_standard_desc,
292: LAST_UPDATED_BY = i_last_updated_by,
293: LAST_UPDATE_DATE = sysdate,
294: source_lang = userenv('LANG')
295: where standard_id = p_standard_id and
296: userenv('LANG') in (language, source_lang);
297:
298: if (sql%rowcount = 0)
299: then

Line 303: 'ECX_STANDARDS_TL',

299: then
300: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
301: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
302: 'p_table',
303: 'ECX_STANDARDS_TL',
304: 'p_param_name',
305: 'Document Standard ID',
306: 'p_param_id',
307: p_standard_id);

Line 305: 'Document Standard ID',

301: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
302: 'p_table',
303: 'ECX_STANDARDS_TL',
304: 'p_param_name',
305: 'Document Standard ID',
306: 'p_param_id',
307: p_standard_id);
308: return;
309: end if;

Line 307: p_standard_id);

303: 'ECX_STANDARDS_TL',
304: 'p_param_name',
305: 'Document Standard ID',
306: 'p_param_id',
307: p_standard_id);
308: return;
309: end if;
310:
311:

Line 316: end update_standard;

312: exception
313: when others then
314: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
315: x_msg := substr(SQLERRM,1,200);
316: end update_standard;
317:
318: /**
319: Delete_XML_Standard API is used to delete an existing XML Standard definition in the ECX_STANDARDS
320: table and its attributes. This API allows users to delete the definitions by specifying the standard id.

Line 319: Delete_XML_Standard API is used to delete an existing XML Standard definition in the ECX_STANDARDS

315: x_msg := substr(SQLERRM,1,200);
316: end update_standard;
317:
318: /**
319: Delete_XML_Standard API is used to delete an existing XML Standard definition in the ECX_STANDARDS
320: table and its attributes. This API allows users to delete the definitions by specifying the standard id.
321: **/
322: procedure delete_standard
323: (

Line 320: table and its attributes. This API allows users to delete the definitions by specifying the standard id.

316: end update_standard;
317:
318: /**
319: Delete_XML_Standard API is used to delete an existing XML Standard definition in the ECX_STANDARDS
320: table and its attributes. This API allows users to delete the definitions by specifying the standard id.
321: **/
322: procedure delete_standard
323: (
324: x_return_status Out nocopy pls_integer,

Line 322: procedure delete_standard

318: /**
319: Delete_XML_Standard API is used to delete an existing XML Standard definition in the ECX_STANDARDS
320: table and its attributes. This API allows users to delete the definitions by specifying the standard id.
321: **/
322: procedure delete_standard
323: (
324: x_return_status Out nocopy pls_integer,
325: x_msg Out nocopy Varchar2,
326: p_standard_id In pls_integer

Line 326: p_standard_id In pls_integer

322: procedure delete_standard
323: (
324: x_return_status Out nocopy pls_integer,
325: x_msg Out nocopy Varchar2,
326: p_standard_id In pls_integer
327: )
328: is
329: begin
330:

Line 334: if (p_standard_id is null)

330:
331: x_return_status := ECX_UTIL_API.G_NO_ERROR;
332: x_msg := null;
333:
334: if (p_standard_id is null)
335: then
336: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
337: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
338: return;

Line 337: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');

333:
334: if (p_standard_id is null)
335: then
336: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
337: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
338: return;
339: end if;
340:
341: -- make sure standard is not used in any code conversion or external process.

Line 341: -- make sure standard is not used in any code conversion or external process.

337: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
338: return;
339: end if;
340:
341: -- make sure standard is not used in any code conversion or external process.
342: -- if there is a reference to this standard id, then return G_REFER_ERROR.
343:
344: delete from ecx_standard_attributes
345: where standard_id = p_standard_id;

Line 342: -- if there is a reference to this standard id, then return G_REFER_ERROR.

338: return;
339: end if;
340:
341: -- make sure standard is not used in any code conversion or external process.
342: -- if there is a reference to this standard id, then return G_REFER_ERROR.
343:
344: delete from ecx_standard_attributes
345: where standard_id = p_standard_id;
346:

Line 344: delete from ecx_standard_attributes

340:
341: -- make sure standard is not used in any code conversion or external process.
342: -- if there is a reference to this standard id, then return G_REFER_ERROR.
343:
344: delete from ecx_standard_attributes
345: where standard_id = p_standard_id;
346:
347: /* Call tbale handler DELETE_ROW for the deletion */
348:

Line 345: where standard_id = p_standard_id;

341: -- make sure standard is not used in any code conversion or external process.
342: -- if there is a reference to this standard id, then return G_REFER_ERROR.
343:
344: delete from ecx_standard_attributes
345: where standard_id = p_standard_id;
346:
347: /* Call tbale handler DELETE_ROW for the deletion */
348:
349: ECX_STANDARDS_PKG.DELETE_ROW(x_standard_id => p_standard_id);

Line 349: ECX_STANDARDS_PKG.DELETE_ROW(x_standard_id => p_standard_id);

345: where standard_id = p_standard_id;
346:
347: /* Call tbale handler DELETE_ROW for the deletion */
348:
349: ECX_STANDARDS_PKG.DELETE_ROW(x_standard_id => p_standard_id);
350:
351: exception
352:
353: when no_data_found then

Line 357: 'ECX_STANDARDS',

353: when no_data_found then
354: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
355: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
356: 'p_table',
357: 'ECX_STANDARDS',
358: 'p_param_name',
359: 'Document Standard ID',
360: 'p_param_id',p_standard_id);
361:

Line 359: 'Document Standard ID',

355: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
356: 'p_table',
357: 'ECX_STANDARDS',
358: 'p_param_name',
359: 'Document Standard ID',
360: 'p_param_id',p_standard_id);
361:
362: when others then
363: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

Line 360: 'p_param_id',p_standard_id);

356: 'p_table',
357: 'ECX_STANDARDS',
358: 'p_param_name',
359: 'Document Standard ID',
360: 'p_param_id',p_standard_id);
361:
362: when others then
363: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
364: x_msg := substr(SQLERRM,1,200);

Line 365: end delete_standard;

361:
362: when others then
363: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
364: x_msg := substr(SQLERRM,1,200);
365: end delete_standard;
366:
367: END ECX_DOCUMENT_STANDARDS_API;

Line 367: END ECX_DOCUMENT_STANDARDS_API;

363: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
364: x_msg := substr(SQLERRM,1,200);
365: end delete_standard;
366:
367: END ECX_DOCUMENT_STANDARDS_API;