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

Line 82: fnd_msg_pub.initialize;

78:
79: -- Initialize Message List
80: IF fnd_api.to_boolean (p_init_msg_list)
81: THEN
82: fnd_msg_pub.initialize;
83: END IF;
84:
85: -- Standard Call to check api compatibility
86: IF NOT fnd_api.compatible_api_call (

Line 94: fnd_msg_pub.add;

90: G_PKG_NAME
91: )
92: THEN
93: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
94: fnd_msg_pub.add;
95: END IF;
96:
97: -- Initialize api return status
98: x_return_status := fnd_api.g_ret_sts_success;

Line 104: fnd_msg_pub.add;

100: -- Check if the version number passed is 2.0 else error out
101: IF p_api_version_number <> 2.0
102: THEN
103: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
104: fnd_msg_pub.add;
105: END IF;
106:
107:
108: -- API Body

Line 117: fnd_msg_pub.add;

113: OR p_status_rec.enabled_flag = FND_API.G_MISS_CHAR
114: OR TRIM(p_status_rec.enabled_flag) IS NULL)
115: THEN
116: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');
117: fnd_msg_pub.add;
118: END IF;
119: IF (p_status_rec.lead_flag NOT IN ('Y','N')
120: OR p_status_rec.lead_flag = FND_API.G_MISS_CHAR
121: OR TRIM(p_status_rec.lead_flag) IS NULL)

Line 124: fnd_msg_pub.add;

120: OR p_status_rec.lead_flag = FND_API.G_MISS_CHAR
121: OR TRIM(p_status_rec.lead_flag) IS NULL)
122: THEN
123: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');
124: fnd_msg_pub.add;
125: END IF;
126: IF (p_status_rec.opp_flag NOT IN ('Y','N')
127: OR p_status_rec.opp_flag = FND_API.G_MISS_CHAR
128: OR TRIM(p_status_rec.opp_flag) IS NULL)

Line 131: fnd_msg_pub.add;

127: OR p_status_rec.opp_flag = FND_API.G_MISS_CHAR
128: OR TRIM(p_status_rec.opp_flag) IS NULL)
129: THEN
130: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');
131: fnd_msg_pub.add;
132: END IF;
133: IF (p_status_rec.opp_open_status_flag NOT IN ('Y','N')
134: OR TRIM(p_status_rec.opp_open_status_flag) = FND_API.G_MISS_CHAR
135: OR TRIM(p_status_rec.opp_open_status_flag) IS NULL)

Line 138: fnd_msg_pub.add;

134: OR TRIM(p_status_rec.opp_open_status_flag) = FND_API.G_MISS_CHAR
135: OR TRIM(p_status_rec.opp_open_status_flag) IS NULL)
136: THEN
137: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');
138: fnd_msg_pub.add;
139: END IF;
140: IF (p_status_rec.opp_decision_date_flag NOT IN ('Y','N')
141: OR p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR
142: OR TRIM(p_status_rec.opp_decision_date_flag) IS NULL)

Line 145: fnd_msg_pub.add;

141: OR p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR
142: OR TRIM(p_status_rec.opp_decision_date_flag) IS NULL)
143: THEN
144: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');
145: fnd_msg_pub.add;
146: END IF;
147: IF (p_status_rec.forecast_rollup_flag NOT IN ('Y','N')
148: OR p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR
149: OR TRIM(p_status_rec.forecast_rollup_flag) IS NULL)

Line 152: fnd_msg_pub.add;

148: OR p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR
149: OR TRIM(p_status_rec.forecast_rollup_flag) IS NULL)
150: THEN
151: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');
152: fnd_msg_pub.add;
153: END IF;
154:
155: IF (p_status_rec.win_loss_indicator NOT IN ('W','L')
156: OR p_status_rec.win_loss_indicator= FND_API.G_MISS_CHAR

Line 160: fnd_msg_pub.add;

156: OR p_status_rec.win_loss_indicator= FND_API.G_MISS_CHAR
157: OR TRIM(p_status_rec.win_loss_indicator) IS NULL)
158: THEN
159: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
160: fnd_msg_pub.add;
161: END IF;
162:
163: -- Check if the required field Meaning is passed
164: IF (p_status_rec.meaning = FND_API.G_MISS_CHAR

Line 168: fnd_msg_pub.add;

164: IF (p_status_rec.meaning = FND_API.G_MISS_CHAR
165: OR TRIM(p_status_rec.meaning) IS NULL)
166: THEN
167: fnd_message.set_name('AS', 'AS_MEANING');
168: fnd_msg_pub.add;
169: END IF;
170:
171: -- End Validation Section
172:

Line 182: fnd_msg_pub.add;

178: IF (status_dup_cur%FOUND)
179: THEN
180: fnd_message.set_name('AS', 'AS_DUPLICATE_STATUS_CODE');
181: fnd_message.set_token('STATUS_CODE', p_status_rec.status_code);
182: fnd_msg_pub.add;
183: CLOSE status_dup_cur;
184: END IF;
185: CLOSE status_dup_cur;
186:

Line 352: fnd_msg_pub.add;

348: OR (p_status_rec.opp_open_status_flag = 'N' AND
349: p_status_rec.win_loss_indicator IN ('W','L')))
350: THEN
351: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');
352: fnd_msg_pub.add;
353: END IF;
354:
355: IF (FND_MSG_PUB.COUNT_MSG > 0)
356: THEN

