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

Line 65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors

61:
62: BEGIN
63:
64: x_msg_count := NULL;
65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: --
69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts

Line 116: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

112: xtr_risk_debug_pkg.dpop('xtr_replicate_bank_accounts_P: '||'Replicate_Bank_Accounts');
113: END IF;
114: --
115:
116: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
117: ( p_count => x_msg_count ,
118: p_data => x_msg_data
119: );
120: --

Line 125: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

121: EXCEPTION
122: WHEN others THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
125: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
126: ( p_count => x_msg_count ,
127: p_data => x_msg_data
128: );
129: END REPLICATE_BANK_ACCOUNTS;

Line 228: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

224: EXCEPTION
225: WHEN others THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
228: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
229: ( p_count => x_msg_count ,
230: p_data => x_msg_data
231: );
232: END REPLICATE_BANK_ACCOUNTS;

Line 833: FND_MSG_PUB.Add; -- Adds the error messages to the list.

829: FETCH c_field_name INTO l_field_name;
830: CLOSE c_field_name;
831: FND_MESSAGE.Set_Name('XTR','XTR_MANDATORY_FIELD');
832: FND_MESSAGE.Set_Token('FIELD', l_field_name);
833: FND_MSG_PUB.Add; -- Adds the error messages to the list.
834:
835: ELSIF p_error_code = 'XTR_INV_TRS_PRICING_MODEL' THEN
836:
837: FND_MESSAGE.Set_Name('XTR','XTR_INV_TRS_PRICING_MODEL');

Line 838: FND_MSG_PUB.Add; -- Adds the error messages to the list.

834:
835: ELSIF p_error_code = 'XTR_INV_TRS_PRICING_MODEL' THEN
836:
837: FND_MESSAGE.Set_Name('XTR','XTR_INV_TRS_PRICING_MODEL');
838: FND_MSG_PUB.Add; -- Adds the error messages to the list.
839:
840: ELSIF p_error_code = 'XTR_INV_CC_ID' THEN
841:
842: FND_MESSAGE.Set_Name('XTR','XTR_INV_CC_ID');

Line 843: FND_MSG_PUB.Add; -- Adds the error messages to the list.

839:
840: ELSIF p_error_code = 'XTR_INV_CC_ID' THEN
841:
842: FND_MESSAGE.Set_Name('XTR','XTR_INV_CC_ID');
843: FND_MSG_PUB.Add; -- Adds the error messages to the list.
844:
845: ELSIF p_error_code = 'XTR_UNIQUE_ACCOUNT' THEN -- bug 4870353
846:
847: FND_MESSAGE.Set_Name('XTR','XTR_UNIQUE_ACCOUNT');

Line 848: FND_MSG_PUB.Add;

844:
845: ELSIF p_error_code = 'XTR_UNIQUE_ACCOUNT' THEN -- bug 4870353
846:
847: FND_MESSAGE.Set_Name('XTR','XTR_UNIQUE_ACCOUNT');
848: FND_MSG_PUB.Add;
849:
850: ELSIF p_error_code = 'XTR_UNEXP_ERROR' THEN
851:
852: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');

Line 855: FND_MSG_PUB.Add; -- Adds the error messages to the list.

851:
852: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');
853: FND_MESSAGE.Set_Token('SQLCODE', p_field_name);
854: --FND_MESSAGE.Set_Token('SQLSTATE', p_field_name2);
855: FND_MSG_PUB.Add; -- Adds the error messages to the list.
856:
857: ELSIF p_error_code = 'XTR_INV_LE_COMP_CODE' THEN
858:
859: FND_MESSAGE.Set_Name('XTR','XTR_INV_LE_COMP_CODE');

Line 861: FND_MSG_PUB.Add; -- Adds the error messages to the list.

857: ELSIF p_error_code = 'XTR_INV_LE_COMP_CODE' THEN
858:
859: FND_MESSAGE.Set_Name('XTR','XTR_INV_LE_COMP_CODE');
860: FND_MESSAGE.Set_Token('LEGAL_ENTITY', p_field_name);
861: FND_MSG_PUB.Add; -- Adds the error messages to the list.
862:
863: ELSIF p_error_code = 'CHK_LOCK' THEN
864:
865: FND_MESSAGE.Set_Name('XTR','XTR_1999');

Line 866: FND_MSG_PUB.Add; -- Adds the error messages to the list.

862:
863: ELSIF p_error_code = 'CHK_LOCK' THEN
864:
865: FND_MESSAGE.Set_Name('XTR','XTR_1999');
866: FND_MSG_PUB.Add; -- Adds the error messages to the list.
867:
868: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
869:
870: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAMETER');

Line 872: FND_MSG_PUB.Add; -- Adds the error messages to the list.

868: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
869:
870: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAMETER');
871: FND_MESSAGE.Set_Token('FIELD', p_field_name);
872: FND_MSG_PUB.Add; -- Adds the error messages to the list.
873:
874: ELSIF p_error_code = 'XTR_DEFAULT_ACCT' THEN
875:
876: FND_MESSAGE.Set_Name('XTR','XTR_1676');

Line 877: FND_MSG_PUB.Add; -- Adds the error messages to the list.

873:
874: ELSIF p_error_code = 'XTR_DEFAULT_ACCT' THEN
875:
876: FND_MESSAGE.Set_Name('XTR','XTR_1676');
877: FND_MSG_PUB.Add; -- Adds the error messages to the list.
878:
879: ELSIF p_error_code = 'XTR_CHK_30_BOTH' THEN
880:
881: FND_MESSAGE.Set_Name('XTR','XTR_CHK_30_BOTH');

