64:
65: -- ******************************************************************
66: -- Validate Environment
67: -- ******************************************************************
68: IF FND_GLOBAL.User_Id IS NULL
69: THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
143: OZF_CODE_CONVERSION_PKG.Insert_Row(
144: px_code_conversion_id => l_code_conversion_id,
145: px_object_version_number => l_object_version_number,
146: p_last_update_date => SYSDATE,
147: p_last_updated_by => FND_GLOBAL.USER_ID,
148: p_creation_date => SYSDATE,
149: p_created_by => FND_GLOBAL.USER_ID,
150: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
151: px_org_id => l_org_id,
145: px_object_version_number => l_object_version_number,
146: p_last_update_date => SYSDATE,
147: p_last_updated_by => FND_GLOBAL.USER_ID,
148: p_creation_date => SYSDATE,
149: p_created_by => FND_GLOBAL.USER_ID,
150: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
151: px_org_id => l_org_id,
152: p_party_id => l_code_conversion_rec.party_id,
153: p_cust_account_id => l_code_conversion_rec.cust_account_id,
146: p_last_update_date => SYSDATE,
147: p_last_updated_by => FND_GLOBAL.USER_ID,
148: p_creation_date => SYSDATE,
149: p_created_by => FND_GLOBAL.USER_ID,
150: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
151: px_org_id => l_org_id,
152: p_party_id => l_code_conversion_rec.party_id,
153: p_cust_account_id => l_code_conversion_rec.cust_account_id,
154: p_code_conversion_type => l_code_conversion_rec.code_conversion_type,
338:
339: -- ******************************************************************
340: -- Validate Environment
341: -- ******************************************************************
342: IF FND_GLOBAL.User_Id IS NULL
343: THEN
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
554: OZF_CODE_CONVERSION_PKG.Update_Row(
555: p_code_conversion_id => l_code_conversion_id,
556: p_object_version_number => p_code_conversion_rec.object_version_number,
557: p_last_update_date => SYSDATE,
558: p_last_updated_by => FND_GLOBAL.USER_ID,
559: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
560: p_org_id => l_org_id,
561: p_party_id => p_code_conversion_rec.party_id,
562: p_cust_account_id => p_code_conversion_rec.cust_account_id,
555: p_code_conversion_id => l_code_conversion_id,
556: p_object_version_number => p_code_conversion_rec.object_version_number,
557: p_last_update_date => SYSDATE,
558: p_last_updated_by => FND_GLOBAL.USER_ID,
559: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
560: p_org_id => l_org_id,
561: p_party_id => p_code_conversion_rec.party_id,
562: p_cust_account_id => p_code_conversion_rec.cust_account_id,
563: p_code_conversion_type => p_code_conversion_rec.code_conversion_type,
703:
704: -- ******************************************************************
705: -- Validate Environment
706: -- ******************************************************************
707: IF FND_GLOBAL.User_Id IS NULL
708: THEN
709: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
900:
901: -- ******************************************************************
902: -- Validate Environment
903: -- ******************************************************************
904: IF FND_GLOBAL.User_Id IS NULL
905: THEN
906: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
907: THEN
908: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
2747:
2748: -- ******************************************************************
2749: -- Validate Environment
2750: -- ******************************************************************
2751: IF FND_GLOBAL.User_Id IS NULL
2752: THEN
2753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2754: THEN
2755: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
2826: OZF_CODE_CONVERSION_PKG.Insert_Supp_code_conv_Row(
2827: px_code_conversion_id => l_code_conversion_id,
2828: px_object_version_number => l_object_version_number,
2829: p_last_update_date => SYSDATE,
2830: p_last_updated_by => FND_GLOBAL.USER_ID,
2831: p_creation_date => SYSDATE,
2832: p_created_by => FND_GLOBAL.USER_ID,
2833: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2834: px_org_id => l_org_id,
2828: px_object_version_number => l_object_version_number,
2829: p_last_update_date => SYSDATE,
2830: p_last_updated_by => FND_GLOBAL.USER_ID,
2831: p_creation_date => SYSDATE,
2832: p_created_by => FND_GLOBAL.USER_ID,
2833: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2834: px_org_id => l_org_id,
2835: p_supp_trade_profile_id => l_supp_code_conversion_rec.supp_trade_profile_id,
2836: p_code_conversion_type => l_supp_code_conversion_rec.code_conversion_type,
2829: p_last_update_date => SYSDATE,
2830: p_last_updated_by => FND_GLOBAL.USER_ID,
2831: p_creation_date => SYSDATE,
2832: p_created_by => FND_GLOBAL.USER_ID,
2833: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
2834: px_org_id => l_org_id,
2835: p_supp_trade_profile_id => l_supp_code_conversion_rec.supp_trade_profile_id,
2836: p_code_conversion_type => l_supp_code_conversion_rec.code_conversion_type,
2837: p_external_code => l_supp_code_conversion_rec.external_code,
3019:
3020: -- ******************************************************************
3021: -- Validate Environment
3022: -- ******************************************************************
3023: IF FND_GLOBAL.User_Id IS NULL
3024: THEN
3025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3026: THEN
3027: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3235: OZF_CODE_CONVERSION_PKG.Update_Supp_Code_Conv_Row(
3236: p_code_conversion_id => l_code_conversion_id,
3237: p_object_version_number => p_supp_code_conversion_rec.object_version_number,
3238: p_last_update_date => SYSDATE,
3239: p_last_updated_by => FND_GLOBAL.USER_ID,
3240: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3241: p_org_id => l_org_id,
3242: p_supp_trade_profile_id => p_supp_code_conversion_rec.supp_trade_profile_id,
3243: p_code_conversion_type => p_supp_code_conversion_rec.code_conversion_type,
3236: p_code_conversion_id => l_code_conversion_id,
3237: p_object_version_number => p_supp_code_conversion_rec.object_version_number,
3238: p_last_update_date => SYSDATE,
3239: p_last_updated_by => FND_GLOBAL.USER_ID,
3240: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
3241: p_org_id => l_org_id,
3242: p_supp_trade_profile_id => p_supp_code_conversion_rec.supp_trade_profile_id,
3243: p_code_conversion_type => p_supp_code_conversion_rec.code_conversion_type,
3244: p_external_code => p_supp_code_conversion_rec.external_code,
3383:
3384: -- ******************************************************************
3385: -- Validate Environment
3386: -- ******************************************************************
3387: IF FND_GLOBAL.User_Id IS NULL
3388: THEN
3389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3390: THEN
3391: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
3580:
3581: -- ******************************************************************
3582: -- Validate Environment
3583: -- ******************************************************************
3584: IF FND_GLOBAL.User_Id IS NULL
3585: THEN
3586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3587: THEN
3588: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');