Line 355: IF (FND_MSG_PUB.COUNT_MSG > 0)

351: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');
352: fnd_msg_pub.add;
353: END IF;
354:
355: IF (FND_MSG_PUB.COUNT_MSG > 0)
356: THEN
357: fnd_message.set_name('AS', 'AS_STATUS_INSERT_FAILED');
358: fnd_msg_pub.add;
359: RAISE fnd_api.g_exc_error;

Line 358: fnd_msg_pub.add;

354:
355: IF (FND_MSG_PUB.COUNT_MSG > 0)
356: THEN
357: fnd_message.set_name('AS', 'AS_STATUS_INSERT_FAILED');
358: fnd_msg_pub.add;
359: RAISE fnd_api.g_exc_error;
360: END IF;
361:
362:

Line 409: fnd_msg_pub.count_and_get(

405: COMMIT WORK;
406: END IF;
407:
408: -- Standard call to get message count and if count is 1, get message infor.
409: fnd_msg_pub.count_and_get(
410: p_count => x_msg_count,
411: p_data => x_msg_data
412: );
413:

Line 419: fnd_msg_pub.count_and_get (

415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO create_status;
418: x_return_status := fnd_api.g_ret_sts_error;
419: fnd_msg_pub.count_and_get (
420: p_count => x_msg_count,
421: p_data => x_msg_data
422: );
423: WHEN fnd_api.g_exc_unexpected_error THEN

Line 426: fnd_msg_pub.count_and_get (

422: );
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: ROLLBACK TO create_status;
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: fnd_msg_pub.count_and_get (
427: p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430: WHEN OTHERS THEN

Line 433: fnd_msg_pub.count_and_get (

429: );
430: WHEN OTHERS THEN
431: ROLLBACK TO create_status;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: fnd_msg_pub.count_and_get (
434: p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437: END create_status;

Line 582: fnd_msg_pub.initialize;

578:
579: -- Initialize Message List
580: IF fnd_api.to_boolean (p_init_msg_list)
581: THEN
582: fnd_msg_pub.initialize;
583: END IF;
584:
585: -- Standard Call to check api compatibility
586: IF NOT fnd_api.compatible_api_call (

Line 594: fnd_msg_pub.add;

590: G_PKG_NAME
591: )
592: THEN
593: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
594: fnd_msg_pub.add;
595: END IF;
596:
597: -- Initialize api return status
598: x_return_status := fnd_api.g_ret_sts_success;

Line 604: fnd_msg_pub.add;

600: -- Check if the version number passed is 2.0 else error out
601: IF p_api_version_number <> 2.0
602: THEN
603: fnd_message.set_name('AS', 'AS_INVALID_VERSION');
604: fnd_msg_pub.add;
605: END IF;
606:
607:
608: -- API Body

Line 672: fnd_msg_pub.add;

668: ELSIF v_win_loss_indicator NOT IN ('W','L')
669: AND v_win_loss_indicator IS NOT NULL
670: THEN
671: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
672: fnd_msg_pub.add;
673: ELSE
674: v_win_loss_indicator := p_status_rec.win_loss_indicator;
675: END IF;
676: ELSE

Line 678: fnd_msg_pub.add;

674: v_win_loss_indicator := p_status_rec.win_loss_indicator;
675: END IF;
676: ELSE
677: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');
678: fnd_msg_pub.add;
679: END IF;
680: END IF;
681:
682: IF p_status_rec.enabled_flag = FND_API.G_MISS_CHAR

Line 858: fnd_msg_pub.add;

854:
855: IF TRIM(p_status_rec.win_loss_indicator) NOT IN ('W','L', NULL)
856: THEN
857: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
858: fnd_msg_pub.add;
859: ELSE
860: v_win_loss_indicator:=p_status_rec.win_loss_indicator;
861: END IF;
862: IF v_enabled_flag NOT IN ('Y','N')

Line 865: fnd_msg_pub.add;

861: END IF;
862: IF v_enabled_flag NOT IN ('Y','N')
863: THEN
864: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');
865: fnd_msg_pub.add;
866: END IF;
867: IF v_lead_flag NOT IN ('Y','N')
868: THEN
869: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');

Line 870: fnd_msg_pub.add;

866: END IF;
867: IF v_lead_flag NOT IN ('Y','N')
868: THEN
869: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');
870: fnd_msg_pub.add;
871: END IF;
872: IF v_opp_flag NOT IN ('Y','N')
873: THEN
874: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');

Line 875: fnd_msg_pub.add;

871: END IF;
872: IF v_opp_flag NOT IN ('Y','N')
873: THEN
874: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');
875: fnd_msg_pub.add;
876: END IF;
877: IF v_opp_decision_date_flag NOT IN ('Y','N')
878: THEN
879: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');

Line 880: fnd_msg_pub.add;

876: END IF;
877: IF v_opp_decision_date_flag NOT IN ('Y','N')
878: THEN
879: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');
880: fnd_msg_pub.add;
881: END IF;
882: IF v_forecast_rollup_flag NOT IN ('Y','N')
883: THEN
884: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');

Line 885: fnd_msg_pub.add;

881: END IF;
882: IF v_forecast_rollup_flag NOT IN ('Y','N')
883: THEN
884: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');
885: fnd_msg_pub.add;
886: END IF;
887:
888: -- if opp_open_status_flag is Y and win_loss_indicator IS NULL else
889: -- if opp_open_status_flag is N and win_loss_indicator not in W or L

Line 899: fnd_msg_pub.add;

895: v_win_loss_indicator IN ('W','L')))
896: THEN
897: fnd_message.set_name('AS', 'AS_INVALID_WL_STATUS_COMBO');
898: fnd_message.set_token('WIN_LOSS_IND', p_status_rec.win_loss_indicator);
899: fnd_msg_pub.add;
900: END IF;
901:
902: IF (FND_MSG_PUB.COUNT_MSG > 0)
903: THEN

Line 902: IF (FND_MSG_PUB.COUNT_MSG > 0)

898: fnd_message.set_token('WIN_LOSS_IND', p_status_rec.win_loss_indicator);
899: fnd_msg_pub.add;
900: END IF;
901:
902: IF (FND_MSG_PUB.COUNT_MSG > 0)
903: THEN
904: fnd_message.set_name('AS', 'AS_STATUS_UPDATE_FAILED');
905: fnd_msg_pub.add;
906: RAISE fnd_api.g_exc_error;

Line 905: fnd_msg_pub.add;

901:
902: IF (FND_MSG_PUB.COUNT_MSG > 0)
903: THEN
904: fnd_message.set_name('AS', 'AS_STATUS_UPDATE_FAILED');
905: fnd_msg_pub.add;
906: RAISE fnd_api.g_exc_error;
907: END IF;
908:
909: -- Lock the row for update. Check to see if the fetched value is same still.

Line 924: fnd_msg_pub.add;

920:
921: IF l_last_update_date <> l_current_last_update_date
922: THEN
923: fnd_message.set_name('AS', 'AS_RECORD_UPDATED');
924: fnd_msg_pub.add;
925: RAISE fnd_api.g_exc_error;
926: END IF;
927:
928: AS_STATUSES_PKG.UPDATE_ROW(

Line 974: fnd_msg_pub.count_and_get(

970: CLOSE lock_row_for_update ;
971:
972:
973: -- Standard call to get message count and if count is 1, get message infor.
974: fnd_msg_pub.count_and_get(
975: p_count => x_msg_count,
976: p_data => x_msg_data
977: );
978:

Line 984: fnd_msg_pub.count_and_get (

980: EXCEPTION
981: WHEN fnd_api.g_exc_error THEN
982: ROLLBACK TO update_status;
983: x_return_status := fnd_api.g_ret_sts_error;
984: fnd_msg_pub.count_and_get (
985: p_count => x_msg_count,
986: p_data => x_msg_data
987: );
988: WHEN fnd_api.g_exc_unexpected_error THEN

Line 991: fnd_msg_pub.count_and_get (

987: );
988: WHEN fnd_api.g_exc_unexpected_error THEN
989: ROLLBACK TO update_status;
990: x_return_status := fnd_api.g_ret_sts_unexp_error;
991: fnd_msg_pub.count_and_get (
992: p_count => x_msg_count,
993: p_data => x_msg_data
994: );
995: WHEN OTHERS THEN

Line 998: fnd_msg_pub.count_and_get (

994: );
995: WHEN OTHERS THEN
996: ROLLBACK TO update_status;
997: x_return_status := fnd_api.g_ret_sts_unexp_error;
998: fnd_msg_pub.count_and_get (
999: p_count => x_msg_count,
1000: p_data => x_msg_data
1001: );
1002: