DBA Data[Home] [Help]

APPS.IEM_DIAG_CREATE_ACCOUNT_PVT dependencies on FND_MESSAGE

Line 58: c_userid := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'), inputs);

54: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
55:
56: FND_MSG_PUB.initialize;
57:
58: c_userid := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'), inputs);
59: c_domain := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'), inputs);
60:
61: select count(*) into l_count from iem_db_servers;
62:

Line 59: c_domain := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'), inputs);

55:
56: FND_MSG_PUB.initialize;
57:
58: c_userid := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'), inputs);
59: c_domain := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'), inputs);
60:
61: select count(*) into l_count from iem_db_servers;
62:
63: if (l_count = 0) then

Line 65: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');

61: select count(*) into l_count from iem_db_servers;
62:
63: if (l_count = 0) then
64: statusStr := 'FAILURE';
65: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');
66: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
67: reportStr := reportStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM5') || '
';
68: isFatal := 'FALSE';
69: elsif (l_count > 1) then

Line 66: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

62:
63: if (l_count = 0) then
64: statusStr := 'FAILURE';
65: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');
66: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
67: reportStr := reportStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM5') || '
';
68: isFatal := 'FALSE';
69: elsif (l_count > 1) then
70: statusStr := 'FAILURE';

Line 67: reportStr := reportStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM5') || '
';

63: if (l_count = 0) then
64: statusStr := 'FAILURE';
65: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');
66: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
67: reportStr := reportStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM5') || '
';
68: isFatal := 'FALSE';
69: elsif (l_count > 1) then
70: statusStr := 'FAILURE';
71: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');

Line 71: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');

67: reportStr := reportStr || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM5') || '
';
68: isFatal := 'FALSE';
69: elsif (l_count > 1) then
70: statusStr := 'FAILURE';
71: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');
72: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM4') || '
';
73: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
74: isFatal := 'FALSE';
75:

Line 72: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM4') || '
';

68: isFatal := 'FALSE';
69: elsif (l_count > 1) then
70: statusStr := 'FAILURE';
71: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');
72: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM4') || '
';
73: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
74: isFatal := 'FALSE';
75:
76: else

Line 73: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

69: elsif (l_count > 1) then
70: statusStr := 'FAILURE';
71: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');
72: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM4') || '
';
73: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
74: isFatal := 'FALSE';
75:
76: else
77:

Line 100: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUCCESS') || '
';

96: l_str:='begin dapls.acct_create'||l_im_link||'(:p_admin_id, :p_admin_pass, :p_oes_database, :p_domain, :p_account_id, :p_account_first, :p_account_last, :p_account_pass, :p_node, :l_ret1);end; ';
97:
98: EXECUTE IMMEDIATE l_str using l_db_server_rec.admin_user, l_db_server_rec.admin_password, l_db_server_rec.sid, c_domain, c_userid, c_userid, c_userid, 'welcome', l_db_server_rec.email_node,IN OUT l_ret1;
99: if l_ret1=0 then
100: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUCCESS') || '
';
101: else
102: statusStr := 'FAILURE';
103: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR') || l_ret1;
104: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'

Line 103: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR') || l_ret1;

99: if l_ret1=0 then
100: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUCCESS') || '
';
101: else
102: statusStr := 'FAILURE';
103: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR') || l_ret1;
104: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'
105: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '

';
106: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
107: isFatal := 'FALSE';

Line 104: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'

100: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUCCESS') || '
';
101: else
102: statusStr := 'FAILURE';
103: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR') || l_ret1;
104: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'
105: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '
';
106: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
107: isFatal := 'FALSE';
108: end if;

Line 105: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '
';

101: else
102: statusStr := 'FAILURE';
103: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR') || l_ret1;
104: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'
105: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '

';
106: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
107: isFatal := 'FALSE';
108: end if;
109:

Line 106: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');

102: statusStr := 'FAILURE';
103: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR') || l_ret1;
104: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'
105: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '

';
106: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
107: isFatal := 'FALSE';
108: end if;
109:
110:

Line 122: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'

118: WHEN OTHERS THEN
119: statusStr := 'FAILURE';
120: isFatal := 'FALSE';
121: errStr := SQLERRM;
122: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'
123: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '
';
124: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
125: reports := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
126: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 123: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '
';

119: statusStr := 'FAILURE';
120: isFatal := 'FALSE';
121: errStr := SQLERRM;
122: reportStr := reportStr || ' ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM1') || '
' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM2') || '
'
123: || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM3') || '
';
124: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
125: reports := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
126: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
127:

Line 133: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT1');

129:
130:
131: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
132: BEGIN
133: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_COMPONENT1');
134: END getComponentName;
135:
136: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
137: BEGIN

Line 138: descStr := '
  • ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_DESC') || '
  • ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_DESC1') || '
';

134: END getComponentName;
135:
136: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
137: BEGIN
138: descStr := '

  • ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_DESC') || '
  • ' || FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_DESC1') || '
';
139: END getTestDesc;
140:
141: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
142: BEGIN

Line 143: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME1');

139: END getTestDesc;
140:
141: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
142: BEGIN
143: name := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TESTCASE_NAME1');
144: END getTestName;
145:
146: FUNCTION getTestMode RETURN INTEGER IS
147: BEGIN

Line 157: JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'),'');

153: tempInput JTF_DIAG_INPUTTBL;
154: BEGIN
155: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
156: tempInput :=
157: JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'),'');
158: tempInput :=
159: JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'),'');
160: defaultInputValues := tempInput;
161: EXCEPTION

Line 159: JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'),'');

155: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
156: tempInput :=
157: JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'),'');
158: tempInput :=
159: JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'),'');
160: defaultInputValues := tempInput;
161: EXCEPTION
162: WHEN OTHERS THEN
163: defaultInputvalues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;