DBA Data[Home] [Help]

APPS.GR_WF_UTIL_PVT dependencies on FND_GLOBAL

Line 1086: l_notify_txt || fnd_global.local_chr(10) ||

1082: 'GR_ITEM_NAME_TXT');
1083:
1084: l_item_name_txt := FND_MESSAGE.Get;
1085: l_item_details := l_item_details ||
1086: l_notify_txt || fnd_global.local_chr(10) ||
1087: l_orgn_id_txt || ' ' || c1.orgn_code || fnd_global.local_chr(10) ||
1088: l_item_code_txt || ' ' || c1.item_code || fnd_global.local_chr(10) ||
1089: l_item_name_txt || ' ' || c1.item_name || fnd_global.local_chr(10);
1090:

Line 1087: l_orgn_id_txt || ' ' || c1.orgn_code || fnd_global.local_chr(10) ||

1083:
1084: l_item_name_txt := FND_MESSAGE.Get;
1085: l_item_details := l_item_details ||
1086: l_notify_txt || fnd_global.local_chr(10) ||
1087: l_orgn_id_txt || ' ' || c1.orgn_code || fnd_global.local_chr(10) ||
1088: l_item_code_txt || ' ' || c1.item_code || fnd_global.local_chr(10) ||
1089: l_item_name_txt || ' ' || c1.item_name || fnd_global.local_chr(10);
1090:
1091: l_item := c1.item_code;

Line 1088: l_item_code_txt || ' ' || c1.item_code || fnd_global.local_chr(10) ||

1084: l_item_name_txt := FND_MESSAGE.Get;
1085: l_item_details := l_item_details ||
1086: l_notify_txt || fnd_global.local_chr(10) ||
1087: l_orgn_id_txt || ' ' || c1.orgn_code || fnd_global.local_chr(10) ||
1088: l_item_code_txt || ' ' || c1.item_code || fnd_global.local_chr(10) ||
1089: l_item_name_txt || ' ' || c1.item_name || fnd_global.local_chr(10);
1090:
1091: l_item := c1.item_code;
1092:

Line 1089: l_item_name_txt || ' ' || c1.item_name || fnd_global.local_chr(10);

1085: l_item_details := l_item_details ||
1086: l_notify_txt || fnd_global.local_chr(10) ||
1087: l_orgn_id_txt || ' ' || c1.orgn_code || fnd_global.local_chr(10) ||
1088: l_item_code_txt || ' ' || c1.item_code || fnd_global.local_chr(10) ||
1089: l_item_name_txt || ' ' || c1.item_name || fnd_global.local_chr(10);
1090:
1091: l_item := c1.item_code;
1092:
1093: END IF;

Line 1109: c3.property_name || fnd_global.local_chr(10) ||

1105: 'GR_PROPERTY_NAME_TXT');
1106: l_property_name_txt := FND_MESSAGE.Get;
1107:
1108: l_map_details := l_map_details || l_property_name_txt || ' ' ||
1109: c3.property_name || fnd_global.local_chr(10) ||
1110: l_current_prop_txt || ' ' || c3.property_value ||
1111: fnd_global.local_chr(10) ||
1112: l_proposed_prop_txt || ' ' || c3.proposed_value ||
1113: fnd_global.local_chr(10);

Line 1111: fnd_global.local_chr(10) ||

1107:
1108: l_map_details := l_map_details || l_property_name_txt || ' ' ||
1109: c3.property_name || fnd_global.local_chr(10) ||
1110: l_current_prop_txt || ' ' || c3.property_value ||
1111: fnd_global.local_chr(10) ||
1112: l_proposed_prop_txt || ' ' || c3.proposed_value ||
1113: fnd_global.local_chr(10);
1114: END LOOP;
1115: FOR c4 in get_unmap_property_value (c1.orgn_id, c1.item_code,c1.property_name) LOOP

Line 1113: fnd_global.local_chr(10);

1109: c3.property_name || fnd_global.local_chr(10) ||
1110: l_current_prop_txt || ' ' || c3.property_value ||
1111: fnd_global.local_chr(10) ||
1112: l_proposed_prop_txt || ' ' || c3.proposed_value ||
1113: fnd_global.local_chr(10);
1114: END LOOP;
1115: FOR c4 in get_unmap_property_value (c1.orgn_id, c1.item_code,c1.property_name) LOOP
1116: FND_MESSAGE.SET_NAME('GR',
1117: 'GR_NOTIFY_NON_REG_TXT');

Line 1132: l_unmap_details := l_unmap_details || fnd_global.local_chr(10) ||

1128: FND_MESSAGE.SET_NAME('GR',
1129: 'GR_PROPERTY_NAME_TXT');
1130: l_property_name_txt := FND_MESSAGE.Get;
1131:
1132: l_unmap_details := l_unmap_details || fnd_global.local_chr(10) ||
1133: l_noti_non_reg_txt || fnd_global.local_chr(10) ||
1134: l_property_name_txt || ' ' || c4.property_name || fnd_global.local_chr(10) ||
1135: l_current_prop_txt || ' ' || c4.property_value ||
1136: fnd_global.local_chr(10) ||