Line 882: FND_MSG_PUB.Add; -- Adds the error messages to the list.

878:
879: ELSIF p_error_code = 'XTR_CHK_30_BOTH' THEN
880:
881: FND_MESSAGE.Set_Name('XTR','XTR_CHK_30_BOTH');
882: FND_MSG_PUB.Add; -- Adds the error messages to the list.
883:
884: ELSIF p_error_code = 'XTR_INV_BANK_BRANCH' THEN
885:
886: FND_MESSAGE.Set_Name('XTR','XTR_INV_BANK_BRANCH');

Line 888: FND_MSG_PUB.Add; -- Adds the error messages to the list.

884: ELSIF p_error_code = 'XTR_INV_BANK_BRANCH' THEN
885:
886: FND_MESSAGE.Set_Name('XTR','XTR_INV_BANK_BRANCH');
887: FND_MESSAGE.Set_Token('TCA_BANK_BRANCH_NAME', p_field_name);
888: FND_MSG_PUB.Add; -- Adds the error messages to the list.
889:
890: ELSIF p_error_code = 'XTR_ACCT_NAME_MANDATORY' THEN
891:
892: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_NAME_MANDATORY');

Line 893: FND_MSG_PUB.Add; -- Adds the error messages to the list.

889:
890: ELSIF p_error_code = 'XTR_ACCT_NAME_MANDATORY' THEN
891:
892: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_NAME_MANDATORY');
893: FND_MSG_PUB.Add; -- Adds the error messages to the list.
894:
895: ELSIF p_error_code = 'XTR_CURRENCY_MANDATORY' THEN
896:
897: FND_MESSAGE.Set_Name('XTR','XTR_CURRENCY_MANDATORY');

Line 898: FND_MSG_PUB.Add; -- Adds the error messages to the list.

894:
895: ELSIF p_error_code = 'XTR_CURRENCY_MANDATORY' THEN
896:
897: FND_MESSAGE.Set_Name('XTR','XTR_CURRENCY_MANDATORY');
898: FND_MSG_PUB.Add; -- Adds the error messages to the list.
899:
900: ELSIF p_error_code = 'XTR_LOCATION_MANDATORY' THEN
901:
902: FND_MESSAGE.Set_Name('XTR','XTR_LOCATION_MANDATORY');

Line 903: FND_MSG_PUB.Add; -- Adds the error messages to the list.

899:
900: ELSIF p_error_code = 'XTR_LOCATION_MANDATORY' THEN
901:
902: FND_MESSAGE.Set_Name('XTR','XTR_LOCATION_MANDATORY');
903: FND_MSG_PUB.Add; -- Adds the error messages to the list.
904:
905: ELSIF p_error_code = 'XTR_STREET_MANDATORY' THEN
906:
907: FND_MESSAGE.Set_Name('XTR','XTR_STREET_MANDATORY');

Line 908: FND_MSG_PUB.Add; -- Adds the error messages to the list.

904:
905: ELSIF p_error_code = 'XTR_STREET_MANDATORY' THEN
906:
907: FND_MESSAGE.Set_Name('XTR','XTR_STREET_MANDATORY');
908: FND_MSG_PUB.Add; -- Adds the error messages to the list.
909:
910: ELSIF p_error_code = 'XTR_ACCT_OWNER_MANDATORY' THEN
911:
912: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_OWNER_MANDATORY');

Line 913: FND_MSG_PUB.Add; -- Adds the error messages to the list.

909:
910: ELSIF p_error_code = 'XTR_ACCT_OWNER_MANDATORY' THEN
911:
912: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_OWNER_MANDATORY');
913: FND_MSG_PUB.Add; -- Adds the error messages to the list.
914:
915: ELSIF p_error_code = 'XTR_ACCOUNT_MANDATORY_FIELD' THEN
916:
917: FND_MESSAGE.Set_Name('XTR','XTR_ACCOUNT_MANDATORY_FIELD');

Line 918: FND_MSG_PUB.Add; -- Adds the error messages to the list.

914:
915: ELSIF p_error_code = 'XTR_ACCOUNT_MANDATORY_FIELD' THEN
916:
917: FND_MESSAGE.Set_Name('XTR','XTR_ACCOUNT_MANDATORY_FIELD');
918: FND_MSG_PUB.Add; -- Adds the error messages to the list.
919:
920:
921:
922:

Line 1001: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors

997: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this
998:
999: BEGIN
1000: x_msg_count := NULL;
1001: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
1002:
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1005: IF(p_ce_bank_account_id is null) THEN

Line 1041: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1037:
1038: END IF;
1039:
1040: END IF;
1041: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1042: ( p_count => x_msg_count ,
1043: p_data => x_msg_data
1044: );
1045: EXCEPTION

Line 1052: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1048: close c_CHK_LOCK_INTEREST;
1049: end if;
1050: LOG_ERR_MSG('CHK_LOCK');
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1053: ( p_count => x_msg_count ,
1054: p_data => x_msg_data
1055: );
1056: --app_exceptions.RECORD_LOCK_EXCEPTION;

Line 1060: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1056: --app_exceptions.RECORD_LOCK_EXCEPTION;
1057: WHEN others THEN
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1059: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1060: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1061: ( p_count => x_msg_count ,
1062: p_data => x_msg_data
1063: );
1064: