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

Line 38: FND_MESSAGE.set_name(G_APP_NAME, G_NO_CHILDREN_MSG);

34: p_child_name IN VARCHAR2
35: ) IS
36: -- PL/SQL Block
37: BEGIN
38: FND_MESSAGE.set_name(G_APP_NAME, G_NO_CHILDREN_MSG);
39: FND_MESSAGE.set_token('PARENT_TABLE', p_parent_name);
40: FND_MESSAGE.set_token('CHILD_TABLE', p_child_name);
41: END set_msg_no_children;
42: --------------------------------------------------------------------------------

Line 39: FND_MESSAGE.set_token('PARENT_TABLE', p_parent_name);

35: ) IS
36: -- PL/SQL Block
37: BEGIN
38: FND_MESSAGE.set_name(G_APP_NAME, G_NO_CHILDREN_MSG);
39: FND_MESSAGE.set_token('PARENT_TABLE', p_parent_name);
40: FND_MESSAGE.set_token('CHILD_TABLE', p_child_name);
41: END set_msg_no_children;
42: --------------------------------------------------------------------------------
43: -- FUNCTION get_service_name

Line 40: FND_MESSAGE.set_token('CHILD_TABLE', p_child_name);

36: -- PL/SQL Block
37: BEGIN
38: FND_MESSAGE.set_name(G_APP_NAME, G_NO_CHILDREN_MSG);
39: FND_MESSAGE.set_token('PARENT_TABLE', p_parent_name);
40: FND_MESSAGE.set_token('CHILD_TABLE', p_child_name);
41: END set_msg_no_children;
42: --------------------------------------------------------------------------------
43: -- FUNCTION get_service_name
44: --------------------------------------------------------------------------------

Line 85: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_VALUE);

81: l_no_data_found := get_contract_rec%NOTFOUND;
82: CLOSE get_contract_rec;
83:
84: IF (l_no_data_found) THEN
85: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_VALUE);
86: FND_MESSAGE.set_token('COL_NAME', 'CONTRACT_ID');
87: END IF;
88: RETURN (l_contract_rec);
89: END populate_contract_rec;

Line 86: FND_MESSAGE.set_token('COL_NAME', 'CONTRACT_ID');

82: CLOSE get_contract_rec;
83:
84: IF (l_no_data_found) THEN
85: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_VALUE);
86: FND_MESSAGE.set_token('COL_NAME', 'CONTRACT_ID');
87: END IF;
88: RETURN (l_contract_rec);
89: END populate_contract_rec;
90: --------------------------------------------------------------------------------

Line 134: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);

130: BEGIN
131: -- Validate START and END dates of Coverage_Txn_Groups fall within the
132: -- START and END dates of CS_COVERAGES
133: IF (p_cov_txn_grps_rec.coverage_start_date < p_coverages_rec.start_date_active) THEN
134: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
135: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
136: TO_CHAR(p_cov_txn_grps_rec.coverage_start_date, G_DATE_FORMAT));
137: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
138: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));

Line 135: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,

131: -- Validate START and END dates of Coverage_Txn_Groups fall within the
132: -- START and END dates of CS_COVERAGES
133: IF (p_cov_txn_grps_rec.coverage_start_date < p_coverages_rec.start_date_active) THEN
134: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
135: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
136: TO_CHAR(p_cov_txn_grps_rec.coverage_start_date, G_DATE_FORMAT));
137: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
138: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
139: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN,

Line 137: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,

133: IF (p_cov_txn_grps_rec.coverage_start_date < p_coverages_rec.start_date_active) THEN
134: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
135: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
136: TO_CHAR(p_cov_txn_grps_rec.coverage_start_date, G_DATE_FORMAT));
137: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
138: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
139: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN,
140: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
141: RAISE l_return_error_exc;

Line 139: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN,

135: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
136: TO_CHAR(p_cov_txn_grps_rec.coverage_start_date, G_DATE_FORMAT));
137: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
138: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
139: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN,
140: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
141: RAISE l_return_error_exc;
142: ELSIF (p_cov_txn_grps_rec.coverage_end_date > p_coverages_rec.end_date_active) THEN
143: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);

Line 143: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);

139: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN,
140: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
141: RAISE l_return_error_exc;
142: ELSIF (p_cov_txn_grps_rec.coverage_end_date > p_coverages_rec.end_date_active) THEN
143: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
144: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
145: TO_CHAR(p_cov_txn_grps_rec.coverage_end_date, G_DATE_FORMAT));
146: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
147: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));

Line 144: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,

140: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
141: RAISE l_return_error_exc;
142: ELSIF (p_cov_txn_grps_rec.coverage_end_date > p_coverages_rec.end_date_active) THEN
143: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
144: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
145: TO_CHAR(p_cov_txn_grps_rec.coverage_end_date, G_DATE_FORMAT));
146: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
147: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
148: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN, TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));

Line 146: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,

142: ELSIF (p_cov_txn_grps_rec.coverage_end_date > p_coverages_rec.end_date_active) THEN
143: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
144: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
145: TO_CHAR(p_cov_txn_grps_rec.coverage_end_date, G_DATE_FORMAT));
146: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
147: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
148: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN, TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
149: RAISE l_return_error_exc;
150: END IF;

Line 148: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN, TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));

144: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
145: TO_CHAR(p_cov_txn_grps_rec.coverage_end_date, G_DATE_FORMAT));
146: FND_MESSAGE.set_token(G_COV_START_DATE_TOKEN,
147: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
148: FND_MESSAGE.set_token(G_COV_END_DATE_TOKEN, TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
149: RAISE l_return_error_exc;
150: END IF;
151: RETURN(l_return_status);
152: EXCEPTION

Line 259: FND_MESSAGE.set_name(G_APP_NAME, G_INCOMPATIBLE_CONTRACT_LEVELS);

255: l_children_exist := cov_products_children_exist(
256: l_cov_lvls_tbl(l_index));
257: ELSIF ((cov_products_children_exist(l_cov_lvls_tbl(l_index))) <>
258: (l_children_exist)) THEN
259: FND_MESSAGE.set_name(G_APP_NAME, G_INCOMPATIBLE_CONTRACT_LEVELS);
260: FND_MESSAGE.set_token('SERVICE_ID',
261: get_service_name(p_services_rec));
262: l_return_status := FND_API.G_RET_STS_ERROR;
263: RAISE l_return_error_exc;

Line 260: FND_MESSAGE.set_token('SERVICE_ID',

256: l_cov_lvls_tbl(l_index));
257: ELSIF ((cov_products_children_exist(l_cov_lvls_tbl(l_index))) <>
258: (l_children_exist)) THEN
259: FND_MESSAGE.set_name(G_APP_NAME, G_INCOMPATIBLE_CONTRACT_LEVELS);
260: FND_MESSAGE.set_token('SERVICE_ID',
261: get_service_name(p_services_rec));
262: l_return_status := FND_API.G_RET_STS_ERROR;
263: RAISE l_return_error_exc;
264: END IF;

Line 320: FND_MESSAGE.set_name(G_APP_NAME, G_SERVICE_ATTACHED_TO_TEMPLATE);

316: BEGIN
317: i := p_coverages_tbl.FIRST;
318: LOOP
319: IF (p_coverages_tbl(i).TEMPLATE_FLAG = 'Y') THEN
320: FND_MESSAGE.set_name(G_APP_NAME, G_SERVICE_ATTACHED_TO_TEMPLATE);
321: FND_MESSAGE.set_token('SERVICE_ID',get_service_name(p_services_rec));
322: FND_MESSAGE.set_token('TEMPLATE_NAME', p_coverages_tbl(i).name);
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: RAISE l_return_error_exc;

Line 321: FND_MESSAGE.set_token('SERVICE_ID',get_service_name(p_services_rec));

317: i := p_coverages_tbl.FIRST;
318: LOOP
319: IF (p_coverages_tbl(i).TEMPLATE_FLAG = 'Y') THEN
320: FND_MESSAGE.set_name(G_APP_NAME, G_SERVICE_ATTACHED_TO_TEMPLATE);
321: FND_MESSAGE.set_token('SERVICE_ID',get_service_name(p_services_rec));
322: FND_MESSAGE.set_token('TEMPLATE_NAME', p_coverages_tbl(i).name);
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: RAISE l_return_error_exc;
325: END IF;

Line 322: FND_MESSAGE.set_token('TEMPLATE_NAME', p_coverages_tbl(i).name);

318: LOOP
319: IF (p_coverages_tbl(i).TEMPLATE_FLAG = 'Y') THEN
320: FND_MESSAGE.set_name(G_APP_NAME, G_SERVICE_ATTACHED_TO_TEMPLATE);
321: FND_MESSAGE.set_token('SERVICE_ID',get_service_name(p_services_rec));
322: FND_MESSAGE.set_token('TEMPLATE_NAME', p_coverages_tbl(i).name);
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: RAISE l_return_error_exc;
325: END IF;
326: EXIT WHEN (i >= p_coverages_tbl.LAST);

Line 344: FND_MESSAGE.set_name(G_APP_NAME, G_MISMATCH_COV_SERVICE_DATES);

340: -- Validate START and END dates of Coverages fall within the
341: -- START and END dates of CS_CP_SERVICES
342: IF ((p_coverages_rec.start_date_active <> p_services_rec.start_date_active) OR
343: (p_coverages_rec.end_date_active <> p_services_rec.end_date_active)) THEN
344: FND_MESSAGE.set_name(G_APP_NAME, G_MISMATCH_COV_SERVICE_DATES);
345: FND_MESSAGE.set_token(G_COVERAGE_START_DATE_TOKEN,
346: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
347: FND_MESSAGE.set_token(G_COVERAGE_END_DATE_TOKEN,
348: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));

Line 345: FND_MESSAGE.set_token(G_COVERAGE_START_DATE_TOKEN,

341: -- START and END dates of CS_CP_SERVICES
342: IF ((p_coverages_rec.start_date_active <> p_services_rec.start_date_active) OR
343: (p_coverages_rec.end_date_active <> p_services_rec.end_date_active)) THEN
344: FND_MESSAGE.set_name(G_APP_NAME, G_MISMATCH_COV_SERVICE_DATES);
345: FND_MESSAGE.set_token(G_COVERAGE_START_DATE_TOKEN,
346: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
347: FND_MESSAGE.set_token(G_COVERAGE_END_DATE_TOKEN,
348: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
349: FND_MESSAGE.set_token(G_SVC_START_DATE_TOKEN,

Line 347: FND_MESSAGE.set_token(G_COVERAGE_END_DATE_TOKEN,

343: (p_coverages_rec.end_date_active <> p_services_rec.end_date_active)) THEN
344: FND_MESSAGE.set_name(G_APP_NAME, G_MISMATCH_COV_SERVICE_DATES);
345: FND_MESSAGE.set_token(G_COVERAGE_START_DATE_TOKEN,
346: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
347: FND_MESSAGE.set_token(G_COVERAGE_END_DATE_TOKEN,
348: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
349: FND_MESSAGE.set_token(G_SVC_START_DATE_TOKEN,
350: TO_CHAR(p_services_rec.start_date_active, G_DATE_FORMAT));
351: FND_MESSAGE.set_token(G_SVC_END_DATE_TOKEN,

Line 349: FND_MESSAGE.set_token(G_SVC_START_DATE_TOKEN,

345: FND_MESSAGE.set_token(G_COVERAGE_START_DATE_TOKEN,
346: TO_CHAR(p_coverages_rec.start_date_active, G_DATE_FORMAT));
347: FND_MESSAGE.set_token(G_COVERAGE_END_DATE_TOKEN,
348: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
349: FND_MESSAGE.set_token(G_SVC_START_DATE_TOKEN,
350: TO_CHAR(p_services_rec.start_date_active, G_DATE_FORMAT));
351: FND_MESSAGE.set_token(G_SVC_END_DATE_TOKEN,
352: TO_CHAR(p_services_rec.end_date_active, G_DATE_FORMAT));
353: RAISE l_return_error_exc;

Line 351: FND_MESSAGE.set_token(G_SVC_END_DATE_TOKEN,

347: FND_MESSAGE.set_token(G_COVERAGE_END_DATE_TOKEN,
348: TO_CHAR(p_coverages_rec.end_date_active, G_DATE_FORMAT));
349: FND_MESSAGE.set_token(G_SVC_START_DATE_TOKEN,
350: TO_CHAR(p_services_rec.start_date_active, G_DATE_FORMAT));
351: FND_MESSAGE.set_token(G_SVC_END_DATE_TOKEN,
352: TO_CHAR(p_services_rec.end_date_active, G_DATE_FORMAT));
353: RAISE l_return_error_exc;
354: END IF;
355: RETURN (l_return_status);

Line 495: FND_MESSAGE.set_name(G_APP_NAME, G_COVERAGE_OVERLAP);

491: x_return_status => x_return_status,
492: x_msg_count => x_msg_count,
493: x_msg_data => x_msg_data);
494: IF (l_overlap_flag = 'Y') THEN
495: FND_MESSAGE.set_name(G_APP_NAME, G_COVERAGE_OVERLAP);
496: l_return_status := FND_API.G_RET_STS_ERROR;
497: END IF;
498: END LOOP;
499: RETURN(l_return_status);

Line 520: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_START_DATE);

516: BEGIN
517: -- Validate START and END dates of the service fall within the
518: -- START and END dates of CS_CONTRACTS
519: IF (p_services_rec.start_date_active < p_contract_rec.start_date_active) THEN
520: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_START_DATE);
521: RAISE l_return_error_exc;
522: ELSIF (p_services_rec.end_date_active > p_contract_rec.end_date_active) THEN
523: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_END_DATE);
524: RAISE l_return_error_exc;

Line 523: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_END_DATE);

519: IF (p_services_rec.start_date_active < p_contract_rec.start_date_active) THEN
520: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_START_DATE);
521: RAISE l_return_error_exc;
522: ELSIF (p_services_rec.end_date_active > p_contract_rec.end_date_active) THEN
523: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_SERVICE_END_DATE);
524: RAISE l_return_error_exc;
525: END IF;
526: RETURN(l_return_status);
527: EXCEPTION

Line 529: FND_MESSAGE.set_token('SERVICE_NAME', get_service_name(p_services_rec));

525: END IF;
526: RETURN(l_return_status);
527: EXCEPTION
528: WHEN l_return_error_exc THEN
529: FND_MESSAGE.set_token('SERVICE_NAME', get_service_name(p_services_rec));
530: l_return_status := FND_API.G_RET_STS_ERROR;
531: RETURN(l_return_status);
532: END val_start_end_dates;
533: BEGIN

Line 631: FND_MESSAGE.set_name(G_APP_NAME, G_VALIDATION_SUCCESSFUL);

627:
628: -- Return Success
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630:
631: FND_MESSAGE.set_name(G_APP_NAME, G_VALIDATION_SUCCESSFUL);
632: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_contract_rec.contract_number);
633:
634: -- COMMENTED OUT 10/23/98 JSU
635: -- TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 632: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_contract_rec.contract_number);

628: -- Return Success
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630:
631: FND_MESSAGE.set_name(G_APP_NAME, G_VALIDATION_SUCCESSFUL);
632: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_contract_rec.contract_number);
633:
634: -- COMMENTED OUT 10/23/98 JSU
635: -- TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
636: x_msg_count := 1;

Line 637: x_msg_data := FND_MESSAGE.GET;

633:
634: -- COMMENTED OUT 10/23/98 JSU
635: -- TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
636: x_msg_count := 1;
637: x_msg_data := FND_MESSAGE.GET;
638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN
640: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
641: (

Line 667: x_msg_data := FND_MESSAGE.GET;

663: -- TAPI_DEV_KIT.HANDLE_EXCEPTIONS because the first thing it does is
664: -- rollback all transactions.
665: x_return_status := TAPI_DEV_KIT.G_RET_STS_WARNING;
666: x_msg_count := 1;
667: x_msg_data := FND_MESSAGE.GET;
668:
669: -- COMMENTED OUT 17-SEP-98 JSU: Forms cannot handle this style
670: -- of messaging
671: -- WHEN OTHERS THEN