Line 1133: l_noti_non_reg_txt || fnd_global.local_chr(10) ||

1129: 'GR_PROPERTY_NAME_TXT');
1130: l_property_name_txt := FND_MESSAGE.Get;
1131:
1132: l_unmap_details := l_unmap_details || fnd_global.local_chr(10) ||
1133: l_noti_non_reg_txt || fnd_global.local_chr(10) ||
1134: l_property_name_txt || ' ' || c4.property_name || fnd_global.local_chr(10) ||
1135: l_current_prop_txt || ' ' || c4.property_value ||
1136: fnd_global.local_chr(10) ||
1137: l_proposed_prop_txt || ' ' || c4.proposed_value ||

Line 1134: l_property_name_txt || ' ' || c4.property_name || fnd_global.local_chr(10) ||

1130: l_property_name_txt := FND_MESSAGE.Get;
1131:
1132: l_unmap_details := l_unmap_details || fnd_global.local_chr(10) ||
1133: l_noti_non_reg_txt || fnd_global.local_chr(10) ||
1134: l_property_name_txt || ' ' || c4.property_name || fnd_global.local_chr(10) ||
1135: l_current_prop_txt || ' ' || c4.property_value ||
1136: fnd_global.local_chr(10) ||
1137: l_proposed_prop_txt || ' ' || c4.proposed_value ||
1138: fnd_global.local_chr(10);

Line 1136: fnd_global.local_chr(10) ||

1132: l_unmap_details := l_unmap_details || fnd_global.local_chr(10) ||
1133: l_noti_non_reg_txt || fnd_global.local_chr(10) ||
1134: l_property_name_txt || ' ' || c4.property_name || fnd_global.local_chr(10) ||
1135: l_current_prop_txt || ' ' || c4.property_value ||
1136: fnd_global.local_chr(10) ||
1137: l_proposed_prop_txt || ' ' || c4.proposed_value ||
1138: fnd_global.local_chr(10);
1139: END LOOP;
1140:

Line 1138: fnd_global.local_chr(10);

1134: l_property_name_txt || ' ' || c4.property_name || fnd_global.local_chr(10) ||
1135: l_current_prop_txt || ' ' || c4.property_value ||
1136: fnd_global.local_chr(10) ||
1137: l_proposed_prop_txt || ' ' || c4.proposed_value ||
1138: fnd_global.local_chr(10);
1139: END LOOP;
1140:
1141:
1142: END LOOP;

Line 1145: l_unmap_details := l_noti_non_reg_txt || fnd_global.local_chr(10) || l_unmap_details;

1141:
1142: END LOOP;
1143:
1144: If l_unmap_details IS NOT NULL THEN
1145: l_unmap_details := l_noti_non_reg_txt || fnd_global.local_chr(10) || l_unmap_details;
1146: END IF;
1147:
1148: l_property_details := l_item_details || fnd_global.local_chr(10) || l_map_details || l_unmap_details;
1149:

Line 1148: l_property_details := l_item_details || fnd_global.local_chr(10) || l_map_details || l_unmap_details;

1144: If l_unmap_details IS NOT NULL THEN
1145: l_unmap_details := l_noti_non_reg_txt || fnd_global.local_chr(10) || l_unmap_details;
1146: END IF;
1147:
1148: l_property_details := l_item_details || fnd_global.local_chr(10) || l_map_details || l_unmap_details;
1149:
1150:
1151: /* set the item attributes */
1152:

Line 1325: l_user_id := FND_GLOBAL.USER_ID;

1321:
1322: l_itemtype := 'GRREGIIO';
1323: l_itemkey := to_char(l_from_item)||'-'||to_char(sysdate,'dd-MON-yyyy HH24:mi:ss');
1324: l_WorkflowProcess := 'GRREGIIO_PROCESS';
1325: l_user_id := FND_GLOBAL.USER_ID;
1326: /* create the process */
1327: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
1328: itemkey => l_itemkey,
1329: process => l_WorkflowProcess) ;

Line 1433: l_user_id := FND_GLOBAL.USER_ID;

1429:
1430: BEGIN
1431:
1432: IF p_user_id is NULL THEN
1433: l_user_id := FND_GLOBAL.USER_ID;
1434: ELSE
1435: l_user_id := p_user_id;
1436: END IF;
1437:

Line 1439: FND_GLOBAL.APPS_INITIALIZE( l_user_id,

1435: l_user_id := p_user_id;
1436: END IF;
1437:
1438:
1439: FND_GLOBAL.APPS_INITIALIZE( l_user_id,
1440: 25583,
1441: 557);
1442:
1443: END APPS_INITIALIZE;